Hi. I have a numeric field which increase with each record ('1', '2', ...). However, I want '1' to appear as '001'; for that, I went to the field format and...

Hi there I'm trying to enter a records into a form on an Access 2000 database and every now and then it comes up with a message that says: "Bookmark not...

I posted the following (see below) a number of months ago. The response I got back then was to make sure that the reference to Microsoft DAO 3.6 Object...

I am using Access 2003/Win xp pro/ SQL Server 2000 I have a form in my access project that doesn't seem to work properly. I am using a combo box to select a...

Hi; It is time to overcome this obstacle. Have an sfrm, (datasheet), that records what a customer purchases; both inventory items and services. The user...

Hello, I've created an Access ADP (2003) that connects to a SQL Server 2000 database. On one of my forms I use a button to create a new record (company)....

How do I save the postion a user is on when a record is deleted from a Detail section? Here's the problem: if the Detail section has a large number of records,...

Can anyone tell me how I can not get an error using bookmarks in a word document if the field has no data TIA Les

Hello everyone, I have noted how experienced many of the users here are, and I was curious as to any books you would recommend to a intermediate user....

Hi i have 6 access books and all books have only 1 table insert them. but i want to see all that 6 table in a source, how can i do that?

Hi, I'm looking for a detailed book on forms and reports. Is Paul McFedries' "Microsoft Access 2003 Forms, Reports, and Queries" good? Any other...

I've created a field in two different tables called "GroupCode". It's defined as a number, field length byte. In my Labor DB, I set the field to a value of...

I have a subform which contains a boolean field. the subform is generated by a query which is reloaded after certain fields on the main for are updated. The...

I am using A97 and trying to set the border color of several controls to specific colors. I set the color of the combo box borders as blue in the controls...

Hi! I'm trying to migrate to Access (2000) Got a database that has images associated with records. Use a form to step through the records. (There are only a...

I want to get rid of the thin borders. But of course the form then looks silly. Setting the special effect to "raised" doesn't do anything at all either. Does...

I hope someone can help me with this alignment snag I've run into. With growing or shrinking Text Boxes with VBA code, I would like for my 4" fixed-height...

I'm using Access 2007 and I can't seem to find the menu item to do a simple thing. This seems like a silly question to me, but is there a way to add a line to...

Is it possible to create a list box that fills from bottom upwards? Cheers

What is a bound item, why is it bound and how do I know when I need it or not? Thanks very much, -F