I have an access 2000/2003 project that is used for data entry into an MS SQL 2000 back end. All of thd users are using the Access 2003 RT Engine instead of...

I need to replace the DoMenuItem command below: DoCmd.DoMenuItem _ acFormBar, _ acRecordsMenu, _ acSaveRecord, , _ acMenuVer70 With something...

I am using an on Double Click event to filter based on the current value on that field. It works when I use it on a number field: Me.Filter = "=" &...

I have two forms, FormA and FormB, based on table A and B. Both tables underlying the forms have different autonumbers as the primary key. Essentially, what...

When I try to design a new form in A2007 it is always maximized and the Min/Max buttons do not show despite the appropriate property settings. Furthermore I...

Hi I am updating a table through form.In the form written a procedure for On Click event of Label.It works fine for updation.In event proc i have put...

A relationship between the "Financial Year" Table (one side) and "Customers" Table (many side) has been created. The record source for the main form is...

I have a form that contains order details and I run through a loop that applies a filter to the form (only view one order at a time), and then removes the...

I am new to this and a friend told me to get involved with news groups to share thoughts, and downloads. How do I get started ?

I have a subform displayed in Datasheet view with the followign fields: Product Number (cbo), Product Name (cbo), Quantity, Discount %, Unit Price,...

Hi, I have about 12 people to work on the database and each has own userID and password. Their UserID and Password input and the form link to the query that...

Hi there, I have looked through the posts to see if i could find some help on it but i still cant get things to work... I have a form called Billing...

I'm trying to design a work order form that would contain a field that I can assign employees to the work order. On any given work order I could have from 1...

I need an Invoice Number text box in the format of "0000-yy" where the “0000� increases +1 automatically. Thanks -- Message posted via...

I have a form called “frmIncidentForm� that has a “Next Button�, “Previous Button� and “Add Button� The form will only allow editing of...

I have a calendar in a form. We do data entry for information that could have occurred today, yesterday, or a couple of days ago, like over a weekend. The...

Don't see my earlier post... here I go again! Scenario: Main form (1)- frm1 based on tbl01 User enters 3 parameters to filter by p1,p2,p3 Subforms (6)-...

this seemed so easy when I first started, but everything I tried has not worked. I have a database with a form: form1 and a subform: subform1 the subforms...

I have set up a form allowing users to select items from a list. After the user makes their selections, they run a query that provides them with their list....

I have a multiselect listbox. When the form opens, the list box height is 240, ie one line high. This makes my form with many listboxes compact until the...