Search results

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?

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.

So a month later I have another question. I'd like to add a piece that causes the worksheet to place the active cell at A2 and remove applied filters when the timer hits. I tried inserting this piece of code, but it doesn't do the trick: Sub EndProc() ThisWorkbook.Close True...

Well, for some reason it appears that Access won't compute a blank cell with nothing in it, so I defaulted any unfilled cells to 0 and now it works!

No. That's where you go wrong. I bolded that statement. While the argument is also a secular one, our Founding Fathers believed that life, liberty, and pursuit of happiness were inalienable rights, given to us by God and that government has no right to interfere with them. Only God can take...

How were these things created? What's the truth, and what's parable? What are the deeper meanings? Science helps to explain part of this. But even to the secular scientist, unraveling answers to questions only results in more questions. Hmm, I don't recall saying nor implying anyone did...

And still no one can seem to find anywhere stating that I believe ra** was "ok". :rolleyes: Who is a "Bible quoter" here? My reasoning is A) a line of reasoning most people don't stop to consider, and B) a secular line of reasoning. In my opinion, government doesn't belong legislating who...