Recent content by GizmoT

:) Thank goodness for that

I have a new database that is based on a tried and tested formula of mine, with the exception of one or two new bits. Everything seemed to be going well, until a couple of days ago (ironically, when this site was down). The problem was this: When I input data into the database manually...

I am not sure I understand you. The information is being sent to us from several different introducers. They all send customer details for us to upload into the database, and then distribute to Sales staff. The idea is that we will receive several excel spreadsheets from different introducers...

I have a macro that imports data from an excel file called DataTest. The data is imported into a temporary table, then split into seperate tables and all records deleted from the temporary table. Is there a way to delete the original records from the excel spreadsheet - leaving it ready to...

Aw - thanks guys. It works. You people rock! :cool:

I am having a problem with the following piece of code, but only incertain circumstances. It gives an error message when the Surname starts O'xxxx (i.e. O'Halloran, O'Connor etc) Code = Left(LeadTable![Surname], 6) & Right(LeadTable![HomeTel], 4) Set CustTable =...

The field appears on a different form, but I wanted to avoid loading this form when I update the form in question. I have however discovered a way round, by introducing another field to the form. Sorry for confusing anybody - it was a difficult problem to explain, and the database is too complex...

Ah - sorry, my mistake. The field that may or may not be empty, is not anything to do with the form. Let me try again. The form looks up data in several different tables, and makes all sorts of calculations. For example: CompanyTable![Amount]=CompanyTable![Amount]+CustomerTable![Cost] Now if...

I have a form that does all sorts of stuff, including adding the contents of one field (Amount) to another. If there is no data in the field, I need a message box to pop up and ask for the amount. I can't for the life of me think of how to do it. Anyone help?? Please!!

Thanks Pat. The sub-report is rather awkward to format, and I had hoped there was an easy (lazy bugger) way to do it. But I resolved myself to it, and it is done.

I have a report which is like an application form, which is based on a query. The query shows all records in tblCustomer and only records in tblCustPrevAddress where joined files are equal. Problem is when a customer has more than one previous address I get two reports - one with the first...

Thanks for that answer - I was close, but just couldn't bring it together.

Nice one John. CHEERS!!!!:D

Errrrrr.... One slight problem!!! The person I tested the e-mail to has A2002, and it was spot on. Problem is the person I want to send it to, doesn't. They can't open a .snp file. Back to the drawing board. Any more ideas? :(

Mile - you little BEAUTY!!! It isn't true what they say about you. You are spot on!! Thanks for your help Giz