Help

Trapping/disabling runtime error 30014
Hello all - This is driving me crazy. I have a table called tblClients - very simple, has the following fields: taxID (PK) ClientName SalesName The main form of my application allows a user to select a client and shows sales transactions on a subform. I wanted to include a button the user could click whic... 6 May 2008 23:24

Problem with reference to control value in query
I should clarify the I can iterate through the list box and get that part of the query fine, I just can;t get the value from the combo box into the query as a constant. Again thanks I have a form with a combobox and a list box. I have many selections in the list box (company names) and one selection in... 6 May 2008 23:24

Problem with reference to control value
I have a form with a combobox and a list box. I have many selections in the list box (company names) and one selection in the combo box, Parent company ID. I need a query to stuff the company name and the parent company ID into a table. Thanks for any help. Kevin ... 6 May 2008 23:24

Help with some VB Code
Here is what I have so far, it loops while the PW is incorrect, or until cancel is selected. I want it to lock the tables for adds, deletes, and edits when cancel is selected, and if the PW is correct. I want this to run when the DB is opened, I would also like the text box to be starred (*) out when text is inpu... 7 May 2008 14:14

Read Only For The Masses
On May 2, 10:28 am, "paii, Ron" <n...(a)no.com> wrote: "colemanj4" <colema...(a)gmail.com> wrote in message news:aff84e62-c93e-4234-9288-5a89398196e0(a)l64g2000hse.googlegroups.com... Hello, I want to make my database read-only for the masses, and have a (preferably single) password in order to ... 6 May 2008 23:24

Combining two tables with no duplicate names
I have 2 tables, Table 1 has Name, NameID, and A, B, C fields. Table 2 has Name, NameID, and D, E fields. Several of the Names/NameID are the same in both databases. I want my merged the tables so each record looks like; Name, NameID, A, B, C, D, E. I have merged them successfully but I am getting two records for... 6 May 2008 23:24

Hiding/Showing controlson a continuous form
I have a form that is set to "continuous forms" view. Several rows of data are shown to the user at the same time. I want to set FieldX and FieldY to true and show them only if the txtEmailAddress control is not null and contains an address. Some rows shown in the detail section of the form will have email add... 6 May 2008 23:24

Access 2007 Form problem
Brian McLaughlin wrote: Hi. Probably a simple problem but i'm pulling my hair out! I have 3 tables(Consultant name, hospital and medical department). Consultant name is joined to the other two by their primary key. I want to create a form with 3 drop down menus. I've managed to do the first two (choos... 6 May 2008 22:20

Report on language preference and sorted by county
I am trying to run an MS Access report on language preference and sorted by county. I am looking at a form someone else made that has reports attached to it. I can't figure out how the report (attached to the form) and the drop down combo box (that allows for selection of county) are connected to each other t... 6 May 2008 22:20

Making installing Access 2002 runtime apps under Vista easier!
I have an app that is built in Access 2002 and packaged with its runtime. When installing it in a Vista PC/laptop, several dialog boxes pop up that require specific answers for the app to install and work OK under Vista. Is there any way to make this installation more straightforward by pre-empting these dialog boxes ... 6 May 2008 22:20