Recent content by BigHappyDaddy

Sorry, but no links handy. But I believe it was Delaware county and Montgomery county. One was directly west of Philadelphia, the other was north. Another (possible) is Red Bank, AL. But I have NOT researched that example.

Not to sound like a know it all a$$, but I (quickly) did some research and there are a few examples of same city names in a single state. Seems that Springfield, PA exists in two separate counties. Lots of other examples that are very similar, but not exact.

No one is forcing you to implement any type of solution. But a question was asked and members of this forum with years (if not decades) of experience have offered solutions that will undoubtedly save you hours/days/weeks of frustration in the future. Remember, we all started out just like you...

Why not just two if statements? If Left(Me.POLICY,1) = "R" then Me.POLICY = Right(Me.POLICY,len(Me.POLICY)-1) if Left(Me.POLICY,1) = "0" then Me.POLICY = Right(Me.POLICY,len(Me.POLICY)-1) This will remove all occurances of any leading "R", "R0" or "0".

What is your complete SQL statement? What is your actual results? What is your expected results?

Not sure if I understand correctly, but you can change the Height of the form footer, but where it appears it determined by where the detail section ends. So to have the footer appear lower on the screen, increase the height of the detail section. Does that make sense?

I haven't seen anything like your issue, but if it works on some machines and not others, I would *guess* some kind of setting difference. Maybe try stepping through the code on a machine that is displaying the problem. That might provide more clues.

Welcome and good luck!

GLese said: Ditto. This forum became my go to reference, when I realized that my problems were not unique. You just have to find the correct thread! Yorky (Puddles), 2 Chihuahua mixes(Baby and Bella) and a Lab/Husky mix (Buddy).

I was surprised to read this only because in my previous workplace, pass through select queries were MUCH faster than the same query in Jet/ACE using linked tables. Especially on larger tables (100,000+ records per table). Am I misunderstanding something when comparing pass through queries...

Well dang! Well, I am with Mark, you really need to step through using the debugger to determine where your code is going sideways. If you are able to debug and find out something useful, feel free to post again if you are still unable to solve it on your own. If anyone else is able to...

Ok, I *think* I know what is going on, but I need you to confirm something for me. Make the following changes to your PrintReport code: Dim fn As String Dim Path As String msgbox "ReportType = " & ReportType Select Case ReportType Case "1" I believe there...

First, I think you really mean "form" and not "report", but the concept is the same. I am not sure what report or form you are referring to, but here goes... For the field in question (The Project or Project?), the control (combo Box or text box) is referencing the record ID. You want it to...

I don't see it either. All the PrintReport procedure is doing is opening a file and setting bookmarks. I as assuming you are expecting the selected report to be written to the file? Do you have a separate procedure to do that?

I have just started looking at it, but already found something unexpected. When I manually open the form "Print Reports" and click the "Print" button, the value that gets passed to PrintReport is "3". A string, not a number. But your Select Case statement is based on text words like "Power"...