Recent content by mailzero28

ca8msm - many thanks for the quick response. You are right, I am populating it on the Page Load event - to a novice it seemed like right thing to do. I'll let you know how I get on.

I have a form, which when I press send will send an email. This works - that's a fact. All the fields are populated from a database. My problem is this: The To field will be initally populated with e.g. 'martin@email.com; paul@email.com; peter@email.com' However, the user may want to change...

Thank you PaulBricker - really got me out of a spot with this exact problem - Many, many thanks.

I have created a report using the data environment. Col 1 Col2 Col3 Weight Cost Price/kg (ie Weight/Cost) <------------Sub Total---> Sum(weight) : Sum(Cost) Sum(weight)/ Sum(Cost) What I need in Col3 is the answer to Sum(Cost)/Sum(Weight) to get...

Hi there, I need to convert digits to text - anybody know how. Its for cheque printing purposes, so 110 would have to read One Hundred and Ten. Any help would be appreciated.

Bass71 - instead of using code, have you tried bridging the gap by using Access 2000 - seems easy to import tables within pages this way.

I have a system built in Access 2000. Client Server based. The network is said to be running at 10/100 throughout the factory. The server is fairly good. I suspect performance is not as it should be. Can anyone tell me how many users should be able to use the one set of data without...

Hi there, I have a TransDate, I have a BirthDate, I need to highlight in a query any people who have a BirthDate that is 16 months greater than TransDate e.g going by today, their BirthDate would be earlier than 12/07/2000 I'm really stuck here, so help would be appreciated loads bye Martin.

Hi there, If you use the TransferSpreadsheet option in a Macro, it allows you to define what sheet you want to specify. bye Martin.

Thanks for the response, Unfortunately, things are still the same. bye Martin.

Add an autonumber on your table, and sort by this. The autonumber will be assigned the minute the record is added, and therefore you should be able to sort by the sequence the records were added. bye Martin.

Try syntax as follows: [Forms]![X]![Y]![po_number] This should be the correct location of the po_number for a criteria in a query. bye Martin.

In the query you would have a field MemberNumber. In your main table you would also have a field MemberNumber - thus the link. Now create a form based on the Query - make the MemberNumber field invisible. Adjust the size and appearance of the form so that it is as small as it can be, allowing...

I have a database which contains two linked text files. I had no problems for at least three weeks - I created a macro and the two files were linked via TransferText. However, on the third week, and ever since, I have been receiving this error: Cannot update. The Database or Object is Read...

Hi Ken, I really hope that your client is not using NT as his operating system on the client machines. Did you know that there is no printer manufactuers around that create driver with a custom page setting for their own dot matrix printers linked to NT machines. However, good old MS have a...