Search results for query: *

Hope this is the right forum to ask this question. I'm trying to write a simple query based upon a single table and all I want is an extra column in the query that numbers the records in the query starting with 1 and ending with the number of records in the query. i.e if four records in the...

Does anyone know if you can export an access table to an excel spreadsheet in a transposed format (column headings become row headings) directly without having to create an Excel object to make the manipulations? I'm hoping that Access has some function that's like...

Hi I would like to save a second copy of an Excel worksheet onto a network drive upon a user exiting Excel. What event do I tie my subroutine to in order to trigger my subroutine? I was hoping that there was an unload or quit event in Excel that I can tie my subroutine too. Any suggestions?

If I have a txtboxProfiles textbox in the details portion of my report with the hide duplicates property set to true, if I have more records than it fits on one page then on every new page the value in txtboxProfiles shows up. This is fine but what is the trick so that when the value of...

Does anyone know if Access 2003 has a significant digits function? i.e. (3.0, 3) get 3.00 (3.1, 2) get 3.1 (0.2, 3) get 0.200 (0.21,3) get 0.210 I'm looking through the threads and help and haven't come across anything yet and was hoping someone had the answer. Thanks

I'm brand new to access and have a question about building forms. How do I add a field list to a form if the form is already created without one? (i.e. built from 'create form in design view' link) I've tried setting the control source on a text field to a table and field like so...

Hi all. Could some please show me how to direct the results of a query into a user defined window created using DEFINE WINDOW myWindow.... For the life of me, I can't seem to find the answer in the threads.

Hi everyone, in VFP 6.0 is there a built in function that will copy the contents of an array to a table? If not what is a clean way to do it besides writing code to create a table and then walking the array. Thanks. -suey

I've got everything pretty much working in my VFP app. All I need now is to create a System DSN on about 20 Windows Xp machines. Rather than doing it one by one does anyone know if I can use VFP 6.0 to automate the creation of the system DSN on those machines? Or should I look at another...

Hi all, could someone please tell me how to get the current page number that the cursor is on in a word document. Which collection of objects is this information found in??

Hey everyone, I was interested in getting some sample code on how to get VFP6 to loop through and open all dbf files in a directory like 'c:\vfptables'. Currently I have the table names in an array and loop through that to open the tables I need. I think this is the hard way of doing it. -suey

I'm interested in knowing what the best way is to open multiply word docs in vfp6. If I have 10 docs i.e. 1.doc, 2.doc, 3.doc, etc and want to open all of them I use the following simple loop. lcSuffix = '.doc' oWord = CREATEOBJECT('Word.Application') FOR lnCounter=1 TO 10 STEP 1...

I'm using VFP 6.0 and have several questions concerning the use of database containers. If I issue the following command: open database mydatabase exclusive this shouldn't affect the opening of the tables attached to this database container should it even though the dbc is opened exclusive...

Hi everyone, I'm running VFP 6 and had a quick question on hiding and showing multiple forms. If I have a command button on form1 that basically does this: thisform.hide do form form2 and then on form2 I have a command button that does this: this form.hide With both forms now hidden. How...

Hi.. This is another one of those beginners questions that I'm hoping someone can set me straight on. I'm playing around with VFP 6.0 and it's ole controls. However I can't seem to be able to access a majority of the ole controls. I have a form opened and when I try to add an ole object the...

Can anyone tell me what the easiest way is to copy the contents of a character field to a memo field in the same table? I was thinking about copying the contents of the character field into a string variable and then use a replace command to stuff it into the memo field. Seems like it's the...

Hi all, could someone give me a hand? Due to my lack of c++ programming skills I'm having trouble creating a nested for loop that would walk through a 6x6 2-D array in the following manner: element[0][0] element[0][1] element[1][0] element[1][1] element[0][2] element[0][3] element[1][2]...

Hi all, I seem to have something set incorrectly in Excel 97. All my spreadsheets no longer display the decimal points. This includes any new ones that I create. The cell is formatted as number with two decimal places. However a 5.25 just shows up as 5 25. Instead of a decimal a space...

Got this weird bug in Office XP when using Word. If I open Word then File..Open the open dialog box is opened behind the Word document and that document starts to blink. I need to minimize the document in order to access the open dialog box. In addition to that the only item that you can...

Can anyone give me a quick heads up on how to convert a string such as 8 into the digit 8 in vfp? thx -suey