Search results

Apparently the buttons were part of a package purchased for the PowerComboBox functionality, I have used the buttons as we have a template library for them & never had an issue with them. Freddy

David Thank you for your help, the method is great as we started of with trying "if visible" but we got it totally wrong because all we ended up doing was delaying the form opening until the timer had finished & all letters were visible on opening, therefore Hannah understands this process...

Boyd According to Hannah there are no specifics on how to do this, it sounds like the teacher will usually go through all the pupils results with the class and discuss the positive & negative issues . Many Thanks Freddy & Hannah

I am helping my niece out with her school project, the part we are struggling with is to spell out "WELCOME" on the screen. The way we have gone is a sleep gap between displaying controls, but there is a focus issue. I have attached a basic db showing the issue, if you open Form1 is design view...

My apologies for the delay in replying, getting other stuff done before the Cricket & the Open. My images are mainly drawings so I've followed your suggestion & created a larger image with no actual zoom controls, but on the mouseover event I have used Stephen Lebans Magnify as a popup. So I...

Cheers I downloaded DbPix & it does everything one could need but like you said $350 is a bit on the pricey side. Thanks Freddy

Afternoon I am far from an expert but the way I get around required fields is to create a hidden textbox for each required field & then assign a value to the textbox dependant on the required field; Private Sub The Client Name_AfterUpdate() If Len(Me.The Client Name & vbNullString) = 0...

I have a form that displays an image to which I have added zoom controls, when I zoom the image I want to know if it is possible to move the image by dragging with the mouse? If possible, any suggestions on how to do this or suggestions on what to search would be greatly appreciated. Many...

HiTechCoach Sorry for the delay in replying, the code was from UtterAccess.com just adjusted for my needs. I created a new table & routine as you suggested & it works perfectly. Thank you for taking the time to help me out, it is appreciated. Many Thanks Freddy

HiTechCoach Thanks Freddy

HiTechCoach I have attached the db, all forms open through frmCalendarApp. Thanks for your help. Freddy

HiTechCoach Thanks for the info, I can soon delete the the 3 additional fields, but I think I my question may have been misleading. I would like to know how I get the date information into the formatting criteria, this is all the code behind the calendar but no matter what I try I can't pull...

HiTechCoach They are currently stored in both a date field & 3 other numerical fields representing Days/Months/Years, I have both as I thought I may need the seperate fields. Thanks Freddy

Morning I am new to Modules & after some advice, I have a appointment db where the appointments & holidays are displayed on a calendar. I am currently formatting the calendar for bank holidays in the following manner; If (intPubMyYear = 2009) Then If (intPubMonth = 5) Then If...

namliam Many thanks for your swift reply, I created a duplicate form with just the label on it & this opens perfectly & displays the message. Private Sub Form_Open(Cancel As Integer) Dim rs As Object Set rs = Me.RecordsetClone If rs.RecordCount = 0 Then DoCmd.OpenForm "frmApptMemo1"...

Morning I have a label in a form with the 'visible' property set to 'No', I am trying to display the label when the query returns no results & the form is blank. The code I am using is as follows; Private Sub Form_Open(Cancel As Integer) Dim rs As Object Set rs = Me.RecordsetClone If...

Evening I am formatting the bank holidays in a calendar & I came accross the alignment format, but I don't know & can't find the required value for any position. Any help would be greatly appreciated; If (intPubMyYear = 2009) Then If (intPubMonth = 1) Then If (intDay = 1)...

In the contacts section of my db I have both home & business e-mail addresses, both have a command button to e-mail the chosen one. The problem is that if the user makes a mistake & chooses the wrong one, then closes the e-mail & selects the correct one, Outlook throws up the following error...

chergh thanks for info, i'll use access I know where I am there. Cheers Freddy

Morning I would like to see if a cell contains a specific word in a string & if it does write the specific word in a new cell, I can do this easily with a data filter text contains but I want to do it with a formula. Any help appreciated. Thanks Freddy