Recent content by CBRAY

  1. C

    Record Count

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

    Record Count

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

    MSCAL.Calendar.7

    Thanks reclusivemonkey so simple I missed it.
  4. C

    MSCAL.Calendar.7

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

    Suppress Error Message 2110

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

    Suppress Error Message 2110

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

    Column Count

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

    Column Count

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

    Column Count

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

    Column Count

    Sorry I dont understand, I want to count columns not rows
  11. C

    Column Count

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

    Update query as SQl problem

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

    Update query as SQl problem

    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 &...
  14. C

    Update query as SQl problem

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

    Field Mapping

    Thanks WorkMad3 it works a treat
See more
Back
Top Bottom