Search results

  1. D

    ON FORMAT event - Detail Section

    Question: In my on-format event for the detail section of my large report, I have code that loads data in to number graphs in the report. This can be rather slow. It seems to me that the on-format event occures for every page and not just when the report is first loaded. So if Page 1 has a...
  2. D

    Is there any way to get around report size restrictions?

    I am running in to this same limitation now. What did you ever do? I am thinking of something like: rptDataReportPages1_3 rptDataReportPages4_6 rptDataReportPages7_9 Now can the 1st report call the 2nd one and can the second one call the 3rd? Will that print continously as far as the end...
  3. D

    Graph Image in OLE Field

    Hello there, I now have a good handle on the Microsft Graph Chart. In my program as data is collected from an instrument, through a serial port, I have the graph changing before my eyes. The end result is very good. Now when I want to creat a report I have to copy that graph to the report...
  4. D

    Properties Window

    Right on! Thanks you!:D
  5. D

    Properties Window

    I want to know this answer too. Did you ever find one?
  6. D

    Detect a keypress during a Loop

    Okay here's what I did and it works. In the "ON KEY PRESS" event for the button that starts the loop, I set an invisible field to "true" on the form. Then once a loop, I look to see if that invisible field is true, if it is, exit the loop/sub/etc. It works as long as the button maintains...
  7. D

    Detect a keypress during a Loop

    Perhaps. My main project was a program to manage a small calibration lab and produced NIST traceable certificate (NBS) and tracked the asset equipment. I am pretty sure I used both QuickBasic and the then Professional Basic Developement System (not VB - sorry) with several add-ins. I remember...
  8. D

    Detect a keypress during a Loop

    Okay, I feel silly. Haven't done that in so many years (since Visual Basic Deveolpement System for DOS, or earlier versions in the '80s.... In a loop what is the best way to detect if a user presses a key (i.e., ESC)? I feel silly asking since it is probably so easy.... this morning my brain...
  9. D

    Enabling Multiple Fields on a form

    The plus symbol was in the field name. Such as: GainAmp-4 GainAmp-2 GainAmpSet GainAmp+2 GainAmp+4 GainAmp+6 I think since then I changed the name to: GainAmp4n GainAmp2n GainAmpSet GainAmp2 GainAmp4 GainAmp6 I also discovered that you can make the TAG line as long as needed (within reason)...
  10. D

    Is the a way for a user to abort code?

    There will be a lot of code locations (funcrions/subs/etc) to test for the <ESC> key. I was hoping there could be a command that simulates the square vcr RESET/STOP button in the VBA Code Edit/developement environment.
  11. D

    Large Front End Not Much There

    My one Database front end got to be almost 60 megabytes (compressed). :eek: I created a brand new database and imported all the forms, queries, reports, modules, etc. The re-linked that new front-end to the backend. Evrything worked great, except the new front-end was 20 megs. That is a...
  12. D

    Defining a Data Type array in VBA

    Hello there. This eaxmple is from C+, I think. I am tryijng to interpret data fed back in to VBA via the serial port of an instrument (UI am using a comm library). Anyway, I was told it was simple... here is all that you need to do... typedef struct...
  13. D

    Is the a way for a user to abort code?

    I have a VBA/Database program that aquires data from an instrument via the serial port while controlling a function of that instrument. The program will control the instrument, take a reading, control it, take a reading until it gets a satistfactory result. It works great unless the user...
  14. D

    Enabling Multiple Fields on a form

    PS - I am already using the TAG parameter to automatically un-enable very control on the form at OPEN. That way, I only enable the fields as needed.
  15. D

    Enabling Multiple Fields on a form

    I have a form that if the user presses a button, 18 fields should enable. Then after they perform a function, I want to lock those same 18 fields. I thought this would have worked for the enable: For Z = 1 To 6 strField = "GainAmp+" & Trim(Str(Z)) Me![strField].Enabled = True Next Z Can I...
  16. D

    Disabling fields

    LockControls.... nice routine! Thanks for the post.
  17. D

    Microsoft Chart Object - How to assign the X-Axis to a column of data

    One more question along this line. Can the resulting graph/picture be saved in a field in a table (such as a scanned in picture can be saved in an ole field)? If so what commands would I use? rs.Fields(69) = Graph_Data.Object <- does not work Field 69 ("Histogram") is set as an ole object...
  18. D

    Microsoft Chart Object - How to assign the X-Axis to a column of data

    I figured out how to send data to a chart object datasheet. By default the chart is based on A2, B2, C2 & D2 and then three rows of each. I have 64 data elements that I want to plot in to a histogram (see attached histogram from excell). I have a loop program A1 (or A2) through A64 data. Now...
  19. D

    Importiong an Excell Chart in to Access

    By the way, here is what I am looking to creat with the Microsoft Chart Object. Please see attached. i have learned how to add data for 64 points by doing this: rivate Sub Form_Load() Dim db As Database Dim rs As Recordset Dim strSQL As String Dim Graph_Data As Object Dim objDataSheet As...
  20. D

    Importiong an Excell Chart in to Access

    Okay, I inserted a Microsoft Graph Chart. It has a small spreadsheet asociated with. How do I put the data points in to that spreassheet?
Back
Top Bottom