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

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

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

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

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