Search results

Thank you; that worked perfectly!

Well, it needs to be controlled off of a form where. 20 was an example, but if they enter 4, 15, 52, etc. it needs to print off that many automatically. How would I be able to accomplish that?

Hi, I have built a tool which allows for people to create multiple placards for shipping. All placards have the same information on them, except for the quantity. Each placard represents a record, and is deleted once the placard is printed. The critical piece is that the records are...

The records are just for the session to generate a report for printing. They then would all be deleted, as there is no reason to keep this data.

Well, I have an Autonumber setup now. One thing I'm wondering is how one goes about telling a record to repeat itself a certain number of times. IE: a person has 5 pallets they'd like to ship out, the record should be duplicated 5 times, with the only difference being the Autonumber...

Well, basically, what should happen is that someone enters the number of Pallets on an order. When the report is generated, it should print off which number in sequence it is and the total number of pallets. There's most likely got to be a way of accomplishing this, but my creative thinking...

I'd like to display the record numbers and how many total records there are on a certain report. IE 1 of 15, 2 of 15, etc for every record that is displayed on the report. How do I allow this?

Well, this form is specific to a plant. All the plants use a standardized placarding, except for one which uses a different report (though the underlying table still uses the same information. When that plant is selected from the initial form, a new form pops up using the following bit of code...

Well, I have it set for that, but it doesn't always do that. The first time a person goes back and tries to edit it always takes them to a new record. The second and subsequent times they try to edit it behaves as expected with the cycle property set to "current record". This is thoroughly...

There will always only be one record in the underlying table. Basically, the form is used to generate reports. Once the person is done, the data in the table is deleted. When the report is generated, I have a command button which should allow the person to go back and edit the information in...

I have a form that when opened needs to always default to the first record of the underlying table. How can I get it to do this?

Hi, I have a dropdown combo box which allows users to record values to a table. However, I have one value in which I would like a different form to pop up immediately upon selection. How would I go about doing this?

It looks like that will do what I need it to do! Is it possible to make it apply to specific columns without it turning into an expression? I can make it an EXPR if there's no other way, but I'm trying to avoid re-writing the entire query as it already contains many expressions.

I was wondering if it's possible to interpret blanks as zeros? I have many fields which then use expressions to tally them up. I need to use the val of some text fields. There are also number fields which are multiplied by the val in the text fields. I find that if I don't place a default...

I was wondering if it's possible to interpret blanks as zeros? I have many fields which then use expressions to tally them up. I need to use the val of some text fields. There are also number fields which are multiplied by the val in the text fields. I find that if I don't place a default...

It still seems to run without stopping. Here's the code using value instead of Formula: Range("C65536:C65536").End(xlUp).Select ActiveCell.Offset(1, 2).Select ActiveCell.Value = "XXXXXXXX" ActiveCell.Offset(0, -4).Select ActiveCell.Value = "XXXXXXXX" 'POPULATE PLANT...

What would I use to make sure they match up?

And what has Obama done to improve the deficit and turn it around? Oh yeah, he wants to spend many times the amount Bush spent and raise the deficit even higher! :eek: Someone please tell me how this is better? You can't blame Bush and then try to "fix" the problem by doing the same things...

Hi, I'm having some issue where a Do Loop is blowing past the point when it's supposed to stop. Once it hits a XXXXXXXX it should stop, but instead it keeps running until it hits the maximum of Excel records. I pasted the code below. Any ideas? Sub DRP_DOH_Report_Formatting()...

Bob was awesome! Always very helpful and patient.