Search results

Hmmm...but what if you an additional technician? Or fire one and don't replace her? You'd have to redo your form. Usually, this would not be done with buttons, because of the maintenance headaches. But, if you insist, one idea is to not use command buttons at all, but make nice little boxes...

The cheap and easy way out is to make two versions of the query. One uses the [entered desired selection] parameter, the other retrieves all the students. Then you put two buttons on your form. One says something like "Selected Students", and runs the parameter query, while the other says...

I have usually avoided the Access security and done my own. Quite often, in my security table for a system, I'll have a field called "security_level" or something like that, set to maybe "A" for admin users, "U" for update users, "R" for read-only types. All users log in exactly the same way...

Maybe something like this: IND_TABLE, with IND_ID as the key, and Name, Address, Phone, anything describing an individual and which they only have one of... GROUP_TABLE, with GROUP_ID as the key, Group Name, similarly, items describing the group MEMBERS_TABLE, with GROUP_ID and IND_ID making...

Don't do it. A basic rule of database design is to not save anything that you can recalculate from the record. I KNOW it sounds like a great idea, but the answer is still don't do it. What will happen if you store a calc, and then the user goes into the record and changes the value of one...

The correct way to do it is to break your single table into two separate tables. One would be the member master, and have the member ID and stuff like name, gender (items which the member hopefully only has one of). The second table would have a key that contains two fields, the member ID and...

Create a query that joins the two tables, save it, then build your report on that query. Here's a hint. Create and save that query, then you may be able to just change the control source of your existing report to the query, instead of the table. Add the new fields & you are done.

If you just run the query, does it still take as long? If it does, I would look at each of the underlying queries and see what you can do to speed things up. For example, let's say that the purpose of all of this is to create a sales report for a period of time (starting date to ending date)...

I can answer part of your question. Yes, you can certainly schedule Access to open using a variety of schedulers. I've used three different ones over the years. The basic idea is to set up a macro that will run your code, then (in this case) shut down Access. The batch scheduler then opens...

Working without my own notes, I think that you need something like this: Dim strNotes as String strNotes = Now() & " " & me.Notes [Forms]![MyMainForm]![Other] = strNotes

Well, there's probably a better way, but why not make each section a stand-alone report, then always run them together (either in code or with a macro)? That way, you'll always start each "section" on a right-hand-side page. If page numbering is a problem, maybe your users can adapt to a...

Hint: When you are testing the report using Rich's method, keep the form open (can be minimized). Otherwise, you'll get a prompt for the text field & it won't look like it is working.

Well, the cheater way is to create a summary query just to do totals & create a new report based on that (can be formatted just like your other report). This is especially useful if your users want the summary page on top, as mine have.

Forgive me if this is a dumb question, but have you just tried setting "Hide Duplicates" to Yes? Remember, too, that you can use sorting & grouping, but have no header line, just put everything in the detail.

I've had success combining the label and the data into one text box. The Control Source looks something like this: =IIf(IsNull([MyField]),"","Something Nice: " & [MyField]) Make sure that you set Can Shrink for this text box to Yes.

In your original post, you have this code: Like [Stock Num]+"*" And Like [Stock Num]+"*" Why do you have the Like showing up twice? Are there other criteria in the query? Try building a form where the user enters the criteria, then hits a "print labels" button. Get this form, query and report...

Let's assume that the two fields in your Orders table are "ID" and "name". In your report, is the Control Source for the text box where you want to see the name, actually set to "name"? If you don't see the "name" field in your field list (go to "VIEW", click on "Field List"), then you need to...

First of all, make a copy of your report and the query underlying it to play with... then try this: 1) You need to add another field to your query so that the query contains the actual name of the order, not just the ID. I don't know your table setup, but you may need to do a join to get to...

Actually, I think that you are getting the message boxes in the right order. Are you certain that you have all the setup correct? It's really easy to forget a step. If you are certain that you have the OnPrint set up in the detail section of your labels (and not anywhere else) and the...

Don't know if this is pretty or not. Let's say that you have a form that contains the date for your variance report, and a button to kick off the report itself. Couldn't you write a query that would only find the current budget records, as of that report date (using group by to get the max...