Recent content by businessman

the only other criteria is that another field says that it is an "Open" issue. all 4 of the dates that i have are open and yet it is only finding 3. what do you think could be wrong with the way i set up the query

ok. that helped a ton. i can get the number of days difference like i want. now how come when i run a query to find where a field "Is Not Null" (its a date field), it will not find all of the records where this field has a date entered?

I want to have a query that will subtract a Due Date from todays date and tell me how many days are left/passed in either a positive number or negative just like the DateDiff Function. how do i do this?

Can i edit a query to equal a SQL string just like i do for my reports? for my reports i say: DoCmd.OpenReport "Check Filter", acViewDesign, , , acHidden Reports![Check Filter].RecordSource = strRecordSource DoCmd.Close acReport, "Check...

how easy is it to have access create a table and export it to excel, and then have fields on an already made spreadsheet filled in.

NM...i just did it the long way.

i have 3 checkboxes A, B, and C. If A is checked i want the Query to search for A in a field. if A and B are checked i want it to search for A and B. Therefore in the query could i have 3 columns for that field and say where strA OR strB OR strC. so in my code if A and B are checked then...

Can i create a query that will have a string in the Criteria box, where that string is assigned a value in VB code? for instance: Dim xyz As String xyz = "TV" and I put in the Criteria Box WHERE xyz = "Pizza"

Is there a way to make sure that no duplicate records show up in continuous form?

is there a command for adding values to tables?

This is probably something already talked about, but if i have a combo box that has an "Add New Entry" selection in it, and when the user clicks on it, i want to add what they want in to the table that the combo box chooses from. can I have that "Add New Entry" selection open a form with a text...

you can use a query to do this. if you bound the form to the query and have the query search where the combo box is equal to what ever other field your looking to match with it, then the query will do all the work.

good point. thanks for the help

So does Access have a lot of limitation or can you pretty much get around the roadblocks to do what ever you want?

can you default the frames to max or is that pushing it a little..lol