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

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

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

How can i know what row (occurance) the user has made a change in in a Tabular Form?

I have a form based on a query. It is Dynaset, continuous form. How do I update any user changes to the record before i run a delete query based on the delete key the user just set in the record?

i changed my code to use SQL delete which works (when there are no child records), however the requery goes right to the error routine displays "Record is deleted". Which I know and want to display the query window with the newly updated recordset. Here is my code: Private Sub...

When I delete a record and hit the 'Me.Requery' statement, it goes straight to the error routine and displays 'Recodr is deleted' (no err.number displays). how do I show the table with the deleted records no longer showing? Private Sub cmdDeleteRecords_Click() 'CAN'T GET THE REQUERY FORM TO...

I have a master table 'JB_Jobs' which is linked to several child tables. I have simplified my code to delete the parent record while there are no child records. I keep getting an error condition. CODE: Private Sub cmdDeleteRecords_Click() Dim cnt As Integer Dim delBid As String On...

This is my code, as I step through line by line, at the JBrec.Delete line it jumps directly to the deleteRecordsError error routine? The "Ready to delete" message shows proper record to delete I do have records in 3 other child tables linked to this delBid I thought I had the delete working at...

I have a form [frmDeleteBids] based on a query 'BidsOnly' of my Job table. After I delete a record i want the query to show the table without the deleted record. I have tried using BidsOnly.Requery Forms!frmDeleteBids.Requery frmDeleteBids.Requery and Requery None seem to work and I trap an...

When only one record matches the search criteria findfirst works fine, however the findNext does not return a nomatch condition. Then fatal error when try to delete non-existent record? NoMatch condition ifs never true?? Set db = CurrentDb() Set JBrec = db.OpenRecordset("JB_Jobs"...

I want to build a form that lists all records in the job table, with a check box in front of each line to be checked if user wants to delete this record? how do I set this up?

When I use rec.Edit, update a field, then rec.Update the record is updated, however current record always seems to be the next record in the table. How do I keep this same record as the current record to do further updates to? Findfirst after an update gets run time error?? I am using Access 97

I keep getting "Object variable or With Block variable not set" Is there any easy way to figure out which variable? I don't find any with blocks in this modules code. Thanks

I have a form and subform. When user wishes to add a new job record how do I add all the records to related tables?