Recent content by Tiny bird

Now this may sound like a stupid question to some......... I'm trying to write an If statement to check a field name if it doesn't contain a word within it I've tried If [FieldName] not like "%Maxflow%" Then and If [FieldName] not like "*Maxflow*" Then and tried using notlike I get...

I have a problem with an Access 97 database. My startup has disappeared. I've gone back to to Tools | Startup "Display Form/Page" and selected the form. BUT! Everytime I go back it goes back to NONE. I've tried repairing the database. It tells me it successfull :p When I compact it it tells...

I have a form with a subform in Access 97 which allows, filters, edits, additons and deletes in both form and subform. When any users (in the User Group) attempts to delete a record (by pressing the delete button on the tool bar) in either subform they get a message saying they don't have the...

I have a simple report with a subreport gathering figures and sorting on a number field. Each report has a common customer ID number that is the link between the two. When i run the subreport it comes out perfect, sorting on the number. When i run the main report it decides to sort the...

Thanks for your comments and advice. I agree totally on joining the 2 tables. They were originally as 1 but we had to split them as the majority were non members 30,000 + and the database speed was being greatly affected. Believe it or not a computer consultancy specialising in Access advised...

I have an Access 97 project - a split database that will soon link into SQL back end. I have 2 tables of customers - tblMembers (2 types of customer) and tblNonMembers (1 type of customer) When creating forms for promotions I find myself creating replica forms for the 3 types of customers with...

Many thanks! Couldn't find it for looking! That worked a treat. I will be putting in a msg to alert the user.

Hi there wonder if you can help. I have a limited amount of experience with VBA but, don't worry I'm going on a course so I won't be bugging you all for eternity!! I have a subform where the user amends an existing serial number into a field. If the serial number doesn't fall into 4 categories...

Hi I've got a form which the user must enter data in a field which is not required in the table. The code I am using on Lost focus on the field is: If IsNull(Me.[VouchersFor?]) Then MsgBox "You must enter who the Voucher is for", vbCritical, "YOU HAVEN'T FINISHED THIS ENTRY"...