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!

  • Congratulations SkipVought 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: *

  1. LWoods

    Cant create ANY queries - PHP - typeError ?

    DW8 - PHP Has anyone run across "typeError: afterNode has no properties" when attempting to create a query in PHP? I can't get anything done on my site because of this $%^&#@ error. I Googled for the error and find that over the last couple of years there are quite a few people that have...
  2. LWoods

    running totals in a query

    Try this and see if it doens't give you what you want:<br> <br> Create a module with the following code:<br> <br> Option Explicit...etc.<br> <br> Dim curTotal as Currency<br> <br> Public Function CTotal( curIn as Currency ) as Currency<br> curIn=curIn + curTotal<br> CTotal=curIn<br> End...
  3. LWoods

    VBA

    VBA is already compiled at runtime (pseudocode, or native). VB Script can be executed interpretively at runtime.<br> <br> Larry Woods
  4. LWoods

    Occurrences of A, B, C, D in Questions 1-20 in report layout

    Well, this may be &quot;cheating&quot;, but here is a piece of code that will do the job for you...from the way you describe it.<br> <br> First, this assumes that your table is as you described it, with the fields as &quot;Q1&quot; thru &quot;Q20&quot; for the question values, and that there is...
  5. LWoods

    Delete Record

    Normally you would execute a MoveNext/Move Previous after a Delete. Is this not possible, or am I not understanding your situation?<br> <br> Larry Woods
  6. LWoods

    Criteria in a Report

    You can do this with a query that uses the results of a combo box selection in a form as the datasource for a report. (Huh???)<br> <br> 1. Create a form that shows the car make choices in a combo box.<br> <br> 2. Create a query that returns the detail records, based upon the output from the...
  7. LWoods

    Access 95 menu offsets used in Access 97???

    I realize that DoMenuItem is bad...and would not use it myself, but the code that is generated by Access when creating a Command Button uses DoMenuItem. I teach this stuff, and I know that a student is going to ask about the correspondence between the offsets and their values. I was looking...
  8. LWoods

    Access 95 menu offsets used in Access 97???

    When you create a command button, and use the wizard, it generates DoMenuItem commands that refer to menu offsets of the Edit menu. According to Access97 doc, the offsets are tied to Access95 offsets. Wellll, that's all fine and dandy, but WHERE is a listing of the Access95 offsets?!? (since I...
  9. LWoods

    Link Combo Box Selections

    Another angle on this...<br> <br> In 'AfterUpdate' for Combo1, if you create the 'SELECT' statement on the fly, you can assign it to the RowSource of Combo2, which will cause a Requery:<br> <br> Private Sub Combo1_AfterUpdate()<br> Dim strSQL as String<br> strSQL="SELECT * ...... " & ...
  10. LWoods

    Newbie: How can I get Access97 to query for report names?

    Sure, you can find the report names... <br> <br> In the 'CurrentDB' object there is list of the the categories of objects in the DB. This is the Collection object. After selecting the Collection, we have ANOTHER collection: the Documents. To see your list of Reports:<br> <br> For i=0 to...
  11. LWoods

    Labels

    Alan,<br> <br> Maybe I am suggesting the obvious, but have you looked at the Label Wizard in Access/Reports?
  12. LWoods

    Need help on Form Function

    Vig,<br> <br> Your description of the field sounds like a repeating field; i.e., an &quot;array&quot;, if you will. If so, this is NORMALLY a &quot;No, no&quot; in a relational database. Maybe you could describe your file structure a little more.
  13. LWoods

    displaying white text on black background

    Did I miss something? What application are you using to generate the report? This will affect the answer.

Part and Inventory Search

Back
Top