anybody have a VBA routine to rename tables after an a link to SQL that gets
rid of the "dbo_?"
tia.

Hello in a field there is data in which comma seperates words. For example:
John Smith, male, Athens.
What I want is the last word in the right of the last comma (in my example
the word "Athens") to be cuted from that field and be entered in a new

I am very new to Access and I'm having a spot of bother.  I have created a
form and on it a button with an "Add Record" action.  When I press this, it
does not add a record in the Datasheet view. Should it? If not, could anyone
give me any tips please? I thought that a form would ...

I'm a brand new access user (2003) trying to follow the tutorial at
cisnet.baruch.cuny.edu/holowczak.... When creating the sample tables (bank
customers and bank accounts) I set the customer ID # as a primary key. Now,
when I go to enter account information for customers that ...

Can anyone tell me how to set up an autonumber on a form (I'll hide it)
please? I would also like to know how to make this my primary key. Any
suggestions?

Please help. I have a form with combos. A button that
adds a new record with the ff code DoCmd.GoToRecord , ,
acNewRec.
When the add new record procedure is started, I do not

I receive a weekly csv report containing "package-level detail" for FedEx
shipments.  The reports contain 36 columns and, on average, 50,000 rows.  In
the past I would import each report into one table in Access.  The problem I
would run into is that the table would become too ...

Hi quick question - Are the same newsgroups available via microsoft's web
based newsreaders as those available through news.microsoft.com?
For example, I can't seem to find the  'general questions' group from
Microsoft's site through the news.microsoft.com server.

Last night, I opened Access 2003 for the first time on my machine.  I
created a table with several columns and added a row of data.  After I
closed the database, I was then able to go to write a web page with ASP.NET
which connected to the database and displayed data from that ...

I am trying to create a query structures the following date:
[problem] [problem_sub_type] [description] [date] [total]
problem1  subtype1                  blahblah      jan      5
problem2  subtype1                  blahblah      jan      12

I am working on a new access application that uses access as database.  It
will be a multiuser app (12 users).  I thought I'd keep the data mdb in a
windows share directory and the forms/reports, etc in a separate mdb either
on each local machine or also on the server with the data. ...

I'm trying to get my Database to at least 3NF.
How important is this to someone who is relatively new to Normalization?
Also, I don't quite get what is meant when each table is supposed to
describe the real world? Could someone explain this for me please?

Okay, thanks in advance for your help w/ this:
We have been given a copy of an access db for use at our place of business.  
A similar but non-competing company gave us the db, which they either
developed themselves or had someone write for them.  We are not able to open

Sorry this could get a bit long, but I think the history is important.
We have a company database, originally constructed using Access 2000.
This is split with the front ends being almost entirely on XP boxes and the
back end being on Win2003 Server.

I created a form in access by creating my textboxes and naming them as I
created the form instead of creating the database first and then bounding
them to the form. Right now I can't scroll through my records on the form
even though I can enter new records and save them to the ...