Search results

I figured it out. Thanks anyway. This is a great site.

I have two tables, one for categories and one for records. I have sorted out the active records. But I only want to see each category once. Right now I see the category for each active records. What I am looking for is a list of categories that have active records in them.

Question 1 My Main From (continuous) Opens from a password form. If there are no records attached to the Employee it opens correctly. If there are records for the Employee then an Error Message opens stating “Reserved Error”. Any suggestions? Question 2 (same form) My Main From (continuous)...

Yes, the program is in was 2000 and is now 2003. How do I add the reference?

In access 2000 I used the statement Dim conn as ADODB.Connection. In Access 2003 I get a ACompile Error: "User-defined type not defined." How do I correct the problem?

I have a query of records that are not related to records is the secondary table. I want to delete these records but when I select the records and click delete I get the confirmation to delete answer to delete them and all the records disappear. When I run the query again, all the records are...

I see know that I can put getdate() and user_name() in the defaults of the fields to get the results I want.

I would like to record the username of the creator as well as the time the record was created (seperate fields). I have a trigger to record the last editor but that runs for each change. Is there a way to create a trigger to only run when the record is created?

How do I set the field so that you can only enter one of 3 specific letters?

Clarification I want to remove the users ability to print.

How can I make a report read-only?

I have coded a button to populate a text field with a few sentences. However, the last sentence needs to be separated from the the others by a return. How can I add this to the code to get a return in the text field?

My form has a memo field. I can type in the filed and use Shift+ Enter to move the cursor to the next line or a new paragraph without leaving the field. The user often enters the same data in the filed but not always. I want to be able to give her a button that fills in the memo field with the...

I tried this but it updates all the records in the database. I only want the approver to update the records that have been queried and displayed in the form.

I have a continuous form that opens all of the records for a specific user on a specific date and displays them in a continuous form. Each record requires an approval check box be marked before it can be processed for reporting. I want the approver to be able to click a button and mark all of...

Thanks, I tried using the example but i still get error 2465 Application defines or object defines error. The subform is a continuous form is there something I need to be doing to cause it to use the selected record. Correction. That error was caused by a naming problem. Thanks for all the help!

Each record in the database has a subform (one to many relationship) with multiple records. When the user clicks on a record in the subform I want the information from the subform and from the mainform to go into a Word document. I am able to pull the data from the main form but not from the sub...

Well, several of these methods worked. However, when I compact & repiar my database or run code to turn off the shift key on startup. It stops drawing the field information from the form to go on the report. muppetmad

I have a combo box that worked fine. Now it will not show any records after the 65530th record. I can remove a record and it will show the next one down so it appears to be a setting that controls the nuber of records shown. Any suggestions on how to show all the records would be great. The...

I hae a button on my form to open a report. However, I get all the records in the database when I only want to see the report with the current record from the form on it. How do I narrow my report?