Search results

Thanks, I read that too, but it seemed to be working ok. Just in case though, i have added the Format() Thanks, Ben

Fixed it, it was missing #`s for dates.. "WHERE AA.[Date of Activity] Between #" & MyDate1 & "# And #" & MyDate2 & "# " & _

PS. I set a debug to check the dates where going in, they are.. Debug.Print stsql CurrentDb.OpenRecordset stsql

Thanks for this, its looking much better than where i was going. I see your point about running the SQL statement like that, however, its not picking up any results. I know the names of tables are right and the join as i copied it from the built query design SQL view. When i run the query I...

Hello, So in my last post I got the answer to calling a function that will export a record set to Excel. but the issue with that, is my where has a WHERE clause that requires the user to input a Date Range. I am trying to get the VBA to get the data from the user then open the query and...

Thanks, i used this, it works great. His page is full of handy tips. All i need to resolve now is how to save the user input before i call the function. When the query opens it asks the user to inputs Dates (Between [Start Date:] AND [End Date]) as part of the where clause. But the code...

Hi all, Bit of an odd one, but can you Export a Query to Excel as a temp file. By that i mean, not writing an Excel file to a save location, but more Opening excel, putting the data in and then the user has to save the document? The reason being, I dont know or have access to any of the...

Not to worry, I tried another approach and it worked. Private Sub Command10_Click() DoCmd.SetWarnings False Dim Path As String Dim Af As String Dim AL As String Dim DT As String Dim SQLDelete As String SQLDelete = "Delete * from ImpAndDevTbl" DoCmd.RunSQL SQLDelete DoCmd.OpenQuery...

Also, which acSpreadsheetTypeExcel12 should i be using? It gives me errors, but if i use .xlsx as the extention, Excel wont open it? Office16 Thanks

Hi all, This is my code: Private Sub Command10_Click() Dim Path As String Dim Af As String Dim AL As String Dim DT As String Path = "C:\" Af = Affiliatebx 'A box on the form that give the client name XL = ".xls" DT = Format(Now, "DDMMYYYY") DoCmd.Close 'this is here as the Readonly...

Hi Steve, Just wanted to thank you for all your help, talking through it and your ideas have really helped me. I have tested 5 tasks for weighting now and they all work and I already have a Sum score buy affiliate. I just need to write in the 30 left over rules and its done! Thanks again. B

I assumed thats what you meant by: I think its a winner anyhow, it means i can keep the current Table and form for tasks, have a table that lists the Tasks and their weighting. the link is automated, which makes the output dynamic. I just need to map them to my other data now. ill keep you...

I think i get what you mean by one giant table, add the weights to Tasks, TASKA, TASKB, TASKC, WEIGHTA, WEIGHTB, WEIGHTC Then i could build anything, like IIF(ISNULL(TASKA),"",TASKA*WEIGHTA) This might be the winner, also if i crosstab it, i could then have the Weight Table made easy for...

So you example is where i am at, on your tblClientTasks table, Task one needs to be a number, Task two needs to be Text Task three needs to be YES/No I have considered having task types (TEXT, NUMBER, YN) as column headings, then working it out from that, but i think it will get messy...

actually the rules get even more complex, and involved some major SQL work on some of the other data in the database. But I have all that done. Its the linking to the value thats the issue. I dont want to write out a rule for each task, as if the complexity of the task changes due to...

Hi Steve, I want to take a list of tasks and populate them for each client. Each task is worth a weighting. (how long does it take for example) If i add up the Populated tasks for each client, i get the client score. However, some tasks are multiplied by the number in the box. EG "How many...

Hi Steve, Thank you for that, its pretty good, but not really what i need. The limiting factor on this, is you cant have multiple input types for the Values in the form. Such as Dropdowns, Yes/no, numbers or Text. I need a Comprehensive form, that allows many input types, that then applies...

I cannot workout how to build a form that lists all the tasks :banghead: I can get it to list task_Name, but as far as i can see forms only list Column headings, which is not how we have discussed the layout of the data? So I am totally lost now. Either i have every TASK as its own column...

Ok, So i think i have the tables linked and set up as required.. but now I am at a total loss on how to setup the form, so that it can populate these tables? I think this is why i had the table as it was, more Spreadsheet, than data table. I cant see how i get the "TASK_NAME" to show on the...

Cheers buddy, I think i am on the right path now! B