I am trying to port a database from LotusApproach to Access. One of the features of Lotus is that one can click find, is given a blank form (much like filter...

I have a text field that opens another form on the DblClick event. In the event there is more than 1 record in the form, I have the following code: If...

Guys can anyone help me out with my problem: Basically I have a form that displays records from a CUSTOMER table based on this query: SELECT...

Hallo Is there a way you can disable the X to close access so it can only be done by a EXIT button on a Form i know you can disable the ones on the forms...

I have a form w/ 3 bound fields and 1 unbound. We use scan guns to enter barcodes into access. all scanning in done in the unbound field and based on a...

Ok, here's one for you guys that should cause a few heads to be rubbed. I just got this database dumped on me by my boss that a previous employee created....

A signed paper form helps to verify that the person who signed authorizes or approves of what has been entered on the form. Is it possible to perfom...

Hi everyone. I have a question about Access, maybe someone can help. Here is the thing: I have 3 fields in a form, all of them on the same table. One field is...

Hello, I have a field called 'contracts ID' and some 'products' each for every contract. I want to create a combo box with a list of contracts and when a...

I have several forms that access the same table or queries based on the same table, therefore with the same field names. I have the need to run a macro with...

Hi all, DanJ's code below was originally used to hide/unhide controls. But I have tried to modify it to unlock controls and to change fore color...

I have two main forms that each have a subform. Both forms are based on a one-to-many relationship between the main form (1) and the subform (many). Based on...

How do I get a form to stop allowing new records off of a query? I still need to be able to edit the query results in this form but do not want a new record to...

Hello Folks: Here's an example below of what I'm trying to do: Previous months comp total $100 (1) Fund Date Comp Credit 722A 3/1/05 $1.00 (2) $101.00...

Hello gurus, I have developed a form that has two fields that are related in one of my databases, process and control number. For each process, there is a...

List Boxes should support transparency just as most other form objects do.

Dear members, be patient I am a begginer. I have a form wish shows me past events and future ones (we have different events through the year), but everytime...

Hi, I 've got a table with some records. In one of the fields there's a date, I'm trying to get a query wich gives me a selection of records with...

I created a simple form to add data to a table and things were going fine until today. I noticed that anytime I entered data into one of the textboxes, a...

I have designed a form that in one of the fields i have built an expression that figures the total cost from two previous expressions on the same form. So...