I'm guessing this might be a bit late, and I might have somewhat over-simplified your problem, but still...
Have you tried it without the '=' sign?
I can't think of why it wouldn't work with it in, as it works just fine for me. (Lotus Smartsuite Millenium Edition).
Without the equals sign it...
How about have column C with a sequential number, and then including that in your formula.
I read a book once called '101 Things to do in Binary'.
It was the best 5 things I ever read.
Creating a macro within approach is quite straightforward, and doesn't really need any technical know-how. It's all point-and-click, and selecting commands from lists.
Do a search in the Approach Help for 'Creating New Macros' and follow the steps there. Once you see how it's done, you'll be...
Are you launching your database from the APR file or the DBF file?
You probably already know that the APR file is the view file where all of your designs are stored, and the DBF file is the actual data.
I read a book once called '101 Things to do in Binary'.
It was the best 5 things I ever read.
The way I have got around a similar problem in the past is to create an identical view to the data entry one, but make it read only.
When users enter their comments, they would be sent to the read-write view, via macros / buttons etc.
After they have submitted/entered their comments, the...
If it is only the text of the email you wish to copy, have you tried looking at the properties tab, and highlighting the contents of the 'Body' field.
You should then be able to copy (CTRL+C) the info and paste at will.
I can't try this until I'm next in the office, but I think it might have...
I would guess that the database could have been joined to others. When you copied the database, the joins remained intact.
This could explain why they were all deleted.
Depending on how often you need to do this, I would probably export the information into a spreadsheet and then manipulate it...
Have you tried replacing the field on your form?
I used to have a few problem with fields suddenly becoming <unbound>, and found that the quickest way to solve it was to delete the item, and then re-insert it.
You should then be able to select your macro.
I never found out why it happened...
Hi,
I would solve this by having a calculated field with the following formula:
If(Church = "Church A", If(Choir = Yes, ChurchACharge,0),If(Choir = Yes, ChurchBCharge,0))
Because the charges will increase over time I would suggest that they are kept in fields, and not coded into the formula...
Not sure if I completely underestimated the problem here, but have you tried creating a macro that finds all records between the specified dates and then runs another macro which starts at the first record, and then sets all the required fields to '' (blank).
(you will have to use the Set...
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.