Recent content by jattman

i have a input box on a form and i want to check that the data entered is in the format of "mm/yyyy" If Date_input.Format = "mm/yyyy" Then MsgBox ("Yes") Else MsgBox ("No") End If The yes and no msgbox's are just there so i know it works. thanks in advance

if it wouldnt be a hassle could you please explain briefly how the second one works. It works fine so thanks for that but i want to understand how it works aswell. Thanks.

what's the easiest and best way to check and make sure that the value entered into an input field, on a form, is an integer?

i have a macro which runs a query. the query has criteria [membership number] i'm planning to run this macro, from forms, through a command button. is there anyway i can get the macro to get the membership number from the form, automatically and use it to run the query? thanks.

no i havent run it through a macro, i havent done it through vb either, because i dont know where to start. and its one query, which i want to run from several different places, so i dont think a macro is the solution. In some forms, the query result is shown as a sub-form and in others it...

i have a query which has as its criteria 'membership number'. i want to run this query from several different forms and instead of typing in the membership number every time, i want the query to automatically select the membership number, from the record that i am viewing. I have some...

i need the query to ignore something if there if it isnt there in a table. i need to calculate the amount of income, from three different tables, sales, bills and membership fees. i always have bills and sales, for every month, but sometimes i dont have any membership fees. When i run the...

can someone please tell me or show me a GOOD example of how to use recordsets properly. thanks in advance