I have a form that is used to lookup records for data entry/revision. Uniquie identifier is an autonumber field called "ID"
Also have a report that is basically showing the user what data ...
Experts,
I am settingup a table (tblBOM) wher any tblBOM record can have many Components but only one component can exists with the same BOMParrtNo. Therefore, I can have a single BOMPartNo w...
I have a field [field1] where I will enter a number. If the number is 75 or more or [field2] is "Open" (that's Text), I want to have another field (a YES/NO field) marked as TRUE else leave i...
HI all,
I have three controls that help me fill in vegetation community naming categories.
Control 1 uses a table to lookup the alliance. When an alliance is selected it fills in a control ...
How can I make sure the Save Button is hit before exiting - it has important updates behind it besides saving the record.
I have a close button on each form that the save button does more ...
I recently gave one of my users a new computer. I installed Access 2003 and all of the latest updates from Microsoft. There is a databse that resides on a network share that a couple of my use...
I used a sub-form (called "frmOrderDetail") of the tabular type as follows for users to enter products in an order (main-form called "frmOrder"). Since there are a huge number of products,...
How can I control the background color on a form. Individual elements placed on the grid I can control, but what about the "paper" on which I place those elements, For example in the attached ...
There is a detailed explanation of this in question:
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_23677287.html
When I posted the original question it was under the he...
i have a CSV file named IItems that i am having trouble importing into Access
if i choose to link it specifying that " is the field separator i get corrupted records
ie: "Mfr","Name"
...
Here is my IIF Statement:
=IIf ([Concept1] = "X" or x , 25%, IIf ([Concept2] = "X" or x , 50%, IIf ([Concept3]="X" or x , 75%, IIf ([Concept4] = "X" or x , 100%, 0))))
The idea is I ha...
Experts,
Everytime I try to open a particular form in design mode it only open minimized displaying the properties dialog box. Howcan I open it in design mode where it is not open minimum.
Experts,
My report is based upon a parameter query. The user clicks on a command button to execute the query. Rather than print a blank report I'd like to evaluate that the query returned dat...
A client has an Access dB on their file server and the Access 10 runtime installed on their workstations.
The application ran fine until XP service pack 3 was applied. Once SP 3 was install...
Ok. I think this one should be relatively simple:
I want a field to show up on a form based on whether or not that field has data in it in the table. Best way to accomplish this?
Hello,
I need to add a msg box to the following
Between [Enter Beg Date: "m/d/yy"] And [Ending Date: "m/d/yy"]
I have it in the code builder in the control source of the form and placed on ...
The database has a table called "COMPLETION". It has fields: "File Number", "Officer", "Date of Action", and then has multiple fields (I'll just refer to them as "Field1, Field2, etc) for app...
I am taking apart and re-architecting an existing, data-populated database and require guidance on how best to construct the necessary SQL (newbie alert).
I currently have four hierarchical...
Say I have a list of 10 queries.
I'd like to set a timer event, say at 5am that will:
a) run each query one at a time
b) e-mail the results to a list of recipients automatically (we use...
I have 2 list boxes on a form the first one displays the tables, querys, and linked tables in the database based on an option button choice. Based on the selection in the first list box I wan...
MS ACCESS 2003: I have many linked tables - where at the very end, the >* option is lit-up and I can go to the bottom and add a row if I want to.
But, there is only one - where this is ...
I have a need to fill out many shipment forms from one carrier.
The form is currently available only in PDF form.
Is there a way to fill out this form from within Access?
I have Adobe A...
I have a combo box set up on an Access form which allows the user to search by client name. When the user types in the first few characters of the name and the name is displayed in the combo b...
I've created a database for Workmen's Comp using Access 2003. Attach is a sample of my database. If you look at the form you will see that I set a criteria for Adjuster_Company and a command...
Hello!
First off, I'm very new to access. I've got my database together and I've developed a form based on a query. The columns have dropdowns in the form. When I change the dropdown option...
