Search results for query: *

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...

Backend table has 100K plus records. Five instances of the FE will be editing 50K of the records, 10K for each instance, one record at a time. The problem is that record locking is preventing editing of some of the records. Some how I want to be able to update any record with out running into...

Thanks PHV, I appreciate it as always. It works great, but I'm a bit sheepish as it seems so plain to me now.

Is there code that can be used with a button that will close the db but leave Access open, something that maybe will close the database window, instead of hiding it? I have user level security applied to several db using same workgroup with Access 2003. Problem is that I'm frequently exiting...

So simple, yes, that was the missing part. Got it working with the task scheduler and Run. Thank you so very much for your help PHV. I hope next year is better for you than what 2008 was. All of your posts have been very helpful to me. Thanks again!!

OK, I've decided to continue using the Windows Task Scheduler. The article looks like it has the info I need. I've added the switches /nostartup /user /pwd but something is wrong. Below is the format used in the Run box of the Windows Task Scheduler and I've tried the same command line in the...