Search results

update I have been playing around with this SendObject and even if I leave out the e-maill address it says that it is sending but nothing happens....... :confused:

Hi I am trying to send a report to one email from form. My code is fired from a command button. It flashing up quickly saying that it's sending the report but nothing happens. We use Novell Groupwise. DoCmd.SendObject acSendReport, "StopeReport_Rise", _ acFormatHTML...

Used .tag I had a play around and came up with this...... If you can see any improvements then I would love to hear them.... My code can get a little messy sometimes. Private Sub SampleID_AfterUpdate() Me![SampleID].Tag = Me![SampleID].Value End Sub...

Got it thanks to the microsoft site. QNumber: Q210141 http://support.microsoft.com/support/kb/articles/Q210/1/41.asp

Any Ideas folks Maybe I could Capture the position of the main form and then postion the second relative to it.....I have a fair idea how to capture the position of a form but not how to relate another to it. Feed me seymour :)

Maybe your after something like this?? HTH http://www.peterssoftware.com/winmanip.htm

I tried as you suggested but same same......Type Mismatch! The MaxFaceID value is derived from a query and displayed in a form with the cmd button Accept (which the RecordsetClone code is behind) and Close. Would it make things easier if I searched the form directly from the select query and...

Hiya pbaldy No FaceID is not a number it's Alpha Numeric and unique (PK).

same same but different problem I am trying to search a form using a value from another form. [MaxFaceID] is the value from the inital form. [frmEdit_EnterFace] being the form to search on and [FaceID] is the field to search in. so [FaceID] = [MaxFaceID]. I am using the code below but it...

Hi Yes I know how to positon a form use docmd.movesize but I have a problem with a floating form that the user can open. On my PC it opens exactly where I want it to but on someone elses it moves slightly over and covers another form. What I would like to happen is that the popup form stays in...

printer driver was the problem Problem sovled It was a printer driver problem....

More than just Access Hey Andy :( It seems that it may be a windows problem as Word and Excel are now playing up. Word shuts down as soon as I type and Excel shuts when I run macros. I will have to seek medical attention else where.................bring in the professionals. Thanks Cress

Hello My databases are shutting down when I try and open any of the reports. My reports are opened using a command button and every one of them, in 3 of my non-related databases are causing me to be kicked out of the databases without warning. This only started happening today for no reason that...

uh huh if you stare at something long enough it starts to blur Thanks 2 easy:D :D :D

Hiya I am trying to update null fields in a table with records from another field using the following code. Public Function FillFrom() Dim rs As DAO.Recordset Dim strPrevTo As Integer Set rs = CurrentDb.OpenRecordset("tblOxidation_ExprtPoint") Do Until rs.EOF If IsNull(rs("From")) Then...

one more possibility Thought might as well add this! I ran my report a few times with different datasets and had the problem where when all of these fields [PEOri$Cap] [PEDrill$Cap] [PESurvey$Cap] [PEStandBy$Cap] were forced to show "-" the total [TotalPECap$]gave #error so to counter...

Worked it Myself Stop the panic I worked it out In the end to account for the fact that I could return a zero value and or an error I came up with the following: =(IIf(IsError([PEDrill$Cap]) Or ([PEDrill$Cap]=0),"-",[PEDrill$Cap]))+ IIf(IsError([PESurvey$Cap]) Or...

Hi On my report I have the following fields: [PEOri$Cap] [PEDrill$Cap] [PESurvey$Cap] [PEStandBy$Cap] The control source for the report is a qry. [TotalPECap$] is the total for above fields. control source for this one is: =[PEOri$Cap]+[PEDrill$Cap]+[PESurvey$Cap]+[PEStandBy$Cap] My problem...

thanks for the help IMO

Hiya I would like to append the current/active records on one form to another open form. Form 1 [frmCollarDesign] (from tblMainCollar PK is [HoleID]) has some design information fields that I would like appended/copied to [frmDrillPlods] (from tblDDHEOM). This will save dataentering the...