Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. kronar30

    object properties

    How do I find what object properties can be tested in code?
  2. kronar30

    how to check which tab is active?

    I have a project written in Access 97 converted to Access 2010. I am hitting an error because a set focus command is trying to set focus to a field in a prior tab. How can I test which tab is active? tabOverhead.SetFocus had changed the active tab to the Overhead tab, but code tries to set focus...
  3. kronar30

    Access permissions

    I am having problems setting a database permission so I can continue to develop the application on my new computer. Also switching from Access 97 to Access 2010. Does the user name in the set permissions screen equate to the windows sign on user? How can I change permissions for the whole...
  4. kronar30

    ReQuery

    ...this code displayed "rec source = UpdateTimeQuerybyDate" qrycall = ChangeQueryDef("UpdateTimeQuerybyDate", "select * from [JBT_EmpTime] where JB_JobBidNo = '" & hldJobNum & "' order by JBT_Date DESC, JBT_EmpNum") Me.TimebyDate.Form.RecordSource = "UpdateTimeQuerybyDate"...
  5. kronar30

    ReQuery

    ..."realWorkHrs = " & realWorkHrs 'Query by job window (upper right) 'qrycall = ChangeQueryDef("UpdateTimeQuerybyDate", "select * from [JBT_EmpTime] where JB_JobBidNo = '" & hldJobNum & "' order by JBT_Date DESC") qrycall = ChangeQueryDef("UpdateTimeQuerybyDate", "select...
  6. kronar30

    ReQuery

    ...new record added, the subform shows all jobs, not just the job entered. here is my code: qrycall = ChangeQueryDef("UpdateTimeQuerybyDate", "select * from [JBT_EmpTime] where JB_JobBidNo = '" & hldJobNum & "' order by JBT_Date DESC, JBT_EmpNum") Me.TimebyDate.Form.RecordSource =...
  7. kronar30

    ReQuery

    I checked the query SQL it did change to the new job number, however the subform is not displaying the new job's records( still shows old job's records). I want to have 3 subform windows on this form showing the job times sorted by date, job times sorted by employee and job times sorted by job...
  8. kronar30

    ReQuery

    How would I check the query? Yes, the subform control name is "TimebyDate
  9. kronar30

    ReQuery

    Form is "frmEnterTimes" it has a window called "TimebyDate" whos source object is "EmpTimebyDate" whos query is "UpdateTimeQuerybyDate" wouldn't the requery change the query criteria to the new sql?
  10. kronar30

    ReQuery

    ...job number??? shouldn't the whole query be changed to the new qrycall? MsgBox "hldJobNum = " & hldJobNum qrycall = ChangeQueryDef("UpdateTimeQuerybyDate", "select * from [JBT_EmpTime] where JB_JobBidNo = '" & hldJobNum & "' order by JBT_Date DESC") [TimebyDate].Form.Requery
  11. kronar30

    ReQuery

    Have not compiled code. Option Explicit is specified in the code. Am I suposed to requery the subform or the query. (I don't find anything labeled TimebyDate).
  12. kronar30

    ReQuery

    subform is named EmpTimebtDate there is nothing listed in the subforms master or child fields. Am I suposed to requery the subform or the query. (I don't find anything labeled TimebyDate.
  13. kronar30

    ReQuery

    ...a subform 'EmpTimebyDate' whos record source is 'UpdateTimeQuerybyDate' order by 'JBT_Date DESC' UpdateTimeQuerybyDate SQL is 'SELECT * FROM JBT_EmpTime ORDER BY JBT_Date DESC , JB_JobBidNo;' After User adds a record I run the requery qrycall =...
  14. kronar30

    subform sort order

    ...code. But records always display in ascending order. Even when I take the DESC out. qrycall = ChangeQueryDef("UpdateTimeQuerybyDate", "select * from [JBT_EmpTime] where JBT_Date = #" & hldDate & "# and JB_JobBidNo = '" & hldJobNum & "' order by JBT_Date DESC")...
  15. kronar30

    Form Requires a parameter value

    I have copied a form and renamed it, but every time I try to run it, I get a window prompting to "Enter Parameter Value" "Forms!frmEnterJob!txtJobBidNo". I changed to form name from frmEnterJob to frmEnterBid. How do I find where the parameter is specified to remove it? I want to be able to...
  16. kronar30

    How to update records displayed after delete-sw set by user

    Setting the delete-sw does delete the record in the table, but I dont know how to requery for the subform displayed.
  17. kronar30

    How to update records displayed after delete-sw set by user

    I use a subform based on a query to display records not yet deleted. One of the fields in the records is the delete-sw. How do I requery the records after user sets one of the records delete-sw (so that record no longer shows)?
  18. kronar30

    How tp let user select a record to delete from database

    Maybe I should start over. I need a way for my users to select a record they want to delete from the database. I was thinking of displaying a small number of key fields to identify the records so the user can choose which ones to delete. Each record consists of several many-to-one table...
  19. kronar30

    Tabular form

    to dhookum: tried the docmd.runcommand but got error: Run-time error '2046'; The command or action 'SelectRecord' isn't available now. * You may be in a read-only database or an unconverted database from an earlier version of Microsoft Access. * The type of object the action applies to...
  20. kronar30

    Tabular form

    Sorry, forgot to add tmy code: Private Sub frmDeletesw_Click() 'delete this record strBidNo = JB_JobBidNo MsgBox strBidNo & " delete this record - delete code here" Stop Set JBrec = db.OpenRecordset("JB_Jobs", dbOpenDynaset) JBrec.FindFirst "JB_JobBidNo = " & strQuote &...

Part and Inventory Search

Back
Top