Recent content by JohnnyBQue

Below is how I finally solved it...I generated a button (ImgSTIdoc)an on a click command (below) It went and look to see if there was any documents in my records table column call "STIdoc" in the fields of the employee chosen. I placed the file path to the actual document (if any otherwise I...

Thanks for all the reply's....I tried is with several employees and it is confirmed that the access rights for the User is set by network directory security setting associated to the Login ID

OK here's a question for the IT guys.... I've completed my db and want to put a copy (not sure if "copy" is the correct word here) on several workstations for use. Now employees at these work station have different levels of access within the network. The IT guy is concerned that when the db is...

Okay I figured it out....went into the OnClick event and used Application.FollowHyperlink [controlsource] and I now open the file associated to the particular employee. I had to change the data from Hyperlink in the records table to just text but keep the file path. I know have to figure how not...

I'll give that a try...

I may be going about this all wrong but I have a text box that is Hyperlink to a directory that opens fine and gives me access to files that I need. What I want is to place a photo of a particular button I've found (in the form) and on the click event have the hyperlink in the text box...

Couldn't figure out the reason why....I'm blaming it on the navigation form.....but I did a work around using the "Detail area" not the subform area and got the results I wanted thanks all that helped.

Well I can wipe the dum-as name off my fore head ....experimented with the Hyperlink and found that I could hyperlink a file path and when click it goes straight to the file so instead of having attachment field I'm going to make Hyperlink boxes and put the path to the folder that contain the...

well the 1.6gb was when I had about have the data I needed to input entered...I went back and zipped all the file and then attached them and entered ALL the data and the database is at 1.94gb......so not much room for expansion....I need to look in to my options here any suggestion would be...

Okay may have a temp fix....if I zip/rar the files there only a fraction of the size as if you add the individual together unzipped...the zip/rar file attaches with no issues and it opens with no issues...the user has to make an extra click to "unzip" but that's no big deal....My database is a...

Hey guys & gals... Question...I have 3 attachment boxes in my table that appears in a form. each attachment box contains specific files (not specific as in extension such as PDF, JPEG, etc.) but specific as in Company Documents, Certifications, Resumes. The issue is there's a lot of document...

OK guys and Gals here's my next installment of what has he done now... Created a Nav form that works as it should ....to a point I have several tabs that connect to forms and they open as they should BUT I have this one form that I called "HOME" where a greeting message appears to the user once...

Okay....came in fresh on a Monday after letting this bug me all weekend....Open the Nav form went into Design View then clicked the 'Detail" bar under the Form Header, then went to the Property Sheet and the selection type showed "Detail" I click the drop down menu and chose "Form" then set...

Microsoft Access 2010...

Hey guys and gals.... Got a question I've created a Navigation Form and one of my tabs brings up another form bla bla but what I want is to bring this form up in datasheet view...is there a setting for this or due I have to create a query to get the look that I want?... *note the...