Search results

Hi Forum, I want to create a report to show the Status of items on a To-Do List that is in an Access table. I will base the Report on a Query. The Query has the fields dtReported, dtStarted, dtCompleted, and dtVerified (among others) that show what date each of these date fields was "checked...

Thank you very much. I really appreciate your help. Dave

Hi Forum, I have a table with a multifield primary key, made up of the fields "Plant" and "Code". Plant is not unique and neither is Code, but both combined provide a unique key. In the VBA code below I have referenced "Plant" (see the part of the code that I have highlighted in magenta)...

So easy! Thanks very much. Just tried and it works great. Cheers D B.

Hi Forum, I have some code (see below) that merges fields from an Access database form into a Word template. It is in a VBA module and works well. I want to be able to run it from a button on the form. I have set up a button on the form and want to be able to run this code from the button's...

Hi, I have a form (with a subForm). The main form shows Equipment with the Equipment Number being the main (key) field. I can use the record selector to click through the records, one by one, and then add information about the relevant piece of Equipment and use the subForm to assign Tests to...

No, there is just an Originator name (Joe Jones) that is the Primary Key.

Hi, I have a “Complaints” table that has a field for the originator of the complaint. There is also a table for Originators. There is a “Complaints” form with a Combo Box where the originator of the complaint can be selected from the drop-down list or entered into the combo box, if not already...

Hi, I am building a database that will be used to assign multiple Test Forms to items of Equipment. There is an Equipment table, a Test Forms table, and an Intermediate table that contains the Primary Keys from both the other tables. I have a Form that consists of a Main Form that displays the...

That has given me enough info to solve the problem. Thanks very much. Dave B

Hi, I have a Form that shows "Equipment Numbers" and a Subform with a Combo Box where "Equipment Tests" can be selected. There is a table for Equipment Numbers, a table for Equipment Tests and an intermediate table TestsToEquipment, where Tests can be assigned to Equipment. When I try to...

I had a gap between my letters in "Approved" just noticed.

Thanks, Works very well! The only thing, I found I had to add the brackets [ ]. Thanks again. Dave B

Hi, I have a field called "Approved" that has a check box. When an item is approved the check box is ticked. I have created a report that has a column of check boxes. In the report footer I have added a Text Box and set the Control Source to =Count (*) to show the totals number of rows in...

Hi Forum, I need to enter the Equipment Code "FO" into a form and Access keeps changing it to OF! It is very frustrating... Excel does the same. Does anyone know how I can enter FO into a form without having it change to OF? Thanks very much. Dave B

Thanks a lot. After playing around a bit I got it working using: Me![subformTestEquip/FIC Subform].Form.AllowDeletions = True Thanks guys Dave B

Thanks. I tried the code: Forms![formEquipmentType]![subformTestEquip/FIC Subform].Form.Allow Deletions = True but I get a message "Application defined or object defined error". I appreciate the tip on not using a slash in the object name, also. Dave B

Hi, I have a combo box and have set "Allow Deletions" to "No" in Properties. I want to be able to allow the user to delete records if they press an "Allow Edit" button. Can I use VBA code from a button's On Click event to change the "Allow Deletions" setting to "Yes"? I tried the code...

Thats it! I set the Focus to another control in the subform as you suggested. I had made the mistake of setting the focus to a control on the form. Thanks very much. :) Dave B

Actually, I just noticed I still get the same problem later on. After enabling the combo box with the "Edit Profiles" button and making some changes I would like to make it read only again with a "Disable Edit" button. When I try this I get the same problem with the message "Can not...