Search results

Forms are for entering data, not tables. Yes, there is utility you can get from Allen Browne for this via a form.

I CAN definitely confirm this to be a bug. I rebuilt the forms/tables/queries in question form scratch and still can't see the subform as a form, instead it sees it as a report and you can refer to it or access any controls via the expression builder. No copying/pasting,etc... Case Closed:

Fresh ones, still researching the issue. It is causing me lot of problems.

I use MalwareBytes but you could also use a free tool from Kaspersky that should remove it.

Do you have the form's Record Locks set to Edited Record?

Thank You, I appreciate it,

Not sure what I'm missing here! Dim strSQL As String 'Add Absence Data to tblHour. strSQL = "INSERT INTO tblHour (WorkDate,EmployeeID,Hours) " strSQL = strSQL & "VALUES (#" & Me.AbsenceDteTo & "#, '" & Me.EmployeeID & "', '" & Me.txtAbsHrs & "')" CurrentDb.Execute...

I was once blind but now I see ... :D Thanks,

I can't see the forest again because of the trees! Error 2447 invalid use of (dot) ! Operator or invalid parenthesis If [frmPayrollEntry].[Form]![txtVacHrTotal] > 364 And [frmPayrollEntry].[Form]![txtVacHrTotal] < 730 Then [frmPayrollEntry].[Form]![txtVacHrTotal]![lblVacHr].Caption =...

Just curious, how is it your binding to the Order Header and why?

I don't have any idea why Access is crashing, i suspect it's nothing to do with email. I don't use Outlook myself but there are many code examples on the site and Google if you do a search. Also examples in the Sample Database section.

Example: DoCmd.SendObject acSendReport, [name of report], acFormatPDF, "recipient@company.com",[cc email(s)],[bcc email(s)], [Message Subject], [MessageBody], True HTH

One refers to the form modules and the other coded modules.

I am so brain dead from debugging that I can't see straight. It compiles, everything works with no errors but the checking continues on and on. My ChangeLog is getting big. 13,107,200 Bytes 70,920 Lines of Code 212 Modules 1,783 Procedures 102 Tables 130 Queries 149 Forms 31 Reports 6 Macros...

I copied a different form altogether. I did not use the same form. As my issue is resolved, I'm going to put this to rest. To much work to create all new forms and re-test. As far as I'm concerned, this is on Microsoft. I could of course be wrong, but will leave it at that. Thanks for the...

Same Result.

I have officially confirmed that it IS an issue. I placed a NEW different form and it showed up in the Expression Builder as a Report where you can't see or access any fields. ??? I don't think my situation is all that unique, maybe it is. I have a frmEmployees with tabs on it with subforms on...

I went through several databases that I have written with similar form structure with no problems. So I think for some reason Access does not like the naming convention of the subforms. I have not tried renaming them as I would also have to change a bit of code but will get around to it and see...

I have not tested it yet. This was a Re-Designed form, so I was surprised. I will when I get time.

I really can't say. It's rare that I use the expression builder anyway.