Search results

I tried to make appropriate changes where I could (some information comes from other databases in the company which I can't change), but I still get the same error. Here is the modified code: SELECT [Generation table].[Ship to], TblShipTo.[Name], TblShipTo.[Street Address], TblShipTo.[Street...

I've built a query that executes flawlessly and displays all the information I need it to. However, when I want to display information from that query on a report, I get an error stating that "The specified field '[Ship To #].[Street Address Line 2]' could refer to more than one table listed in...

I am still having issues with it -- I put that right in the code for the OnFormat event, and it refuses to do it properly. Am I maybe missing something, or is there a better way of doing this?

It still seems to be doing the same thing. :( Is there a way it will allow me to use the nz function to specify a value, and then use that value to allow the blank line to display and make the text box invisible?

Hi, I wrote some VBA code which looks at a value in a textbox, and if it's null it will display a blank line. However, it doesn't work properly with null values, only if I substitute actual values, which I want to avoid if at all possible. Here's the code: If Me.Year = Null Then...

Awesome, everything is working perfectly now! :)

I agree. We should have equal treatment under the law. As far as other "rights", well, our Founding Fathers identified certain inalienable rights -- life, liberty, and the pursuit of happiness. They felt that these were given to us by God, not the government. Rights granted by the...

It is slightly too large to post here. Could I send it? Is there something I should be looking for here that I'm missing? I've found I learn a lot simply by doing.

Well, that's what I've tried, and I keep getting run-time errors, so I'm not sure what I'm doing incorrectly. The run-time error I get is '2465' and says that Microsoft Office Access cannot find the field 'l' referred to in your expression. Here's the modified code: Private Sub...

The problem with governmentally-provided healthcare as a RIGHT is that it creates a worse population in the long-run. People who expect something as a "right" then expect the government to provide that "right" with what is, in this case, a tangible good. If government doesn't kick in, people's...

So after some playing around, I found the code was for if there was a checkbox on the Report itself. So, the good news is this code works. However, the issue I'm running against is that checkbox is on a form, not the report. The form records to a table, and the field that the checkbox records...

I keep getting run-time errors. I try to change the "CheckBox" to "Check21" and "Textbox" to "Field1" so it matches what's currently setup, so I'm not sure why it's spitting run-time errors back. Am I inserting the wrong values into these code formulas?

Awesome! So I put that in the report code to execute, correct?

Okay, I found it. Would I need to compile code for this? I can do some coding when it comes to queries, but I'm not sure what I'd need to code to pull this off. I still have a lot to learn, and I appreciate your help. :)

I'm sorry to sound ignorant, but where do I find this? When I go into properties for the form's checkbox I want to control, I don't see a detail format event. Am I looking in the wrong place?

Well, it should not display that textbox, which normally gets populated from that query. At the bottom of the form is "Generate" button, so clicking on the check box shouldn't trigger the report to generate or anything else until "Generate" is clicked. I'm not quite sure how to get this to...

Hi, It's been quite awhile since I've had to post in here; I think I have the general hang of Access down. However, there's one thing I am struggling to figure out right now. I have a form in which people enter information that runs a query and spits the results out in text boxes on a...

Just curious, as these sorts of printers are a bit different than a regular printer. If Access could print out to a Zebra Thermal printer which uses continuously-fed labels, that would be awesome.

It's disturbing that so much power has rolled up the federal ladder of power. Most of the laws we have on the books at the federal are unconstitional per the 10th Amendment.

Not only did they vaporize, in the ultimate irony the baby boomers adopted and exacerbated the very things they supposedly were against!