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!

  • Congratulations IamaSherpa 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: *

  1. Impart

    Jpeg files into picture plus field

    No, we now onl;y use bitmaps but the memo file is mega! Is there any way to manage it, like compress?
  2. Impart

    Sorting a alphabetic field in non alphabetic order

    PS 1,2,3 or 1st 2nd 3rd seems better still
  3. Impart

    Sorting a alphabetic field in non alphabetic order

    You could use letters A B C to represent High Medium Low, that seems simple enough but if you want the words then aHigh etc. would work
  4. Impart

    How to print selected record on partially used laser lable sheet?

    Do you mean putting the sheet through more than once? I tried this and got in a right muddle with labels going round the roller and would never try it again!
  5. Impart

    Jpeg files into picture plus field

    We have front counter security photos taken by web cams to include in a picture plus field. This needs to be done quickly as the counter can be very busy. The Import Picture routine is too slow so we have attemted to use drag and drop direct from the camera software with limited success. Where...
  6. Impart

    Running a macro once in a session

    I would make a numeric variable ISDONE and start the import macro : RUN IF ISDONE=1 END THIS MACRO .... Remainder of import routine .... SET ISDONE=1 To be certain use an Open macro to set ISDONE to 0 But I'm not an expert.
  7. Impart

    I can't add new records.

    Perhaps you have a non standard menu system. In design look at the form's properties, on Basic Tab if the 'Attached Menu Bar' is set to something other than Default then try 'Create, Custom Menu' & edit the special menu to include any other items you require.
  8. Impart

    Hit the limits

    Msg 'Charts Limit =20 reached' I expected to get over this by running a macro to open another APR and get an extra 20 charts. It didn't, I got the same msg. I need additional charts. Also I will need lots of reports & I seem to remember that is a low limit too. A second associated point is...
  9. Impart

    find "not including" text

    Thanks Paul, it works fine but I don't see how. I can understand the Position statement but I have only seen IF documented as IF(test,then if true, else if false). This looks like IF(test) Can you enlighten on this version of If please.
  10. Impart

    find "not including" text

    I need to write a complex search, 1 aspect will be to determine if a text field does not contain the word 'video'.
  11. Impart

    WRONG RECORDS IN WEEKLY REPORT

    PPS Ooops, what a waste of time. Yours and mine - sorry. My one line macro that changes the view to this report had spawned an extra line 'Find using stored find'. I havent got any stored finds. My apologies for wasting your time, problem solved.
  12. Impart

    WRONG RECORDS IN WEEKLY REPORT

    PS I have listed both the good and the faulty records as found by the search routine. Before and after running all other summaries the records list correctly. After running the problem report the records are allways the same ones; found 1895 of 55597, these are dated from 1/1/04 to date &...
  13. Impart

    WRONG RECORDS IN WEEKLY REPORT

    Thanks Paul, there are several joined joined tables in this apr but this part is all on the one dbf and yes I have checked (several times!). Thats not the answer.
  14. Impart

    WRONG RECORDS IN WEEKLY REPORT

    I have various reports analysing data from a single .dbf. These are all Summary Reports with the group set to field 'date', some by month some by week. All except one work as expected. All data is searched for on a screen based on the same dbf file then the reports can be launched via buttons...
  15. Impart

    Find NonActive customers

    I need to select 'old' customers, people who have not spent with us recently to do a mail-out. We have the usual invoice file with date, amount, cust-ref fields etc. How can I find customers to be sure that there is no invoice for them with a more recent date?

Part and Inventory Search

Back
Top