thayes5150
Last Activity: Dec 8 '09, 03:29 PM
Joined: Nov 11 '09
Location:
-
Thanks again everybody for all the help - The subform is really just a Datasheet view of the underlying table and so Buttons on the subform are not an option. Also I kind of like the Alt -S option. It's kind of elegant. -
Thanks, that did the trick - had to play around with placement to get it to keep from interrupting my code execution, but it works like a charm now. Much better alternative to a generic sleep timer that I was going to use. Thanks again. Completed code posted below:
...Code:Function DataTransfer() Dim cnn As ADODB.Connection Dim cmd As ADODB.Command Dim lngRecs As Long Dim rCount AsLeave a comment:
-
Trying to wait for Count > 0
I have an Access 2003 database linked to an MS SQL 2005 backend. We use the database as part of a process whereby we use Zone OCR to scan records off paper forms into an XML file, suck the data off the XML file into a table and then present the data in the MS ACCESS db for manipulation and correction before being pushed back into other SQL tables. The Scanning process runs on a seperate instance of SQL so the only way to fire it from a Form object... -
Sorry for the bad form, I did not know about using the Coding tags, I will do so in the future. Based on your example, I also now know how to break and concatenate lines in vba, it is frustrating in that the syntax is close to the .net version of vb I am used to, but different enough that nothing seems to work (you use an underscore _ to indicate the end of line, but do not need to include the ampersand in .Net, the system just knows) I apologize...Leave a comment:
-
I believe the problem lay in the fact that I was referenceing the parent form in the where clause. I modified the Query that feeds the subform to carry the necessary key along to the subform and it seems to be working now.Leave a comment:
-
Continued Problems on Subforms
OK, next question :) Once the form sub sub form is open I am trying to update a table based on a double click selection. - employee may have multiple claims, they need to select one to attach charges to by double clicking one of the records in the opened sub form. I have been trying to get the following to work. (forum is wrapping the lines)...Code:Private Sub Form_DblClick(Cancel As Integer) Dim stSQL As String stSQL = "UPDATE
-
OK, Never mind - this was a stupid error, have to treat the SSN as a string, so code should be :
I hate dynamic sql...:)Code:DoCmd.OpenForm "ClaimDetail", , , "[SSN] = '" & Me!ImportSsN & "'"
Leave a comment:
-
Problem opening subform when double click record from main form
I have an Access 2003 database used to research unemployment claims. The main form contains a subform in datasheet view listing the employee claim records, including employee Social security number. I would like them to be able to double Click a record in this datasheet and have it open a subform, populated from a Query that is passed the SSN from the recordset that was clicked. I have included the following code in the vba:
...Code:Private Sub
-
I actually just figured it out as I received your e-mail. Stupid copy/paste error on my part - when I brought the line curTotal = curTotal + Nz(!Amount, 0) into my code I forgot to change the field name from Amount to TtlChg, updated that and it works like a champ. Thanks again for all of the help.Leave a comment:
-
First I want to thank you for all of your help so far, The code you provided seems to work fine, and fires the btnRecordSum_Cl ick code I included before, but the total still comes up as zero, despite the selected records. If I uncomment the error code the message box does not pop, which makes me think there is a problem in the code that sums the records, but it is also not popping the Error message box, so I don't know where the issue lies. I think...Leave a comment:
-
Unfortunately the data in question is sometimes 20 -30 pages with 50 records on each page and I don't know of a way to mass select the check boxes (as you can drag select records in a data sheet) This means they would need to check 50 boxes, then sum, then check 50 more etc for all 20 -30 pages. Is it possible to add a keypress event, maybe on the S key so when they select the records and press S it pops the sum message?Leave a comment:
-
Record selection losing focus on Subform when button click on main form
I have an access database that uses a subform to display records, one column of which is charge data (currency). My users need to verify the charges against the paper form they are scanned from, so I would like to allow them to select a subset of these charges (shift click) and sum them into a message box to verify page by page that the records are correct, or find incorrect records. I found the following vba code and added it to the db
...
No activity results to display
Leave a comment: