I hope someone can help me. I've been working on this database for week and the more my customer requests the form does, the more I realize I may have set...

Hello, Hoping someone can help because haven't been able to find info online, and it's driving me crazy, and please bear with me thru the background info, as...

Hi - I have a field in a table which simply inserts the current date and time using the now() function. However this is now based on the server is the Us...

Hi. I'm doing a project with Access 2007, but the version probably doesn't matter. I'm building a database for a business that keeps track of customers,...

I have a access data I'm doing a mailing went into (report) and (labels) put the zipcode comes out as "123456789" instead of "12345-6789 any idea the (input...

Hi IN a table design is it better to have the Validation Control set to Is Not Null or the Required Control set to Yes, if I want to force someone to enter...

Hi, in a table I have ytwo date fields. i want to put a validation on the second field so that it cannot be earlioer than the first field. is this possible...

Hi i have created some very simple tables in Access 2003. I then needed to provide versions of these tables for our students who are running Access 2000 and...

Hi, Is it possible to set a table fields properties to undertake a dlookup, and if so where would I put the syntax. i know how to do this in a form, but this...

I want to use the autonumber as a serial number, but need it to start at 1005. is this possible please? Thanks A

Hi I am trying to change the field type in a table, from text to Number, and I am getting an error message saying that I need to delete relationships first. ...

Hi, is it possible to set a Text field to Yes or No, I dont want to use a check box Thanks Alex

Hello, In my table called (DataImport) I have a field called "ReceivedDate" I get a data dump from our AS400 system, which I export into the table. My...

Hello, I have a problem that I am trying to resolve and I need some professional tips. I am developing a front end database (queries, forms,...

Hi, I am using Access 2002 and I am trying to put accounts numbers in a field call account number, the only problem I have is that I am unable to put 017108,...

I am wondering if someone can give me an elegant solution regarding importing data. I am getting daily CVS files that I would like to import into Access 2000....

Hello. Just came across some stunning discovery, my database of customer complaints seems to be working fine, BUT when I open access file and enter 1st...

How to capitalize the first letter of every word (for names)? Thank you in advance

I have some records that I need to add a Visio drawing to. The drawings are stored within an OLE object. It works fine. However I need to be able to set some...

Hello everyone, I have a question regarding ID's and masking them. I am designing a DB where we entre information on people who attend our annual meeting. My...