I have a situation here where I'm drawing pricing info from an AS400 into
Access that's being used to select components for a quote. The price info is
live so if a price change occurs on the AS400 side, it shows up on the Access
side. What I'd like to do is after a quote has been ...

I have a table that is linked to an excel spreedsheet. In the spreadsheet
there is a coloumn where the format is text (but there is a number shown). My
problem is that in access the datatype is set to number. I want the datatype
in access to be text. How can I change this in a ...

I have a form used to create an inventory of items.  Associated with
the form is a table of items that have been previously entered.  When
I enter an item that is on the list it automatically fills 2 form
fields; one with the item name and one with some additional info.  In

New Access user here.
I am looking to setup a simple query in Access.
I have a workbook with seven worksheets.  Each worksheet has one column of
numers on it, product codes.  Each worksheet covers a different product.

hey all, I fuond posted somewhere awhile ago where you can make forms any
shape (circle, polygon, etc) with some code.  Wondering if such a thing
exists for command buttons?  I have a help button on one form which brings up
a custom help form.  It has a circular help symbol on it ...

Is it possible to paste the content of a Word doc directly into a record in
Access?  I have designed the form and have a field where I'd like to be able
to past Articles - is this possible to do?
Thanks

I have a table with several foreign keys that are not required, but whenever
I attempt to add a record without the FKs set I get the error message "You
cannot add or change a record because a related record is required in table
'tblFoo'."  When the FK for tblFoo is the optional ...

I have two tables that have the same structure (as shown by the
documenter). I am trying to manually copy and paste a record from one
table to the other. I get a paste error 'The field is too small to
accept the amount of data you attempted to add. Try inserting or pasting

I am designing a database, after taken advice previously I have read up and
managed to normalise the fields in my tables.  I was however, wondering if
there is a way when an outcome is not achieved it automatically opens up
another form to record the variance, action taken and ...

I want to build an expression in  my table so that when I type a particular
City name, the zip code of that city will automaticall fill-in in the "zip
code" field.
How do I do this.  Please be very specific, as I am not an expert at

Need a business card, the same as the one appeared to edit and use my if it
is possible.

The users need to be able to enter numeric or alpha in a textbox.
The textbox Input Mask = 00\-00\-00;0;_
Example = 99\99\99
My database is linked to an SQL db.  The field is currently "nvarchar"

Good Afternon.
I need converters quattro pro 5.0 files, to Excel 2000.
Please send this file
Thank you.

I have a database that i have replicated and distributed to four different
users.  When i replicate the master the file bloats, and so too are the
replicas.
Question, can i just replicate the tables?  Is there a risk?

I have 3 tables that I want to relate/link.  When I link 2 of them, all's
seemingly good.  When I introduce that 3rd table, it messes up the other two
and doesn't work right itself.  Is there some kind of validation procedure
I'm supposed to do?  For what it's worth, the linked ...