Search results for query: *

Hi VBApprentice, You have to make the instance of Access explicitly visible: appAccess.DoCmd.OpenReport "TestReport", acPreview appAccess.Visible = True Good Luck, MLK

Have you tried putting zero in the textboxes with no values, instead of "". MLK P.S. Make the Default value in those fields 0 in the database. MLK

Try this: "SELECT tablea.fielda1, tablea.fielda2, tableb.fieldb1, tableb.fieldb2, tablec.fieldc1, tablec.fieldc2 FROM (tablea INNER JOIN tableb ON tablea.fielda1 = tableb.fieldb1) INNER JOIN tablec ON tablea.fielda1 = tablec.fieldc1;" Good Luck MLK

Hi dc1688, Are you trying to access an existing event at runtime(e.g. If This = True Then Command1_Click) or do you want to create your on event that you can trigger at runtime? MLK

Hi 99mel, You can also set the CursorLocation property of the first recordset to adUseClient and when you close it, the second recordset will be disconnected and you can use it as you see fit. Good Luck MLK

Hi arcanist, Have you considered using data-bound classes to solve this problem. You can make your DB access class a data source and your middle-tier a data consumer. You can then directly bind your grids to the approiate data member in your data source. Good...

Service Pack 4 is a set of updates and bug fixes from Microsoft to help Visual Studio work better. There is actually a Service Pack 5 as well and it fixes more stuff than SP4. Should you download it? That's too philosophical. MLK

Hi svm, What if you define a new variable strValueToStore AS String(or dtmValueToStore As Date). strValueToStore = Text1.Text & "/" & Text2.Text BIDDATE = strValueToStore Hope That helps MLK

Hi asg, Are you running your query fro VB or from Access? If you are contacting the database from VB and are using any of the data controls or data environment, rather than straight DAO or ADO code you get this error because these tools where invented before Access 9.0 hit the market. You can...

Hi nath, This is some rough code to automate Access Reports from VB. Option Explicit Private Enum DocumentOption doInvoice = 0 doTimeWorksheet = 1 doMaterialsWorksheet = 2 doLabels = 3 doLargeEnvelope = 4 doStandardEnvelope = 5 End Enum Private m_accApp As...

Thanks Martin for responding to my question. I tried your suggestions and the problem remains. I'm wondering if it is "MailingLabel Wizard" specific, since I'm not having this problem with 4 other Reports whose queries are all written the same way. Thanks, MLK

I'm trying to solve a problem involving automating an Access mailing label report. When I send a "WHERE" clause to Access in the OpenReport method I keep getting the little parameter dialog box popping up asking me to fill in the parameter I just sent. I'm not having this problem with...