Search results

Hi, i am trying to open a word document within access to allow the user to review but not change the document. the process is as follows. the document gets created in word by the author and saved to a location on the server. we then have another form opened by the reviewer who can say click a...

Hi, My table has a field called hyperlink which is a text field referenced to a document location. We have now decided to move all documents to a new location so the hyperlink path will change from N:\location\foldername\filename to \\servername\location$\foldername\filename. obviously each...

Worked a treat: thank you yet again.

Hi All, Here is my scenario.. I have created a form bound to a query and added a list box to go to the record when i highlight it from the list. Each record has a hyperlink to a pdf document [Hyperlink] and i would like to show a preview of this document when i click on the corresponding...

Great, worked a treat. I have attached the full code for reference: Private Sub Command55_Click() ' Location of main folder Const Parent = "N:\Document Library" Dim Doc_Number As String Dim Folder As String Dim fso As Object ' Get Main ID from control Doc_Number =...

Hi, I have code that can create a folder from a button based on the field name in Access and it works well. The issue i have now is that the field i am using in the code has Data like 123/456/789 in which case it cannot create the folder.. is there a way in code i can substitute "/" with "-"...

Pat_Hartman you put me on the right track.. Ok so i created a table with a single field numbered 1 to 50 records. added this to my append query and set this to be <= an unbound field value on a popup form as well as the job title. This then created the correct amount of records to append to my...

Hi, I have created a popup form with some unbound fields that feeds criteria on an append query. my question is how do i add a set number of records based on an unbound quantity field on the form. E.G. I am on the mainform and i create a new record which generates a job_Number. This record has...

How do you do it on the report?

I have a query with criteria based on a form field that then feeds a report. There are only 10 rows the table the query looks at and in this example the results are 3 rows based on the form.. what I need is for there to then be 7 blank rows below the results.. so I need there to always be 10...

Works a Treat, Thanks Minty and Others.

Thanks for that. Cant get the code to populate addresses. i have changed the table to a query which shows the right results "email_query" and field "email_address" and enabled the display. outlook launches but no email addresses are populated. i only have 2 addresses in the query. here is the...

Hi, I trying to write code that emails all email addresses in a table. at the moment the code only emails the first address and never moves to the next record. what am i doing wrong? The table is Called DC_Appointees_Test and the field is Appointee_Email. Here is the code: Private Sub...

Frothingslosh That worked a treat thanks

Yeh tried this bit it wont accept the code. see image,of what query looks like in data view.

SELECT Sources.Source_ID, Sources.Serial_Number, Sources.Date_Of_Receipt, Sources.Form, Sources.Nuclide, Sources.Activity, Assets.Asset_Description, Sources.Reference_Date, Sources.Estimated_Activity_On_Receipt, Sources.Active_Dimensions, Sources.Overall_Dimensions, Sources.Description...

Ok, i am trying to count the values of field Activity which is a numeric field in 10 rows/records. i can use the totals command in the query that lets me choose the field and it counts up perfect on datasheet view. The issue i have is i cannot get this total onto a report as it doesn't show...

moke123 this worked a treat.. thanks

Hi, I have created a form with a selection of radio buttons the user clicks on to show results in a query. The buttons are not tied to a group and can have multiple selections. My question is, how do i create a select all radio button that can turn all radio buttons on without the user having...

I have created a list of scheduled tasks in my database with Job_ID Job_Description scheduled_date and Completed Date. Each job has a different scheduled date interval E.G Weekly scans run weekly, network scans quarterly, server updates monthly. at the moment I am manually inputting dates when...