Search results for query: *

OK, thanks for the input. The Where ([item1]=[Forms]![DataCrit]![item1] Or [Forms]![DataCrit]![item1]="*") And ([item2]=[Forms]![DataCrit]![item2] Or [Forms]![DataCrit]![item2]="*") ... seemed to address the wildcard issue. However, I...

I am using an unbound form to print specific information in a report. Each item is a dropdown list which is based on a table. However if a user does not wants to see all the items for a particular category then I want them to be able to use the asterick to do this which is set as the default...

I keep getting this error message and I am not sure what it means. Sounds to me like something has gone wrong with my Access program itself. I have some simple buttons that I created with a wizard that simply open a form. However, when I click the buttons the forms open but I get the error...

Geese, I beginning to think I have some kind of bug in my database or something. I fix one thing and something else goes crazy. I created a button on my form using the wizard. All the button does is run a macro. However, when I go to form view and actually try to use the button, I get an...

OK, can someone please tell me what could possibly be the problem. All the sudden one of my forms is not visible in form view. It is not the visible properties or display when. I just cannot figure it out and I am really frustrated. One minute I could see it the next one poof!! Anyone got...

Spott, I looked at what you wrote and I think that the Dlookup might work for what I am trying to accomplish. However, I was not quite sure I understood the part that you were talking about how you have the macro set up. Is the Dlookup function in the macro or is it an expression that is...

So this is like a SELECT WHERE statement? Is that right. Something like this for Sales Rep Name: SELECT [SalesRepName] from [tblImport] Where [JobNumber]=[Job] Me![SalesRep]=[SalesRepName] Am I anywhere close on this. I really do not know how to write VB. Sometimes I can manage to stumble...

I am trying to figure out how some fields can automatically be filled in on a form based on an ID number selected from a drop down list. For instance, let's say that Based on a JobNumber selected from a drop down I would like the SalesRepname, SalesRepcity, SalesReptype automatically filled...

OK...here we go! I have a query that counts the number of occurences of something in a table. Then I have a macro that I want to run if that query counts more than 0 occurences of this thing. I tried to set this up as a condition in the macro but with no success. What I have in the condition...

I have table A and table B which have a field in common called Clients. I want to find all the Clients in table A that do not exist in table B and add them to table B. What is the easiest way to do this. I am sure it is a simple query? Thanks!