I'm trying to perform a lookup for a SoftwareName field in the Software Table
and load it into Text Box ControlSource in my UserSoftware table.  This is my
syntax.  I keep getting "Invalid Control Property" and when I run the lookup,
I get #Name? in the results field.

Hello,
The answer to this question is probably posted here, but I can't seem to
find the solution. I have a main form/subform on which I have a button that
opens a subsequent form. I need the subsequent form to open with just the

I'm trying to add 2 colums of values to a listbox by selecting the combo box
(which has 2 columns). I have in the afterupdate of the combobox:
If Me!lstCompany.ListCount <= 0 Then
   Me!lstCompany.RowSource = Me!cboCompany.Column(1)

I have a form linked to an "invoice header".
It contains a subform linked to an "invoice line" table.
On the subform, I have a couple of calculated fields eg [$ amount].
I need this field to update the invoice line table once the user exits the

I would like to establish an unbound box using Expression Builder to create a
job order where the first four characters are in Upper Case based on the
names of different hotels in the "Hotel" field which is a drop down list.
e.g. The Carlton Hotel would be "CARL"- the remaining ...

hi every one
i have one table "invoice register" in which i will enter any invoice i
receive "taking to consideration that i may reject some of them after
checking" but any way i should keep record for any invoice i receive will

I have noticed that if one creates a hyperlink field, and tries to use that
for storing email addresses (aka johndoe@abc.com), that even A2K still
defaults to the [johndoe@abc.com#http://www.abc.com] and unsuccessfully
tries to open up an internet address when the corresponding ...

Hi All,
I have a several lookup comboboxes on the same form, they lookup differant
parts of the database, these are working perfectly.
What i want is that after the user has looked up and found the record, I want

I have an application, now over 10 years old (although extensively upgraded
several times) starting in Access 2 now in 97 and 2003.
Both the recent versions of the 97 and 2003 versions (sometimes) remain on
the taskbar once the application has been closed. When you try to close it ...

I have a query where I filtered a particular record, and then when
adding a table of demographics, linked by the common ClientCode, I get
a result of four identical records in the query, not just the one I
expected.   Where did I go wrong??? :-)

I have a beginners question....
I created a continuous form based om a table with two fields (field1 and
field2)
In the form all records are shown as lines (continuous form)

I want a sales invoice to change the inventory numbers.
I also want a report (invoice) to print for only that invoice number.
How?

I want to run an update query for the current record in a form by clicking a
command button. When I do this, I get a prompt letting me know that the
current record is being changed by another user. Is it possible to override
this prompt using code?

I have a popup that attaches files and stores them in the db.  I would like
to know if it is possible, and if so, how, to pass the file name back to the
original screen and retain it as a hyperlink.  I have created a separate
table for the attachment and have links to the primary ...

I have a similar problem as a question posed earlier.
I have a hidden text box with the default value of 'open' when ever i click
a button to write the data it submits open in the table and all is good. I
now have to be able to close it with a different button. If i run and update ...