Search results

I am designing a report in which I have a column that is for "Total Listings" and this "Total Listings" number is the "Sum" of some other entries in a form. The "total listings" shows up fine in the report for each entry, but when I try to total the "Total Listings" at the bottom of the column I...

Thank you! There it was right in front of my face. Do you know how long I looked at that without see it ...

On the main access screen, on the right side where you choose what datebase file you want to open, under "Open a file" I am only given one database file to open, and then a yellow folder icon, next to which it says "more files." How can I get the menu to list more than just the one file under...

How do I turn off auto save? I don't want the form to automatically save as I move from form to form. I want to be prompted to push the "save" button. Thanks.

Thanks Jimmy. That worked perfect. I was trying to export the file I wanted to the new datebase, instead of importing to the new database. I appreciate it very much.

Joe657 I have a data base which has five files within that data base. I want to take one of the files and put it into a separate database with a different name so that I can e-mail it separately from the others. How do I do that? It must be easy but I have spent hours trying to figure it out...

I enter a sale price and then in another field, a percentage commission received. I have another field that automatically calculates the dollars received based on the commission. This calculated amount shows on my form, but not on the table, and therefore it does not show on my reports. Why is...

Thanks Jack. I am using Access 2002, have you used this latest version with no problems also. I'm just wondering if 2002 was redesigned so that it works better with Windows XP.

I am currently running Windows 98, the first version. Before I started using Access I very rarely "locked up." But now, after installing and using Access, I get very frequent crashes of the Access program, not my whole computer just Access. It says it is very sorry but it is shutting down and...

Excuse me again. It does work when using a filter but not with Find and Replace. It seems odd to me that it would work with one but not the other. Anyhow, thanks!

Oops. That doesn't appear to work. I am writing it in the Find Box like this you said <> Y, but nothing is coming up. I have tried it with other fields as well and it does not work. What am I doing wrong? Thanks.

Thank you NAGYL for the very fast response. I just went to the bathroom and when I came back there was the answer. Now that's what I call fast. Say, is there a list of those searching formats somewhere in the HELP files for Access. I looked but could not find one, but I know there must be one...

I am trying to search a field for a letter that does not equal Y. I have tried various methods such as /=Y, and Not equal to Y, etc. But nothing works. How is it properly inputed, to find a letter that is not equal to Y but does have a letter in the field, in otherwords it is not empty. Thanks.

So that means sending a series of keystrokes in a macro is not really something that can reliably be done? So don't spend a lot of time on it, because even if you do it right it won't consistantly work the same? Is that what you're saying Rich? (Enthusiasm is ebbing to the point that my wife has...

Okay. Made progress. What I wasn't doing was saving as AutoKeys. So, I know how to assign a key or button to one of the selections in the dropdown menu. But I am still stuck on creating a macro of a series of keystrokes. What I have tried is first making a new macro with the keystrokes I want...

Thanks Oldsoftboss. I have that exact same help page already printed out, sitting next to my keyboard. I have been working on it for hours but can't seem to get it right. But now that I know that that is for sure the correct place to be finding answers, I will give it another go and let you know...

I want to run a simple macro. Like a series of key strokes. Such as, Go to a specified control, enter a number or other character, save, and close. I want to assign a key to the macro like ALT-P, so that when I hit ALT-P the series of keystrokes in the macro will run. I have searched HELP in the...

Duh . . . Pat, there is one thing you must remember when responding to one of my questions, I am very very very dumb. I can just see you thinking to yourself now, I can't believe he took me literally and put in [ParticipatedField] . . . oh well, please excuse my ignorance. I have now done...

Okay Pat, see if you've heard this one before: "I did exactly what you said but it didn't work." Well, I probably did something wrong, but after I did what you said, and then clicked on the Run Icon, a box pops up which says, Enter Parameter Value and then in smaller print below that it says...

You're right. It sounds like a lot of work. Too much for this Access rookie. I recently imported the data from a DOS based program, (Q&A) which I have been using for over 20 years. It is a great program but is not supported by Windows, so I reluctantly made the switch over. In Q&A I just did a...