Search results for query: *

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

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

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

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

I am using A2000 I am looking to connect to data contained in another .mdb file using DAO and I am struggling to get started. ********************************** There is more than one way to skin a cat...but who wants a skinned cat?

I want to display in a label the number of available characters left available as a user enters data into a text box. I want this value to update as they enter each character. I am sure I have seen this done in the past, but cannot find the thread. ********************************** There...

I have Access 2000 and need to stream data to a printer. I have my print routine set up, all except the actual command to send data direct to a printer. E.g. If I wanted to send "Hello World" to the printer, what command(s) would I use? Thx ********************************** There is more...

Hi I am looking for a way to print basic data direct to a printer. The help I have found within MS shows I can print to a file, which is OK, but I want to print to a printer (and not necessarily the default printer. How would I print "Hello World" to my printer, for example? Thanks...

Hi I have seen in the past, a posting that shows the number of characters available as a user enters text into a textbox. I know it used the OnKeyPress Event, but i cannot emulate this satisfactorily...can anyone help? Thanks ********************************** There is more than one way to...

I have XP home on my computer and would like to set up a facility to boot into W98 when required, but have no idea where to start. Obviously, I don't want to lose any existing data. I will use W98 very infrequently, and, if i can dual boot, I would ideally like a time-out pause of a few...

Apologies first for ginving scant information, but I am doing this third hand. A client has Word installed and states that whenever a new document is created from a template, it is giving trhe new documant a .DAT extension. Changing the extensio back to .DOC makes the document readable in...

I am using Access 2000 on XP. I am either losing my mind or i am doing something so basically wrong. I have a table (1900 records). I was going to build a query with a series of tables, but have encountered a problem. I am expecting 15 records to show, but only one record is. To find the...

I have both Access 2000 and Access 97. I now have a new computer and need both versions of Access on my PC asI have an Access 97 application which won't convert to 2000. However, i installed 200 first and then 97, but Access 97 gives me a dialog which states... Microsoft Access can't start...

I am running Access 2000. I have a listbox and I want my app to select anitem in the list, so I issue the command: Me!lstClubs.Selected(n) = True (where n is a variable integer) However, the item is selected ok and the procedure runs to competion,but then all the controls on the form appear...

Hi i am developing an application for a snooker league with league tables etc. My question is: 1. Should I generate leaue tables from SQL each time they are required OR 2. Have a table that keeps track of results as they are entered and modify table if results are required to be changed /...

Hi I am using MS Access 97 and have been doing so for many years. I have just created a report that is sent to the printer, but the printer deletes it. You can see the status advising spoling, then printing, but then the document is deleted. I can print from any other application and also...