Search results

I have a cmd button executing the following code: Private Sub btnNewItems_Click() On Error GoTo Err_btnNewItems_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = "frmNewOptions" stLinkCriteria = "[SitesID]=" & Me![sitesid] DoCmd.OpenForm...

Is there a way to print the number of an error code on the OnError event?

I'm exporting data from Access to Excel using "DoCmd.OutputTo" and it works fine. However, I need the data formatted in Excel and would like to know if there is another way to export into Excel using a custom template. Or a way to automate formatting of the excel spreadsheet.

Hi there, Is anyone able to tell me whats wrong with the following. I have pasted the fields used in the process and the logic below. I have also written what they are for: Field: [dteOriginalFrom] - Behavior: Manual Date Entry Field: [dteOriginalTo] - Behavior: Manual Date Entry...

Hi there, Is anyone able to tell me whats wrong with the following. I have pasted the fields used in the process and the logic below. I have also written what they are for: Field: [dteOriginalFrom] - Behavior: Manual Date Entry Field: [dteOriginalTo] - Behavior: Manual Date Entry...

Hi, Can someone advise on how I would turn the following code into an IF statement returning the following values? =(Nz([OriginalAmount]-[RebillAmount])) IF more than Zero then return "1" If less than Zero or 0 then return "0" Thanks in advance

Hi Ok this is what I am trying to achieve. I want to be able to check for a null value in the following formulas: =Nz([OriginalAmount])/Nz([dteOriginalTo]-[dteOriginalFrom])*365 and...

Hi, Anyone know whats wrong with this. Its keeps returning missing parenthesis or Vertical Bar? =llf(Nz(Nz([AmountDifference]+[12MonthCostAvoidance]+[CashReturn]),0)=0,Null,(Nz(Nz([AmountDifference]+[12MonthCostAvoidance]+[CashReturn]))

Hi Thanks for the reply. If I explain further apologies for not making it clear. frmSitesMain has a subform called frmSitesAccount frmSitesCRCMain shares the same subform frmSitesAccount The cmd button will be located on the frmSitesAccount (subform) So im trying to find a way for the...

Hi all, I have a form that provides function to two areas. Therefore some of my command buttons have no relation to one of the forms. For example frmSitesMain = command button not visible frmSitesCRCMain = command button visible How would I achieve this?

Hi John that didnt work and probably nothing to do with your advice. I didnt give all the correct info. So here it is: Main form = frmSitesMain pkSitesID Other fields etc On this form I have a cmd button that opens: frmSitesAccounts I have the following fields in this form...

Hi John, Firstly apologies because my code was incomplete thus making it slightly ambiguous. I has pasted the correct code below. Essentially what I am looking for is a particular subform which has related data to the selected value in the combo box to appear. I already have the nomrlised...

I have a main form which pulls a unique ID called "pkSitesID" I have placed a button on this form to open another form called "frmSitesLog" and link by fkSitesID and display only records that match the pkSitesID. All that works perfect. The only issue I am having is when I want to insert a...

Hi all, I am trying to create an after update event using a combo box but with the following code it returns a runtime error 2494 Action or method requires a form name argument. Ideally I would love for it to open a subform based on the value but I dont know how to do that. Heres the code...

Having trouble working out the mysql

Thanks Bob, Is his solution the right one by the way?

Hi, Any chance you can downgrade the file to 2000 version?

Firstly I want to say, how do you guys know so much about access. I am trying so hard to learn and pick things up but its real slow. Are you just naturally gifted or what? Anyway, this is another one of my issues: I have a main form called "frmsites", its is controlled by a PK of sitesid...

Well I have an if statement checking whether a form is active or not. If it is then the button that points to it is disabled or in this case a label with a click command in its place.

Thanks David I shall have a go at that, as I know buttons are far easier to work with.