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 wOOdy-Soft 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: JimRich
  • Content: Threads
  • Order by date
  1. JimRich

    Date() & Time functions do not work

    I have installed a program on 4 different computers. On one of the computers the date and time functions do not work. It is running Windows98. I let Office2000 repair Access. The rest of the program seems to be working fine. Any ideas as to what causes this problem. Any help will be...
  2. JimRich

    Comparing values in objects on the main form and subform

    I need to compare the values in an object on the main form to an object on the subform. The main form (Donors) has an object called TotalCommitment. The subform (donations) has an object called Total. The following code gives me error message 2450. MSAccess cannot find a form named...
  3. JimRich

    Cannot open file message

    When I try to open a web page I get the following message: Server error: Cannot open file "service.lck" for writing. That file name might be "service.ick", I can't tell which. I understand that this might be a server error. I have full administrative rights. My OS is MS...
  4. JimRich

    3 column report prints right on one computer but not on another.

    My 3 column report prints right on my home and my office computers but when I install it on two others it only prints one column. They all are the same version of Access 2000. All computers are set in Page Setup/Columns to the same settings for 3 columns. All other settings on the Columns page...
  5. JimRich

    Can I pass a variable from the open event in a report to

    How can I pass a variable from the open event in a report to the report itself. The query for the report already has a couple of inner joins and a union. It is really complicated for me. Now my user needs some additional information that I need another query to calculate. I then have to...
  6. JimRich

    On Docmd.close a dialog box wants value for Forms![Find Skills]!listFi

    On Docmd.close 2 dialog boxes come up asking for values for Forms![Find Skills]!listFindSkill and Forms![Find Skills]!listFindSubCat. These two criteria are used to fill the subcategory list box based on a value selected in the combo box. The other is used to fill the skills list box based on...
  7. JimRich

    Finding a record based on a comboBox error msg

    The code I am trying to used worked in an Access 97 application. However I am getting an error in 2000. Here is the code: Sub cboFindLname_AfterUpdate() Dim rst As DAO.Recordset Dim strSearchName As String Set rst = Me.Recordset strSearchName = cmdFindLname.Column(1)...
  8. JimRich

    Control source in select statement does not work.

    I have a report built on a control source with 3 criteria based on a form. The report will run correctly if the form is not open and each of the criteria is entered when requested. If the form is open I get an empty record. The form name is "Find Skills", all the criteria is present...
  9. JimRich

    Control source is select statement does not work.

    I have a report built on a control source with 3 criteria based on a form. The report will run correctly if the form is not open and each of the criteria is entered when requested. If the form is open I get an empty record. The form name is "Find Skills", all the criteria is present...
  10. JimRich

    How to save a value selected in a list box?

    I have a list box that works fine. My problem is that I need the selected value in the box stored in a varaible. I have tried the following in an on click procedure: dim varC as string varC = Forms![Find Skills}!listFindSkills.column(2) and varC = me.listFindSkills I get varC = Null Any...
  11. JimRich

    Where can I find good Add-ins for 2000

    I need a good source for addins for MS Access 2000. I especially need the Switchboard Add-in. I have searched on this and other sites but have come up empty. Thanks for your help. Jim JimRich
  12. JimRich

    No compatible data source

    Although I have been programming since 86 I have never actually programmed in VB6. However, I am teaching a High School class in VB6. I know that is not very good but it is my situation. Here is my problem. I receive the following message when trying to set up a DBGrid. No compatible data...
  13. JimRich

    Disable the backspace key in MS Word 2000

    How can I disable or map the backspace key in MS Word 2000? I teach kid how to type and they are frustring themselves using the backspace key. I need to be able to toggle it.
  14. JimRich

    Disable Backspace Key in Word

    How can I disable the backspace key in MS Word 2000? I teach kid how to type and they are frustring themselves using the backspace key. I need to be able to toggle it.
  15. JimRich

    Hyperlinks in MS Word

    I have hyperlinks in a file that is used by everyone on my network. On one computer the word "hyperlink" and the bookmark are spelled out with {} around them. Where is the setting to fix this problem. Thanks! Jim
  16. JimRich

    At Load Access can not find file system.mdw

    I had a virus and this problem started after the virus was gone. Access 2000 has been reinstalled several times with the same messages reoccuring (I also reinstalled the operating system.) There are two messages that happen when I open Access one following the other.(They also happen if I try...
  17. JimRich

    Prevent save in edit mode

    My form starts in Edit mode i.e. a blank entry form. When data is entered and the form is closed the save is automatic. That is okay. Sometimes the user exits without entering data. In that case a blank record is added. I do not want the blank record saved. How can I prevent a blank record...
  18. JimRich

    Access 97 and Windows XP

    I upgraded my computer to one that came with Windows XP. I have a program written in Access 97. Even though I installed Access 97 on the new computer I am having trouble with my program. It is on my server and runs fine on the other computers on the network none of which are XP. I do not...
  19. JimRich

    Losing value in key field

    When my user enters a new child record, the last tab page causes the linking key to the parent record to be erased. The user selects the Source of Business from a drop down box; the cursor is moved to the end of the pre-defined text so additional info can be entered. Upon changing to any other...
  20. JimRich

    Merging Access data into a Word doc.

    Like many people I want a single button that will open a Word Mail Merge doc. What I would like is when the Word doc is opended it would have the fields already filled with the data and not have to run the Mail Merge function in Word. My user will make a selection by Letter Name on an Access...

Part and Inventory Search

Back
Top