Search results

Is it possible to have a form that is accesible by everyone on my Network, that adds data to a database that is on a drive that most people dont have permission to access? If not, what other ways around it are there? Maybe I could put the database on a public drive but have a password to...

A very common question in forums such as this is how to have a linked image in your form. Such as a photo in a personnel database form. I have found this webpage that appears to be a great solution: http://www.tek-tips.com/faqs.cfm?fid=1294 It does however lack a little clarity on exactly...

I found it. It was something the Query that the form is based on was looking for.

no thats not it...

OK I have a Personnel database with a personnel form that has all the fields in it. I want to create an Injuries form where you just select/type an employees name and then add injuries data to an injuries table (linked to the persons ID number in the Personnel database). What is the best way...

When I open my form it asks me: Enter Parameter Value Personnel.photo2 I know I dont need this but I cant find where it is refrenced to on the form to delete it. How can I find and delete it?

Ideally it would also set the [Photo] field to: "C:\Documents and Settings\tlancaster\Desktop\Photos\no_image.bmp" if it is empty.

Can I write vba code that does what this macro does: SetValue [Forms]![Personnel and Training Form]![imgEmployee].[Picture] [Forms]![Personnel and Training Form]![Photo] It takes the file path from the [Photo] field and sets the image [imgEmployee] to display it.

Nice one UncleJoe, you got it! :)

Ok well I think it may be that my button is unrelated to the photo text field? Its just a button I made and told it to call the Sub. The MsgBox does work, it tells me the correct path. But when I try: [Photo] = strInputFileName it says "External name not defined" and when I try: Me.Photo =...

A very basic question, but I am new to this... I have the following code to get the path of an image from my form, and it works fine. I just need to get the resulting string into the correct field on my form. The field I want to put it in is [Photo]. Sub openfile2() Dim strFilter As String...

Yea you are right, I will do that. One slight problem, I have made my main form to get data directly from the table. Can I change it to get its data from a Query? Or do I have to make the whole form again?

I have a database of employees. What I would like is a button that removes the current employees record from the database and exports it to a seperate Archive database. The reason being that when an employee leaves they are taken off the main database but the info is still accessible is...