I'm moving to new e-commerce platform and I need to modify the way I
store my products.
My current layout for products in multiple category:
sku|category_id

I have a table with 250 fields. Of course you are wondering why 250
fields... what could I possibly be storing in so many fields?
I am using this table as a general import table for files that vary
based on user selections. The input files are CSVs and can number from

I am familiar with the issue of missing references but I have a
situation that is new to me.
I have a split fe/be system.  A copy of the fe is on the server which
is then copied to each user's PC using AutoFE.  This has worked well

I'm not a fantastic Access developer, but I'm trying to help get
Inventory and whatnot organized at work. They are used to 5 year
budget plans that list out exactly what has to be purchased what year
and how much it will cost. Currently these are kept in Excel and look

'add one textbox to form1 with Control Source property = ID
'copy/paste the form_load code below:
'Then open the form and then attempt to sort the datasheet
'crashes 2003, error 3450 Access 2007 - I can't find much info on

In a database I am developing, I have a listbox with contents that
change per record that is being displayed.  TO do this, the first
thing I tried is to change the rowsource via SQL in the forms current
event procedure.  This resulted in an error that i haven't seen

I wonder if someone might be able to help me please.
I'm fairly new to MS Access, and everything I know is self taught so please
bear with me.
I have put together a query which consists of a few fields. Some of  these

I've searched and found the following code on this forum to send a
single email to a list of people that is contained in a table. The
table is "CustTable" and the list field is "CustEmail":
Dim db As Database, rs As Recordset, sql As String, emailTo As String

I have a multi user database and users were created by user level security
wizzard - as I mentioned in message before. Everything works fine for those
users, but now I have another problem. I have another database with linked
tables from secured database.

I'm using the code below to loop through the XML response from a web
service. What I want to do is to use the rows returned as a recordset
for a continuous form. The data does not need to be editable.
This is being used in an ADP but I don't want to write the data to a

Hi I created a databse system but i have a problem figuring out how to
create some tables / relationships....
The part of the systems that i am having problems with is the
following i have a person (person table) that a specific date & time

I'm creating a report that will present information split into several
sections with each section dealing with a particular aspect of data.
No problem there. However, one of the sections will contain
photographs which I need to snake across and down the page. That's

Hello friends,
I'd like to know how to get all my vba code from an access 2002
application (.mdb).
I want to send it all to a text file and then compare it to my older

I work for a warehousing company. I was hired as a Customer Service
Rep. My boss wanted me to redo some old Excel worksheets so I
suggested converting them into Access databases.
I have now created 8 seperate databases and numerous Excel

SELECT tblProspectsNCDMVdealerList.DealerID AS ID,
tblProspectsNCDMVdealerList.DealerName AS Company,
tblProspectsNCDMVdealerList.Contact AS Contact,
tblProspectsNCDMVdealerList.DealerAddr1 AS Address,