Search results

I commented out the error handler, and now my tells me that one of my form names is incorrectly named, which I've checked numerous times and that's not the case! The debugger runs to this line every time: The name is correct, should I remove the underscores or shorten it to help?

I switched the order of the If statement as indicated, but my error handler is catching the Run-time error 2450 (MS Access can't find the form "form name") when I run the command button. This error occurs even when the form is open! Would this whole command I'm trying to accomplish be better as...

The names on the forms include the underscores. I was told to avoid spaces in names when working with objects. I was thinking about shortening the names up regardless since they trail a bit too long. The DB I have is still in its development stages so there's room to improve :D

The If order pbaldy suggested makes perfect sense, but I'm getting my error MsgBox when I try to execute the button (Run-time Error 2450 - Microsoft Access can't find the form "frm_Batch_Deposit_WR" referred to in a macro expression or visual basic code). When the Parties form opens, the...

Hello, I'm working on a feature I'd like to include in my database that utilizes the IsLoaded property to check for an open form and complete an action depeding on which form is currently open. I have two forms, both of which can pull Party Information from a Parties table. My problem has...

Hello again folks, I've been driving myself up the wall trying to get this query to add both the values I'm after, but to no avail. Here's my dilemma: My goal is to add two values into a table; one from a separate table and another generated from a function. This is my SQL so far: Every...

After working on the problem for a minute, I came up with another solution which involved altering the beginning of the IF: This removed the extra message I was getting, but was the reason simply because I used the MsgBox call twice? And BTW, the other 3 scenarios were yet to be added; I...

Ok, so here's what I got based on vbaInet's suggestion (though I'm not done ruling Mile-O's out!) So, the MsgBox is being shown when the ID doesn't match A######, but a second MsgBox appears after strIncorrect that simply says "1" with a vbOKonly button. Is there some way to stop this from...

Hello, I'm starting out on a new database for my staff to create labels for correspondence folders, and I'm in need of some help. I have an unbound field that I want a command button to evaluate to check the field before moving onto the report. My first idea was to use a validation rule, but...

What I'm trying to do is create a new record in a separate table for each batch number. For example, a user will enter 30 records under one batch number. I'm hoping that each time the user begins a batch with that number, it is recorded into another table prior to the first record of the...

Good morning, I'm working on an application where a user would initiate a new batch number for a group of records in one table, but would send this new batch number to a parent table. This seems backwards and I'm not sure if it can be done. Is there any solutions that could do this? Let me...

I understand the process, but can you provide an example of how this might work? I'm terrible with VBA at the moment. Thanks again!

Hello, I'm trying to add a MsgBox to the On Enter event of my control, but is there a way to set it to run only once? Or does this always occur when entering the control? Thanks! Matt

Excellent! Thanks Bob!

Thanks Bob, In closing, should the following statement Me.cmdPrintNew.Enabled = Len(Me.Barcode & vbNullString) > 0 be placed in both the On Current and the After Update, or the Before Update event? Thanks again, Matt

Hello, I'm trying to write a simple If statement for my form that enables a command button only when a value is entered into the text field. This is my first guess: Sub Barcode_AfterUpdate If Me.Barcode = "" Then Me.cmdPrintNew.Enabled = False Else Me.cmdPrintNew.Enabled = True Me.Barcode...

That's exactly what I did. I noticed that when the Now Printing dialog box was being displayed. Thanks for responding so quickly!

Adding onto this thread... I recently just changed my PC at my office and I'm trying to use the same button in Access. For some reason, a Save As dialog box is now appearing prompting me to save as an *.xps format. If I click cancel, the run-time error tells me that the OpenReport action was...

Hello, I'm slowly getting used to the benefits of concatenation, but my question might be a tricky one that I can't seem to find an answer to. In my DB, I have a form based on a query from my main table that displays results depending on which employee the user chose on the previous form by...

Concatenate in a text box... What if you're trying to use fields not associated with the Record Source? I'm trying to concatenate a First Name and Last Name from my Staff table on a form that uses a query result. For example, I've tried SQL... =(SELECT FirstName & " " & LastName FROM...