This is where the error is:
I'm only changing the last name field to test this function. It's an indexed text box (duplicates okay) limited to 50 (field size.)
I was able to get the following AuditTrail module working but it throws an error. Type mismatch 13.
I can't seem to figure out what's causing the error?
Sorry if I posted too much info...
Any help greatly appreciated. Thanks so much.
frmContacts (Changed LastName and error fired)...
This is something I've struggled with for years. I have never found the solution.
If it ends up being something simple.... erg...
Anyway, I use a database to print invoices. I have the following to print all open invoices for a specified driver. It auto prints two (2) copies of every invoice...
Hate Microsoft.... Love Access but hate Microsoft....
I just went without BUSINESS email for over a month because of Office 365... They could have cared less... I eventually switched hosting companies and now use SiteGround's proprietary email service...
They need to stop breaking shit. They...
I just added some ('s and )'s () and it seems to be working...
Can it really be that simple....?
If (Me.CurrentRecord = 1) Then
Me.cmdBack.Enabled = False
Me.cmdFirst.Enabled = False
Else
Me.cmdBack.Enabled = True
Me.cmdFirst.Enabled = True
End If...
I use in a couple places...
The one that's causing an issue is below. The Form_Current event.
This one works okay. The Mouse_Wheel event.
Mouse Wheel
On Error Resume Next
If Not Me.Dirty Then
If (COUNT < 0) And (Me.CurrentRecord > 1) Then
DoCmd.GoToRecord , , acPrevious
ElseIf...
This is causing my database to crash... I don't have any missing references...
Any ideas? Thx so much in advance...
So simple...? I don't understand... I can't find any help on this one.
If Me.CurrentRecord = 1 Then
Me.cmdBack.Enabled = False
Me.cmdFirst.Enabled = False...
Hi, I came across this post regarding copying records from one subform to another using a popup window (to enter qty) and an append query. Would you by any chance have an example of this? I'm so so with access/vba and this is something I've struggled with. Very little help online regarding this...
I'm sure this been asked/answered many times before but I can't seem to find the answer.
I have an order Entry Screen. The Invoice Number is not issued or finalized until the user clicks "Issue Invoice" after all of the items have been entered.
On the Order Entry Screen I have two subforms...
I'm searching for a MS Access 2013 Personal Finance Budget Template. I'm surprised I can't find one anywhere online... If you have one or know where I could download one, I would be grateful!!!! Thanks -Jason