Search results

Ahh. I tweaked the code a little because it was not tracking the subform. Changed: Screen.ActiveForm.Controls to Screen.ActiveForm.ActiveControl.Form I would have to go back to the original code but How can I audit both main form and subform? thanks for assisting.

All, I am using access 2010. I am using code for Audit Changes as follows: Sub AuditChanges(IDField As String, UserAction As String) On Error GoTo AuditChanges_Err Dim cnn As ADODB.Connection Dim rst As ADODB.Recordset Dim ctl As Control Dim datTimeCheck As Date Dim...

using access 2010; Can and How do I upload fonts for a barcode scanner program. Thanks

All, using 2010. I want to create or find a gradient background for use in my access database. I am having no luck. I can't find any effect tools in Access. Anyone have any suggestions?

Got it. I'll try this. thanks

I apologize. The table should look like the following: CustID Ext State Rate 2500 2500 AZ 1.5 2500 2500A AZ 1.5 1300 1300 MT 2.5 1300 1300A MT 1.5 The custid is like the parent and the ext is related to the custid. I hope this helps.

All, using Access 2010. Looking at the table below, I need to query so that the results would identify only the CUST ID with different Rates in the same state. The query results in this case would be 1300 and 1300A. I tried to do a group and count but I get everything. Any suggestions...

Thanks so much. I couldn't think of this:)

All, I am using 2010 Access I have a query that returns what I need. But now I want to exclude records that are in another table. How do I exclude all records that are in another table. My first thought was to use the where clause but I want all the records to be excluded in the table. thanks

Thank you all for your responses. I'll try this.

Hi All. I am using 2010 access ver. can you change the color of the text in a msgbox. I've searched but have not come across any thread pertaining to this. Example: "MsgBox "DO NOT CONTINUE UNTIL YOU.. I would like the text to be bold and red. Thanks

Sorry for the delay; I was away for a few day. I am looking as the database and will get back with findings tomorrow. Thanks for all you assistance.

All; I created a sample database that seems to work with code and design flaws. It has to be something with the data. I'll have to find whats wrong. Please can someone review and make suggestions for a redesign and maybe I would get some time to redesign this flawed database. smh.

I appreciate all comments. VBAINET; Most of my databases are inherited and require immediate fix and not a lot of time for overhaul. You may be correct that this may run slower than a query. I was just opting for the quickest solution to save time. With that being said; This is the current...

I was getting an error because I made the QuoteNum the primary key so it wouldn't give me the duplicate quotenum. But the tables may have the same quote number for two or more states. So I need to be able to identify the quote number once. If I remove the primary key; I get the quotenum...

JLC: I had an autonumber field in the tbl ModifiedRecords. I will run again and post back. Thanks

I tried that and couldn't get it to work. I declared sql as string and used the code and I couldn't get it to work.

JL; this code works to give me the number of records that don't equal; but I need to get a list of quotes/records that don't so we can see the fields that don't match. Code to modify to give me this pls? Thanks

Thanks all for your help. I'll try this when I can get back to my laptop:)

Sorry for the omission. That's exactly correct. I get you solution; but I just been informed they may be adding additional calculated fields in the query used. So my question is; might there be a way to do this in vba; maybe a loop? Else It would be a nightmare to do this for each field...