Search results

Ahh, It is in the expression of the table field (field is calculated). Am I going about it the wrong way. Should I be putting it in an onclick or onchange event of the dte_datePNGReceived to change the dte_targetPNGDate field.

Thanks again. The field is date/time type and I only have 2 entries in the database so the date/time I know are filled in for both.

I limited to the iif statement to just 1 iif and still coming up with the same error CalcTargetDate: IIf([cmb_GR_servlevel]="Standard", [dte_datePNGReceived] +10)

thanks for the quick reply... ( I tried it, but same error). Would It make a difference I I am putting the formula in a calculated field (not an onclick button)

morning all, could i cast your eyes over the below as I am sure its a quick fix but I can't find the issue in the structure. CalcTargetDate: IIf( [cmb_GR_servlevel] ="Standard", [dte_datePNGReceived] +10,IIf( [cmb_GR_servlevel] ="Premium", [dte_datePNGReceived] +5,IIf(...

Thanks for such a quick reply. It works great but is asking the user to input the ID number. Is this because I haven't referenced the forms correctly (therefore can't find the current) or is there something missing where I need to select current record only.

Morning all, I need the ability for users to click a button in the dbase userform and that will select the current record only and save/export the current record to an excel sheet. (this I will then RunCmD to open a word doc merge). This effectively will mailmerge ONLY the CURRENT...

sorted... it wasn't liking the .value part. I removed it and alls well.

if useful. the Text261 box is a newly created unbound text box. no other alterations or changes at all.

I must be doing something wrong as its still giving the runtime 424 and referring to the me.txt261 line. Private Sub Combo192_AfterUpdate() Me.Text261 = Me.Combo192.Column(1).Value End Sub

Thanks very much, I never thought of VBA and me! commands. I'm a vba newbee so this is what I've changed in the response. Private Sub Combo192_Click() Me!Text261 = Me!Combo192.Column(1).Value End Sub this is causing a runtime 424 object is required issue. any idea?

hi all, sorry its a really simple one but am at a loss. I have 1 table and 2 columns (with a code and then corresponding description). "tbl_ccode" "QC_cmb_ccode" and "QC_cmb_ccodedesc" On a new form these are linked on a combo box where u can see both columns but when the...

Morning all, I am venturing into sql but stumped at the first hurdle. I have 2 tables with the same headers and I want to combine the two (i.e. may has 100 entries and tbl_ams_apr16 has 100 entries so I want a unionall to bring back 200 entries. each select works on its own but...

thanks for the quick reply. so how is that done in vba. sounds like I need to create the query, then report then link the report via the userform button. I would prefer to have it done without additional reports/queries as this single piece of code does everything except landscape commands.

morning all, I'm new to vba so very much loving forums and google. Its a huge learning curve but forums like this have been invaluable... I have a simply piece of code that takes the current userentry and emails it in a pdf... only problem is the page orientation is portrait and I...

Morning all, I have finance package I have put together that includes calculated cells/onclick command buttons showing/hiding tabs and lots of commands running queries. However nothing top programmatically complex. The issue If I open the dbase and userform for the first time and...

Hi all, I am a basic user of access and have limited vba knowledge but am quite a quick study. I have built an access application that has 3+ subforms. I show/hide these subforms via the below code: Private Sub Check246_Click() If Check246.Value = True Then frmAltPaymentAddress.Visible =...

currently access is being used as a user input device only. so very flat (only 1 table) a lot of accounting manipulation is done in excel vba i just needed a way for multiple locations to key in the same class of data in the same way which spits out the core data in the same format (currently...

Thanks for the quick response. Thats quite funny... I could imagine for expert users that the logic behind the problem solving shows which program i have more history using. bang on... so when structuring the table, how do i get the link between the mailmerge done and the interface recording...

Hi all, I am a relative newbee when it comes to vba although I am very useful in that I have a good level of understanding of excel and access functionality. I have a mailmerge query that pulls by date (-14days from a chosen field date). What I need to do is to fill the date the query ran...