Search results

BINGO Works like a charm. You are a life saver. Thanks a HUGE amount, I have been beating my head on this one for days now.

Something is off..... Here is what I have: SetTempVar Name count Expression = InputBox("How Many Copies?") PrintOut Print Range Pages Page From 1 Page To 1 Print Quality High Copies count Collate Copies yes RemoveTempVar name count Nothing prints. The question is...

I understand that the print dialog box is more powerful. There in lies the problem, when the print happens it is critical that the user not be able to change which printer, forms, etc.... I am looking for the InputBox() in the macro functions but cant find it. Is it a macro function or do I...

The are using the runtime setup and do not have access to the code. There is also a lot of things on the PrintOut that I fill in to control the printing. Thus unfortunately have to get the number of copies as a inputted variable and supply it to the macro.

I have a macro that asks the user for a number then prints a report based on that number. What the end user has asked for is to print multiple copies of this report, with the ability for the user to say how many copies. I am using the OpenReport followed by PrintOut. There is a field for...

Hey Paul, thanks for all your help, everything is working slick right now!! How do I flag this thread as "Solved"?

Well added the () to the end.... Got farther.. Now got the error Invalid use of the Me keyword. Highlighting the line: PrinterNumb = Me.Copier As for posting, would not work, there are external databases involved also.

Changed to function, got the same error message. Was a good shot....

I can try that, how would I do that? Do I just change the header, or do I need to copy past into a function?

Yes it is under the modules section off "All Access Objects" in a container called MainCode. Have all my global VBA code in there. Have another button on the 'Main Menu' which calls a procedure that updates one table. This modulal is different from the first in that it is getting data from an...

Think I have it... Now I am getting a different error.... When I push the buttom I run a Macro that does the following: Set Warnings On No OpenQuery NextNewBarcode RunCode NewPartWorkOrder OpenForm PartsWorkOrder SetWarnings On Yes The VBA for NewPartWorkOrder is in the main module and looks...

Thank you! You have 100% proved my point. Americans refuse to take responsibility for their actions. What if the robber was not a robber, but someone who stepped into the wrong house by mistake? Maybe in the USA, the family of the victims should use the wrongful death suites and sue the...

Very true. We all remember the Columbine school shooting. What most people do not realize is that the major employer in the area is Colt Firearms. Need I say more....

The house most likely to get broken into is the one with the best stuff to steal. the house who's ocupents are more likely to be shot? the one with the guns. the robbers will shoot before the home owner does. Question, since robbery does not carry the death penalty. if you shoot and kill an...

I am sure this has been asked a million times, but I cant seem to find it. What I need to do is press a button on a form. When the button is pressed, I want to create a new record in a table not already open and populate some fields with data from the form I am looking at. Then call up a new...

Lets look at the murder and gun death rates in the two countries with the HIGHEST number of guns per person. Switzerland and Israel, murders rates are extremely low (Not counting the civil war in Israel) What is different? Well training, personal responsibility are way way higher in these two...

Does the Me. part change too? I am working on something like this also. Basically need to change a text box to red if a flag is set.... Sounded easy when I started :banghead:

Ah, I see where you are going. Think what I am doing is easier (I hope) there are no forms in play. Just one table. What exactly is going on is: There is a table of Opening/Closing ballances. There are two logical fields ACTIVE and EXPORTED. When a record is created ACTIVE is True and...

Have written a few VBA proceedures. Still very green tho, most did programming in Fortran, Visual Foxpro. Not overly familular with manipulating Access tables in VBA. Is there a chunk of code I could work off of to get syntax correct. Thank in advance.

I have a table it contains a list of opening and closing values along with a date and a couple control fields. What I would like to do is duplicate a few fields from records that meet a criteria onto the same table. After that is done there will be a few updates on the new records. Looking...