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 Rhinorhino 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: simon1974
  • Order by date
  1. simon1974

    SQL Union Query using NotesSQL

    I am trying to reformat the data in a notes table by using a union SQL statement. I am getting an error anytime I try to union more than once (see below) SELECT CATEGORIES AS AUDIT, HOURS_1 AS HOURS, NAME, Period_1 as PD FROM Admin_Time_Reporting_Table WHERE HOURS_1 IS NOT NULL UNION SELECT...
  2. simon1974

    Listbox Used to Navigate a Recordset

    I have a single record form and have added a listbox populated with a unique field from the recordset (I'm using a dataenvironment). I want to enable the listbox to navigate through the recordset, similar to what access does when you add a listbox and choose to have it "find a record on the...
  3. simon1974

    Multiple actions on hyperlink

    I have a frames page: a banner and a body. When I click a link in the banner frame, I want to feed one page into the body as well as changing the page in the banner. Can't figure out how to do this. I am running FPage 2000. It seems that for a hyperlink you can only specify one page and one...
  4. simon1974

    Data Access Page: Total Not Allowed

    I am trying to do a TotalType = dscSum on a field element in a DAP. When I select dscSum it tells me that Totals are not allowed on the field. The field is numeric. Documentation is sketchy on TotalType so I couldn't find what the rules are that govern its use. Any help would be appreciated.
  5. simon1974

    Treeview Refresh

    I have a form with multiple treeview controls. The nodes are fed via code from hierarchical tables native to the Access database. I have several "new record" forms that launch off of the main form which essentially create new records in the native tables. I would like to have a way, when the...
  6. simon1974

    Multiple Images For a Treeview Node

    Thanks gol4. I think this is a viable solution. The only problem is that the ImageList control squeezes the icons into the size of one, so when I create a new image that is twice as wide as the standard icon, the image is distorted/elongated. Anyway you know of that I can make the image wider...
  7. simon1974

    Multiple Images For a Treeview Node

    Is there any way that I can assign two images, side by side, to a treeview node instead of just one? I am designing a task and documentation database and I want an image for the type of document it is and then an image for the status (working, complete, reviewed, etc.) I wasn't sure how to get...
  8. simon1974

    Icon Drop Down List

    I am working on a database that essentially manages tasks. I want one of the fields on my form to be a drop down list of icons representing various task stages (in progress, complete, reviewed, etc.) I don't need text, just the list of icons that I designate. Can't seem to figure out how to...
  9. simon1974

    Outlook 2000 Form Problem

    I have created a form in Outlook 2000, saved as an oft file. The body has rich text and a hyperlink. When I create an email from the form, nothing shows up in the body (only the subject). The body does show up when I am editing the message but not in the outbox after I send it (the sent...
  10. simon1974

    QIF Conversion

    smedvid, thanks for your post. What VBA functions are useful in reading in the continuous record after record format of EDI/QIF? I'm not sure where to start. Thanks
  11. simon1974

    QIF Conversion

    I would like to create a small application in Access that will track credit card and banking transactions. I want to enable users to import qif files from various institutions. Does anyone know of a VBA routine or ODBC definition that will allow import of the QIF "record after...
  12. simon1974

    Incrementing a Number in Tiers

    I have a table and a query that lists bill numbers and adjustments. I want to create a field/formula similar to an auto number where the first instance of a bill number will be assigned 000 and then increment up 001, 002, 003 until the next bill number is reached at which point it will restart...
  13. simon1974

    Update Calculated Data from Linked Excel Table

    Jim, Thanks for your help... actually it seems that in order to get the formula value to update, I have to open the EXCEL sheet, save it, and then reopen the table. Closing and reopening the table doesn't seem to do the trick. Not sure if I'm missing something. Thanks. Sean
  14. simon1974

    Update Calculated Data from Linked Excel Table

    I have an Excel table that is linked to Access. One of the fields is calculated (in Excel). I am able to update the data from the entry fields but must open, save, and close the Excel file in order for the calculated amount to appear as updated in my linked table. Is their any way to call a...
  15. simon1974

    List box record number not updating

    Here is my scenario: I have two list boxes. One is populated from a "total population" table. One is populated from a "selected population" table. I have VBA code that adds the record from ListBox1 (Total Population) to the recordsource for ListBox2 (Selected...
  16. simon1974

    Refer to field using concatenated text

    Thanks Robert. What I really need to do is this -- I have several fields that have a preset payment amount (named, for example, [Payment1], [Payment2], [Payment3]. I have another field that does a calculation to determine which period I am in and returns a 1,2, or 3. I want a final field to...
  17. simon1974

    Refer to field using concatenated text

    It appears that the "fields" function does not work in a query. Can anyone offer any further help? Thanks
  18. simon1974

    Refer to field using concatenated text

    Shannon, I need to stick it in a query. Thanks for any help you might offer.
  19. simon1974

    Refer to field using concatenated text

    I am concatenating several pieces of data together which will tell me which field (among several) from which to pull data. The question is, how do I refer in a formula to a field by using concatenated text. Can't figure it out, would appreciate any help.
  20. simon1974

    Complex Financial Calculation

    Yes, the payments (cash flows) increase by 1/2% each period. I need to be able to return (not necessarily save) the interest and principal payments for each period of the annuity. I have done a two tiered annuity where the payment amount changed in the middle of the annuity. In that instance...

Part and Inventory Search

Back
Top