Recent content by helloworld

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?