Recent content by Elana

Hi Again, I feel like such a dolt - while I have designed several applications in Access, I've never really had to work with the Timer. I'm self-taught and for some reason I can't get my brain around this particular concept. Could you possibly give me an example of how I would check the time...

On the main form's After Update event (meaning that once a new record is entered on the main form), place this: me.YourSubformName.requery Unless you've already tried that... E

Thanks - I didn't realize that about the Timer. I now know what to do to fix things. E

Hi- I tried Ghudson's example for using an "animated" gif and it works great - only I have one problem, which I described in a post 10 days ago that no one has responded to. Thought I'd post on this thread with the hope that you can help me. I've created a Please Wait form to display while...

Hi- I've created a Please Wait form to display while a semi-lengthy process runs. I used the example from the MS Knowledge Base: DoCmd.OpenForm "frmpleasewait", , , , acFormReadOnly, acWindowNormal DoCmd.Hourglass True DoCmd.RepaintObject acForm, "frmpleasewait"...

I believe I've figured it out. Public Function ExcelTest() Dim objXL As Object Set objXL = CreateObject("Excel.Application") With objXL.Application .Visible = True 'Open the Workbook .Workbooks.Open "C:\skiapplicationdata\resortinfo1.xls"...

Hi - I've been trying to figure this out for two days and have gotten close, but now I'm stuck: I need to open several excel workbooks, then calculate, save and close them. I want to do this from Access and here is what I've developed so far (using only one workbook as an example): Public...

Check out the OnTimer event of the form.

Here is some code I used for a form's notinlist event - the important thing to do is set the value of your combobox field to null: Private Sub ClientID_NotInList(NewData As String, intresponse As Integer) On Error GoTo ClientNotinListErr intresponse = MsgBox("'" & NewData &...

Hi - check out this MS Knowledge Base article #209203 - should solve your problem: http://support.microsoft.com/default.aspx?scid=kb;en-us;209203 HTH E

Hi, Sorry about that - when I started composing my last post to you with my rudimentary example, I walked away for awhile and then came back to it. Never noticed that in the meantime you had posted your code! Sorry - it's pretty obvious you didn't need such a basic example. Note to myself...

Here is an example of a Select Case syntax that would work on a form event (like the AfterUpdate event of the TargetPickupTime field). Select Case bill_code Case "BR", "RB", "TB", "B2", "VB", "B3" Select Case target_pickup_time case 17:00 jsgrade = 100%...

In the On Current event of your form, place this code: if me.newrecord then Me.YourFieldName = DMax("YourFieldName", "YourTableName") + 1 else 'do nothing end if

Looks almost exactly like the code I gave you :confused:

Set the control source of txtSub to =sum([expr1])