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

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

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

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

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?

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

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.

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

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 = '" &...

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