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 gmmastros 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. cschnable

    Function is not available

    Thanks! I will give it a try.
  2. cschnable

    Function is not available

    Should I just remove this reference Microsoft Windows Common Controls-2.6.0 (SP4) or replace it with something else
  3. cschnable

    Function is not available

    The following references are listed Visual Basic for Applications Microsoft Access 10.0 Object Library Ole Automation Microsoft ActiveX Data Objects 2.1 Library Microsoft Office XP Web Components Sagekey Security Microsoft Windows Common Controls-2.6.0 (SP4) Microsoft DAO 3.6 Object Library
  4. cschnable

    Function is not available

    I am using the Sagekey Solutions runtime package so I really don't think it is the runtime causing the problem and all of the customers are using Win XP. I am wondering now if the problem might be referenced to their internal clock settings since part of the function includes "Date()". I am...
  5. cschnable

    Function is not available

    I have a program which is run from an Access mde file in a runtime environment and a few people using it on their computers get this error when trying to open the referenced form. 99% of the people can open the form with no problem. Function is not available in expressions in query...
  6. cschnable

    Idea's to licence application

    Check out www.sagekey.com They have a great security package for a very reasonable price. I have used it for many of my programs and it is a super package.
  7. cschnable

    Change Totals from Positive to Negative or Vise Versa

    In a query is there a way to change a calculated amount form Negative to Positive - such as ($63,568.00) to $63,568.00 I actually want to append field totals to another table and when they are appended I want to reverse the + and - figures.
  8. cschnable

    mdw reference in (shortcut) startup command

    Thank you for your help - Just what I needed Thanks
  9. cschnable

    mdw reference in (shortcut) startup command

    I haven’t used this option in a few years and I forget the command line layout for using a specific mdw file for a database – I anyone can help me it would be appreciated – I cannot find the answer in access help. If I want to run the following program “C:\Program Files\ProgDir\Program.mdb”...
  10. cschnable

    Referencing lost script files

    I have an InstallBuilder 8.1 installation script which was written by a third party and in the main script it references the following script files: %_WISE_%\Include\Access 2002 Runtime\reboot.wse %_WISE_%\Include\Access 2002 Runtime\MSDE.wse %_WISE_%\Include\Access 2002...
  11. cschnable

    Combining Number field with Date()

    Thank you for your help - I just figured it out - I used =[MyNumber] & "_" & Format(Date(),"dd_mm_yyyy") It worked fine
  12. cschnable

    Combining Number field with Date()

    How do I have a form field display an existing number field with Date() if The number field = 971 and I put [Field]&"_"&Date() I get 971_7/16/2004 I want it to read out as 971_7_16_2004 Any help is appreciated - Thank you!
  13. cschnable

    PIM Calendar

    Does anyone have any suggestion on a program which I can purchase to add to my access datase to add a calendar for scheduling - Or is there a way to tie my data to outlook without having to import/export. I hope someone can point me in the right direction!
  14. cschnable

    Stand-alone Access 2003 App for WIN 98?

    Check out sagekey.com they have a beautiful runtime package wqhich runs in all levels of Windows
  15. cschnable

    Changing a plus entry to a minus entry

    Thank you very much - WORKED GREAT! I had a major mind lock (grin)
  16. cschnable

    Changing a plus entry to a minus entry

    I have a payment form in which one of the fields is [amount]. How can I enter a number without preceeding the number with a negative sign every time I record a payment. I want the number to go into the table as a negative without pressing the negative button every time I make an entry. Any...
  17. cschnable

    Finding files to open while in access

    How do I open a folder, or a file list while in access so I can open a word or excel file without getting out of access.
  18. cschnable

    Using second collumn in Combo Box

    Angela - It is a bound form with bound fields Part_Description and Part_Price At the present time I am using a combo box to bring up the part description, and another combo box to bring in the part_price. (both from the same query) This means that the user has to make 2 selections of...
  19. cschnable

    Use second field from COMBO Box

    It shows an error and states the following Cannot find Macro which named Part_Price = Me!cboPartsList.Column(1)

Part and Inventory Search

Back
Top