Search results

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

Oh you get the whole cigar and two cookies....That did it no need for the "Abs" =Round(DateDiff("d",[HireDate],Now())/365.25,2) BUT if you look at my earlier post this is the exact formula that wouldn't work...and I found the reason was the extra parenthesis at the end of my earlier version was...

Give Mark Half a cigar...and Minty cookie....I changed the formula and I now get the same answer as my query returned ....BUT I'm getting a negative number (-13.39) SO not being totally helpless I changed the formula to =Abs(Round(DateDiff("d", Now(), [HireDate]) / 365.25, 2)) AND .....wait for...

well I GOT A NUMBER BACK THIS TIME!...but it's not the right value....lol...my HireDate is 6/25/2001 in my Query using the above formula I get 13.38 (years) and in my form using the formula in the unbound text box source control I get -36953...It's obviously performing a calculation but is it...

Plain and simple (famous last words) Got a database that is working great 1 table - Employees 2 Queries 1) - QEmployees Extended 2) - QyrsEmp 2 Forms 1) - Employee Details (source control is "QEmployees Extended") 2) - Employee List (source control is "QEmployees...

Lets tagged this a resolved ...I think my biggest problem here is TMI....I'm going to re-post my question in a very simple format and see how it goes from there... Thanks guys