Search results

is there a way to stop my user from selecting past/previous days on a date picker ?

i wanted to have a default value for my EndDate, like 00/00/0000. When i declare my variable as date and not assign a value, i get 12:00:00 am as my default value. thats ok but i wanted to use it as a placeholder in a disabled text box. is there a way i can get 00/00/0000 to use

how can i specify a blank date for a field in my table. the field in my table is a date field. it is called end date and its supposed to be blank or null till i decide to update it. any suggestions ??

@ PatHartman & @ ridders, i tried both suggestions but none worked. the error i get now is Syntax Error (missing operator in .....) im stumped. Did any of you open the database to see my dilemma? the query is called qryPartnerSummaryB . this is the one i need to work. this is the last thing...

i have a query that works great. till i add the highlighted section. This field is a calculated field using another calculated field in a calculation. SELECT CUSTOMER.TRN, CUSTOMER.Active, CUSTOMER.Fname, CUSTOMER.Lname, PARTNER.PartnerId, PARTNER.Type, PARTNER.StartDate, PARTNER.StartAmount...

no. i have a form with buttons that open pop up forms. Something like a menu form. this "menu form" opens a form that adds/edit/delete records. when the form to add/edit/delete records is called, id like to close the menu form and only have the called form open. on close of the called form, i...

ok im sorry. i said this initially .. .... i have a number of pop up forms. i now realize that i can have three or more of these forms open. id like to be able to just open one format a time and when i close that form, i want to return to the form it was called from.... to be more specific...

Hey man, thanks for the help.there is a hitch though, on the Calling form, add an OpenArgs parameter to open the PopUp form passing it's Name: DoCmd.OpenForm FormName:="PopUpFormName", OpenArgs:=Me.Name i havent figured out where to do this ?do i attach it to the button that calls the new...

i have a number of pop up forms. i now realize that i can have three or more of these forms open. id like to be able to just open one format a time and when i close that form, i want to return to the form it was called from. ive been looking at code in the repository but im more confused now...

How can i disable or hide the record selector at the bottom of my form ? By record selector i mean the tool at the bottom of the form that allows me to skip through records ...

thanks Arnelgp. works like a charm. thanks you so very much.

Private Sub submit_Click() Dim PaymentDate As Date Dim PartnerId As Integer Dim Amount As Double Dim paid As Double Dim inst As Double Dim start As Double Dim diff As Date Dim check As Double paid = Me.paininstall.Value inst = Me.Installments.Value start = Me.StartAmount.Value...

thanks bruh. i had solved it though, using diff = DateDiff("d", StartDate, now) paid = Me.paininstall.Value inst = Me.Installments.Value start = Me.StartDate.Value If paid = inst Then Me.submit.Enabled = False ElseIf diff >= 6 Then...

hey. this is my code: If paid = inst Then 'Me.submit.Enabled = False Else if DateDiff("d", StartDate, now) >= 6 Then Me.submit.Enabled = False Else Me.submit.Enabled = True End If i want to disable a button if the days between now and the startdate is less than 6...

is there a way to have access print receipts ? currently all i can print is reports. is there a way to specify your page/receipt size ?

thanks mi G, like the realest type u came thru once again

as always, im not sure what exactly you're referring to. could you please be a bit more specific.

works thanks. now there is a new problem. i experiment in a new file with the same tables, and data, when the experiment works, i incorporate it into my main project. iv copied all my now working form, and put it in my main project and the error im now getting is this: Compile error...

im trying to create a login form and after much research ive gotten this far except i keep getting the above error. on click of my login button: Dim dbs As Database Dim rstUserPwd As Recordset Dim bfoundMatch As Boolean Set dbs = CurrentDb Set rstUserPwd = dbs.OpenRecordSet("qryUserPwd")...

wow thanks man. so the same with double barrelled last names or hyphenated names. good looking out man. thanks