We have a particular form that reads from a table which stores start/due dates for production orders. Those dates change as the quanitty of the production order changes, either longer or shor...
Using an Access ADP, in 2000 format. I have several forms with check boxes.
These boxes are bound to individual fields.
All works well on each pc, and for nearly all the Terminal Server user...
I am having a issue with a textbox in Access. I have read so much about using the NZ function to clear the #error I'm getting but I must be entering it incorrectly as I cannot get it to work. ...
It is a very stupid question, but I am running out of patience looking on experts and google because I don't know how to express myself well enough to find useful answers. Supposely this shoul...
Ok a great query was written for me in this thread.
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Forms/Q_23616492.html
I have been able to build off of this and c...
I am using 2007.
Lets say I have a 1:m form, with the one on top and the many down below. The many part of the form is a grid. In the past, when I have had a situtation like this, and ther...
tblOFInvDetail
OFInvDetailID Auto Key
OfInvDetail
Company Code
tblOFInventory
OFInventoryID Auto Key
OFInvTypeId Not required
OFInvDetailID Numeric key from...
Hi all.
I have a table (tblCustomers):
Customer---ParentID
ABC--------123
DEF--------456
GHI--------123
JKL-------123
I have a form where the end user chooses a ParentID and a con...
Hello,
I have an Access form with three checkboxes and multiple combo boxes. I am adding a reset button to 'clear' the form. All the code works fine until I attempt to set the value of the ...
I need to disable controls (or enable at another time) during runtime. My very short code is listed.
In the debugger, stopping at "If TypeOf," ctl.Enabled shows as True; yet, when the next...
I have a table that holds three dates (Stored as Short Date in UK date format). When the record is created, the date fields are blank, however depending on events, one or more of the dates are...
I have a memo field in an Access 2003 database that my users want to paste into from tables in MS Word. The table loses all its formatting when it's pasted. Because the field can have differen...
I have an admission board for a hospital in continuous form view. It filters out yesterdays patients based on date/time.
Several clerks are sharing the form on different computers. I have a...
I have a query that returns multiple records. I want to be able to display all of these records on a form as a single record. At present when I design a form based on the query, you have to na...
The contents of alll the drop down lists disappeared recently from a form in use for over 10 years. The form pulls the lists of items from different tables. The tables look OK and the items ar...
Access 2003 - I have a form with two text boxes and a list box on it. I want one text box that looks up a company name (or even a few letters of the company name), and the other text box look...
Good Morning,
I have a table with rows in it that I would like to make data entry columns in a query, form, and report.
For instance,
I have a project table with the following colum...
In a form with a number of input fields there are 3 fields that are required every time.
I'm using this:
If IsNull (Me.Field1.Value + Me.Field2.Value + Me.Field3.Value) Then
MsgBox "Bla...
I understand how to create subforms. However, because of the user interface design, I need to put about 5 forms on the main form - one form is a child of the main form, and some other forms a...
I have several MS Access databases created in prior versions of Access (i.e. 2003) that have reports that get exported to Excel.
A Macro runs various queries, and the final step is using the ...
Hi all.
I have a list box on an access 2003 form that I would like to insert the values into a table once the user clicks the SAVE button. The user may choose multiple selection in the list...
How can i add an input mask on an inputbox
I am entering a password, and i would like to show *
i do not want to do a form, i am using InputBox
thanks
MS Access 2003 -
I have a sales order form. In the form footer, I have a complete button that runs several queries, but has two different If Then statements that fire off before they are al...
Hi
I would like to force the first character of a field on a form to upper case and then allow the rest to be optional. I know how to force to upper case and lower case, but I want to turn...
How can I change the property of a text box in a form to change teh shading color after update? My problem is when I change the value in the field, the back color changes. But when I add a n...
