Search results for query: *

Hi Guys, I have a form fsubFitments which is a subform for frmFleet. When I run this code I get a message "MS Access can't find the form "fsubfitments". I guess I am not referencing the the form somehow, ie "frmFleet!fsubFitments" Any suggestions would be appreciated. 'Check if the original...

Hi Guys, I am trying to work the following out with vba and I am not succeeding. Lets say I have two colums, Col A and Col B in an Excel worksheet and the first 12 rows of col A contain data. The VBA I am trying to do is as follows: For cell B1 return the following, if A1 contains the word...

Enterprise Planning - Analyst (Delete Macro) I have created a macro that I now want to delete. I cannot see how to achieve this from the macro menu or other menus on the tool bar. Can someone point me in the right direction please.

Hi Guys, I have a combo box that when I select an item in the list, I would like it to refresh two other combo boxes. A query runs that creates a table with new data the old data is deleted. The combo boxes then use this table data as a rowsource. The the main combobox is cboCustomer and the...

Hi Guys, =IIf(IsError([txtFR1]/[txtTot]),0,[txtFR1]/[txtTot]) For the formula above, when txtTot is 0, it shows the #Num! error. I have tried using IsError function to get around it and it does not work. Any suggestions would be appreciated. Hayton McGregor

I have a form which has a button that initiates a ‘make table query’. This query extracts a single field which is used to populate a combo box. I use the combo box as a filter for a report. If I run the make table query a second time the following error message occurs, “The database engine...

Hi Guys, I need some advice. Scenario 1: I have a textbox on a form which has this formula as its control source '=DateSerial(Year([txtBegindate]),Month([txtBegindate])+1,Day([txtBegindate])-1)'. My question is from a performance perspective would be better to leave the formula as is or...

I have a form with a textbox called txtBeginDate. I enter a date into this textbox and it will always be the first of the month. ie 01/04/07. I wish to display the date for the previous 12 months in another textbox called txtPrevious. I have used this to do that...

I have a workbook with about 30 worksheets in it. This workbook is used for a reporting tool for a customer(s). So we have many reports generated from the same template. We hide some sheets because a customer might not require it in his report. So for each worksheet I have a snippet of vba that...

Hi Guys, I need some VBA code that says: If an error exists to skip the procedure and move onto the next condition or else run the following bit of code The Code is: Sheets("CPK Manipulation").Select With ActiveSheet.PageSetup .PrintTitleRows = "" .PrintTitleColumns = ""...

Hi Guys, I have this module called LockControls. It has 2 functions in it: Public Function LockControls() Dim ctl As Control For Each ctl In Screen.ActiveForm.Controls If TypeOf ctl Is TextBox Or TypeOf ctl Is ComboBox Then With ctl .Locked = True...

Hi Guys, I need to use the library sample database for some training I need to do. Does anyone know where or how I can obtain a copy of this sample db. Hayton McGregor

Hi There Guys, Our IT department has given me a new PC however when I open certain Excel files the timer rins for about 30 seconds opens the file and then closes it. I also get this if I try and change a property. There are no macros or any embeded code in the files. They do not know whats...

Hi Guys I have this code to insert data into the footer of an Excel Worksheet. With Worksheets("Dashboard").PageSetup .CenterFooter = "&""Tahoma,Regular""&8""© Company Name " & Year(Now()) .CenterFooter = "&""Tahoma,Regular""&8""Page &P of &N" End With However it does not...

Hi Guys, We have in the centre pace of our footer the following text "© Companies Name 2006". When we roll over from one year to another we have to open all our workbooks and change the year say from 2005 to 2006. Is there some VBA I could insert that will change the year automatically as we...

Hi There, Could someone give me code that will ensure that an Excel Workbook always opens at a particular worksheet. Any suggestions will be appreciated Hayton McGregor

Hi There, I have a dte faormatted as follows:24/01/2005. I need to extract the first cell the month and the second cell the year. I have tried various options and can't get it right. Any sugestions would be appreciated. Hayton McGregor

I have an application with some modules that have been written by another programmer who is no longer in the employ of our company. We can't open them in design view. Design view is greyed out. Does anyone know how I can view the code in these modules? Hayton McGregor

Hi Guys, I need to start learning how to program Java. Can anyone point me to some tutorials. Wishing you all a Happy Christmas and a Blessed New Year Hayton McGregor

Hi Guys, I use this code in an HTML script for my E Mail signature <IMG height=31.2 hspace=24 src="jaapie.jpg" width=20.6 align=left border=0><BR> When i craete a new memo the image does not apear the size that has been designated in the script. How can I enforce the image size? Hayton McGregor