Search results

Gentlemen, I have developed a database that needs to be used by up to 30 people (but probably no more and 2 or 3 at the same time). It has a front/back end split. However, I am unable to install the front end on the users PCs (No privileges) so the FE.mdb and the BE.mdb sit on the network. All...

Troops, I have a table with approx 2500 records. The StaffID field (a long integer) has lots of blank data. However when I use ‘Is Null’ as a query criteria it only returns 14 rows. They are not zeros (0). Is there anything else can use to search out these rows? Then I can use an IF to replace...

Morning Gentlemen. I have the following code in my report. All I want to do is show the dates the report is filtered on in the report header. These are the text boxes txtStart and txtEnd. The title is “List of jobs between txtStartDate and txtEndDate”. Or of the user doesn’t select a date then...

Morning Gentlemen :-) I'm an old Access developer who has just returned to the scene after a few years out teaching Maths. Without giving away too many official secrets I've got a temporary detachment at a home office IT department and have been given the task of creating the IT helpdesk...