Search results

No...any idea how I would do that?

Alright...I have managed to narrow the problem down to one event. I get this error only when I leave the database idle for more than a couple of mins. Could there be a reason for this?

Hi Wayne, Thanks for your reply. However, that does not seem to fix the problem as I keep getting the same Error Message.

Hi there, I have some code for generating reports that involve an IsNull Statement. I have 2 comboboxes that are in a if statement. The code should execute if Combo1 is not null and Combo2 is Null.But the wierd part is the code fluctuates. Sometimes it works when I have If (IsNull(Me!Combo1)...

hey there...do a search on this forum for something called a query def. that code takes input from an query and puts it into a variable!

Thanks for your help Ken...when I thought about it a bit more, I realized I had to go back to the good old Truth Tables in order to find out what is wrong. Also since an 'If' statement returns a boolean and so does the IsNull() function, the issue of Double negatives came up. But thanks a lot...

Ahhh...it is making a little more sense now...b/c my code would not fire when one was 'True' and one was 'False'. I had to use "" for one of them. Thanks for the help man. As a side note, where do I find documentation that explains these rules? These forums have been a great help but I cannot...

Thanks for the reply, but is this also true when you have multiple parameters in an if statement? ex: If isnull(...) = true and isnull(...)=false then.... what I tend to do is put both those parameters in brackets so it is a bit easier to read. If (isnull(...) = true) and (isnull(...)=false)...

Hey there, can someone perhaps explain this little problem to me? It regards an IsNull statement within an If statement. sometimes when I go... if (isnull(forms!formname!nameoffield) = true) then.... the statement works at other times, when I go if (isnull(forms!formname!nameoffield) =...

Thanks for the help Wayne...but one more question...what do I do if I have a date? I tried the # as many people have suggested throughout the forums but that did not help. I enter a date in the form and it turns out to be a totally different date in the tables. Your help would be much appreciated.

Hi Pat...thanks for your reply, but how would you include the double quote in the SQL Statement? PS: I tried searching the forum but did not find anything that specifically regarded my problem.

Hey guys, Can anyone tell me what is wrong with this statement? I keep getting a syntax error when the Record Create Identifiers are equal to 'johnsmith' and i get another syntax error when the record create identifiers are equal to something to something like 'John.D'Souza'. Your help would...

Once again, thanks for your help guys! I really appreciate it!

thanks a lot Milo and Mitch...I got it working thanks to you guys...but I do have one more question :p Can you include a combo-box in an input box?

the attachment works! so what is wrong with my code?

Hey guys...thanks a lot for your help, but I still get this message in the textbox: #Name? I might be missing a reference but I am not sure which one...I have over 30 references that are unchecked so I am not sure which one I would need. Can anyone help?

Access 2000

Hi Milo, I tried that and I get this: #Name? what does that mean?

Hey Mitch...thanks for your reply, but I am a newbie and I am not sure how I would call this function. Right now I got: Forms!FormName!TextBox=CNames() I get an argument error...can you help me?

Thanks a lot for your quick reply! I added an undo button which did pretty much the same thing. However, which one would you recommend? Also, is there anywhere for Access to grab the username of the person using the computer at that time and display it in a textbox?