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

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

    ReQuery

    Here is some of the forms code: Option Compare Database Option Explicit Dim db As Database Dim temprec As Recordset Dim JBrec As Recordset Dim JBTrec As Recordset Dim JBTdaterec As Recordset Dim JBTjobrec As Recordset Dim JBTemprec As Recordset Dim EMrec As Recordset Dim EMTrec As Recordset...
  6. kronar30

    ReQuery

    reseting thesubform seems to work. I took out the requery. But now , after 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...
  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

    That helped some. Now the subform updates properly if I am adding a record for the job number currently displayed. The msgbox shows the new job number '601' but the subform still displays the query for the original job number??? shouldn't the whole query be changed to the new qrycall? MsgBox...
  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

    I have a form 'frmEnterTime' which has 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

    After User enters a new record, I do a form requery using this 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 = '" &...
  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