Search results

HiHow do you open File Browser in VBA that will open in MyComputer and not in MyDocumentsThanks

Hi There, The following code does the job, but some times when I try to open the form the computer freezes and I have to kill the process to get out of this situation. I'm using Access 2003. Any Idea what makes it to happen? Private Sub Form_Open(Cancel As Integer) Call sEnableDrop(Me) Call...

There is a thred on the following link to bypass the Outlook security message . http://www.tek-tips.com/faqs.cfm?fid=5230 It is for Sending Mail. I've tried it for drag and drop an email from Outlook to a memo field from the following link but it does not work for me...

I'm using the following to bring a person details using a Barcode . It works fine. But if I'm using the same barcode again on the already found person, for some reason it brings me a person that is not related to this barcode. In the third attempt it will bring me the right person... and so on...

Hello there! The following code works fine G_StrWhere = "[Group]=" & G_Group_Code & " AND " & "[EntryDate]=" & SQLDate(G_Greg_Date) Me.Filter = G_StrWhere Me.FilterOn = True I would like to get 2 Groups together in the first part using the syntax " IN" e.g. (4,6 IN G_Group_Code) Anyone...

Hello, I have a main form with a continuous subform. I am filtering the subform by using the following code from the main form and it works fine. Private Sub Form_Current() strWhere = "[Seder_Code]=" & G_Seder & " AND " & "[Bahoor_Code]=" & G_NameCode Me.SubFormFines.Form.Filter = strWhere...

Hello there I try to get the mailmerge letter opened by a Command Button. Its works fine but the only problem is that it opens initially the Document with another name (Letters1) and the mailmerge toolbar is not functioning. After I close it the right name apperars and I can manipulate the...

In a report on a certain condition i want the field to be invisible and the code is : If Me.Field1 = 1 then Me.Field2.Visible = False End if But the problem is that when I type Me.Field2. the word Visible doesn't appear on the list. I use Access 2003.

Hi there, I'm trying to open the form when the cursor sits at the end of the text that previously was typed, after todays date was inserted on the next line. It does all that but at first you see only the date, and to be able to see the previous text you need to scroll with the top arrow...

The following routine resets 36 Text Boxes in array: For i = 1 to 36 Controls("ID" & i).Value = "" Next i It works fine. -------------------- With the following code I get a Run-Time Error 2465 that it can't find the Field ID1 For i = 1 to 36...