Search results

Thank you for the suggestion, RainLover, but unfortunately that won't work because you can't have aggregate expressions in a where clause. Thanks!

Hello, working in access 2003 and having a strange problem today. I need a query that selects a list of names from a table called EmployeeTask_FTE where thesum of the field FTE (numeric- double) is equal to 1 for at least one month in the specified 3-month range. I do this via a subquery that...

Hello, I am working in Access 2003 and need some help wrapping my brain around how to make a subform- a date-filtered view of a table- update the table directly from the form. Here is my set-up: I have a table listing pay amounts and other salary information per pay date per employee. In this...

Doh! Now I feel really stupid! You are absolutely right- I did in fact have fields called just that in one of the tables- and that wasn't an issue in the other parameter queries because they involved only select sub-queries that did not select those fields in particular. Thanks again! Sorry for...

Hello, I am working in access 2003 and have noticed an odd problem with parameters in one of my queries. The query is pretty straightforward- a simple select statement- and it takes two date parameters- called [startdate] and [enddate]. I should note that I use date parameters in a few other...

Thank you David! I think your suggestion of using schduled tasks is exactly what I was missing. I will certainly do more research on it. Thanks again!

Hello, I am working in Access 2003 with a back end and front end split. I am looking for any suggestions for the best way to set up an automatic back end back up and compact schedule. I've read some posts about creating a copy of the folder where the back end file resides and pasting it to a...

Hello, yes you are correct- I tried many different syntax versions- I just forgot to put the me!'s back when I pasted the code into the thread. To answer your question- [EmployeeName].Column(2) refers to the third column of the combobox EmployeeName- this is the column that holds the FirstName...

Hello, I have to apologize in advance for posting yet another thread on docmd.openreport, but I just could not find what I am doing wrong from the dozens of threads that I browsed. Here is my goal and my problem (working in Access 2003): I have a form which lists employees in a combobox. I...

I will definitely do more searching on this to understand CopyfromRecordset better. Thank you, Paul!

Paul, thank you so much! I tried doing just that after reading your reply and it worked like a charm! You are officially my favorite forum member!! Just out of curiosity- why would it matter if the recordset was at the first or the last position in this instance? The recordset isn't pasted...

I should add that the row number of lastrowcumreg corresponds to the right formula that it would have been if all 35 records were inserted: lastrowcumreg = header_cumreg + cum_reg_recordcount + 1 The sums (which I put in after the records are pasted) are pasted in row 42, which is exactly...

Hello, I am banging my head against the wall with this problem. BEGGING for your help! I am working in vba, access 2003. I need to run a parameter query on a loop with a new parameter at each iteration of the loop, store the result of each iteration in a temporary table called CumulativePS, and...

Hello, working in access 2003, been looking at various solutions for this problem, but can't seem to get any of them to work. I have a main form EmployeeTask where the user picks an employee, a task, and some other fields from comboboxes. Then the user can update or insert these fields into the...

Hello, here is an update of what I tried: I included a message in the status bar 'please wait while generating report' in hopes that it will show me when the sub is actually done running. Well, here is what happens: the sub creates all the workbooks with all the right sheets and the correct...

Hello, I am working in access 2003. I need some quidance on a vba module I wrote for the on-click event of a user form. In this form, the user sets several parameters for a query which will be used in the vba code. The on-click sub is supposed to do the following: -Create a different workbook...

Ah! That does make sense! Thank you! I will definitely try your solution, which seems much more elegant than the interim one I came up with: I created a copy of the original stores query and put the two extra parameters there. Then, I defined the querydef as before, simply adding on the two...

Hi Mark, thank you for replying! But I don't quite understand how the variable 'somedate' will take on the value of the control on my form (this whole code is inside a on-click event of a button in a form), which is what I want- I want the parameters of the original query to take on the value of...

Hello, I am working in Access 2003. I have a parameter query called MonthlySalary_FinalQuery_TASK_TOTALS I have set this query and its parameters in vba as follows: 'set main MonthlySal query Set qdf_monthsal = CurrentDb.QueryDefs!MonthlySalary_FinalQuery_TASK_TOTALS 'parameters...

Hello, for anyone looking to this string for guidance, I have finally gotten the code to work the way I want it with the help of the fantastic folks here and at MrExcel forums. I am posting it here if anyone else has similar issues: Sub boblarsontest() Dim dbs As DAO.Database Dim rs...