Recent content by hprwdvd

Bingo! Turns out in the above code i had a quite misleading line docmd.save which shouldn't be there for BeforeUpdate events. So now it is working fine!!!

Good morning, I have a continuous form with a hyperlink on each row that opens to a dialog form for that record where the user enter/change data. When the dialog form closes, the main continuous form is automatically updated. The continuous form also contains a column of combo boxes for...

I have the same problem. The printer is already set to the default network printer. The database runs quickly on my local drive, but slower on some other computers' local drives without the Full version of Access. Opening the first report is slow, but then in subsequent tries it opens in 1...

Good afternoon, I have designed an Access database in Access 2007. It works beautifully on my local drive. However, when I send it to another computer without Access (Windows 7 - so has Runtime 2007) it slows down a lot. Opening a report of 9 fields takes up to 5 minutes (and for only 1 or 2...

Hi RuralGuy, Could you provide the code for deleting the just added Subform record?

Hi Rural Guy, here is what is doing the trick right now: Combo316_AfterUpdate_Exit: Form1.SetFocus If Me!Form1.Form!Category <> "" Or IsNull(Me!Form1.Form!Category) = False Then DoCmd.RunCommand acCmdRecordsGoToNew Else End If Exit Sub I built on the afterupdate code you provided. It' s not...

Thanks Rural Guy

I stuck that code in the AfterUpdate event, after: If Not Me.RecordsetClone.NoMatch Then Me.Bookmark = Me.RecordsetClone.Bookmark which you have provided.

Hi RuralGuy, I will try that. I have another question: Because my subform is in form view and not datasheet view (due to the many fields and ease of use), is there a way to get the subform to open on a new record? For example, after adding in a new customer name, it lands on the just added...

Okay I answered my second question: DateDue = dhAddWorkDaysA(5, Now()) MySQL = "Insert Into Cases([Customer], [First Response Due]) Values(""" & NewID & """, """ & DateDue & """)" And I put the rest of the default values into the Default Value section of the Table itself in design view, not...

I have one default value that is a function for a DueDate field: =dhAddWorkDaysA(5,[OpenedDate]) where [OpenedDate] is a field in the subform with a default value of today's date. Otherwise, I suppose we could manually put the names of the fields into the INSERT INTO statement and assign the...

Hi RuralGuy, sorry just noticed something else. I assigned default values to some fields in the subform (in my master database) via the property settings panel on the side when the form is in design view. However, none of these work for a new record added to a new customer name. Could you...

Hi RuralGuy, I've tried it in my master database and it works great. I had to change the cycle of the main form from Current Record to All Records. I have one question, is there a way to undo the newly added subform record upon closing the form? The Customer Name can be saved in the Customers...

RURALGUY, THIS LOOKS GRREEEAAATTT!!!! I am going to put it into my actual database and see. THANK YOU FOR YOUR HELP!!!! :D

And sorry just a correction, the "buttons" I refered to in post #19 are comboboxes. So Combo335 and Combo337 are comboboxes, not buttons.