Search results

I am trying to run the following code in a case select BeforeUpdate. I keep getting an error mewssage saying I must save the record before I do this. I thought this modified the record before it was saved. I am confused. strA = InputBox("Free Available Chlorine appears to be high. Please...

On print access is nice enough to waste lots of ink, on grey or whatever other colour your form happens to be. Anyone know how to make it print black data and labels et al on a white background instead. I tried instructing it to print data only, however, this then misses labels and other...

My application currently emails me tables from site. This is working fine. My question is can I tell the email to send, without the email appearing in the users window. For various reasons I could imagine the user may not always click to send it, and if they don't my database at this end will...

My application currently emails me tables from site. This is working fine. My question is can I tell the email to send, without the email appearing in the users window. For various reasons I could imagine the user may not always click to send it, and if they don't my database at this end will...

It appears from your last responce you now want to store the Mini ID in the table with the rest of the data. You could do this by setting a field in the table containing the rest of the data to a number or text field. We will name this field x. Create an unbound text box on your form, with...

Now I am confused. Looking at your previous posts, there appears to be some contradictions in what you want. Do you want to type in a value in a textbox, which is then compared to a value in another unrelated table? Do you want to type in a value in a textbox, which is then assigned as a...

The code as posted should look up the value okay. As a suggestion what I do when I can't work something out, to try and save some hair, is I add it to a field that doesn't matter, run it stepwise on click events such as msgboxes, until I have it doing what I want it to do. THen I simply copy...

Add a check box to the form. Is owner driver? then write a quiery which says if chkbox is true then divername = ownernmame etc.

From your question it appears you have a code that goes something like: x+y = addWeekdays if this is the case then I think this would fix the problem if (addWeekdays=Holidays) then txtW=addweekdays +1 elseif (addWeekdays<>Holidays)then txtZ=addWeekdays end if strA=txtW,txtZ

I had similar problems, the only way I was able to address this was by changing to a beforee update event.

I have an application where my user enters information at supposedly the same time every day. However, due to other issues, they could enter the data any time within about a two hour window. What I would like to do is compare the data entered now, with data entered yesterday for the same...

I think this is selectable under properties for the hyperlink.

At time if and if else logic becomes too large and complex there are two choices I have found work. The first is the call statement if x<10 then Call Exact(x as double) elseif x>10 and x<20 Call notExact(x as double) and so on This works well for other values, where two or more values require...

I have written an application over the last twelve months in Access 2000. Originally as a query, and more recently as VBA. This has been a long, torturous and tedious path, however, I am now complete. Except for one function, which I have had trouble with since day one. The delete...