I have here a small problem... I need the get the day-number of a date, for example from the date 21-11-2005, I need the value 21 in a variable... Is there a...

I'm wondering if there is a way to copy the menu line a made in one accesss file to another. When it comes to queries, forms, reports etc I can use the Import...

I need to sort this out today if possible as I don't have much time to work on it after that. I have set up a DB at work and each month we will receive data in...

I have a report based on a query that displays 3 fields. 1 is a number of items produced (A), the next is number of items destroyed (B). The last field (C) is...

I was trying to have some of my input in upper case letters. When I use the input code nothing happens. What am I doing wrong?

Hi All, I posted on the wrong thread, I am newbie to Access, any help will be appreciated. I have 4 tables: PROTO PROTOITEMS ...

Am looking for help in scheduling two teams of five (5) persons....7am to 3pm, and 3pm to 11pm...Mon-Sat. (Sundays off). Furthermore...of the teams of five,...

Hi, Thanks for organizing this great web forum, hope this will settle my problem. I've created a form with search command button with code; Me.Filter = "='" &...

Lately when I open a access data base I ge a window that says "Windows Installer and Prepairing to install" the message flashes on the screen for a few seconds...

Hi, i have a csv file that i import into my database. in one of these excel cells there is quite a lot of information and it imports ok into access. what i...

I need a way for one of my fields to change incrementally as new records are created. This field will always have 9 numbers max. It must start with todays date...

I want to be able to enter four numbers into the field and have the field automatically place the " : " for time stamp (i.e. 11:54) Six numbers into the field...

I WANT TO CREATE A DAYCARE FLYER WITH PICTURES ON IT WHERE CAN I FIND OUT HOW TO DO THAT

Hello, I'm fairly new to access, so I apologise if there is a simple solution for this, but I have looked everywhere that I can think off to see if this...

I've just started using Access 2003, teaching myself to use it with the Microsoft online training site and a commercial manual. I've spent days creating and...

-- thanks & regards, jd

Hello all. I have read all the posts I could find dealing with calculating age based on a start date. I can't find anything dealing with calculating age in...

My Access books do a pretty good job of telling you how to design and create a database from scratch, using lots of tables, primary keys, etc. I've found that...

Is there a way I can put a rule or something on field that is populated by the sum of 3 other fields to display an error if a max value is calculated?

I want to create a button or whatever on my form so when folks are done entering the required information they can click on the button and it will...