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 Chriss Miller 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: cschnable
  • Content: Threads
  • Order by date
  1. 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...
  2. 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.
  3. 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”...
  4. 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...
  5. 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!
  6. 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!
  7. 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...
  8. 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.
  9. cschnable

    Using second collumn in Combo Box

    If I have a form with 2 fields, such as Part_Number and Part_Price, and I use a 2 collumn (Part_Number, Part_Price) Combo Box in the Part_Number field to enter the Part_Number. How do I have the part price automatically be entered into the Part_Price field on the form?
  10. cschnable

    Use second field from COMBO Box

    If I have a form with 2 fields, such as Part_Number and Part_Price, and I use a 2 collumn (Part_Number, Part_Price) Combo Box in the Part_Number field to enter the Part_Number. How do I have the part price automatically be entered into the Part_Price field on the form?
  11. cschnable

    Need help with syntax

    I am trying to generate the day of the week in a query, the following is not working and I don't know why. - Can anyone help me out. WeekDayText...
  12. cschnable

    Using more than 1 field from a COMBO BOX

    I know how to select which collumn I want to use from a combo box in that field. But how can I use the second collumn from the same selected row in the combo - FOR ENTRY INTO ANOTHER FIELD ON THE SAME FORM?
  13. cschnable

    Office XP Compatability

    I know that Office XP is using Access 2000, but it being a new program, does anyone know if it is fully compatible with the current Access 2000. I don't want to spend the money for XP, and load it on my machine just to find out that there are going to be problems with the databases I already...
  14. cschnable

    BackEnd Security for linked files

    I am building an Access application with a backend Access db and I cannot get the tables to link unless I give the users group administration rights on the tables. Does anyone know of a way around this, because I don't want everyone have administrative rights to the tables. Thanks for any help...

Part and Inventory Search

Back
Top