Recent content by Palemo

Hi, I have set up the following Event Procedure for ON CLICK of a command button: DoCmd.SendObject , , , ([txtEmail]), , , ("Classified"), ([txtMain]), 0 This basically emails the address in the txtEmail field the details in the txtMain field. THe email sends fine, and the body is fine...

Hi, I need to limit a memo field to 35 characters per line. That is it needs to rap after 35 characters onto the next line. Once the user has finished typing in text, I then need something to count the number of lines. Can anyone help me with this? Many thanks.

Hi, I need to limit a memo field to 35 characters per line. That is it needs to rap after 35 characters onto the next line. Once the user has finished typing in text, I then need something to count the number of lines. Can anyone help me with this? Many thanks.

All transactions are in one database, all members are in one database. Transactions database holds the member id as well as subscription details. We mail out on the last edition that the person is subscribed to. The problem is, if that person has resubscribed he/she gets included in the mail...

The problem is that if I do renewal = false and edition end = 4 then I still get the same information. For example: Name1 expire 3 renewal no Name1 expire 6 renewal yes Name1 expires on issue 3, but renewed from 4 - 6. I run the query looking for 3 as a last issue, and renewal = false, and I...

Correct, every transactions gets a new record. We record their memberid, and all subscription related data (price, quantity, expiry etc.). I run a query that asks for subscription end so we can send out a renewal email. It looks in the subscription end field, and if the values match then it...

I do have two tables, one called members, and the other subscriptions. All subscibers are in one table, and all transactions (ie subscriptions) are in the subscriptions tables. The problem with updating their record is that we need to keep history reports for each subscriber. I have a subform...

Hi, This has been bothering me for some time, so I will attempt to explain the situation. I run a subscription database, that basically holds user information and their relevant subscriptions. I have all the data in one table. The problem is this: if a member subscribes for a year, the...