We have an access database on our server. We recently installed a new server. The links in the split database from the front end to the back end all reference...

Microsoft Office Evolves Community as Part of Office 2010 Launch: As you know, this is a big year for Microsoft as we are launching the latest version of...

Is there a way to do the following? The scenario: The “Animals� database contains the “AnimalsInfo� table. tblAnimalInfo contains the “AnimalType�...

hi may i know if we are allowed to modify te sample northwind database and use it in our small usinesses

I thought it best to start new from the thread "Items Table help" that I originally posted. Original Post: I have a photography business that I am setting...

For an example, I have been using MS Northwind example. One problem I have run into is adding the same item twice in an order. I am keeping track of time in...

I have a date/time field in a table for which the format is general date. The default value is Now() which returns for example 4/27/2004 12:31:10 PM. How can I...

Hi all, I have Table "T_Data" in my database. In "T_Data" I have 220000 records. I need to export them into txt files. I need some kind of macro which...

I have a registration from that has numerous fields and would to like if the register this year pull all the fields from old over to new db - I can either...

I am using the lookup wizard to create a lookup column using an existing table within my database however I get an "automation error". I can get as far as...

Hi, I am trying to locate the expressions: IIF, Count, Sum, in the Expression Builder window opened through Validation Rule in TableDesign. (Access 2002...

I would like to be able to pull one word from the drop down box in a form or report and it pull up that person's information. Is this possible?

I have two different ODBC tables and as a result of a make table query I'm trying to change the Data Type on both tables to read "text". One table already...

Hi All. I need to send a "patch" to a remote user to replace a form in an Access 2007 application. The code behind the forms of that database has been locked...

I have a table with an autonumber that I need to start with the number 20801. Access help says to change the New Values property. I don't see that property...

I was just finalizing a good and working database so i tried using the startup option directing it to startup on the switchboard manager form i created.I must...

Hi All. I have created a standard report as a type of template. Users can access this report in layout view and change label captions, positions of fields...

Hi, I have a RESPONSE field on my table. This field is set up as a text field (I do not want to change it due to specific requirements)- however, I'd like to...

Sorry, I was assuming you knew how to write Access code. You will need to create a VB function to perform this task. I don't have much time now as I have to go...

I have been reading all about the evils of lookups in tables, however could someone please explain how you avoid using them - is the answer to have many tiny...