John Wilson I read your code on updating a form in increments of 1 however i must be doing something incorrect as I get Run Time Errors. I have a group of...

My .csv file contains dollar amounts with no decimal point and leading zeros: $100.14 is 000010014. I would like to import this into a table and convert them...

Hi I'm quite new to this and I could need some help, please. I'm trying to create a database with information about fees and opening hours for...

I have a table that needs to hold the monthly grade of our members locations. There are 6 aspects to this grade. Now, each inspection will always give a...

HI There, I'd like to have a defult field in a table to display the number of "Yes's" in the other fields of the table. Is that actually possible? or do I have...

I am starting a new db to track hydraulic fittings and inventory. I want to do it right, from the start by having it normalized, and not quite sure what I am...

I am playing around with an old database in Access 2007, and thought I would use the Analyse Table function. So I had it to analyse one of my tool type...

I was trying to make my database more efficient so I ran the "Analyze Table" database tool. I chose my "tblContacts" table and drag and dropped the "AD...

Access 2003. access 2000 database format (have also tried 2000 and XP...) I tried to run Analyzer, as I have many times, selected some tables, set options,...

I created a database based on one that the office already had. There is one table that contains everything instead of several tables therefore some...

hello, whe i connect database file with office word (mass correspondence) all date change from DD/MM/YY to MM/DD/YY and i need the form DD/MM/YY (in word)....

Hi All. Any suggestions how I can insert animated clipart into a form. When I insert the clipart as an image it loses its animation. Thanx in advance --...

There's a bug in Access where the Autonumber reuses old numbers as the primary key. According to Microsoft, this bug was supposed to be fixed in the latest...

Okay, I have an annual calendar set up to track employee attendance which Duane Hookom (thankfully) pointed me to on the Hook'd on Access page. Now there are...

Hi all, I'm hoping that my tables are normalized properly, but I'm stumped on a particular layout and design structure. I hav a table with faculty, which...

Some of you might recognize this project, since it has been over two months that I have been struggling with the design and I am still not close to being...

In my efforts to customize, I messed something up. In the original form, the Assignments subform of the Classes form will let you enter a grade for each...

I created a database to log correspondence topics at work. Each entry/issue is assigned a unique log number. The number is a combination of things. Example:...

I have 3 excel files to import....there are 10 fields..there are duplicates in these excel files. But what constitutes a duplicate is that field 2, field 5...

I've been working on this for some time and have yet to get what I need; I'm working on a db to keep track of art shows I apply to and attend, there are...