Search results

The resolution to this is the following link:http://bytes.com/topic/visual-basic-net/answers/557865-how-set-openfiledialog-my-computer

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

I've used a different method . I've cancelled the main Form and turned the subform ito a Main Form and used the following: strWhere = "[Seder_Code]=" & G_Seder & " AND " & "[Bahoor_Code]=" & G_NameCode DoCmd.OpenForm "Fines", , , strWhere and it works fine. Thank you

You are right, Initially I'd passed that info to the main form but later I've use the General Modules fields.

I've tried to use a query by using the - Forms!MainForm!Field - and it didn't work as it was not there

The subforms is tied together with a common PersonID field but I want to filter some events on the subform and not to see all of them

Thanks for the reply, The Main Form has the general details of the person, and the subform consists of several events related to him. I'm coming to the main form from anther continuous form that has numeros people. Thanks

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

Thank you for the advice

Thanks a lot. I've tried without a condition and found that the visible=false worked. Than I made a condition that if the value is Null than visible=false ELSE visible=True. Great stuff

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.

Thank you for your help I've solved the problem by using DoCmd.Maximize

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

Thanks It works.

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