I would like to set the caption of a report to a value in one of the fields in the report. Is this possible and if so how can it be achieved? Thanks

Hi, Have looked for this in the forum but with no luck I have two fields in a database 1) Form_No (example value "FT001") 2) Time_Of_Call (example...

Hello, I am creating a new table and my client wants it to have a hyperlink to a file (PDF, DOC, XLS) on the server. Once the link is clicked on, it would...

Albert, Enlighten me if I am confused. His user is using a different FE, hopefully on his own computer. Since he is opening the FE, wouldn't his .ldb files...

I have an off-the-shelf app that uses an Access database as its backend. One of the tables contains a field with an "OLE Object" datatype. I'm writing some...

I have a subform which has several combo boxes on it. The first combo box provides the name of a product. Each product has several grades. The products are in...

-- A basic user who would love to be able to know more

I have a sets of questions I want to answer on different pieces of equipment and I am not able to figure out how to relate the tables to one another. I have...

I believe your problem has to do with record locking. Check your settings in Tools-Options-Advanced Default Open Mode should be Shared Default Record...

We are using Access 2003. We want to do a mail merge using multiple tables. Is this possible ? Thanks

1. If a user can choose multiple items in an listbox, how can I save that information in one field? I don't want to create a yes/no field for...

One to Many Relationships Employees (primary) Daysoff (secondary) i chose Option 2 with referential integrity entered one record to Daysoff report reflects...

How to make a Rounded-Corner command button to become a sharped 90 degree-corner command button? Thanks in advance Kennykee

I am designing a database for trades. The following is what I have so far…. Trans_ID is the primary key and is just an incremental...

I have developed a project in ms access 2000 (frontend and backend), after 3 months i am getting the error unauthorised database format, my database 15 mb now,...

Is there a way to connect a check box, so when I put a check in it, it automatically fields in the date with the current date ?? -- "JR"

I am creating a table, under a field type I chosed mumber, and under that I chosed standard and under decimal place I chosed 2. And I have saved the changes....

Do you recommend SQL statements, in the RecordSource property, or a saved query? Any particular reason? Thanks.

Hi, I have a field in a table where users enter the time a task took. This is entered in minutes, such as 90 minutes (1hr 30mins) The field is currently a...

when Open my access data base I got this message ( unrecgonized )