Recent content by ormsk

You've kinda answered your own question: ...and I make a shortcut to a client computer... ...I had thought, probably erroneously, that only the computer which runs the solution needs these files The shortcut may indeed point to a file or executable that exists on another machine, but the...

Just a long shot... you don´t specify whether Windows 7 is 32-bit or 64-bit. If it´s 64-bit, you may be looking for the control in the worng area..See Sytsem32 vs WOW (windows-on-windows) folder ********************************** There is more than one way to skin a cat...but who wants a...

I have seen a few examples of a workaround to this problem, but the ones I have seen involve creating a function or require an iterative process. Unfortunately, the solution I need has to work within 1 SQL statement as the users only have a window that allows a single SQL statement. I am...

I have a task that needs to return the last value and the previous to last value on the same row. I know I can return two rows, but for mailmerging purposes, I need these values on the same row. For example, to keep things simple, we have 2 tables: Property Table PrID (Primary Key), Address 1...

I will be creating a front end that allows users to enter a series of words, with an AND and an OR option, along with other searchable criteria. This will return a list of documents along with the number of occurrences of the entered word(s), so it something I want to develop. Also, there are...

Using VB6, I want to give users the ability to search a folder that contains .doc files that have certain words, specified by the user contained in them. However, I wanted to do this without automation. I thought about opening the .doc as a text file and searching for text, but of course Word...

I am not sure if this is possible... I want to create a query that will dynamically refer to an INNER JOIN statement dependant on a value of a field e.g SELECT Documents.ID , Documents.Type FROM Documents INNER JOIN Owners ON Documents.UserID = Owners.ID; The above is straightforward...

I am using VB6 to automate Word (2000). Basically, the app opens up a WORD.doc and searches to see if a certain colour exists. This had been working fine for a while, but now returns Object variable or With block variable not set (Error 91). However, I have not amended the code anywhere...

You mention the addition / change of a different printer. Is the printer connected directly to any PC or to a hub. Network speed issues are sometimes attributable to a printer connected to a hub. ********************************** There is more than one way to skin a cat...but who wants a...

I have already checked the forums for this specific problem, but with no success. I am creating a routine in DB (A) and I want to copy a table from DB (B) to DB (C). I have looked at the TransferDatabase command, but this only appears to allow you to copy an object into the CURRENT DB...

I want to know if the following is achievable: An app we have will open up a word document The user can make changes if they wish when they close the document, I want Word to save without prompt NOTE: We currently use AutoSave, but this has a detrimental effect on users across a network. I am...

I have access 2000 and have exported some objects (forms and reports) into a new database (also vers 2000). However, when I open the new db and look at the objects in design mode, the code has all disappeared. Fortunately, I have got around this by using access 2002, but wondered if this is a...

Clients send in mdb's for testing (checking for missing records in a particular table) They send in a 'corrupted' mdb along with a good known backup. My app allows user to browse through to both files, wherever they may be. The app then checks a prticular table (that exists in both mdbs)...

The problem is that the name and locations of the other mdb's are not constant (just the structure will be constant - table names etc). The user selects these on the fly subject to the task in hand. ********************************** There is more than one way to skin a cat...but who wants a...

I have an application in Access 2002 that 'accesses' data from other mdb's. I want to create a query that accesses tables from these mdbs. The code exists in mdb (A) and I want to create an append query that appends from a table in mdb (B) into a table in mdb (C). I can do this via...