Search results

im so proud! Ive solved it! Changed the field from hyperlink to text got rid of those ##'s and then used this code Only I do get a microsoft office warning about a trustworthy source and would I like to open the file... If i could get rid of this that would be great!

Hi.... Im back, I've tried the code and Im getting a runtime error Here's the code I'm using I've attached an image of the run time error too, its a problem with the # tags and for some reason I have a http:// added too. Nearly there but not quite yet!

Thanks... would I put that code undera button on the form? I was thinking about this just and im thinking of a continuous form with a couple of fields for date and description then a button at the end to lauchthe file. Thanks TJ

Thanks Paul... That worked great.... I can now see my file name and folder as hyperlins in the table. One other question, how would I combine both so I can give the complete path? Im hpping when I click the link it will start the file and associated program. Many thanks, its such a small thing...

Hi, I have a table named tbl_imagepaths with fields: ImageID File Folder The command button has the code below, it works great and pops up with a window with the file name and path. I now just need the code to insert the file name and path into the table.... Can anyone help Private Sub...

Ive been looking at this all morning and so far got DoCmd.OpenReport "myreportname",,, "[IncidentID]=" & Me![ID] Unfortunately it printed a three page report to the printer, but I haven't got a printer here!! So Ive tried to amend it to give me a print preview using: DoCmd.OpenReport...

Hi, I hope im using the right terminology! I have a main form with a subform. The subform has linked tables from the main form. People are on the main form with the index PersonId and they are linked to incidents by IncidentId. I want to put in two buttons. First put a print report button...

Thanks CJ, Thats worked great. Realise the mistake with the "" and the grouping. Keen to learn, will make these queries so much easier! Thanks again

Sorry for the confusion, will start again. I have a table detailing a number of checks performed daily, each of the checks is a number (ive changed the field type now). There are four checks that require a value, if the value is above 0 the query puts in a number 10, using this...

Thanks for that! Since posting this ive fiddled and lost the query. I needed to add FitRmSecureScore to NoSecTagsScore and display in a column totalscore I have added a screen shot to explain further.... The values FitRmSecureScore and NoSecTagsScore are created by the same query using the...

Hi, I have a query which I want to add up to fields Score1 and Score2, im using the expression below in a column on the query total: [Score1]+[Score2] This is what Im getting... RecordID,Score1,Score2,Total 1,1,2,12 2,1,1,11 3,4,4,44 what I really want is the sum, ive tried different...

Hi This is my first post on access programmers, im a novice with vb thou! Im developing a database for work, I would like to provide a link on a form to run an external program. The form is call frmProfile. The table is called tblProfile and the hyperlink field is called link. I would like a...