Search results

I have a form with 100 textboxes on & I want to loop through table records & colour the textboxes which meet the criteria. The textboxes are named 'txt1' , 'txt2' & so on to 100. The code below works to a degree but not correctly, when I use the code it changes the colour of the first textbox...

My pal has a business which operates on calendar months, but the datediff function in access can't cope or I can't get it to cope, eg. Date 1 = 28th Dec 2009 Date 2 = 1st Mar 2010 Access datediff returns 2 months 1 day, when in calendar month terms you have 3 days to end of Dec & the whole of...

I have come across the following code to export e-mails into access, the problem I have is that I wish to export the inbox & bypass the folder selection process, any help would be appreciated. Sub ExportMailByFolder() 'Export specified fields from each mail 'item in selected folder. Dim...

I have a contacts db from which the user can send/read e-mails, the read element is sourced from a table linked to Outlook. The problem I have is that unless outlook is running in the background the outlook automated send/receive service is not running & thereby not updating the db with new...

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...

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...

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...

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...

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

Afternoon I have a textbox on the main form that is contolled from by selecting a record on subform1 it in turn it controls what data is visible on subform2. Is it possible to also control the textbox by selecting a record on subform3, in other words can a textbox have 2 control sources & just...

Afternoon I may be going about this in a backward manner but this is where I am at, I have a text box on a sub form in tab 1 which updates a hidden text box on the main form which in turn updates records in another sub form in tab 2. Is it possible to add an afterupdate event procedure to the...

Morning all I have been trying for a few days to import bitmaps into a table but due to the OLE Server issue I can't. I've tried all the microsoft registrations & reinstalling photo editor etc all to no avail, but one thing I did find is that if you import a table from another db the bitmaps are...

I have a query which returns each entrant with the speed figures in a descending order for previous races, I wish my query to return the top 5 speed figures per entrant or if the entrant has less than 5 previous runs it needs to return all available data. I am not VBA literate, so as simple as...