Search results

Oops! Spoke too soon. The hyperlinks appear fine, but when I click on them in the subreport, sometimes the links work, and sometimes they don't. On examining the table, I found by copying and pasting that the filenames which do not work have the characters ## at the end of the filename -...

Many thanks - this has helped solve it.

Thanks...I am using a subreport, which looks exactly how I want it to. As for adding the attachments to tblAttachments, I found this from Bootwalker: SQLstring = "Insert into [Hours]([Entry date], [User], [Hours], [Task], [Description]) " & _ "Values (#" &...

Hi - I got stuck! Then I found this: http://www.access-programmers.co.uk/forums/showthread.php?t=153350 I created a new module and put the functions in it; I can now browse for a file, and store the link in a textbox. I would like to be able to add more than one file, and have them...

Excellent! Thanks again.

I would like to be able to add more than one scanned document and link them to one record. If it is possible, I would like to have a command something like "Attach file" on the form displaying the record. The user could browse to find the scanned document and it becomes a link. The user could...

I am trying to do something very similar, but would like to be able to add more than one scanned document. If it is possible, I would like to have a command something like "Attach file" on the form. The user could browse to find the scanned document and it becomes a link. The user could then...

Many thanks - I finally understand it. Also apologies for not noticing the DATE_LOGGED error. I do notice that, as I move into a new year (i.e. a year that does not fit the condition in the code >=2012 and < 2013), all records have the same "count number" i.e. after the last record of 2012...

Yes... I am having problems trying to use the subquery: I have tried pasting this into the SQL of the query qryIncidents as suggested by CJ_LONDON: OK, so you would put the subquery solution in your qryincidents query and as you say, the dcount solution could go in your txtRecordno...

I am still having problems.. I tried using the DCOUNT expression in a control but still got the #Name? error - I am sure I used the correct field and txtbox names. I am now trying to check in the command button what variables are being passed: I create a new record with today's date and want to...

Thanks for your continued support... I am wondering if the solution involves placing the dcount in a subform? When I look on the properties of the textboxes "txtRecordno" and "txtYear", I do not see RECORDSOURCE - only CONTROL SOURCE. The RECORDSOURCE for my current form (FrmIncidents) is...

Again, thanks to all who offer help; I am still unable to make these work. I do have an ID field (Autonumber) in tblINCIDENTS, but the subquery doesn't work, nor does the DCOUNT.

Thanks again Galaxiom, but it still shows the total number of records (including 2011 and 2013). Is this something to do with the Format?

This almost works, but always displays record number 1. To try to figure out the syntax of the DCOUNT function, I changed it to this: =DCount("*","tblINCIDENTS","DATE_LOGGED >= #1/1/2012#" And "DATE_LOGGED< #1/1/2013#") It now always shows the total number of records. Could you let me know...

Thanks both for the replies - I realise the autonumber is no use; it was the way I originally set the structure of the table. I will try DCOUNT, but am unclear as to how this will also link with the YEAR, unless I store it in the table? Sorry it is unclear. I mean it to do the following, e.g...

I have a form linked to table tblINCIDENTS When I create a new incident, I select DATE_LOGGED in a text box. This updates the field in tblINCIDENTS. I would like to show on the form (and store in the table), e.g. "Record 5 in Year 2013" I already had the new record number as an...

Hi - I have a form which accepts a start and end date in 2 unbound textboxes. A 3rd textbox allows the user to select the status of te incident. On clicking a command button, I can open a subform which displays each matching record: Dim strWhere As String Dim ststatus As String ststatus =...

Re: send email from access Thanks for getting me started on emailing from a form. My problem is, I have a form called frmINCIDENTS, with a text box (txtemail) which holds the email address to be sent. It sends the information correctly to outlook, but when I click SEND, on returning to Access I...

Thanks for getting me started on emailing from a form. My problem is, I have a form called frmINCIDENTS, with a text box (txtemail) which holds the email address to be sent. It sends the information correctly to outlook, but when I click SEND, on returning to Access I get the attached error...

Thanks Missinglinq. Attached is the file - it now nearly works (the name appears in the textbox but after 1 or 2 updates I am told Index cannot be empty) You will see on my form the next stage is to send an email to the person I select (I wil cross that bridge if I reach the river!)