Search results

I have a query Identical to this one that works fine but this one just gets the same data from a different table. Can you see whats wrong with it. I get a Message saying that it may be too complicated or complex and I may want to assign variables. Bad one PARAMETERS [Enter last two digits of...

Thanks Thank you very much for the help. It worked perfectly.

How can I secure the VBA code, I have the databse secured already, but the user can still see the code if he or she knows how to get to it. I cant make it a .mde file for some reason it wont let me. Any oher way to do it?

I was able to figure it out, thanks for all your help though, it is greatly appreciated.

No its not using combo boxes, the user enters in the data in text boxes.

I have a form where a user enters in two entities of a record which together make up the primary key for a record in a table. The user is promted to enter in new values and if the user enters in values that already exist then they get a error message saying that the record already exists. Which...

I have a form that is based on one table that selects diferent fields from a table. The form is opened by the user after the user types in quarter dates, a quarters beginning date and ending date. The form should only display records if that record has a date in that range. I have tried to solve...

I created a Function public Function EndDateFun() EndDateFun = EndingDate End Function then in my query I put Where ExpDate >= EndDateFun and I got a error message saying that the Function was identified or could not find function. What am I doing wrong? I would appreciate any help...

Thanks It works great

How would I add the delete to the Query? Here is my SQL that appends the record. It works great. Now I just need to delete it from the original table called Casefile. Can I just do a delete right after that statement? Parameters [Enter CCN of the case you would like to close] value; INSERT...

finally figured it out, thanks for all your help

I cant figure out how to take a record that is in one table and move the entire record to another table. Can I use a parameter query for this. I tried one with an update statement but it did not work. It also needs to delete the record from the table that it comes from.

I have used a query and I can not get correct information. Here is the DCount that I use to count the number of records returned fromt he query. but it does not give me correct information sometimes it tells me that rows are returned and there are not any rows. Here it is maybe I got something...

yes I am just using it now to double check my code and make sure that the comparison is working.

I am sorry but I have never done anything like that before. Could you please elaborate? Thanks

I am using DCount to count query results. If a query does not return any values I want to message to say "No Activity Durning this quarter" Here is my code. Am I doing something Wrong? The first part of the If statement works fine but the Dcount gives me incorrect results. If (LcAuth >=...

thank you so much I got it to work, I just took out the exit subs and inserted my own code and it worked beautifully. Thanks again

I tried it but it did not work. I will show you what I did. I did it when the form is loaded. Should I put it somewhere else? Thank you for your help. Private Sub Form_Load() If DCount("*", "[renewquery]") > 0 Then Exit Sub Else MsgBox "There are no active records." Exit Sub End If End Sub

is there a way to test if a query is empty in VBA? I have a subform based on a query and if it returns no values than I would like to user to be notified by a message box.

can I test to see if a query is empty after it is run? I have a subform based on a query and if that query returns no values I want a message box to say something like "No records exist for that time Frame"