Search results

I have 3 fields. one is a date field - Date the second is a number field - Number_Days the third - Finishing_Date. when the user enters the starting date (Date), and the length of the meeting (Number_Days), i want the finishing date to be auto. calculated. i tried making a query with this as...

Wayne. Yeah i got it working. not entirely sure what i was doing, but yeah it works now and gives a blank default value which is what i wanted. thanks for the advice

Hi. I have found fixed up my cascading combo problem, and am now in the process of fine tuning. I have to cascading nicely, but there is one prob. when ever i select a value from the cascading combo, and i then create a new record, it still keeps the value of the casc.combo (ie. it does not...

Ok here comes the n00bie question for the day. what is the "does not equal" syntax for VBA? i tried If x != "" Then blah blah blah but it doesnt like != which is what it is for alot of other languages. what is it for VBA?

Hi again,. this is a very simple sample of the database that im trying to create, with only the relevant tables included. There are 3 tables, a Decision Table, a Subject Table and a Meeting_Agenda table. The Subject table contains a list of all the possible substances that a meeting agenda...

I have a database which has a table Subject - which contains the values - Liquor, Tobacco, Kava etc. I have another table which has decisions. Now the database is supposed to store the specific decisions to complaints made about each different type of substance. Thus i have another table...

What is the code that i have to put in the [Event Procedure] i have never done any VB code, so i dont know where to start. but you are right, the NotInList thing is what i want, but it doesnt give me the code that i need for it to add to the drop down box list. so what should the code be to...

I have a form based on a table which has a drop down box refering to another table. ie. I have a table and on it is a drop down box with venue names in it, so that the user can select the venue which they want the record to relate to. Is there any way that if the venue the user is wanting the...

Ok heres another one for you. I have a pop up box that comes up when i run my query asking for a venue name. is there a way that i can type the first few letters of the name, and then get it to autocomplete the name (maybe look up the value from a table), or use the * button to complete the...

I am trying to get my database to return records for the last 6 months. Its a database that stores record information for venues that hold functions, that are variations of their normal trading conditions (eg. holding a party that is outisde thier normal trading hours). I am trying to set up a...