Search results

  1. C

    problems with VB code

    is the form bound to any of the tables?
  2. C

    Skip Record in report if error is found

    If this is in the detail section of the report...try using the Onformat or OnPrint event of the Reports detail section Need a sample...email me
  3. C

    Creating Graphs

    I would either use Crystal Reports or Excel. These are much better for creating complicated reports then access is. Need a sample...email me.
  4. C

    Printing Problem

    Are u using VBA? if so let see the code.
  5. C

    Equipment utilization

    you may be better either using Crystal Reporst if you have it...or linking the data to Excel...to make something pretty Need a sample...email me
  6. C

    Printing report

    you need to explain a little more...but i would look into the OnFormat and OnPrint events of the reports detail section. if you need a sample let me know
  7. C

    Help with memory issues (RAM)

    I think your best bet is just getting more RAM...its dirt cheap...checkout EBAY...one of my co-workers got 256MB for $75
  8. C

    Counting Records in query

    you can us a recordset object and count the records that way....If you want some sample code email me.
  9. C

    Check for a - in a string

    i would use the InStr instead. Dim intX as integer intX = instr("XXXXXXXXX") if intX > 0 then ..... ..... end if
  10. C

    Problem calling a function

    Dim adpClientName As ADODB.Parameter Dim strSearchName As String strSearchName = txtSearch.Text & "%" With cmd Set .ActiveConnection = conn .CommandText = "qrySearchClientName" .CommandType = adCmdTable Set adpClientName =...
  11. C

    How to do this...

    Option Compare Database Option Explicit Dim db As Database Dim rs As Recordset Set db = CurrentDb Set rs = db.OpenRecordset("Query or Table Name") With rs tempVar = .Fields("Field or Column Name") tempVar2 = .Fields("Next Field or Column Name") tempVar3 = .Fields("You get the...
  12. C

    Finding a Library Database

    heres a idea that might work for you...instead of using access to create the lib...use VB and create a DLL program and write all you common code there...then you can just plop is someplace on the clients machine...and its there. Peace
  13. C

    Sorting Arrays

    heres another idea....if your populating the array with a recordset...just sort the recordset via SQL (ie.. SELECT tabel1.* FROM table1 ORDER BY Customer)
  14. C

    PDF Format Problems from Access 97

    can anyone give the code for exporting a report to adobe acrobat using the docmd. thanks Chad
  15. C

    PDF Format

    Can anyone give me the syntax for exporting a report to PDF format in Access 97. Thanks Chad
  16. C

    Compact Database??????????

    Thanks Richie, That worked great. One more question, is there a prettier way of doing this?? Like maybe keeping a Form Loaded or something while it compacts. Thanks Chad
  17. C

    Compact Database??????????

    Access 97
  18. C

    Compact Database??????????

    Can anyone tell me how to run the Compact Database tool from my VBA code. I current do docmd.RunCommand(acCmdCompactDatabase) but it pops up a window wanting to know which database I want to compact. Is there a way to automate this within the current DB so there has to no user input. Thanks Chad
  19. C

    Automating Reports and PDF

    ok...i got that. But is there a way to kick off just a normal access report...say at 7am every morning. or anytime specified? thanks Chad
  20. C

    Automating Reports and PDF

    Can anyone tell me how to automate a report in Access 97 that will run everymoring at a certain time. Also can anyone give me an example of how to output a report to PDF format.
Top Bottom