Search results

I have a footer on many of my reports that indicates the date the report was last revised...but what it actually does is show the date the report was last printed. Since the report relies on a parameter query, and thus changes often, I doubt this is possible, but I was wondering if there's any...

I am currently trying to learn how to program in VB and I'm stuck. Here is the code I am trying to work with, but my calculation doesn't work, when I click Calculate, I just get $0.00. Any help would be great!!! Thanks! Option Explicit Const mcurRate As Currency = 12.25 Dim...

I think that I need to use a table or record-level validation, but I can't seem to get it to work: I have two fields: Tribe and Organization. Any one person cannot have data in both fields, therefore I want to set it up so that the user can't enter data in both fields???

Thanks, Jack, That was one thing I had thought of, I was just trying to get around having to remember to do more data entry than we do already. another thing is that one of the key staff that use the database to generate reports only has read-only access to the db, and she would have to email...

I have a report that generates nametags, and we save nametags from one function to the next and try to reuse the ones we can. It would be great if I could use a parameter query to filter out the folks I have nametags for already. Is it possible to set multiple parameters on the same field...

I have an unbound text/list box that uses a SELECT FROM statement as its record source. It is basically a search results form from the user entering first and last name, but it searches for either instance (first or last name), so if I enter "John Williams" it gives me all the johns and all the...

is the field displaying the #error referenced correctly in the report?

Is it possible to make a specific record (in a form) grayed out when a field "Active?" is designated as "inactive"? I need to keep the person in the db for tracking purposes, even if they are no longer an active participant.

Why do you need both forms open at the same time if they're displaying the same information? Couldn't you just use one form, and if it had to be separated, use a button or some macro/module for distinguishing records to add or records to edit? Or you could just have it go to a new record for...

...meaning, that if you tried to find which records are in tblX, and not in tblY, try running the query the other way around; find which records are in tblY and not in tblX.

Perhaps you should store the "rented" value in the Transaction Table. Otherwise it sounds like you might need a way to relate the Book Table and Transaction Table by some foreign key. Then you could query them together to display the information.

search this forum for more information on "populating" or "automatically filling in data" on forms. There have been many posts here on this topic, most of them offering the same/similar response. good luck

I actually print forms when an average db user in my office just want's a person's contact information (which is what the form displays), then they don't need to know how to modify a query and report, etc. So it is of use sometimes. What I've done to prevent the gray background from printing...

What you need to do then is use a report (with the query as the recordsource) and adjust the grouping options to get what you want.

I know I posted most of this question in macros the other day, but I got no response, and I've added info to the problem. Hopefully, someone has something for me...thanks! Here's what I have. )> A macro that essentially directs Form1 to >Save 1.OpenForm2 2.FindRecord based on matching ID...

Can anyone help me with this code? I want to add a new record to a form, but I'm getting a syntax error with my code. Also, do I need to use the Update method with NewRec? DoCmd.OpenForm ("CONTACTS", acNormal, , , acDataModeEdit, acWindowNormal, DoCmd.GoToRecord [,,acNewRec]) Thanks!

Also make sure that your field labels are not in the detail of the report (if you are including labels)...they should be in the appropriate section headers.

Well, I guess, first of all, make sure you are calling your fields correctly. I see that you have "actionassignedto1" in the Private Sub line, and "me.[action assigned]" in the code. Make sure your field name (and not just the control source) matches what you call in the code. Secondly, I...

You might check out my post from yesterday: http://www.access-programmers.co.uk/ubb/Forum6/HTML/000281.html The part that works for me should work for you, though it uses a macro, you should be able to just do the open form/gotocontrol/setvalue actions to where your ID fields match each other...

See this thread and reply if you need more direction. http://www.access-programmers.co.uk/ubb/Forum4/HTML/000258.html