Search results for query: *

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

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

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

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

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

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

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

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

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?

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

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

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.

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

...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")...

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

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

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)?

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

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

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