Search results

Rich.... that gave me an error message saying "there was an error executing the command"... It shouldnt matter about the blank entry... ill just have to make our salesmen understand this... lol... does anyone have a large stick so that i can beat it into them? (No offense to any salesmen here...

thanks Jack... i felt embarassed asking that question... lol if the user types in nothing, is there a way of showing all records?

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...

on that topic... how would i go about doing the insert picture thing (on the ole object) in the on double click event.. eg: the user double clicks on the ole object to bring up the insert object dialogue. ben ps: for now i told the guy that does the pictures to cut them down in size... it...

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...

thankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyou worked like a charm! weeks of hair pulling has ended!

Private Sub DeleteComponent_Click() Dim strTableName As String On Error GoTo Err_DeleteComponent_Click strTableName = NewComponentName.Value 'MsgBox strTableName DoCmd.RunSQL "DROP TABLE " & strTableName 'CurrentDb.Execute "DeleteComponentTypeQuery", acEdit 'Delete table...

yeah i have tried a delete query... it would never delete the right record! Could you help me with one? I can set them up but the Condition is where it falls down for me I think... actually choosing the right record to delete!

Didnt work.... The code I have for deleting the table is... ------------------------ Dim strTableName As String On Error GoTo Err_DeleteComponent_Click strTableName = NewComponentName.Value DoCmd.RunSQL "DROP TABLE " & strTableName ------------------------ Ive tried a delete query, and...

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...

Mendel... my observation (this stuff is way over my head) is that you have the \x with the wrong /.... (Hope im not way off) ben

Thanks Pat... I have a combobox (CustomerIDLookup) and a textbox (CustomerID) set up as you said... The combobox selects the records ok and the textbox displays the value ok... I need some help with the rest tho... I want the combobox displayed in the same position as the textbox... eg so...

no no... not the not in list... if the user chooses an existing customer from the combobox, it updates the form with that customers information...(part 1) if the user types new customer information into the combobox, it creates a new record.. thanks for the link tho... I will use it for...

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...

Thankyou!!!!!!!!!!!!!!!!!! Greatly appreciated.

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.