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 strongm 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. 426Hemi

    Access charts keep trying to reconfigure.....

    I ran MS Diagnostics and it seemed to fix the problem.
  2. 426Hemi

    Access charts keep trying to reconfigure.....

    I recently converted from Access 2000 to 2007. My original graphs were created in 2000. I converted the db, everything appears to be fine, but everytime I try to access my charts, in any mode, the Windows installer comes up trying to reconfigure. Am I missing references here? Also in print...
  3. 426Hemi

    Functions not working after install of SP-3

    After upgrading my Access 2000 to SP3 functions that used to work on my forms are no longer working. For example, I have an order form that has a subform on it that is a continuous form showing all the days orders listed by time shipped. I have set it up so that a user could click on the order...
  4. 426Hemi

    Check a drive for availability

    Thank you for your help, that did the trick!
  5. 426Hemi

    Check a drive for availability

    Is there another way to check a drive other than the Dir command? Dir works for me only when the computer I am trying to access on the network is up and running, otherwise, I receive an error. If the cpu I am trying to access is up and running, this code works [ availTest = Dir("the path +...
  6. 426Hemi

    i get a else without if statement when running if statment

    After the second Else, bring the If right up next to the Else part of your code, ElseIf .....etc. This should do it.
  7. 426Hemi

    sample access VBA module

    To output a report or form into Word, take a look into the OutputTo command by creating a Macro. You will have such options as having Word autostart, and the report can be saved in formats such as .rtf, etc.
  8. 426Hemi

    Turn Multi-Value Parameter Results into Individual Reports

    You may want to try using Sorting and Grouping in the report. Right click anywhere on the report and go to Sorting and Grouping. After doing so select the name of the field you want to sort, for example, student name, choose Yes for header and footer, select Each Value for Group On, choose...
  9. 426Hemi

    MouseMove Event

    Thanks to Jitter, that idea actually does work. But until I get better at VB, there must be an easier way to apply a rollover to each button instead of writing a MouseMove event into each control. Again, thank you for your input. I will check out the website....Looks good so far, thanks for the tip.
  10. 426Hemi

    Problem with Calculating Values which are based on Previous Values

    In the report design view, when you right click on the control you created to calculate the balance, go to Properties, Click on the Data tab, and where it states, RUNNING SUM, click over all if it is for one client, over group if have several sets of data grouped by client. I am not sure how you...
  11. 426Hemi

    MouseMove Event

    This may be a simple question, but is there an easy way to attach a mouse event to a control such a a MouseMove event that will change the ForeColor of a control's text (such as a caption on a button) and revert back to the original color when the mouse moves out of the area of the control (Just...
  12. 426Hemi

    Access as a large scale operation

    Thank you all for your input, I appreciate all who take the time to read these posts and provide such great information. This truly is an excellent site for those looking for tech help.
  13. 426Hemi

    Access as a large scale operation

    Does anyone have any thoughts to Access as a large scale database? Can it be used effectively with thousands of transactions stored within? Can an Access Database be upgraded to SQL Server if need be down the road? I recently completed a database application in Access for my boss at one location...
  14. 426Hemi

    Mysterious problem with Access on small network with WinXP and 98

    Thank you all for your help. I recently switched the data to the Win98 machine and now all is well. I am quickly learning how MS can make you look silly in a hurry with these quirky problems that can arise. Again,thank you for your insight.....
  15. 426Hemi

    Mysterious problem with Access on small network with WinXP and 98

    Thanks for the response. The mystery continues today. I made a new database, imported the existing data from the most current copy I have, and then created a shortcut from the Win98 machine to the host, the XP machine. Lo and behold it worked. I then went to the XP machine and accessed the new...
  16. 426Hemi

    Mysterious problem with Access on small network with WinXP and 98

    Does anyone know of any conflicts between XP and Win98 when accessing a database over the network? I only have a two station network, directly connected, no hub. My application was running fine for several days and now the Win98 cpu cannot access the database on the XP machine. I tried one of my...

Part and Inventory Search

Back
Top