Search results

apologies but I couldn't open the db.accdb file to check if I was right in my original assumptions and I was wrong anyway :(

I hope I'm getting this right but you already have the form open with the required parameters already selected and you have a button on the form to open the report? Try using this for the button on the form and make sure you have a field called ID on the report (can be set to Not Visible) and...

hehe funny you should mention that, I use Waynes FnSendMailSafe to send the email and that does fall over when no CC to is specified. Getting around it atm by populating the CC to field with a default dummy until I can figure out how to do it properly. there will only ever be 1 CC so that...

thank you for your time and effort, that still gives a syntax error and I can't see what changes you've made that would include the CC To field. I have kinda solved the issue by creating a second duplicate contacts table to hold the CC .

Thanks for the reply but that just gives me the following error Syntax error (missing operator) in query expression ‘[Contacts_Opened By].ID =Issues.[Opened By] INNER JOIN Issues ON[Contacts_Assigned to].ID=Issues.[Assigned To]’. I have 2 tables Issues and Contacts, Issues...

Sorry I just placed the orginal unaltered sql in the original post below is my attempt SELECT Issues.ID, Issues.Title, [Contacts_Assigned to].[First Name] & " " & [Contacts_Assigned To].[Last Name] AS [Assigned To Name], [Contacts_Opened By].[First Name] & " " & [Contacts_Opened By].[Last...

I want to adapt a query written by another to include a CC to email address, but in the Query designer there are two tables shown that are not in the table listing Contacts_Opened By and Contacts_Assigned To I looked at the sql and tried to copy paste to add an extra one Contacts_CC To but keep...

my apologies I read a couple of tuts about add-ins and they all mentioned making alterations to the registry so assumed all needed it

never would have thought of doing that myself actually while waiting for a reply from them I thought I'd ask what I thought were the nice friendly helpful people on here, didnt expect anyone to fix it for me but did think someone might explain to me why addins need registry access

hi guys tried the free ezy dashboard builder from aadconsulting but it fails to install with an error adding to registry message so 2 questions, 1 how can I fix it and 2 why does an addin have to alter the registry at all?

hehe actually thats good for Janet 100% would mean she's not washing her hands at all, a problem in a food factory :)

Thanks for the help I had to remove the date fields otherwise it was treating each date as a unique record but works fine now

pcnt: Sum(IIf([GradeID]>=3,1,0))/Count(*)*100 I'm tryting to use this expression to give a precentage of GradeId above 3 for each employee ie Janet has 2 out of 11 to give a percentage of 18% howeve the above gives Janet 100% sql from the query below SELECT tblHandswabs.Surname...

how can I open a new form linked to a different table for data entry by entering a number into a control DispoNumber and using that number inside the new record? I can get the form to open using OnUpdate but not sure how to transfer the number

I use the following to send a .pdf to the required email and it works well, but is it possible to include a boolean yes/no field in the table that holds the data and change it from no to yes in VBA so I know when a record has been emailed? Private Sub SendEmailToAssignedTo_Click()...

Hmm I tried doing it via the report and with a rolling year it would sort on the month not on the year so it woul go Jan 2010, Feb 2010 March 2010, April 2009, May 2009 etc

Follow up question I decided to try and make each save unique by doing this to add the time to the filename using a field on the form called Time but it just saves as Issue2Forms!Issues!Time.pdf blRet = ConvertReportToPDF("Issue", , "T:\Issues\Issue" & Forms!Issues!ID & Forms!Issues!Time &...

I have a report (.jpg attached)some data in a table sorted by a couple of queries and I need to list by month and shift I also need to sort it by year but despite mucho searching I haven't been able to do it, so I would be grateful for any pointers/help here is the record source SELECT...

Excellent works perfectly, thanks

Hi All, I'm using A2003 and using Lebans excellent code I have managed to get as far as creating a pdf from a report and emailing it, but I am trying to give each one a unique name based on a field in the report This is my current code Dim strFilter As String strDocName = "Issue"...