Search results for query: *

Im creating a form with a subform in a table format. What Im trying to do is specify what records I want to show using a combo box. So if I want just all records from CA to pop out, I will pick this from my combo box and the subform will just display the record that have CA. How do I do this...

I have created a query for my Shipping Log. In the standard order forms in Access, the Bill TO is usually the Ship To unless you enter a specific Ship To when entering the order. From my query , I have both the Bill To and Ship To fields available. In my actual report, I dont want the Bill...

I am trying to create a Query. It is based on a table of Customers. If the command for specifying dates is " Between [Beginning Date] And [End Date] ", what would the command be for specifying other fields so I can sort it by state , classification etc.? Any answer is greatly...

In Acess, there is a generic database for Contact Management. Lets say I created this and named it Contact A (all belonging to a certain Category). Now I need to create a new category so I created another one of these generic db's and named it Contact B. My problem is this: When I try to import...

Great! Im kinda new to this and this forum really helps beginners like me. Thanks Bry!

Do I type this in the Critera are below the InvoiceNo Field? If so, I must be doing something wrong because it wont Run. This is what I typed. WHERE(((tblOrders.InvoiceNo) Like [Put text for input box here])) Thanks again.

I just created a query with data from a table.One of the fields in the table is Invoice No. When I open this Query, all the record appear. I need to have only a specific record based on a criteria to show up, in this case, I want to pull up a specific Invoice No. My Invoice Nos are formatted...

Scott, Thanks a lot!

I have just created a form with 3 subforms. However, when displayed in the form, each subform still has the gray vertical bar on the left side with the little triangle icon on top,Also the bar on the bottom of the subforms that shows the record number and directional arrows also shows. Is there...

great! Ill try all of these suggestions and Ill just bug you guys some more if I have any more questions. Thanks a lot to everyone!

Actually no I havent worked with parameter queries before.

I'm fairly new with Microsoft Access so please bear with me. I have created a report based on a table. However, evrytime I preview this report, it will open all the data from that particular table. What I need to do is create a button that will ask for a date range. Subsequently, the report must...