Search results

  1. F

    installing new application onto server

    HELP ! I tried installing an application onto a server and a message came up explaining that the version of the DAO350.DLL file trying to install is newer than that of the one on the server. Also note that the message did not allow me to override the older version with this newer one...
  2. F

    apprehensive about my next step - distribution

    I have finally completed my application and miraculously I also have a customer lined up to purchase a copy. The situation is as follows: eventhough I stressed this was designed as a standalone, he wants a second "user" to gain access to the data - viewing only (which I can do). Compiling a...
  3. F

    importing excel file from MS Access

    Our IT dept just reloaded MS Office and now I can't import excel files into Access. When I click on the GET EXTERNAL DATA button and then click on IMPORT, I get the usual dialogue box listing the file types with the exception of excel files. I installed and re-installed ALL selections having to...
  4. F

    Faxing a report

    thanks. For some reason I expected something much more complicated. I'll give that a try.
  5. F

    Faxing a report

    I too have been asked to come up with such a feature. Are you saying that if we have a printing device (we have a printer, copier, scanner all in one) that we may be able to send a report through this machine's software? Please explain as I am really interested in learning more about this...
  6. F

    Is this possible - Select Field Query

    sorry the bmp file was too large. try this!
  7. F

    Is this possible - Select Field Query

    I personally have never seen it done that way however, I can assure you that book has what you want. I had a look at the code and it's not that bad. It's not as simple as you would hope it is. I'll try posting a snapshot of the form itself and you'll have a good idea of what the sample does...
  8. F

    Tracking Inventory Using Tables

    Jamie, Not exactly sure what you want (probably cause I'm reading it diffrently and cant understand why you would want to have one field read the same as another) But, if you have a look at the samples that come with ACCESS, there's an inventory database that may provide some insight. Sorry...
  9. F

    Is this possible - Select Field Query

    John, Yes it's possible. Most of my forms are designed with the user in mind and having them select from a combobox or even simply enter some text or numbers is something I include all the time. Unfortunately, it's a very complex and lengthy process. Most is code written using VBA and if you...
  10. F

    help with this SQL script please

    just can't get this query to perform right. I'm trying to modify my script and keep running into a circular reference error. Any suggestions would be appreciated. SELECT DISTINCTROW tblRatesHeader.Quote,tblRatesHeader.ServType, tblRatesHeader.ServLevel, tblRateDetail.Currency...
  11. F

    summing sub forms

    you may want to include Not IsNull in your code. I think that may do the trick
  12. F

    Having trouble calculating tax

    reading this post painfully reminds me the all too real tax dilemma we have in Canada ! :eek:
  13. F

    Having trouble calculating tax

    might I suggest that you also include the HST and while your at it, breakdown the PST's by province since they vary. (better off to do right from the start than to recode at a later date because you know someone is going to ask for it!) Just a thought Ray
  14. F

    report information taken from multiple sources

    thanks Rich I'll give that a try.
  15. F

    report information taken from multiple sources

    I checked the forum for similar problems and came up empty. Hope someone can help me out. I have a rpt with detailed information and that information is then followed by a summarized version with totals, min, max, etc ... The detailed protion is not a problem and is fed from tableA however...
  16. F

    calculating a sum using a column from list box

    here's some code I came across. It is based on listbox properties for VB and I understand that their are some differences with Access but can you see any possibilities with this code? Private Sub CommandButton2_Click() Dim a As Single For x = 0 To ListBox1.ListCount - 1 a = ListBox1.List(x) b...
  17. F

    calculating a sum using a column from list box

    are you speaking of a "running sum" in the underlying query?
  18. F

    calculating a sum using a column from list box

    Thanks Rich. I saw that code a couple of days ago when I was reviwing previous messages however this code runs when one selects a record. I need the code to run before selection. As a matter of fact, selecting has nothing to do with this. This code should only run once I execute a list and add...
  19. F

    calculating a sum using a column from list box

    Does anyone know how to reference a column from a list box AND able to add up all the numbers (column is $$$) to arrive at a total using a textbox (TOTAL). I've been going my reference materials and noticed very little information on listboxes and it's properties. Thanks
  20. F

    open form with related details when double clickin a selected item in listbox

    I've been at this for several days now and not anywhere closer now then when I started. Does anyone have a sample where when double clicking on a selected item from a listbox, will trigger a form to open with it's related information? Would appreciate ANY direction at this time. Thanks very...
Back
Top Bottom