Search results

im haiving problems with the update statement. There is nothin in ghelp i have this but i keep getting told that i have a syntax error. Am i going about this the right way? UPDATE [tblTest].[Melt ID/Tube ID] = '1324A' WHERE [Melt ID/Tube ID]="DONE";

Ok one more question... How can i select a field from a database and relace whats written in a the field using SQL (i really have no clue about databases and SQL) Thanks again if you help me.

Thanks for that colin. Im glad you pointed that out - im so used to working with VBA in excel i sometimes forget that there are differences. Thanks again Chris

thanks for the replies (Both of Them) I have a query to copy a row and insert it in to another table depending upon a result selected from a combobox. The method you suggested works fine if the saved query has a number in it instead of "& combo0 "&. (is thjis the correct way to do this? I...

How can a query be run in VBA code? I have q query which transfers data from one table to another however i would like the code in VBA. is this possible? Thanks for any replies given.

Is there a query to copy an entire row of data in a database?

Is it possible to add data to a combox selection. For example i would select a number from a combobox. Then select a number that would be associated with a checkbox list and for that number to be added top the end of the figure in the combox. I hope this makes sense thanks for any replies given

This is difficult to explain so please bear with me. i need to select Si from the table below. At present the user has to select assy = 1 and notes = 2 to get Si = 1111 to be displayed (Comboxes in a user form are used to select the data). The SI data is entered in to a spreadsheet. If...

Just out of interest i thought people might like to Know that this code populates ca combox with a list of table from a database using VBA. 'Populates the combo box with the tables from a database 'declaration of variable Dim strDatabasePath As String Dim oConn As Object Dim oTable As Object...

Is is possible to search a table to see in a fieldName exists using VBA?

I have an error message telling me an Item not found in collection. The item is present in the database howver. I have tried the On Error Resume Next function however this prevents the error message but still does not gfet the data for me. Does anybody know why this message occurs?

thans for the replies. It did the trick.

Im not too good at all this query stuff as i havent worked with acces/Databases too much so please bear with me. I have the following query in VB which selects data depending uon a selection in a combo box. How can i make the query Distinct (i think this is the term) ie: to display values...

this is probably asy so forgive me for wasting your time (im not an access/query expert) Is it possibly to count the number of rows in a record that contain a certain number? field1 1 1 1 3 3 3 4 4 4 eg i could return something that lets me know there are 3 rows contatin number 1 etc...

thanks for that ill give it a try.

ive tried what you have said and i still get eh errors. This is really annoying. if i change the title so thatit has no _ in then everything works fine. If you are really bored then heres is the code. Thanks for the reply tho. Private Sub CommandButton1_Click() Dim dbs As Database Dim rst As...

is it possible to populate a combobox in a user form with a list of table taken from an access database?

Thanks for the reply. If you dont mind explaing. How would i go about doing that?

i have q uery within VBA that requires a user to input a Table Name via an input box. The query fails if the name contains a _ (underscore). Is there a way that this can be over come?

This is hard to explain so ill try my best. I hope it makes some sense Is it possible to sort my data depending upon the number of entries in a table. For example i would like to sort the data below depening upon the number of entries in field one i would to display data Where Field = 20 and 3...