Recent content by Du2good

Still learning about subquery design. I've been researching this, and have gotten to this point, unfortunately still have much to learn about this subject Trying to get count of Acc grouped by Stats that have a balance > 0 and count of Acc grouped by Stats that have a balance <= 0 in the same...

Thank you again PHV. I'm surprised how bracketing affects the subquery, my actual table had poor design with spaces in the field names. When I tried your solution, and added brackets to the field [Resolved Dt], Access gave me an error. With a temp table, and field name as [ResolvedDt], your...

trying to use this subquery: SELECT Max([ResolveDt]-[ReceiptDt]) AS Age, Max(MyTable.ReceiptDt) AS MaxOfReceiptDt, MyTable.ResolveDt, Count(MyTable.ItemID) AS CountOfItemID FROM MyTable GROUP BY MyTable.ResolveDt HAVING (((MyTable.ResolveDt) Is Not Null)); With this outer query: SELECT...

Can I get this? MyTable has items [ItemID] added to it daily [ReceivedDt]. ItemID's may be resolved [ResolvedDt], on or after the [ReceivedDT]. Looking at the unresolved items, can I find out what the oldest item was, that was not yet been resolved, for each day there was an item that was...

Good info, scope was never considered before. Ha, years of stuff to clean up now that I know better. Option Explicit I knew about but was always fortunate?? to get by without using 100% of the time. This was the biggest eye opener, I knew Public and Private existed but never took the time to...

I thought I'd sent off a reply to this post already. But here it is now with some additional information/questions. I intended to provide the actual error message in the first post... by fail I mean I get an error message of "Invalid procedure call or argument". I've come to suspect that lack...

I've assembled many Access 2003 db's on Windows XP. They all perform a multitude of If Thens that are used to compare string variables such as strRptNm with "ChargeOffs". If strRptNm = "ChargeOffs" Then End if Converting the db to 2010 is causing the If Then to fail. I can rewrite the code, and...

Thanks for the reply strongmm. Good article, I hadn't seen that one. My solution hopefully will be (as I'm building it now) is: Since users are entering data into a form, use multiple text boxes (memo fields) limiting character input to 255 characters. The db should export the memo fields...

Hi everyone, I'm using Access 2003, Excel 2003, and Word 2003. Trying to export a table or query or transfer a spreadsheet to Excel that has a memo field with greater than 255 characters. The plan is to use the spreadsheet as a merge data source. Searched for past 3 days, found multiple posts...

Thanks AceMan1.. It does exactly what I wanted... and thanks for adding the subform code too!! It is working great!!

I want to track some(not all) of the buttons the users are using. For instance if a user clicks Private Sub cmdAffidavit_Click(), I'd like to be able to call a function that will return the name of the event. Currently I've added a line of code to each event, that is the name of the event...

JoeAtWork, oharab, Sorry I missed the intent of your previous posts. I finally get what a 'staging' table is. <duh!>. Build the recordset, save the updated records to the 'staging' table, and then update the BE table using the 'staging' table as the source. <2xduh!!> I can already see the...

vbajock - After 4 hours of researching ADO on this site, this is what I have so far, but I'm getting an error of "Records cannot be read;No read permission on 'tbltest'". So it seems the line "rs.Open sql1, cn, adOpenKeyset, adLockOptimistic" is missing something. I've tried different methods...

Thanks JoeAtWork I'm familiar with using SQL with VBA and would love to do so, but for this case we are doing a 'screen scrape' off of a mainframe session. Each record is a different account, and we get the data for each account, one at a time. So we need to update each record from the info on...

Thanks for the reply vbajock. I take it that there isn't much of a 'better' approach to overcome the record lock problems. We are pretty much stuck with the equipment we have. As long as we can run the process, 'they' don't really care how long it takes. So we may just do as is with the burden...