Search results

Thanks for you reply I see your point. What i need to achieve tho, is I have another form that popsup a reminder for unpaid accounts.. Current setup is to have a yes/no box and have that as the critia, but I would rather have it search unpaid accounts based on the Account Status.. So if...

Hiya, I know this is simple but forgot how to call it in I have a form and a subform on the main Page, The main form contains th customers details, name address etc and a field called AccountStatus The subform has Workorder details, Startdate, material total, labour total, total payments...

Hmmm I see you point Don't really need the settle option at all. As for the account in Negative, I hadnt thought of that either, however, at the end of the month when the reports would be printed, this would show up on the account.. Or do you have something else in mind, as in Fail safe...

How do you mean? ________ BoomChix

Sorry lol I put it in the wrong place.. Works gr8 thanks alot ________ Medical cannabis seeds

Hiya John I tried that code but nothing changed ________ MFLB

Hiya guys I have on my form the following - Outstanding Balance (Currency) Account Settled (Yes/No) How would I do an IF statement or something that would automatically place a tick in the Account Settled? Basically, If the Outstanding Balance is ?0.00 then (YES) Account Settled.. And if...

Just an update to say I got it working.. Forgot the add the Critia to the Query Thanks for the help tho ________ Mercedes-Benz Om615 History

Hiya m8 Cheers for the reply, Any ideas on tackling this? I found this on the MS website Private Sub Form_Load() 'On Load of the switchboard check Jobs table for any uncompleted jobs Dim intStore As Integer 'Count of uncomplete jobs that are past the Expected Completion Date intStore =...

Hiya guys Looking for some help on this one.. My database has these basic fields on a form - StartDate - Date of job started Billed To Date - Date the work MUST Stop Total Days - Total Days between Start and End dates So for example I have this Start Date - 11th May 2009 Billed...

Hiya Just installed Windows 7 :D and office 2007, when I run my database and click on View calendar, I get this message - There is not object in this control The control is CalendarControl MonthView (MSComCtl2.MonthView.2) if that helps? I built my Database in Access 2007 with XP...

Yeah sorry should have said that Its the MS Monthview default one ________ MARGOSHA_

Hiya Is there a way to resize an Active X Calendar? If I try to drag the size, its fine for deisgn view but goes back to original size in form view? Cheers ________ Free drupal themes

Hiya m8 Its ok managed to get it going Do you know tho, Is there a way like, umm hard to explain lol If I have a main form with a subform on it, and if I change data on the subform, can I have a command that will tick a Yes/No box on the main form? ________ Free Starbucks Gift Card

Hiya m8 Its a Calendar I got from someone else who used a Table called Main T in the original Deisgn.. Ive since made my own table that I want to use called Table1 and I'm trying to add that into the Code.. The original code was Private Sub Form_Timer() 'date1 = Empty 'date2 = Empty...

Hiya Having an issue with this Error code Private Sub Form_Timer() 'date1 = Empty 'date2 = Empty Me.Table1.fldDate.SetFocus UpdateDayBold 'boolRedraw = False Me.TimerInterval = 0 End Sub MSOffice Can't find the field "l" referred to in your expression? ________ GANG BANG ANAL

lol ok m8 will keep trying it and see if it goes I've added a table into the main form now which will display the following fields FldDate Employee CmrName CmrLocation I have added this in as a subform at the top of the page, so when I make an appointment using the table, it will link to...

Hi Dick Yeah the subject is really useful, I will change that to something like Quote, Workorder, Emergency Repair etc, very handy I have noticed tho that sometimes it won't save a new record Click on the date I want, say 3rd Oct, Select the subject and type what I want, click on Save...

Hiya, Thanks very much for that, looks good Will have a play with it later and see if I can find a way to have the data entered by a form rather than trying to remember dates & time for an appointment then add it in manually.. Think this should be possable with the help of some guys here lol...

Hiya Yes I would be interested in that, thanks very much ________ Heavenscent69