Search results for query: *

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

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

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

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)...

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

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

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

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

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

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

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

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

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

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