Search results

Thanks Bob. Unfortunately, that doesn't work either. Copy-pasted code is SELECT Characters.* FROM Characters WHERE (((Characters.CharName)='')); Since this is the only argument, it should be the argument that's triggering the error. The AC2007 help says to use two double-quotes. But it...

How hard can this be? But I'm stumped. A very simple query that should pull up fields with zero-length, to be used in cleaning up the database: SELECT Characters.CharName, Characters.* FROM Characters WHERE (((Characters.CharName)="")); Running Access 2007, I receive an 'Invalid Argument'...

Seems there are a lot of opinions, and most of them are context-sensitive - the client's needs and demands and capabilities drive much of how each of us works. After all the competition in the software marketplace in the late 80's and 90's, Microsoft killed (or they died on their own) all the...

WOW!!!! I thought I was just being grumpy, but--- Simon, you seem to be a bit apologetic about 2007. Perhaps YOU don't use drop-down menus, but I've written a pretty complex database that has a custom menu for each major form, and it's for a reason- the menus are context-relevant and...

Perhaps I'm the nutcase here, but after avoiding the issue of upgrade for quite some time, i've finally downloaded a 2007 demo, and I cannot believe how #$@*ed up 2007 seems to be! Wow! I've been programming in this environment for 10 years and I cannot get a handle on WHY MS would make this...

At first I was very disappointed that I was not on the VIP list, but then I realized that I have contributed very little to this forum, especially in relation to the people you've put on the real list. Congrats to those of you who have put so much effort into this support network. As for...

Hey, Karma I apologize if I mis-read you here, but it sounds as if you're a beginner with Access, so: Welcome to Access. You are indeed asking a very broad question, so you will probably only get puzzled or broad answers. But you've got to start somewhere. My answer to your question would...

Thanks, Moniker, I appreciate the help. Yes, Google often has some answer, but I usually find the source of the help to be as important as the answers given. This forum has always been excellent, and I put more trust here than elsewhere.

You can do it with a query. The query can be set up to update every field you wish to. In the query design window, enter a colum for each field that you want to act upon. Enter your desired replacement value ("0" or "") in the Update To: row of each column. In the first column, enter "is...

I've been perfectly happy with Access97 and WindowsXP. But my laptop's circuitboards have deteriorated, and I need a new computer. I'm wondering what the real-world has to say about using Access 97 with Windows Vista. Does it run seemlessly? Please say yes. I have an application which I've...

If your form is based on a table, it's more difficult than if your form is based on a query. Try this: 1. Create a query which calls up all the fields in the table on which the form is now based. You can bring the fields from the second table into that query, linking the tables together with...

Is the Record Source for the report "above45" ? When you open the report with the docmd.etc. is the form "frmoverdue" open?

"If we insert state as AZ and run the query then query pulls records" How are you doing that?

Take a look in Access Help under "TransferSpreadsheet." It does most of the coding. As for choosing the target directory and filename, I use the commondialog directX control. I'm using Access97, and the CommonDialog control was only available with the Developer Edition Tools which was sold as...

Have faith. It works left to right unless forced otherwise!

I know how frustrating this stuff can get. It's driven me crazy, and this is how I ended up! I have found that it's important to have a way to trace a problem, then I can usually find where I've gone wrong. One thing you can do which will help you see where the problem is: 1. Change the...

Do you mean that the yes/no fields are not functional, but you just want to have checkboxes on the report? If that's so, forget using y/n fields, just place a label with a checkbox character from Wingdings font. Or, even simpler, two square shapes, one black, overlapped with one white with...

Yes. Presuming that your report is based on a query, simply filter out students who's switch is set to false. In the query, enter the yes/no field, fill in the criteria as FALSE, and un-check the SHOW box for that field. Then your report will only receive records who's yes/no box is set to...

I'm not sure this is an Access function, but rather a function of the printer (and driver) that you're using. I have a couple of different printers, and their drivers require me to set margins at specific minimums which the printers can handle. Each printer is different. In Access, you can...

I could be wrong, as I often am, but I believe you have an unnecessary quotation mark in your statement. It's right after acPreview, before the comma. Statement should be: DoCmd.OpenReport "Report Overdue", acViewPreview, "above45", "[state]=Forms![frmoverdue].[cbotext].[seltext]" It's...