Recent content by HarmonyGirl

I saw that several people viewed my post, but no one responded. That is OK ... I found what is causing the problem, and since I am a software tester, it was a very exciting find! At my job, we have 2 printers: one is an HP 4100 and the other is an HP 8100. When the computer is set with the...

Hello, Here is the background on my issue: * I have a database that I have been using for a while, with a cadre of reports. This database (and all reports) was developed in Access 97. This database is split into a front-end / back-end configuration. * I have successfully converted this...

If I understand your request correctly, I have a suggestion that might work for you. If you reverse the logic, and alert the user if they have not entered time for that day, that might be more intuitive. If you take this route, insert this code into an Event Procedure on your form's On Open...

Thanks for the quick reply! When I added this code to my form, it works ... except it changes all to italic, and then when I reopen the form, all selections in the field remain italic. I tried adding similar code to the form's OnCurrent event ... what am I still missing? Also, I'm thinking...

In my Access 97 database, I have a form with a combo box that allows you to select an employee. In my Employee table, I have a Yes/No field called Active. This field value determines whether the employee is employed or has left the company. In records assigned to inactive employees, I would...

I have never successfully done this, but I think what you need is in the Solutions.mdb sample database that comes with Access. Check out the example titled "Create a listbox that allows you to select and manipulate multiple objects." HTH, and good luck!

Are you using the Expression Builder to build a query on which to base your form? When I was first learning Access, I once changed the Record Source of my form to an inappropriate query, and all my controls (linked to fields no longer correctly represented in my query which was now the Record...

If you have the Solutions.mdb sample database, I think the EditProducts form has the example you're seeking. If not, post again please!

After some minor struggles, I borrowed and modified some code to get this to work on my database. I am also a software tester, and my database is a bug tracking database. I use this email code to access (and populate) a report, to notify developers when they have a new defect. I checked your...

It sounds like you might want to use a report vs. printing the form itself. It also sounds like what you want is to select a value in a combo box, and based on that value, have other fields automatically populate. I've successfully used 2 methods to do this. One method is described by Jack...

Open your form in design mode. Double-click on the FORM property window. On the Format tab, there is a property, Record Selectors=Yes (by default probably). Change this to Record Selectors=No. You might also want to look at some of the other properties in the Format tab, such as Navigation...

This is the code to use on the OnNoData property on the Event tab for the report. I found this code on another post in the archives here, and successfully included it in my database this morning. ' This code displays a message box to let ' the user know there is no data for report MsgBox...

Thanks for the tip! Could it be b/c of landscape vs. portrait page orientation? I found that the portrait was significantly faster. What could I do to still use landscape?

Being the ambitious newbie that I am, I debugged and designed my first report. This report is a project status report, and has a condition where the user inputs the project prefix against which to create a new report. I should mention, this is a very simple report, and there are no calculated...

Make a copy of your database first, for safety's sake! Then, delete all records from your database, and Compact your database. This should reset the Autonumber field.