Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: MLK
  • Order by date
  1. MLK

    Viewing Access Report in VB6

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

    TYPE MISMATCHES USING ACCESS 2000 DATABASE

    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
  3. MLK

    sql query (in access vs sql7)

    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
  4. MLK

    adding a new event handler into the code

    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
  5. MLK

    copying a recordset

    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
  6. MLK

    ADO and Grids on a 3-tier architechture.

    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...
  7. MLK

    Service pack

    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
  8. MLK

    connecting dates

    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
  9. MLK

    Access 2000: Win2K vs. Win98

    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...
  10. MLK

    Automating Access Reports from VB

    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...
  11. MLK

    Automating Access Reports from VB

    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
  12. MLK

    Automating Access Reports from VB

    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...

Part and Inventory Search

Back
Top