Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Access Query to Form Question
Name: psonix Date: June 6, 2006 at 08:18:50 Pacific OS: Win Xp CPU/Ram: Celeron D Product: HP
Comment:
I am executing a query from the VBA using the docmd.openquery command. The same query is also the record source for the form I want to use.
When I call the open query command it opens up as a data table. How can I get it to sync up with the form and open into the textboxes?
I need to run the open query command to execute code in the vba that allows me to do multi keyword text searching.
Name: Jennifer SUMN Date: June 21, 2006 at 16:25:25 Pacific
Reply:
I'm not sure if I understand what you're asking. Do you want to have a user open your form, which will then ask the user to input criteria and then the results (matching records) will show up in your Form View? Do I have that right?
Life is more painless for those who are brainless.
Summary: Hello All, I work as a programmer for a direct mail company. Here is my problem: I am developing a Access (.mdb) database for a company that we just mailed tax forms for to there customers. The com...
Summary: I have an Access query (Qry2) that I need to update data in a table (Tbl3). Ory2 is pulling data from another query (Qry1). Qry1 is calculating data from Tbl1 and Tbl2. Okay, so the data shows up f...
Summary: I'm trying to program an access query so that people can enter a database and 2x click the query to receive an input box for the search term. So far I have [Enter company name preceded and followed by...