Search results

I created a search form that searches for Customer Number, Part Number, and Revision Number. The results are displayed in a List Box. I want the user to be able to make a selection on the List Box and click an "Open Selected" button that launches that record in another form. How is this possible?

From the DoCmd.OpenForm, I added the Forms("frm_BevelInfo").AllowAdditions = False Then on the click button, I did: Forms("frm_BevelInfo").AllowAdditions = True DoCmd.RunCommand acCmdRecordsGoToNew Forms("frm_BevelInfo").AllowAdditions = False I'm not sure why that didn't work in the...

It's been 8 years since I've taken a Visual Basic class and I'm a bit rusty. Just starting to use VBA for a db I'm designing. I have a multiple items form with a tabular layout. When this form is loaded, it filters in only at a few select records. At the bottom, I added a "Delete Button"...

Wait I figured it out.

Why am I better off using AfterInsert versus Current? (like I said I have used VBA in 8 years) I tried this: Forms("frm_BevelInfo").AllowAdditions = True Forms("frm_BevelInfo").DataEntry = True DoCmd.RunCommand acCmdRecordsGoToNew And I get the following error: Run-time error '2046': The...

I have frm_Parts with a button on it that launches frm_Bevel. frm_Bevel is the form I want to hide the New Record row, and it is a multiple items form that has a tabular layout. So the OnCurrent for frm_Bevel info has the following code: Me.AllowAdditions = False I also have an AddButton...

VBA is the next two chapters in the Access book I'm reading. Maybe I should go ahead and read those chapters...

I set an embedded Macro to the command button with the following: GoToRecord -> Object Type: Form, Object Name: frm_BevelInfo, Record: New SetValue -> Item: [PartNumber], Expression: [Forms]![frm_PartDatabase]![PartNumber] SetValue -> Item: [RevisionNumber], Expression...

I have a form (frm_Parts) where the user will input part number, reivision number, and customer number and the record of that part comes up in the form. If this part has a bevel operation, a button with "Show Bevel Info" appears. Upon clicking that button, frm_BevelInfo is launched in a new...

So I am creating a database (Access 2010) that shows all the parts my company produces for various customers. Each part we produce will have a unique combination of Customer Number (number the company assigns internally), Part number (number customer gives us), and revision number (number...

I have begun desiging a database for my company that stores information about parts we produce for our customers. I am relatively new to Access and am using Access 2010. Sometimes customers parts have dimensions given in inches, while other times they are given in millimeters. I would rather...