Search results

You're right! I forgot that you can read SelStart to get the current cursorposition :o Greetz!

Steve, When you look in Help for PrintOut, you'll find de specification of this function. I don't think you did this, because you then didn't ask this question.. But Ok, add one argument to the DoCmd.Printout: DoCmd.PrintOut acPrintAll, , , , 2, True Set the last argument to True for sorting...

The most simple way is using Sendkeys. (the integrated sendkeys has a bug with turning Numlock off. To be sure, look here: http://www.mvps.org/access/api/api0046.htm)

Is database Two always the same one? Then try working with a reference to that db (Tools, References) and you can work with the objects of that db.

I should think that it's quite simple:Dim rs1 as Recordset Dim rs2 As Recordset rs1 = Currentdb.Openrecordset... rs2 = rs1After that you can filter rs2 with the Filter-property of the recordset.

Hi, I agree with Wayne that it might be better to use the GotFocus-event of the Merchant-form. You can refer to fields in the datasheet with 'Me.Parent', ie - On the Merchant-form you've the field txtSearchstring - On the PDSF you've the field txtProductDescription Then use in the GotFocus...

Sleep well :D I'll have a look at Bob's question...

OK, (it would be fine if you'd told in your first post that it had to be a general function) It can be discussed to work in this general way. Me personally it's going further than might be useful, but don't mind. I'm thinking about two options: 1. Create an extra Optional argument for the...

Hi WayneRyan, thank you for helping when I was sleeping :D jguscs, I'd think most things are solved now. WayneRyan's solutions are good. Maybe you can prefer the method with setting DoCmd.SetWarnings, because that doesn't depends on the computer where it's running. The other setting is set at...

Hi, Create a New Query and change to SQL-mode. Delete everyting and then copy-paste this:DELETE tbl_Bank.*, tbl_Bank_Branch.*, tbl_Bank_Employees.*, tbl_Bank.bnk_ID FROM tbl_Bank INNER JOIN (tbl_Bank_Branch INNER JOIN tbl_Bank_Employees ON tbl_Bank_Branch.brnch_ID = tbl_Bank_Employees.brnch_ID)...

Debug.Print will 'print' the value of strSQL into the Immediate-window (you can open that by pressing Ctrl+G). Then you can see exactly how the string has been interpreted.

Can you post a part of the DB here (attached)? Then I'll see what to do...

Try this:Dim varItem As Variant Dim SaveToTable As String Dim strSQL As String For Each varItem In Me.LstTables.ItemsSelected SaveToTable = Me.LstTables.ItemData(varItem) strSQL = "UPDATE " & SaveToTable & " SET " & SaveToTable & ".[Client Name] = '" & Me.ModTxtName & "'" Debug.Print...

Hi, As far as I can see, the ZoomBox is a modal form that works in the way a MsgBox works. That says: your code stops running until the ZoomBox is closed. Now you can cancel the updat form the ZoomBox. i.e.: Private Sub Knop6_Click() Me.txtCompaynName.SetFocus DoCmd.RunCommand acCmdZoomBox...

Indeed Access 2003 doesn't add very much new things. I see only one problem for Office 2003: Windows XP is needed. For me it's no problem, and I think for most developers, but many of my customers work still with Windows 98 / ME, so I can't distribute the Access 2003 Runtime Edition to them. Now...

Sure you've to declare de strSQL. But now I read it back and see that it can't work, because we don't give the command to run the SQL :eek: Will this work?Dim varItem As Variant Dim SaveToTable As String For Each varItem In Me.LstTables.ItemsSelected SaveToTable =...

Ok, Then try this:Dim varItem As Variant Dim SaveToTable As String Dim strSQL As String For Each varItem In Me.LstTables.ItemsSelected SaveToTable = Me.LstTables.ItemData(varItem) strSQL = "UPDATE " & SaveToTable & " SET " & SaveToTable & ".[Client Name] = '" & Me.ModTxtName & "'"...

Hi, Are you sure that 'frmMasterList' exists in your database? And that the combobox 'cmdCounty' is on the first form?

Is it on each computer? If yes, then I agree with VBITS. Else, you can try to import all objects in a new database...

Hi, I'd think that you first have to delete all employees and Branches (with a delete-query), before you can delete the Bank?