Search results

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

I've seen a lot of messages asking how to pro grammatically change the color of a TextBox to a color, but not on how to do the reverse. If in my form or in my code, I have the BackClolor set to red, how do I pro grammatically change it to be transparent? Thanks, Crhodus

That did it! Thanks for your help. Crhodus

Hello Everyone, I have a query where I am trying to pull records where the user took a class that is 2.5 years old or newer based on their license expiration date. Can someone tell me what I'm missing/doing wrong? SELECT tblCE_Details.LIC_NUMBER, tblCE_Details.Course_Code...

Thanks for the info! Crhodus

I have figured out a way to prevent my edit check from executing by moving and modifying some of my code in the subForm. I'm still curious to know if you can capture the button click event from the parent form from within the subForm. Does anyone know if this is possible? Thanks, Crhodus