Search results

Thanks for the prompt reply. Well you have made me dip my toe in VB. I understand the logic behind your suggestion but when I tried to make it work I kept getting a can't find object type error. (I'm not very conversant with the syntax and when to use brackets etc).

I have a simple form with 2 date fields on it, date1 and date2. Date1 is required but date2 is not. When input, date2 should be greater or the same as date1. In the properties of date2 I have put >=[date1] as the validation rule which seems to work OK. Problem is that I only want this to work...

Thanks Mario, that worked just like I wanted it to

This must be easy but I am an old DataEase hand trying to make the great leap into Access and visual basic. I have a form with an input box on it. Users type in a number and then click a button. The code behind this click action makes the input typed into a variable value. It then does some...

Thanks DJN. In the end I got around it by using a table with the user name on it and yes/no option boxes to select the start menu. I don't know if I am showing people how to suck eggs but I did the following Create a table with fields USERNAME, MENU1, MENU2 etc Menu1 and menu 2 should be yes/no...

I have created several forms to use as opening menus with different options on each. What I want to do is have a specific "menu" open at startup depending on who logs in. eg" welcome to fred's menu" if Fred logs in or "welcome to Jo's menu" if Jo logs in. I have tried having a blank form as the...

Thanks very much Paul that sorted it out for me and taught me a thing or 2 at the same time

Fairly new to Access, having moved from DataEase but am having problems with what should be a fairly straight forward report. I have a table which is used to record enquiries received. On this are 2 fields, one for date enquiry received and one for date answered. I want to run a report based on...