Search results

Hi Paddy I did try Have you got an email address I could send it to. Its a little bigger than the 102.4kB limit Cheers Luigi

Hi Patrick I've attached a test report and form I've been using. The report is called AM_Asset_Maintenance_List_EMS and it opens the form. I'm basically just trying to get the Ok_Click event to send the two specified locations to the report. It works fine if I use a "Like" operator but this...

Hi Patrick No the pesky = is there thus: Asset_Loc = "Paris Or Rome" If you look carefully at the error msg you'll see Rome is concatted with the "AND" keyword ??? Cheers Luigi

Hi Paddy No go! Getting a syntax error: "Syntax error (missing operator) in query expression ........................... AND asset.Asset_Loc Paris Or RomeAND as....................." ??? Cheers Luigi

Hi I'm trying to send a string from a form to an SQL in a report. This one works: If cmbLocation.Enabled = False Then Asset_Loc = "Like '*'" Else Asset_Loc = "= '" & cmbLocation & "'" End If but not this one: If cmbLocation.Enabled = False Then...

Hi Rich I checked that code - its all good stuff. But is there any samples that calculate and end date based on a start date plus x days less holidays. All that stuff works on end date and start date to calculate elapsed days. Cheers Luigi

I need to calculate the end date of a course of 156 days duration and adjust for holidays if they occur during the course. There may be one or two X 1 week holidays (5 April to 12 April and 20 September to 27 September) between the start date and end date depending on the start date. Is...

Hi Pat I probably did but what I really wanted was a way to sort the data out and put it into a spreadsheet in a certain way. Actually I'm quite pleased with myself coz I created two recordsets with an inner and outer loop to give me this functionality. I was left with the impression that...

The transferspreadsheet method doesnt appear to give me the control over the way the information is displayed, display the units by student. The method just displays all records in full, line by line in the order it appears in the query. this leaves the recordset route - correcto?

Can I use "TransferSpreadsheet" and get some control over what info to put where in the spreadsheet or do I need to cycle through a recordset?

Hi Pat this is exiting. Where's the best place to go for help on this TransferSpreadsheet method? Do you have any code samples? Cheers Luigi

Hi Babe You want to open a specific excel file from Access - correcto? I can help you if this is what you want to do Cheers Luigi

HI Rich I cant use a query and Access report although I'd like to. The client wants a spreadsheet populated from the database - who am I to argue?

I have a recordset which I’m using a Do Loop on to extract records for each student and put into a spreadsheet. Problem is The student Id is in one table and the other values are in the “many” table joined on Student Id. My recordset is: Set rstStudents1 = dbs.OpenRecordset("SELECT...