Search results

Hehe, yes I tried it and it too (DoCmd.RunCommand acCmdSelectRecord) gave gocus to the first column.

It already does that with the bookmark; i.e. go to a record. However it's focus is the first text field. I can change this with the 'SetFocus' method and it works. But what I am look for is: Along the left hand side of a form is the record select button (okay it isn't really a button but...

I definately like your code example better. Much cleaner. Thanks again, Not if I can select an entire row/record I'm set.

Don't know if I should start another thread for this but. Next question: I know how to select a specific field in a record (after it is found). Does anyone know if I can and if so how do I select the entire row/record? Thanks again,

Yeah! With your help I solved it. I was over looking the simple answer. First, when the original code ran, nothing happened??? So here is what I did. Dim rs As Object Set rs = Me.sfrm_Common.Form.Recordset.Clone rs.FindFirst "[dt_Date] = DLookup('dt_Current', 'tbl_Stored_Date')" If Not rs.EOF...

Hi all, I have a main form sub form. However I do not populate the subform until the main form is open. i.e. in the Form Load (of the Main Form) I set 'RecordSource' of the subform. I would like to open the form and have the subform go to a specific record. I have tried: Dim rs As Object...

Don't I feel foolish. DELETE tbl_PayType_Local.* FROM tbl_PayType RIGHT JOIN tbl_PayType_Local ON tbl_PayType.Pay_Type_ID = tbl_PayType_Local.Pay_Type_ID WHERE (((tbl_PayType.Pay_Type_ID) Is Null)) I believe this will work.

Yes, the idea is to search for null in the remote table. If null then delete the records from the local table. It actually works greate if there is a single record that doesn't match, but... if two or more records don't match them I get an error saying it can only select a single record??? I...

Hi, I have a local and remote table. What I'm trying to accomplish is deleting anything from the local table that doesn't exist in the remote table. Of course the easy way is to delete the entire local table and re-insert. But I have data attached in other tables that I need to leave intact...

I'm not sure if I can. I believe the subform has to update first. Then I need to prevent the user from navigating away. Here is the larger picture (so to speak). I data in a Master Table. As the user navigates between records a copy of each (individual) project's records are copies to a...

I know this sounds foolish, but a common problem I have when creating SQL like your example is remembering to include spaces. For example If myvar = "tbl_My_Table" then your script "UPDATE" & myvar might give this result Instead of So... you could try "UPDATE " & myvar Just a problem that I...

I have a traditional Main-Form sub-Form. On the Main-Form I have enabled the mouse wheel for scrolling and of course there's the traditional navigation buttons as well as a combobox. All normal ways of moving between records. However, this time if any data has changed (deleted, added...

Sorry for the bother. I'm not sure what happened. I recomplied and republished and the problem went away. I suppose I could have set that check box. I usually don't but my first compile with 2007. Thanks Bob,

We are slowly switching from office 2003 to 2007. Our db applications are still 2003, but I am using 2007 for continue to modify them. We use passwords on all of our databases (mde). This open though another mde (not password protected) that calls the correct database witht the corosponding...

Hi, I have this query that sort of works. If vw_Type is a linked table to MSSQL it works fine. If it is an MSSQL View I get an error saying the query must be updatable. vw_Type should be a view not a table for various resons. I would like to change this query UPDATE vw_Type RIGHT...

Acutlly as it turns out the User has identified another table (subform) that needs to be added. i.e. MainForm linked to subform1 linked to subform2 linked to subform3. All subforms NEED to be datasheet have have the ability to add/edit/delete their own records (as well as cascade). So far it...

I'm not sure about the filter and filteron method. If there were no matching records in the subform it should be completely blank as all forms with no records available. This would not work since I could not add records to subform2. I tried the method of created a text box to link to. Looks...

Is Filter and FilterOn the best way? I have used those before but not as a Parent - Child. I can't link (Master-Child) the two subforms?

I have, in other applications, a Main form with subform1 (as a single form) and subform2 (as a datasheet). Having subform2 as a subform on subform1. It works, no problem. In this application I have a main form with fields that a user completes. On subform1 (datasheet) which is links by a...

I have done the other way before. On this form it is much easier if both subforms are datasheet.