Search results

Path = Right(Source, Len(Source) - InStrRev(Source, "\") + 1)

Guys thanks alot! Works real well. Below is the code I settled on. I don't know if there is an easier way to find the actual name of the file, I used a Do Loop and multipe Right() fucntions. 'declare variables Dim Source As String Dim Path As String Dim fd As Object...

Is there a way to create a browser window so the user can search and find his/her's file??? Right now I'm hard coding the source path. I need the user to be able to search for the file. thanks

Hi gbnz, I can't get Set fDia = Application.FileDialog(msoFileDialogFilePicker) to work. Any ideas on how? Thanks

wow, thanks for the quick response, I'll give it a try and let you know if I come accross any other roadblocks

I have a database where users can attach documents or pictures to a form. I want them to be able to select the attachment they want to attach to the form from their local HD or wherever and I want it to copy/paste it automatically to a network drive so the database can link to it at all time...

I see what you mean, the grow/shrink option works for reports but not with forms. I unfortuantly can not help you with the api code.

click on the text box, open the properties, under the Format tab near the bottom there are two options: Can Grow Can Shrink make sure both are Yes. The boxes will grow or shrink depeneding on the amount of characters. using the same option on reports will actually make the text box...

I need to learn how to put attachments from pictures to PDF files onto a form. I want them to be linked to keep size of the database a minimal. I want users to select an attachment from their HD and it gets saved to a network drive, that way everyone has access to the file and we don't have...

I think I can use this. I have a form for inspections, the inspector fills out the form and then I want them to be able to attach pictures of their findings. I want them to grab pictures from their HD and attach them to the form. I want all pictures to be saved to a network folder, this way...

yes, environ("username") works as far as I know, everytime. There is no reason to do anything else. Assign it to a string, then use a DLookup to see if that user has access to the said form.

This looks great, I only want to lock the form when it is signed off by management. If I run this On_load it will lock all records, correct? So it would be best to run this on Current i think. Private Sub Form_Current() If Me.SignedOff <> "" Then Your code here ...

would this lock the form and all of its records. What if only certain records are locked; could a On_Current work???

This looks great, but if you have alot of fields will take a while to sent all Tags to "Lock". Is there a way to lock the whole form, or do I have to do each control?

Hi Bob Fritz Sorry the delay reply but i finally got some time to go back and work on that form. Your example worked fine, and now my form filters the Approved/Unapproved Vendors. To make searching and selection easier I have included a combo box that displays all of the vedor's names...

Hi Boblarson Worked like a charm

I have form with a subform. The subform displays info in datasheet mode and will have fields, Items and Cost. I want a text box on the main form that displays the summation of all the items' cost. Any ideas? Thanks

Thanks AccessMSSQL, that will work

Thanks AccessMSSQL Will I have essentially have two boxes, the selection combo box and the display employee name box? And I'm sorry but I don't quite understand your first statement "In your form recordsource do a join to the tblemployees table and then on your main form display the...

I want a combo box to display only current employees, so I have a combo box that displays employees name, with a query WHERE (Status = TRUE) meaning that employee is currently working for the company. Problem with this is, when that employee leaves (Status = FALSE) then all forms that use to...