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!
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...
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.
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.
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...
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.
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.
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 &...
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.
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...
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?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.