I am trying to get data from 3 separate forms to display in 1 table.
The 3 forms contain separate text boxes that should connect to the one
table. The table seems to be only saving data from the first form.
Then the data from the other two froms are blank when you check the

Well, I have a table with fields like Quantity Borrowed and Quantity Returned.
I have a query with a field QuantityAvailable which is calculated based on
some formula...
So, problem is I want to build a subform consists of this table and query

I have a button on a form that thru code will run a macro which will run a
query.  How do I get the results from that query to append to a table, all
through vb code of my form?
Thanks,

I have a form where I enter numerical data into 4 columns.  Typically, there
are about 30 rows.  Because of the nature of the values, it is easier to
enter the data for each column from top to bottom before going to the next
column.  I currently enter a value then have to tab 4 ...

I have been given a rather hairy piece of sql to put into a module but I
have not been able to properly convert it to SQL that access can process.
Can anyone help with this?
The sql is:

I am trying to build a main form, that will have a tab control and 2 pages
each with a subform (the easy part) .  I have this already, but I have 2
seperate forms and 2 query's for the tab control pages.  I figured this is
not the best way - if I had to make a change, I have to do ...

Plugin.ocx file continues to be removed when we run MS Updates. The databases
are 2003 and forms don't work without the plugin.ocx.  Tried making the .ocx
file read only, but that didn't work.  We have to copy it back into Windows
System folder each time we run updates.  Any ...

I've having problems with my vba sql syntax. When changing my forms
RecordSource with CODE 2 below, I get an error. CODE 1 works fine, but I
can't seem to concatenate the ORDER BY after the WHERE clause varible.
Me.idControl is an integer type. What am I doing wrong?

I was just asked to create a date validation pop up on a form that I'm
designing. The validation is a pop up box that asks the user if the
end date of the period is correct by taking the last date of the
previous period and adding the number of days in the current period.

Hi Alll,
I have an Access database on branch office (other country) I need to
connect from oother place via VPN.
What is the best method to connect Access database via VPN? if

Hi, I am working on a database I did not create, always fun.  I have a form
with a combo box on it for client name.  There is a button to add a new
client.  When you click on it, it brings up the table and you enter in all
the client information.  This particular form only needs ...

I am using the following code to determine if a record is present, then doing
stuff accordingly.  Trouble is...I do get the message if there is a record
and do not get the message if there is not.  
Am I doing something wrong?  Is there a better way?

I have clearly failed to understand the syntax of enumerated types.  Having
declared :-
Enum ACGroup
       A = 1

I actually have two scenarios that I need help with.  I have a form (created
and coded by someone else) that I am revising.  The form is set up with
columns of data and a corresponding button for each column that the user can
click to sort the data by whichever column is selected ...

I want to end up with a program that will create table tents for restaurant
tables.  I want to be able to have a form that will allow me to choose from a
list of different images.  When I select an image from a list of image files,
I want that image to be the graphic to be used ...