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!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by RichF01

  1. RichF01

    Multiple Users with Linked Oracle DB

    Hi All, I have developed an Access 2000 system which can be used by many different users, with a series of links to tables in an ODBC back end (which i have no control over). This is on a multi-user network. When I use the system, I am prompted for my password access to the ODBC back end...
  2. RichF01

    Excel controlling Access controlling Excel!!!

    Found the problem In the access coding I should have been using GetObject rather than CreateObject.
  3. RichF01

    Excel controlling Access controlling Excel!!!

    A brief overview of the system I am devloping is an Access data repository system, that feeds into Excel where the report writing is done. (I know Access can report write, but everyone who uses the system (including me) is happier with Excel). I have a functioning Access system that...
  4. RichF01

    Controlling Many TextBoxes on One Form

    I am still interested why my last post is, but I have found a way round it using keypress event Using a variation on Combo's code above . . . Private Sub cTextBox_Change() If cTextBox.Value <> "-" Then If Abs(cTextBox.Value) > 100 Then cTextBox = Left(cTextBox, Len(cTextBox) - 1)...
  5. RichF01

    Controlling Many TextBoxes on One Form

    Combo, brilliant start for me, thanks a lot. However, one little niggle is that I am validating the textbox value, (obviously a scroll bar has finite values it can take) and I want to do it on the BeforeUpdate event, but in the Class Module editing pane, I do not have the beforeupdate event...
  6. RichF01

    Controlling Many TextBoxes on One Form

    I have a userform with 66 Text Boxes and 66 Scroll bars, which are paired up (the text box shows the value of the scroll bar, and if the text box is written in by the user, the scroll bar changes accordingly). I have code that works for one text box/scroll bar pair and is easily replicated to...
  7. RichF01

    Open Access Database from Excel, and then run an Access Module

    Molby You absolute star. Works perfectly. That pretty much finishes my project so you have just made me a very happy man Thanks a lot! Rich
  8. RichF01

    Open Access Database from Excel, and then run an Access Module

    Hi people Thanks in advance From an Excel macro, I am trying to open an Access database and then run a module within the database. I can get Access opened in a couple of ways, but can not open a specific file. Dim Retval Dim fileval Retval = Shell("C:\Program Files\Microsoft...
  9. RichF01

    Passing variables to Function Modules

    Hi All, Rich the Muppet here again. I have a module (constructed by Access by Save Macro as Module) as shown below. However, I am trying to make the input and output locations variable. The input files (highlighted in red) are all related by date, and are different in number, depending on date...
  10. RichF01

    Excel VBA Process in Access VBA

    Jerry Cheers for the help. Now working well. Still not convinced it is particularly elegant, but it does the job Thanks Rich
  11. RichF01

    Excel VBA Process in Access VBA

    Sorry, I might not have explained myself very well there. I have tried what you suggested. All the post codes in Table 1 are of the form AB12 3CD. However the post codes in Table 2 are of all forms A, AB, AB1, AB12, AB12 3, AB12 3C and AB12 3CD. So for example, in table 1, the Post Code WX89...
  12. RichF01

    Excel VBA Process in Access VBA

    Hi I have got a search routine working in Excel, but need it in Access as the number of records is too large for Excel. I have two tables. Table 1 has fields PCode and general data, Table 2 has fields Pcode and EXZ. The number of Pcode in Table 2 is only exhaustive when the search routine...
  13. RichF01

    Counting records in multiple defined ranges

    After fiddling with brackets works like a dream. Thanks a lot. Rich
  14. RichF01

    Counting records in multiple defined ranges

    I have a large database with two relevant fields that I am attempting to extract and summarise. eg Area Volume SW 10000 NE 8000 NW 7500 SE 12000 SW 9000 SW 8000 I would like to summarise the data in an array, with Area in rows and...
See more

Part and Inventory Search

Back
Top