I enter ID and data on form 1. It gets stored in table A. I input same ID on form 2, for which I want a select number of fields (populated) from tableA to be...

Hello all: I have two tables (one with employee data and one with Office location data). They are joined using the office address as the primary key in the...

At work, we use a large database. In it, there are 400 records for personnel. The table this is based on has about 40 fields. Currently, whenever we need to...

what makes the text in an unbound listbox align left or center since there is no 'align' property? Some of mine are left-justified and some are centered and...

Hi, I Hope you guys can help me. I need to lock a single record in a suborm. The code I have is (in the subform) I basically need to allow only one addition...

I'd like to be able to fill-in data into an Access Form and then export the fields to a Microsoft Word Template with merge fields setup. Can anyone set me...

I am using the following code to disable the date field if the yes/no box is null or false: Private Sub Combo33_AfterUpdate() Me.Ctl1st_Date.Enabled =...

I have a listbox on a form that is not showing the data anymore. It seems to be associated with a particular table. I can create new listboxes on the form...

I have an Access 2K3 MDB for which I have developed a search form modelled after Allen Browne's sample search form. One issue that I have found is that when...

I have a shared Access application. At random, some desktops have a problem where when someone trys to enter data in a field, they get glyphs instead of...

i have a main form with many combos. i work my database through this form only. i fail to requery my combos that are based on different queries and tables....

In my form, I have entered a field where percentages must be entered. However, when I enter 0.5, the value changes to 0. If I enter 1, it displays as 100%...

I want a textbox (or combobox) in an Access form that works like the URL bar in IE in autocompleate mode. It should look for my previous entries in that ...

Hi everyone! I have a question, and it most likely a simple solution, but is giving me fits here. I have a form, and oh what a form it is. Everything works...

I have a very simple problem that is driving me nuts. I have the following tables with these pertinent fields: Products -ID -ProductCode -ProductName -Price...

Hi, Looked low and high for a basic tutorial on how to make use a form to enter some "field criterias" and from there run a report. That is, I have already...

I have "inherited" a database where the Name field contains both the first name and last name in the same field. I am trying to sort the field, but can only...

Hi All, I'm trying to sort my list box value through a combo box.So in the criteria row of the list box query builder,I put the below line: !! & "*" Perhaps...

I have a main form for supplier name and details, and subform for the invoices details. Since make subform to have an alternating row is difficult and also I...

I'm creating a database to track upcoming worldwide rocket launches and I just can't seem to figure out how to creat a form that allows me to easily input...