Recent content by connie

Thx again...ok so I unhid ctlpkNumber on the Parent subform and changed the def of IntPK to: IntPK = Forms![frmPermitEntry]![subfrmPenetrationData].Form![ctlpkNumber] And I still get "Run-time error '2455': You entered an expression that has an invalid reference to the property Form/Report"...

THANKS for answering! :o Yes, there is a pkNumber field in tblInspectionData. You're right about the IsNull...I modified my code per your advice to: Private Sub Form_Current() Dim IntPK As Integer Dim x As Integer IntPK = Forms![frmPermitEntry]![subfrmPenetrationData]![ctlpkNumber] x =...

Well, I thought that worked. Unfortunately the more I was working with that subform I found random instances where the default value # is totally off. Like starting off at an 8 when there's no matching child fields. So I'm back to trying to set it up in VBA, and I've tinkered it to...

I'm still not sure I figured out the answer to what was wrong with that syntax, but I've managed to work-around by using an expression instead (which I was doing initially but then ran into a snafu and had decided to switch it up). If anyone's curious, here's how I'm now auto-incrementing...

This is driving me insaaaaane. :eek: I've spent the better part of the day Googling variations of this and nothing I've found has really helped. I have a subform that is based on another subform inside a main form (so 3 forms total). I want to do a DMax default value in VBA to autonumber...

Awesome, thank you! Unfortunately I just finished renumbering a ton of them manually, but I should have more later today or Monday and I'll update this thread with how that goes.

Hi all...just wondering if this is not possible to do? I just Googled "renumber query access" to try and research more on my own and the first result was this post. :o Hopefully we can figure this out so if someone in the future wants to know how to do this there'll be answer on this post...

Thanks for the response, Vassago :) Nope, it's not tying the data together - that is done by a hidden Autonumber primary key that's unchanging. The answer is a long one, I'll try to make it short. There are numbered items that need to be inspected. If one fails, I'm told "#5 failed" and...

Hi all! I have a bunch of tables that have numbered data (but not Autonumbers). Oftentimes line items need to be removed. If I have to remove #50, for example, I then go back in there and re-number everything from 49 on manually. Is there an update query way to do this that I might tie to a...

Thanks...wow that's complicated. It's also the troubleshooting for a parameter query, which mine isn't. All I want to be able to do is have the query exported to Excel with a command button...is there a simpler way to do it? I want the spreadsheet just to open with the query data pasted in...

Thank you. I just tried your suggestion but still get Run-time error '3061' Too few parameters. Expected 6. :(

I have a form with 6 dropdown fields that feeds into a query. I want the query to be exported to Excel if the user selects that option via a command button. I am however getting the error: Run-time error '3061': Too few parameters. Expected 6. I'm assuming this is because the form itself...

Thank you...no, it still does the same thing. Looks perfect on screen but prints with "#Name?" However the detail of the report prints fine. The code is written to close the form & query and bring up the report, and I'm wondering if this has something to do with it...because if you tried to...

Hi, I have a form with combo boxes, and when the user makes their selections and clicks the command button, it feeds into a query and opens a report based on that query. The report all works fine, except this. In the header of the report I put fields that are supposed to show what the user...