Search results

  1. J

    SQL Insert Into using VBA with where criteria

    Hi all, Been trying to get this piece of VBA code to work but not sure why it isn't. This SELECT statement works fine: strSQL = "SELECT [" & strTmp & "].* FROM [" & strTmp & "] WHERE (([" & strTmp & _ "].[Work center]) Like '*' & [Forms]![frmImport]![txtCode] & '*');" However...
  2. J

    Control Source as a Variable?

    Is there a way to declare a control source as a variable? I have a report filter like this: DoCmd.OpenReport "report", acViewReport, , [site1] = "open" I want [site1] , which is a control source, to change to [site2], [site3], [site4], depending on a value chosen in a combo box. Thanks!
  3. J

    Bounded Columns

    Hey guys, I have a combo box (Man1_AB) with 2 columns -> ID and name. The combo box is bounded to column 1 - ID. I want to open a report filtering results for the combo box's non bounded column. Is there a way to do this? I know this works for the bounded column: DoCmd.OpenReport...
  4. J

    Report grouping question with 4 input

    Hey guys, What's the best way to do an "Assigned to" report with group headers for 4 variables? A little more detail: 4 workers can work on a task. When the user enters the data, they can put the worker in any of the 4 fields. cboWorker1 cboWorker2 cboWorker3 cboWorker4 All combo boxes...
  5. J

    rst.findfirst problem

    Hey guys, Relatively new in access and programming and having a small problem. I'm trying to open a table and find a record where the ID value on the form matches the PK of the table and grabs that record so I can edit 2 fields. The problem I'm running into is that rst.nomatch is always false...
Back
Top Bottom