Recent content by crhodus

Can Microsoft.Jet.OLEDB.4.0 be found on all versions of Windows, even if Access is not installed on it? I'm working on a .NET application that will export data to Excel using Microsoft.Jet.OLEDB.4.0. Sorry to double post this. I posted this under the General section a week ago and have yet to...

Can Microsoft.Jet.OLEDB.4.0 be found on all versions of Windows, even if Access is not installed on it? I'm working on a .NET application that will export data to Excel using Microsoft.Jet.OLEDB.4.0. Thanks!

The user wants the default navigation buttons on the form, so I have to leave them. I ended up using "If Me.NewRecord Then " Thanks for the help and all the suggetions!

Hi Everyone, Can someone tell me what event is triggered when the "New (blank) Record" button in the record navigation section of a form is clicked? I want to auto-populate a field with data when the user clicks this buton. Thanks, crhodus

Thanks rainman89. That helped me solve my problem. I had to use the following: =Forms![RMTDetails]![subRMTDetails]![txtBusinessName] crhodus

I've tried using the following in txtPulledName, but it still dispalys #Name? : =[Me]![Tab_1]![SubRmtDetails]![txtBusinessName] =[Me]![SubRmtDetails]![txtBusinessName]

Hi Everyone, Can someone point me in the right direction with my form? Here is how my form is designed: Form BusinessForm has 4 tabs on it. Above the set of tabs is a TextBox named txtPulledName. Tab_1, on the BusinessInfo, form has a subform on it named subRMTDetails. The sub-form...

Currently, the users do not have any version of Access installed on their machine. Is there a way that the Microsoft.Jet.OLEDB.4.0 can be installed?

I have a question about Microsoft.Jet.OLEDB.4.0 We have a client who does not have Microsoft.Jet.OLEDB.4.0 on their computers anyome. They recently bought new computers with Office 2007. They are unable to run a specific functionality in a VB6 legacy application, which has the...

I have made changes to a table for a client. I've had to add additional fields, modify properties of certain field (such as Allow Zero Length), add input mask for phone numbers, changed the length of field size ( Increased some and decreased others), etc.... I now have my new table structure...

Thanks everyone! Bob, I ended up using your code, with one exception. I think part of my problem was the "OnlinePaymentCount" piece in the DCount. OnlinePaymentCount is not a field in the table, it is just a name that I had been assigning to the number of records. When I changed this to a...

Hmm.... It still seems to be receiving the same error. How would go you about using a record set in vba? Thanks, Crhodus

Hi KenHigg, Thanks for the quick response. It looks like this might work. I tried adding the following to the control source for txtHiddenPayment: =DCount("tblOnlineRenewalInfo","OnlinePaymentCount","tblOnlineRenewalInfo.LIC_NUMBER=Forms![SW_form]!SLIC_NUMBER") But I'm receiving #Error for...

Hi Everyone, I came across a last minute issue just before launch time for a form that I'm working on. Why does this always happen? :) Anyway, my form is populated by a query named qryPopulateRenewalForm. I have added a text box to my form named txtHiddenPayment. I want txtHiddenPayment to...

Thanks for pointing that out! I was looking at the wrong line in the property popup window. Crhodus