Search results for query: *

Hi Guys, thanks for your advice. I redisgned the app got the code to check if frmFleet is open and all worked well. Hayton McGregor

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 Skip, I take your point. I am not really up on forum ettiquet The world I come from you shake a persons, hand look him in the eye and say thankyou. You will notice at the end of my current post I said thanks. Hayton McGregor

Thanks very much. I'll give it a whirl Hayton McGregor

I am not a code type guy and battle with it. I normally record a macro and and hack that to try and get it to work. However I can't record a macro to do this. Hayton McGregor

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 AceMan I seem to have got it working. Thanks for the help Hayton McGregor

Hi Aceman Both these queries are make table queries. The tables are use for the combobox rowsource query. So what I am trying to acheive is the following: 1. I select a customer from cboCustomer. 2. In the after update event for cboCustomer place a code which will refresh data for cboFleet and...

Hi AceMan1 Thanks for the reply AceMan. I am trying to refresh two comboboxes (cboFleet & cboTyresize) on the same form using the after update event for a combobox(cboCustomer). After I have selected a customer from cboCustomer, cboFleet and cboTyreSize need to be refreshed. All 3 comboboxes...

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 PHV, Thanks for the reply. Hayton McGregor

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

Thanks Remou, I added some code for the rowsource On Error GoTo Err_Command172_Click Dim stDocName As String Me.cboFleet.RowSource = "" stDocName = "qryVehiclesDDM" DoCmd.OpenQuery stDocName, acNormal, acEdit Me.cboFleet.RowSource = "SELECT DISTINCTROW...

cboFleet Hayton McGregor

Remou thanks for your reply. Could you please help with the code. This is the code for the combo box. On Error GoTo Err_Command172_Click Dim stDocName As String stDocName = "qryVehiclesDDM" DoCmd.OpenQuery stDocName, acNormal, acEdit Exit_Command172_Click: Exit...

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

Thanks micanguk. Your suggestion works just fine. Hayton McGregor

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