I am using access 2000. I created a query that pulls info from 4 different tables. I am trying to create a report that lines up the related records, ACROSS the...

How do I set up a database for my books, cds and dvds? I am using Microsoft XP

Morning All, With the help of ppl here to create a crosstab query below, and a lot of messing about I have been able to create a semi functional timesheet for...

Can a field be set to 'index-duplicates ok' by using a macro? Thanks,Kat3n

My fields that contain a general number round to the nearest whole number. It is only the fields that contain numbers, the fields that contain dollars will...

If I export a query from the Access file menu to an Excel spreadsheet and check the "save formatted" box, the resulting spreadsheet has gray labels, one...

I have a table with about 12 fields. Whenever I add a new record at the bottom of the table, it goes to the top of the table until I close the table. If I am...

I have a database, the back end is in SQL server and the front-end (forms, Query's mudules) is in Access. I will be distributing this to my client who will...

Hi group, Access 2000 win xppro I can create a command button that will open a file based on the data in a textbox. The textbox displays 1234 and clicking on...

With Access 2000, I can't seem to move selected controls (i.e., field, field labels, buttons, etc.) with the keyboard arrows. In Access 97 I used to do that...

How would I create a splash screen to appear for 3 seconds then load up my login form?

I currently have a table that has arrival and departure times formated in the general date format. In my query I would like to subtract the two dates and only...

I downloaded the File Picker routine from Ken Getz: http://www.mvps.org/access/api/api0001.htm and put it into my database. this is called when the users...

help, how to stop access from rounding up values you enter in a table? i enter this 458.59 and access changes it to 459.00. I have the format set to standard...

¼ìÄê¤ý, ¦ÊÅܬP§g, r102030r, ¥§¶ø·s¤B 4 ±ø¥´¹v¥J.

I keep getting the following error message...FUNCTION IS NOT AVAILABLE IN EXPRESSIONS IN TABLE-LEVEL VALIDATION EXPRESSION. I realize this is too vague for...

I put together a 8 pg. newletter for a non-profit. No web site. Can I somehow share work capabilites? Pub.2003. with another pc? email? or what. I am really...

I have to secured databases and i am trying to link tables. no matter which one i am trying to link to even if i am loged into both using teh admin account i...

Hi, I have two tables I am working with. One (table 1) includes 444 zip codes, and each zip code is assigned a region code. There are 7 region codes for...

How I can carry power point's downloads designs template to a computer that no have internet? I have access to the internet only in the university and I want...