Search results

The way I'd do what I think you're wanting to do is, I'd have a frame form with a box for @BeginDate. The recordsource returned by your stored procedure would be displayed in a subform of this in datasheet view (and with a little adaptation, the code suggested should work). Apart from the...

Applications regularly surprise me in just the way you describe. Although I know they only do what you tell them to do, I regularly find myself thinking "Did I really tell it to do that?" You should be able to set up a query in Access that will set up the details you need for your mailmerge...

Code on the Button If you put a button onto your form and call it "cmdTemplate", (View, Toolbox; turn the Wizards off [the magic wand button at the top of the toolbox should be un-pressed]; draw a command button; then right click, Properties; turn to the "Other" tab, and type "cmdTemplate"...

A way that might work In Form Design View: Set the form's RecordSource property (the Data tab on the properties popup) to the name of the stored procedure you're wanting use: spDataValidation_Scrap_GoodVsScrapPerHr Set the form's InputParameters Property to a string similar to this...

A loose manner of speaking? Mile-O-Phile, what you say makes complete sense, and, yep, you're right. But here is something that can happen - though I've been unable to replicate it: A form works just as it should. Key strokes such as [Tab] and [PgDn] are accepted, and if the form's...

Web Browser Cactus Tool? If you inserted an ActiveX webBrowser control, but tried to use code for an OLE object, that might explain the problem. But maybe using a webBrowser would be easier. A browser might not be quite as fast as an OLE, but there's only one line of code. To insert an...

Losing focus One of my forms loses focus too. The user has to click on the form before standard keystrokes will work. I'm not sure why this happens, but there's quite a lot of code this form, and there might be some operations that make focus vanish. I'll check back in case you find a...

Use Number, Double instead of Date/Time? I had this problem too, and couldn't get to the bottom of it. I came up with the probably not very good theory that even on a network where European settings have seemingly been imposed across the board, server Access sometimes overcorrects. If local...

isFormOpen If you create a new module and paste in this code: Function IsFormOpen(strFormName As String) As Boolean IsFormOpen = (SysCmd(acSysCmdGetObjectState, acForm, strFormName) = acObjStateOpen) End Function (from ghudson, http://www.access-programmers.co.uk...hlight=isloaded)...

Sorry for the needless complexity. I was thinking that If isFormOpen("frmProject") then Forms("frmProject")("cboCustomerID") = Me.customerID End If should go on your button's click event instead of just Forms("frmProject")("cboCustomerID") = Me.customerID as this line on its own...

This might be a work around to roughly what you want. Try making your "values" form a datasheet sub-subform of your "headings" form. Make your "headings" form a datasheet subform on some containing form. Not too intelligible, sorry. Outline.zip, though, illustrates what I'm not making a...

Workaround? Create boolean variable right at the top of your form's module after the Option line(s): Dim booUserClickedSave as Boolean Then on the click even for your save button put code like this: booUserClickedSave = True DoCmd.RunCommand acCmdSaveRecord booUserClickedSave =...

Tried Spacebar? Try tabbing to one of your buttons and pressing spacebar. When a button has focus, spacebar, enter, and maybe other keys too, should click it. If spacebar works, then there might something that is stopping the button from responding to Enter, though I can't think of anything...

Ole Control or Browser? You could put an ole control on your form (the xyz cactus tool), and name it oleWord. Then put the following code on e.g. a command button Me.oleWord.Class = "Word.Document" Me.oleWord.SourceDoc = "c:\documents\example.doc" Me.oleWord.Action =...

Not sure But you could try putting code like this on the Before Update Event for each of the subforms. Me.Parent.RecordUpdated = Now If that doesn't work, try making a public function on the main form: Public Function updateTimeStamp(dteUpdate as Date) Me.RecordUpdated = dteUpdate...

I ran up against something like this too. In an Access 2003 .adp on Windows 2000/Windows XP, one of the applications I'm working on has a form with a 5-page tab control, each tab page having (yikes) a datasheet subform. One page even has a browser too. Oh dear. Remarkably, all this works...

It's puzzling that "Me.subFormCompanyResult.Form.RecordSource" isn't working for you. I use this sort of expression a lot, and haven't had serious problems getting it to work. To work out what's going wrong, try typing the code rather than copying it. VB's intelli-sense could help you diagnose...

module Yep. Create a new module and paste the second bit of code into it. I'm not sure why these things are sometimes called public modules, but maybe it's because the routines stored in them are available by default to all other objects in the database.

Yep, that'll work So long as the control is called say txt_TimeStamp and the field is called fld_TimeStamp and you use Me.fld_TimeStamp = Now You should be OK

You could try something along these lines: str_Msg_Title = "Edits by" & CurrentUser & " on " & Date str_Msg_Body = "User changed: " & vbcr & vbcr & _ Me.field1.name & " to " me.field1.value ... DoCmd.SendObject , , , strToWhom, , , "This is a test email"...