Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: FoxEgg
  • Content: Threads
  • Order by date
  1. FoxEgg

    Modifying An Existing Report

    Thanks for the assist... I have an existing Report (say Report A) I need another similar Report So, I thought that I would create a new Report (Report B) by opening Report A and save it as Report B then modify Report B.... BUT I don't seem to be able to be able to edit the TEXT fields....in...
  2. FoxEgg

    Deleteing a cursor and returning to original table

    I have been struggling with this forever I wanted to browse the table... but it was seriously slow BROW fields ENTRY_NUM :4 :H= '#', PRINT :P='!' :4 :H= 'Pr', TRANSFER :6 :P='!!!' :H= 'T/F' , percent_fe :5 :H= '%', FILE_NUM :R :28 :P='!!!!!!!!!!!!!!!!!!' :H= 'File Number', LAST_NAME :R :18...
  3. FoxEgg

    Running the same form over and over till done

    I am putting in data to a patient file... (finally) I am using a form with text box with a search for an Item Number to populate a grid. Then selecting from the grid ... Selecting the particular Item Number then using an Array.. appending from the Array and using INSERT INTO for certain other...
  4. FoxEgg

    Perplexed with loss of indexing

    Why doesn't this work ? I checked it in COMMAND WINDOW --------------- IT WORKS (keeps the indexing) I checked every step-------------------------- IT WORKS (keeps the indexing) I then run the same code in a form in a TextBox.Init --- IT Loses the INDEXING AND SO FAILS THE SEEK SELECT...
  5. FoxEgg

    Coding ComboBox Upclick and DownClick

    May I ask.. I have a Combo box on a simple form with values Mr, Mrs Miss Ms etc I can cycle thru clicking with the little arrow on the Combo with the mouse.. But I thought it would be nice to use the keyboard up down keys.. Hence my code. I checked with messagebox that 24 was getting thru...
  6. FoxEgg

    WHAT IS GridBase ? in Ramani's incremental search in Grid

    I gave up after a day of toiling on incremental search using SELECT and VIEWS and went to Ramani's FAQ on GRID Incremental Search ... and Ramani's stuff is usually fabulous... BUT It has a section of code... ThisForm.Refresh() ThisForm.GridBase1.SetFocus This.SetFocus...
  7. FoxEgg

    Incremental Search and SELECT with display in a GRID being a problem

    Sorry, back again... I use a TexTBox and InteractiveChange Event with Actual Last Name is calculated to lcLastName Actual First Name is lcFirstName SELECT LAST_NAME, FIRST_NAME, FILE_NUM, INSURANCE FROM 1; WHERE First_name = UPPER(ThisForm.lcFirstName); AND Last_name =...
  8. FoxEgg

    Changing Data in Original Table

    Hi Folks I am hoping to exploit the season's good will, because I fear my question is a bit basic and I probably deserve to be hauled over the coals for not knowing how to do this.... I have searched and tried to find the action I want to do.... without avail. OK so (and no criticism yet...
  9. FoxEgg

    Null Date

    Hi All I am converting a FoxPro prg to VFP I have used a null date example : date123 = {00/00/0000} in the original (so a display shows '00/00/0000'} So I changed the lines to {^0000/00/00} or {^0000-00-00} and VFP doesn't like it. (I have used {^2000/01/01} which works... but it will mean...
  10. FoxEgg

    SQL Syntax What am I doing wrong ?

    The following works SELECT patient_episodes.file_num , patient_episodes.title , patient_episodes.last_name FROM patient_episodes INTO CURSOR temp1 wHERE file_num = x So I want to label the columns.... and yet this doesn't work SELECT patient_episodes.file_num AS File Num...
  11. FoxEgg

    Deleting a misspelling .. using Word Automation

    Hi all I have written a simple program to solve a newspaper puzzle... the 9 letter scramble. It simply runs through all the 9 factorial combinations... and it generates millions of letter combinations. I write the generated 'word' to a Word document using a simple word automation ... and...
  12. FoxEgg

    Assist with a unique indexed file

    Thanks for your advice: Background: I have a database of my patients. I create an individual file number. (Based on first two characters of last name and reverse dob... called FILE_NUM) This file number can have an extension (especially if they have a surgery) Example: John Smith 1/1/1965...
  13. FoxEgg

    I cannt seem to populate a GRID with an SQL command

    I cannot get this to work (I am such a dunce) What I wanted to do was search for a NAME in a TABLE. I have a TEXT Box as a Data Entry and I wanted to use an entry format like... LAST NAME,FIRST NAME... where the comma was the clue that the letters followed were FIRST NAME.. I have put my...
  14. FoxEgg

    iMac Newbie Cant Access Office Word etc from Guest Account

    Background: I am very familiar with PCs but this is my first iMac. Loaded Office 2008 in the administrator... then opened a Guest Account and there in no access to Word PowerPoint Entourage etc.. go back to Administrator and there it is ! So is there a switch, or another work around solution...
  15. FoxEgg

    How to assign an event to a TEXT BOX

    This is a bit embarrassing... because I am not sure how to ask the question I want answered... But I can describe the problem. I have some code which I have put in the RIGHT CLICK event of a Text Box...It lets me Right Click and Copy or Paste (thanks to those who helped me develop that) LOCAL...
  16. FoxEgg

    Memo field problem

    Glad I am not the only one to be using FPD26... I have a memofield and I use Ctrl-W to write and close the memofield... It worked fine before I used Popups .. now the ctrl - W invokes them... Is there another way to write and save the memofield ? Or am I doing something dumb IF memofield >...
  17. FoxEgg

    EDIT slow to relinquish control after DOWN ARROW or PAGE DOWN

    New problem... I browse all the records in a particular patients file by using an EDIT and first I set a filter SET FILTER TO FILE_NUM = FNUM ... and then I EDIT FIELDS 1,2,3,4,5 etc WHILE FILE_NUM = FNUM The problem is that if I go down to the last edit page and then I push a DOWN...
  18. FoxEgg

    Slow APPEND FROM How can I speed it up ?

    FPD2.6 I have a large database... 100 MB I want to copy a set of entries to a new temporary database... But it is very slow (15 seconds or more) USE 1 COPY STRUCTURE TO QUOTE USE QUOTE TO 10 SELECT 10 APPEND FROM 1 FOR FNUM = FILE_NUM Is there any way that I can speed it up ? Thanks for...
  19. FoxEgg

    Refining a Right Click pull down menu

    I posted a similar enquiry ages ago... What I would like is a Right Click - Drop down list with various commands... This is like the Drop down lists you get in Excel or Outlook which have a series of options... (Rt Click a cell and down drops a menu) I got an excellent answer from Ramani...
  20. FoxEgg

    Adding data

    Sorry... this is probably a simple one for you guys.. I created a form and I want to add cheque data to the table via the form... Amount, Chq details, date, comment etc I had a series of text boxes for each field and, underneath, two buttons ... One 'ACCEPT' the other 'CANCEL' The 'accept'...

Part and Inventory Search

Back
Top