I am supposed to build a database, and till now, finally I think I get
the GUI part of Access. But not sure if it is enough to build a
database. For example, if I build two forms, the first form asks a user
to pick up a productID, and based on the productID he/she picked, I

I am trying to create a ListBox based on a search from a TextBox.  I have a
TextBox where I will enter in a MemberAlias.  I want to click on a Search
Button and that will do a select from a PersonData Table that I have filled
out and look at each MemberAlias column for each Person ...

        To this point I have used a color for my form background
(detail, header, or footer) that is approximately the same as the
hard-wired background color of command buttons.  For the record, the
color value I use is  -214748363.  Then I choose a different color

I need to produce mailing labels every week for staff, but not always for
the same people.  I have found a procedure using a filter form which
allows individual names to be selected from a list box which are then
applied to a report for printing.

I have a large table which I wanted to filter and then edit the selected
record.
I'm using a form with several pull down fields linked to lookup tables which
correspond to fields in the large table. The user selects a number or

  In work I have created a database for meter readings in access.  I
am not a programmer, but would like to try something.  Please respond
with detail as I will be lost otherwise.
  What I would like to do is eliminate the possibility of someone

how to execute/ create  Joe Celko Nested Sets in VB Ms ACCESS
environment

i'm sure there's someone who has the solution from me out there.  i
have a simple database and one of the fields in the table 'products' is
'stock'.  now i need to add or reduce the value of the field 'stock'
through a form.  i mean if the stock is 25, and the user enters 5 as

I have a frontend with some fairly complicated forms (lots of tabs). It
took me some time to figure out - but when I set the "Allow Additions"
attribute to "No" the form takes 45 seconds to open. When I set the
attribute back to "Yes" it only takes 5 seconds. I'm thinking this

Any good advice to help solve this problem would be most welcome.
I can not open a recordset based on a query (called qryNoDateSetYet).
The qryNoDateSetYet uses another query within it called qryInputSat.
qryInputSat takes a parameter from a control on an open form.

I have the following event proceedure on a command button - which works
great, however, i would like to add the value of another field onto the
end.
e.g i have a field with the computer name in, and i would like the

The guy I've given it to is running Access 2003. He says he
tries to open the file and is presented with a message to the
effect that he doesn't have permission. He tried it with 2002
and it told him he had to join a workgroup to do it. Have I

I created an application which use MS Access 2000 as user interface and
MS SQL Server 2000 as backend. If I want to get data from MS SQL Sever
2000 and display them on the MS Access 2000 form, where do I set the
database connection to the form (i.e. tell the form to get data from MS

Greetings all...
This has been driving me nutz and I was hoping an expert could help shed
some light.
Why does this query work in Access but not in an

I regularly use FTP to place Self Extracting Zip files on the web for
remote users to update their datafiles. Works very nicely.
I have automated the creation of the initial zip file ( update.zip ),
and can automate the FTP'ing of the SE zip file to the update site.