Search results

Im sure this is simple but i cant figure it out. All i want to do is have a query that returns a range of values specified by a user. I have set up the basic query with criteria of [Enter length range] this brings up an inputbox and you can type in one number to query. What i want is for the...

Hi guys, Basically i have a form for used trucks, it all works nicely and includes a picture of the truck in question (OLE object). The problem is, the guy that takes the photos uses a digital camera (large individual files) and when each record/picture is viewed (.jpg format), it takes a long...

I have a form called EnterNewComponent with a combobox called NewComponentName (its control source is ComponentType (a table)). This is just one little form that acts like a dialogue box. If the user presses the delete button (called DeleteComponent) it deletes the table with the name that...

Hi guys, hope you can help... I have a form (CustomerList) with a combobox (CustomerID) which is the primary key for the table, and a whole stack of bound textboxes with their info in it.... I want the user to be able to select an existing record based on the combobox selection (i can do this...

Can someone help me with exporting a record from one table in one database (database 1), to a table in another database (database 2). I need it to run when a command button is pressed. I would prefer to perform this action from database 1 (to export it into database 2), but the reverse would...

Private Sub DeleteComponent_Click() Dim strTableName As String strTableName = NewComponentName.Value 'Value from a combobox DoCmd.DeleteObject acTable, strTableName DoCmd.RunCommand acCmdSelectRecord DoCmd.RunCommand acCmdDeleteRecord NewComponentName.Requery...

I am having trouble creating a table in access using code (vba). The fields required are ITEM|PRICE|UNIT|DESCRIPTION. The name of the table will come from an inputbox value.