Search results

Greetings, I have a quote database, and I have put in a special feature in the product code field-the user double clicks on the product code field, and it brings up the whole product table in a form, that the user and search through. But, the one thing I can not find a way to do is have them...

Thanks Ian, I can see where it is leading, I think, but, I still don't see where that will create the different results, maybe I am dense though! I must admit that, while I can write minor queries in true SQL, I still depend on the wizards to do most of the work. But, I am trying to learn to...

Hi, I am trying to put together a form so users could query the database for select info, like- customers that have *design* in their name. I figure I can create a query that would use their criteria easy enough, but I want them to be able to pick which field to search for the data in, like...

Hi, One of my databases is displaying the following error: Jet database will not let you write to that file because you or someone else is trying to write to the database. This database is not shared or on a network, so I don't know why it would have that error. Any help would be, well...

HI I not sure this will solve your problem, but it is worth trying at least. I am not sure of the code involved, I am new to code so I still rely on macros. Create a new macro and in the conditions field (if you do not see a conditions field go to: Tools > Options > View tab - look for Show...

Do you mean the part with the GetTimeCardTotal? The way I read it, that works with info in a table and not on a report? Will that code work with the info on the report, or do I have to use a table to get the first in order to use the total part? Thanks for the any info. DAK

Two questions: Do you have a field in the table that signifies the quarter the field is in? And are you calling to that field to pick from in your combo box? And are you using the combo box in the criteria of your query? I guess that is 3 questions! I am just trying to narrow down where the...

Greetings, In my database, I track when someone logs in and logs out. I found the code that can bring the time out of the date field (GetElaspedTime), and the time shows on the report in hours, minutes & seconds, but how do you get the Total time? The regular Sum code doesn't work. Any...