Search results

I tried this first and yes it did work but has not sped up the loading time of the database.

I thought all of this was doing just that... but I kept asking if I needed to remove all of the source objects from the properties but I never got an answer so I just tried it and this no longer works because nothing comes up when the tabs are clicked. That being said... obviously I was...

it is interesting that I had actually already tried that exact same thing but I got an error regarding the record source either being blank or misspelled (I tried it with the under scores as you suggested) but when I did it again as you said it worked this time. The database with the linked...

I really need this last part to work so I can move on. I already got all of the reporting features working thanks to some great help in another thread and aside from some minor error handling here and there it is complete if I can just get the forms on the tabs to delay loading until the tabs...

This was perfect... thank you so much... here is the final code that works perfect Private Sub cmdGenerateReport_Click() If Me.cboReports & "" <> "" Then DoCmd.OpenReport cboReports, acViewReport, , IIf(IsNull(Me.cboFacility), "", "Facility='" & Me.cboFacility & "'") Else...

Please don't give up on me now! Advice to ignore advice taken and ignored :D

Here is a screenshot of the first tab and the form that is on it... what would be the subform control to use as the source object?

My mistake about the pg2 repeating. Now... I guess I am not understanding what sub form control you are talking about. My tab control tabs all have different forms on the pages with different record sources... none of them are linked with child fields except for one of the forms has sub forms...

Okay... so what am I doing wrong? I changed the .sfm parts to the names of the control on the tabs like this: Select Case Me.CurrentPage.Name Case "pg0" Me.NewRecordInputForm.SourceObject = "frm_engineerinput" Case "pg1" Me.VisInputForm.SourceObject =...

I tried your code like this: Property Get CurrentPage() As Access.Page With Me.TabCtl87 Set CurrentPage = .Pages(.Value) End With End Property Private Sub TabCtl87_Change() Select Case Me.CurrentPage.Name Case "pg0" Me.sfm.SourceObject =...

I stated the error I was getting at the bottom of the post. What I am trying to do is defer the loading of all of the forms on the tabs in the tab control except for one so the db doesn't take 1-5 minutes to open. The code above is supposed to do that but something is wrong with it. Error...

I agree that the words a little help are comical with 5 pages of conversation. Things are never as easy as they seem I guess. I am getting closer to using the tabbed control version of the database... most of the issues are small nit-picky reports and the like and the only stopping point now is...

Thank you this fixed it. As for your edit to a previous post... the query stopped working before I ever did any code edits anywhere. However with all you have helped me with the query isn't the same anymore and that part became irrelevant.

Okay... so here is the code: Private Sub cmdGenerateReport_Click() Dim strWhere As String If Not IsNull(cboFacility) Then strWhere = "Facility='" & cboFacility & "'" DoCmd.OpenReport cboReports, acViewReport, , strWhere ' Else ' MsgBox ("You Must First Select a Report...

That actually was the parameter in qry_waitvis before posting post #1. After reading post #1 I realize there was missing code in the query I showed there. This was the complete query code in qry_waitvis when it worked and then quit working: SELECT tbl_auditdata.AuditID, tbl_auditdata.Status...

This worked but I lost the ability to require them to choose a report. Leaving the facility blank and leaving the report choice blank produced a "run-time error 2497. The action or method requires a Report Name argument" I tried leaving in the else code but it errored saying there was an else...

I tried this code I found: Private Sub TabCtl87_Change() Select Case TabCtl87.Pages.Item(TabCtl87.Value).Name Case "pg0" If Len(NewRecordInputForm.SourceObject) = 0 Then NewRecordInputForm.SourceObject = "frm_engineerinput" End If Case "pg1" If...

The query code I said worked last week Forms![frm_home]![ReportCenter].Form![cboFacility] The query code you said to use: Forms!frm_home!ReportCenter.Form!cboFacility Is that not the same minus the brackets? I copied and pasted your code into my query and had the same result unless I am missing...

I had already tried removing the brackets but had the same parameter popup result. Very strange that this worked last week but doesn't this week. Anyway I changed the whole thing to use 2 comboboxes. One for selecting the facility and the other for selecting the type of report desired. The...

Turns out I broke it by setting the record source of the frm_userprofile to the tbl_users rather than the query qry_userprofile. That created a lot of crazy issues and errors. I have nothing in there now regarding the delaying of forms loading on database open. I have stripped down and attached...