Search results

how do i create a new table from within VBA? i have a query all built i just don't know how to get the results into a table. thanks, deno

ok i'm stuck again. how do i to the same thing but with a table instead of a query?

thanks!! that seems to work great. if you could just clue me into a couple more things i should be all sorted away. what's your error sub look like and is there anyway to pass inputted data from the form to the report? thank, deno

(sorry i'm a bit new with access) how would i do this? thanks

i have created this form with has a bunch of check and text boxes that the user uses to select what they are looking for. these are used to build a query complete in VBA (it doesn't exist as an actual query). what i'm need to figure out is how to get the record set into a report. help! deno

>Are you using the form to select the criteria for the query? yes >What is the name of the query? the query is built completely in VBA. >Will the same fields be used for every report? yes. i hope i'm going about this the correct way. this query does a select (and sub select) across multiple...

but how would i do that if my query changes everytime? the form that builds the query has check boxes for each day of the week so the user can check what day of week to search in. i do have a query that real close but it prompts the user with dialog boxes for input that get used in the WHERE...

i'm pretty new to access and have got stuck on this problem. i've build a form that has a bunch of check and text boxes which are used to build this (huge) query. everything is good with that but i can't figure out how to get the record set into a report. thanks, deno