I had 2 tables:
table1:                                             table2
stockno   qtyonhand                      qty_sales   customer  stockno
i want to create a form(sales form) that will issue to a customer. A form

How do I define a memo or data type larger than string in Access code?
Thanks.

How can I chang a subform's recordsource from parent form code?  
This doesn't work:
Me!<subform>.RecordSource = strSQL
Ideas?

Can someone please give me step by step
instructions for creating a continues form that shows
the results of a SQL query.

I have a main form that contains client data including a client number.  The
main form has a subform that contains test prices.  I have a default price
list and a special quotes price list:
rftbl_SQPriceList

Have in import routine that calls a number of sheets, how can I avoid an
error message if the file does not exist?
This is my code:
DoCmd.TransferSpreadsheet acImport, 8, "tblmamprospects",

I have created a form and am trying to force entry in each field.  Each
field is not to be null.
I tried entering is not null in the validation rule - but that only
works if the individual enters information then tries to remove it.

OK, I've got a form that works fine with the user selecting a combobox entry
that is required manually.
I want to set the default when the form is opened so you only need to do that if
the default isnt what you want.

I would like to be able to select an option from a combo box on a subform and
have the value show on the main form.
Also wondering if I can split a combo box between subforms and still
accomplish the above field fill-in.

I was using Access 2003 to develop an application and had a host of problems
with OLE server connections or Active-X server connections. So, I was forced
to go back to Access 97.
Now, what I have is that I have a check box which when checked a couple of

Hi all, I am new in using Access to get recordset back from SQL Server.  Here
is my problem:
I am using ADO to access MS SQL Server.  I also have a unbound form.  
Question is what do I need to do on Stored Procedure to return the recordset

Can anyone tell me how to retrieve the  [ autonumber] when executing a
Docmd.runsql statement on a table that has such a field.
When i do a INSERT INTO statement the autonumber is automatically generated.
But i want to use that number also in one of the other fields of the table...

I have a main form and a sub form based on it linked by SiteName.
In the subform I have two combo boxes for Supplier & ProductName. I have the
ProductName combo box based on the value in the Supplier combo box, this is
done by a query.

I’m having a serious problem with a combo box. I need it to tell me whenever
its value is changed. At the moment, I am testing its current value against
its .OldValue property. Problem is, the .OldValue property refers to the
value it held when the form was loaded, which gets out ...

I added a number of controls to an Access 2003 form. I then painstakingly
named each control using standard naming conventions.  IE change Command2 to
cmdGetRecords.  When I move from the form designer in Access to the VBA
coding environment, the names sometimes have the old ...