I need to write a nested if statement for the first time and am unsure how to start. My If statement is as below:- Private Sub...

I am trying to link word documents to outlook so I can send myself an alert if the document is time sensitive and has not been responded to by the recipient....

I'm setting up a ticket booking database but on the bookings form I want to restrict the price of tickets if the performance is a certain day. I have a combo...

i am trying to automate emailing a word form using vb in access. it looks like i have the open and email side working but i am not able to 'save as' could...

I have created a small program to visualise the images from my camera in an access database by subjects. To visualize and zoom the images I use the PictureBox...

Id like to be able to tab through all the controls on a form which has a subform. for example: my main form has 2 textboxes, txt1 and txt2. the subform, 2...

Hi, I have a form the point of which is to show aggregated data, based on a query. I need a calculated control on this form to cuont the unique values in...

Hi, I try to run a query and I get an error message "query is too complex" and not running in access 97. Can anyone please help ? Thanks.

Hi all, Users of my database must have the possibility to copy and JPG from Paint and paste it into a form. So I created a OLE object called Photo. Put it...

anyone know of a good 3rd party imaging tool

I would like to put a command button on my switchboard form that will open a blank data entry form that is ready to enter data. I have a button to open a...

I am attempting to add a text box to form that has a linked table. Unable to proceed, do to the addition not being allowed because of the table being...

How do you create a data form in Access that when you pick the data in a menu bar can allow all the other data on the form be changed automatically according...

Hello, I have main form that displays weekly data and a subform within the main form that displays monthly data. I have a button on this same form that opens...

Hi: I've a MAIN and RESULTS forms. I've a RESULTS query that deppend of a textbox inside MAIN form. this is the criteria option in the query: Like...

I am building a form that has the following fields among others: 1) Today + 28 Days 2) Today + 3 Days 3) Patient Over 1 Year Old? 4) Expiration Date of...

I would like to create a general form that the user can select one type of ProductClass (for instance) and then select the ProductName from...

Which brings something to mind....the properties box seems to only allow one bound field....is that correct? from what you've just said, I should be able to...

I need to design a quiz (using ?) and know that Access is the best way to store the different quizzes/answers for the company training program. I know the...

Hi all This is quite a stright forward one that I know it has been posted here before, but I can't find the answer!.. I need to change the entered text in a...