Search results

Hello. I'm trying to use the value in a text box on a form as the table name in a query. Example Form Name: Frm_Module1 TextBox Name: text500 I want to use the value in text500 as the tablename in this query: SELECT [tablename].Field1, [tablename].Field2, [tablename].Field3 FROM...

Kind of stumped on this. Searching "append for each" just kind of throws me into standard quering articles. Any help would be greatly appreciated. Table 1_Customer: ID, First, Last (2 records) Table 2_Transaction: ID, CustomerID, Date, Amount What I'm trying to do is create an append query...

Is this possible to have available in a Form???? To show in a Form tables with the related tables below to be able to insert records in this view? I have been searching high and low and maybe im not searching proper terminology? Is this even possible in access?

First, I'm so sorry for my lack of terminology in what i'm trying to ask here. You know how when you make relations amongst tables and then when you open the table you can "expand" the + to see the underlying related entries in the other tables and make additions, deletions, edits from right...

I made the entire db and interface all in one acess 2003 db. I then upsized the db to sql server 2005. Now i have a front end in access 2003 and the tables are linked to sql server 2005 tables (i believe this is DSN connection via odbc driver, correct? and please correct my terminology if wrong)...

[Access 2003 in Windows XP] For the first ever, i created a security group (mdw) for 1 db that i have. Tools>Security>Workgroup Administrator I proceeded to "Create" and created a mdw called ProntoSec.mdw for a database called prontoparts.mdb and saved it in the same folder where...

The user views a record via form. This record has an image which they view on that form. I would like the user to edit that image (draw a line or a circle on that image) and save it back to the database - and would like for all of this to happen within the access db project. CAN ANYONE HELP...