Search results

That worked like a charm. Anyone else have those days when you just feel like an idiot? Thanks for the help.

I have an odd situation. I am trying to program a combo box to select two different sets of criteria depending on the value in a text box on the form. For example, when I open up the form, it is pulling in a Manufacturer name from another form based on the Equipment ID. But if the equipment...

If I were to get certified in SQL Server 2008, would I be able to apply that to our current SQL Server 2005 databases?

Yes, I am doing that for some databases. However, the ones I am currently having a problem with are not split. I'm having a different problem with the split databases.

Let's go a different direction. What about incompatibility with Novell? It seems the trouble occurs when I am accessing a database on our Novell network. When I copy a database down to the local PC, no problems whatsoever.

I did not install Office 2007 in XP mode. I just took the standard install. Would it be worth trying to uninstall office, then reinstall in XP mode?

Yes. (10 character limit reached here.)

This is the 32 bit version. Could that be the problem?

Bob, I have SP2 installed. Rainman, the stopping and restarting of the print spooler didn't seem to have any effect.

Any time I open any database, it immediately gets a 'not responding' message, then just sits there for quite some time.

I'm having the same problem with Windows 7 and Access 2007. They just don't seem to play nice.

Forgive my ignorance, Bob, but how do I check for a specific error code?

When I delete a record on a form, I want the form to go to the previous record. This is no problem except when the record I want to delete is the first record. How do I check for that?

I am looking into getting certified in SQL Server. Anyone have any good advice on where to start, what kind of books or training to acquire, etc?

I need to reopen this discussion. Ray, I'm not sure how to make your idea work in my case. I have a form with multiple listboxes. When I open the form, it displays the records and of course the first time, no choices have been selected in the listboxes. When those choices are made, I need to...

I believe I have it. I needed a space between the quotation marks in the If statement. Thanks for all your help.

That doesn't work either. I know I've done this before, but I just can't remember where and how.

No, the code is not working. Anywhere I put it, it either generates an error or the field shows up anyway. The label is not linked to the control.

No, it is just a simple report. I have a field called Other along with the corresponding label. If there is nothing in the field for that record, I don't want the field or label to show up. Obviously the field won't show up since it is empty, but I don't want the label to show up either. The...

I get the good ole "You entered an expression that has no value" error when I do that. And there is no OnFormat event.