Search results

Thanks Peter Of course testcountval.movelast It works a treat Cheers

On my form I need to choose and compare the primary keys of two tables. As I select each table and field a textbox COUNTSOURCE builds a SQL statement (basically a duplicate query). If I pass this statement to a como box all the records are listed, in my case 72 records. How could I actually...

Thanks reclusivemonkey so simple I missed it.

Does anybody know if MSCAL.Calendar.7 can be set so that Sunday shows as the first day of the week instead of Monday.My company uses a timesheet with a week begginning on Sunday. Thanks

No worries I used this: Err_Command0_Click: Select Case Err.Number Case 2110 Resume Exit_Command0_Click MsgBox Err.Description Resume Exit_Command0_Click End Select End Sub

Hi I run a bit of VB on the click of a command on my main form, the last instruction is: Me![frmLoadOLE].SetFocus Me![frmLoadOLE].Form![cmdLoadOLE].SetFocus This is to set the focus on a command button on a sub form. The commands on focus then runs more VB. It is a bit messy but all...

Carl I amended your advise to Dim myRecs As DAO.Recordset Set myRecs = CurrentDb.OpenRecordset(lsttables) tblsamp.ColumnCount = myRecs.Fields.Count tblsamp.RowSource = lsttables.Value Beautiful!! Thanks Chris

Carl I amended your advise to Dim myRecs As DAO.Recordset Set myRecs = CurrentDb.OpenRecordset(lsttables) tblsamp.ColumnCount = myRecs.Fields.Count tblsamp.RowSource = lsttables.Value Beautiful!! Thanks Chris

I have one list box 'lsttables' which uses MsysObjects to show all tables in the database. I select a table from 'lsttables' and this sets the rowsource of another list box 'tblsamp' to the table selected in 'lsttables'. tblsamp now shows me the first X number of records for this table. I have...

Sorry I dont understand, I want to count columns not rows

Hi I have a list box on a form where I can select any table in my database, the onclick event puts my selection into the rowsource of another listbox. Private Sub lsttables_Click() tblsamp.RowSource = lsttables.Value tblsamp then acts as a sample view for the selected table. At the moment I...

wrong code, this is what I am trying to use: "UPDATE " & lsttables & " SET " & lsttables & "." & cmbunique & " = " & pretext & cmbunique;"

Workmad3 Thanks for the reply. I am taking the value for ID from combo box cmbid on the form and therefore substituted for this for ID in your code. Pretext is resident on the current form so I also removed Forms!PDTScript_ACAD! UPDATE & lsttables & " SET " & lsttables & ".cmbid= " & pretext &...

Hi I am trying to use a form to update a field in a table by selecting all the values on the form and passing them into a SQL statement. I select the table name [Points] on my form from a list box 'lsttables' which uses MSysObjects as row source to show all the tables in the database. The On...

Thanks WorkMad3 it works a treat

Hi I am trying to use a form to append data in several tables to one main table by mapping field names and feeding them into SQL. My data is supplied in one format but the column order will always vary. On my form I select a table name [Points] from a list box 'lsttables' which uses...