Hi, Im wondering if there is a way to lock the information shown on a form. The information that shows on my form is from a table, and i want to make it...

I saw this article: http://office.microsoft.com/en-ca/assistance/HA011730581033.aspx, but doesn't look like it works in my case. Assuming: I have 1 table, 1...

I have a form in the front end of an Access 2002 database used only for Data Entry. The form contains several labels, text boxes and combo boxes bound to a...

Dim EmailAll As Variant Thanks in advance: I have this script iin a button EmailAll = DLookup("", "LocationName", " = 1") Table: LocationName Field : ...

First of all, thanks to BruceM for the help with an IF/Else statement to generate specific autonumbers, works beautifully. My problem now is this: I have...

I'm trying to make a form where the user will get a list of check boxes and can select as many as are appropriate and then this data is entered into a field on...

Hello All, Code example below... What I want is turn Prospect into Customer (working); requery lstClientID and cboClientID (working); then select the first...

My company wants me to convert an Excel generated timesheet of Employees into an Access generated timesheet.Are there more advantages of doing the same thing...

I have a master form called DesignMaster, and a subform named DT, in DT I have a projectname combo box that I would like to get a default value from the combo...

I have several users who have different screen resolutions. Is there anyway in VBA to resize the forms automatically on opening according to the screen...

I would love to use a custom color as a conditional format. I can only 'see' the standard colors when I choose the color option. Can other colors be used for...

I have a combo box with two columns in the row source. I would like when the user selects that both columns of info would show in the box instead of just the...

I have built my table and my form, I can build an expression on the form that performs and displays the calculation I need, but I can not make it return the...

Hello I have a form that sums the total for all records which works fine. However i want a seperate total at the bottom which just totals records from one of...

Hi Freinds, I have my database on the shared drive, but the problem is only one user at a time can open the .mdb file. The .mdb file has tables linked to SQL...

Hi, I have an old problem. I have a form (frmDic) that he contains a list box (lstDic) with 4 columns (Code, Port, Eng and Esp) based in a query (qryDic). I...

Help or ideas needed please.... I have a multi select listbox where the user selects different catalogue types and they click a command button which send the...

Posted a while ago and haven't heard anything?? Most recent below and previous items listed below that. Did the pull data from the quote record- when just...

Hello I‘d like to have a form to fill info for customers and their contract. Customer’s name is given in a combo box and I want to have two options...

I have this query where i want to display all the columns(attributes) of the test table of a particluar vehicleOEM,model n year. strSQL = "SELECT * FROM...