I have two querries from one table, and each querry create different form. In this table have autonumber, how can I create the form share the autonumber, for...

I want to select a field when the condition (other fields in the same are true) -- Message posted via http://www.accessmonster.com

Attention! With several on-going cases of fraudulent practices being carried out by criminals on the internet, you are advised to carefully read this...

Hi All, I have use the 'Save' command button in the access2000. However, I need additional function when I click the 'Save' button. Click 'Save' - ...

BACKGROUND: Have a form with two subforms imbedded in a tab control. Each subform has, in its Form Footer, a totals row. each text control in the totals...

Hi. I'm using this mask for a phone number mask: !\(999") "000\-0000;0 Now, we have international phone numbers as well. I'm wondering if I need to add an...

I have MS ACCESS database with images saved in few fields of table. The data type of field is "Long Binary data". However, images do not display on form. Can...

Hi, The query below is working fine but once I have added this new line before the last line: ELSEIIf (!! = "Quantity Error", (SKF. Quantity), An error mssg...

In the forms, Properties | Others tag. When I turned both the "popup" option and the "share mode" option to TRUE, the deletion of the record will not display...

I like the format of a particular query result as opposed to the result in a report. Is there any way to use the Switchboard to run the query (as opposed to...

I have a subform in continous view that contains text fields. One of them is a rating field with 5 possible choices. How can I apply conditional formatting...

I have used a sample listbox search form from another database that will allow you to type and it automatically start listing records that correspond to that...

I have read countless threads and reviewed material on MS website regarding normilization,but it seems the more I read the farther I am away from understanding...

Hello, I have a form with several tabs on it, and on one of the pages, there's some text, and only then comes a subform. When I go to that tab, the page...

Hi Does anyone know how i can print a report showing the customer and address and phone no once and then show all the coolers attached to the customer. I...

Hello All, I have couple of tables namely Customer and Suppliers and want to create a form that would display a Year To Date business done with each customer...

i am looking to do 2 things with a form. 1. Edit existing records in a database 2. add new records to the database I have a combo box, cmbEditAdd, that...

Can the list box be configured on the form to select from a horizontal (left to right) positioned list instead of a vertical (top to bottom) list? -- FL

I have a Department field which looks up Divisions. A division only can belong to a certain Department. I have a Department Table and a Division table. On...

I read all the article that posted on this forum but could not find or make it works. Please help!!! O.k, I have a client table name "CLIENT"with the column...