microsoft.public.access.forms | Forum profile

I have tblPackages: 1) PackageID - unuque index 2) ClientID (cbo with ClientID and ClientName based on tblCLients ) 3) ProductID (cbo with ProductID and ProductName based on tblProducts) 4-14) A few fields with package-related info. The table determines how the clients want the product to be packed for delivery. Every ...

I have a sub form based on based on table tbllevy which has a control txtmemnbr. There is also another control which is a combo based on a query which inturn is based on a table tblindividual. The combo has 3 columns: txtfullnamea, txtsurname, and txtmemnumber. I have the second 2 columns hidden and the combo list is sorted on the ...

Hi, I look thru some related message and found I have similar problem. I learned from here the below but it couldn't work in my form which as a subform. me.field1=me.combobox.column(1) me.field2=me.combobox.column(2) It work fine in single form but no in a form with subform. How could I come around it....

Could somebody please assist with the following problem:- I have a form named “Add or Delete a Customer” which has many fields. Two of the fields are named “CustomerName”, and “Comment”. The information within this form is stored on a table named “Customer”. Now, there is another form, named “Add and Edit Orders” ...

I have a client that created 8 databases and can only be viewed in the data sheet view. I want create a blank form that I can use a pull down to select anyone of the databases into the form and view and perform any functions that are attached to the form. Then blank the form so I can open another database etc. ACCESS 2000...

Hello, I have 2 combo boxes. One is a category, and the other is a subcategory. category combobox is cmbotype subcategory combobox is cmboreason My goal is to have cmboreason be limited only to the reasons that pertain to the cmbotype category. I have 2 tables: the category table is ContactID...

I know this has probably been covered there but I wasn't really sure how to phrase this so wasn't very lucky searching for an existing topic. And I'm not really sure how to ask this to convey what I'm wanting to do. I have values in a table, Field Name is Priority which contain L, M and H (for Low Medium and High) which consequently ...

some of my field names are longer than the data contained in the field, how can i increase the label row height and wrap the field name text. in a datasheet subform. can this also be done on a table??

Hi All, i am trying to copy a record into the same table prior to updating the original with a form. To achive this i am using the following code; Dim fld As Field With Me.RecordsetClone .Bookmark = Me.Bookmark Me.Recordset.AddNew For Each fld In .Fields...

I have a data base with the following fields Customer Number Last name First name address phone number When I enter a customer number into my form that has already been entered in once i would like for the remaining information to auto fill so that i am not entering the information over and over. I know ...

Is there any way to populate a list box from the bottom up? I'm in Access 2002 but can use 2003.

Here it goes. I’ve reworded this question. I have a form (“Volunteer Database Form”) with an attached subform (“Volunteer Hours Subform”). I would like to add a control box to my form with an expression that will do two things. 1.) Pull its data from a calculated field labeled “Total” on the subform. This field’s equation {=([End ...

Hello, MS ACCESS 2003 on XP PRo. I have a form fed by a query fed by a query fed by a query... basically it's a bunch of nested queries. I thought that form based on this query chain would back fill data backwards to the tables eventually. So my question is: Is there a way so that edits to the form data will...

I have a form based on a query with 2 tables that are joined already. this form has become locked for edit. I have checked the enabled and locked settings in the form and they are set correctly. I have reviewed several posts on this subject so I check my query and tried to change things around to see if I could isolate it but I was ...

How do I open a form in query mode, so that no records are displayed until I do a search. I have looked at filter and it does not work as I want it too. Please experts help.

Hello: I have what seems to be a very simple request for help. I have a customer table (with address info, etc) and a sales order header table and a sales line table. When creating a new order, the first field to be completed is the customer number (which is a lookup to the customer table). After the customer ...

This code does not pause and allow the user to pick a sort method on form "area form." I brings it up for a second and goes right on to the report. What do I need to do? Even if I pick "no" it briefly shows the area form and then goes right on to the report. Thanks!!! Private Sub Command25_Click() On Error GoTo Err_Command25_Click...

Hi I want a shortcut menu bar for one of my forms. I've gone to Tools| Customize | Toolbars and created a new one called SDIShortcut. I then changed its properties to make it a popup, which confirmed that it had been made a shortcut menu. All fine so far....... However, now I cannot seem to be able to add ...