Search results

Hi CJ, If Fizzio's code works for you, you're all set. However as for reports they are easily printed out using the 'OpenReport' method with the view argument set to acViewNormal (or left blank). See the Help for more details. HTH

Any reason why you can't just create your letter as a report and print it directly from Access?

Sorry to post such a dumb request but this is driving me up the wall. I have a combobox where in the after update I have some code which goes off and does somethings depending on the value selected. Now I want to verify the selected value before accepting it (i.e before running the code of...

The query that "sub1" is based on should have an [order number] field (or whatever it may be called). In the design view of form "sub1" you should link to "sub2" via this [order number] field; there is no need to reference anything on the main form. HTH Dembrey

I managed to 'solve' this one (although I still don't know why it should work one time then not again ....) So incase anyone else has this problem here's how I managed to sort it. The problem seemed to lie with the:"ActiveDocument.Name" in the save document line. So I just 'captured' the new...

Hi all, Got stuck on this one and can't find out whats wrong: I have some code which opens a new Word document and then pastes some stuff in from the Db. Everything works OK the first time the code runs but the second time I get the error message "RPC Server is unavailable". Access has to be...

Andy, Thanks. I'm having some trouble with syntax since the control is sometimes in a form, sometimes in a subform on a form, ...etc. Got some more things to try before I cry help though. Thanks for the info.

Hi all, Been stuck on this quite a while, here's the problem. On each of my forms I have a Locked/Edit button pair to control the 'edit' status of the form's controls (and any subforms controls). These buttons execute some generic code (used by all forms) which uses a For Each...loop to...

I believe you should be doing this with a calculated field in a query where the calculated field would be something like: [New_Query_Field] = [C Code] & " - " & [Store Code] HTH

Hi, Sound to me that what you need to do is set up a query where the criteria is [call_back] <="Today's date". Then when you start your database use a DCOUNT to determine the number of over due 'call backs' and display the list if it is >0. HTH, Dembrey.

If the field Purpose is not a text field try: DCount("[BuildingID]","tblARoom"," [Purpose]=1") [i.e. remove the single quotes from around the 1]. For the second line the check value of [Building ID] appears to be missing, try something like: =DCount("[BuildingID]","tblARoom","[BuildingID]=2...

Try this: Case "1100", "1200", "1300", "1400", "1500" I think that's how it goes. HTH.

I'm not sure exactly what problem you are having with the "REF=forms!refsubFrm!txtControl.Value" line, but is the form 'refsubFrm' open when you try to read the value of the control? Have you considered storing the REF as a Global variable? Store the text control value to REF at an appropriate...

Your criteria reads: X = Y > 1 And A = B The >1 after Me!JobNumber is wrong if you want your criteria to read: ([JobNumber] = Me!JobNumber) AND ([SalesYear]= Me!SalesYear) you need to remove this '>1' HTH

There appears to be an erroneous '>1' in your criteria and maybe a field missing in the year expression. Is this something closer to what you want (I've assumed a missing field {YearField}). If DCount("[Jobnumber]", "CloseOutData", "[JobNumber]= '" _ & Me!JobNumber & "' And...

Doug you're a genius. Yes it does. Many thanks.

That's some string. I copied/pasted this into Access and put in various "& _" and added some quotes until I got no redlines. Here it is, hope it works for you. Function Update() On Error GoTo Update_Err DoCmd.SetWarnings False DoCmd.RunSQL "INSERT INTO tblArchive" & _ "( [Supplier ID]...

Maybe you've already thought of these but anyway... Is your [InstCode] field a Text field? If it is the comparison value will need single quotes around it i.e. strCriteria="[InstCode]='" & Trim(Str(OpenArgs)) & "'" If that isn't it or it still doesn't work I'd have a look at the OpenArgs...

Hi All, Help with the following would be appreciated (Access97). I have a 'generic' function that (attempts) to set the SpecialEffect property of all TextBoxes on the specified form. Problem is that the Forms that call this function contain a variable number of SubForms and I would like to set...

Thanks Alex/David. String Chopping here I come.