Recent content by driver7408

Thanks. I actually ran nearly the same as that first set of code on the click event of the continuous subform on Parent.RecordsetClone and it worked without needing any separate call function. I will keep that in mind though if I experience any further snags.

I have two subforms on a main form. Both use similar queries and nearly the same set of records and PK. The first subform is for data entry and the 2nd subform is a continuous form that lists the entries in order that are made from the 1st Subform. (for entering in vacation days and...

Yes, I tested it extensively and none of the warnings were occurring. I doubt anyone went in there to mess with any of the settings. None of these guys have any clue how to use Access nor would they intentionally mess with it. The only thing I can think of is on one of the computers, those...

Before I distributed my database frontend, I went into the Access Options and set the Confirm Record Changes, Deletions, and Action Queries all to unchecked (off). My db runs many update and delete queries and I do not want those message boxes confusing my users. For some reason, I am having a...

I am trying to open a report in normal view, popup & modal so the user can view the report prior to printing it. Problem is, the report will only open to a certain height and ends up cutting off the bottom inch of the report. The report is only about 7 inches high by 6 inches wide to begin with...

Not to resurrect an old thread, but I came across this issue as well and could not find a solution anywhere online, yet a handful of people have been looking for answers. Yes, some forms should not be so long to be scrolled to begin with, but certain design implications may dictate doing so...

It is a very large form with 3 1:1 tables, several subforms, calculated fields, and queries that pull some information from another database. It is used only to generate several temporary variables that are printed out on a paper form, and then deleted at the end of the week.

Never mind, figured it out...Had to repaint the splash screen first. Private Sub Form_Current() Forms!frmSplash.SetFocus Me.Repaint DoCmd.OpenForm "frmRAW" Forms!frmRAW.Visible = False Me.Label10.Visible = False Me.Command9.Visible = True End Sub Label10 is a label on the splash screen that...

I have on very large form in my db that takes several seconds to load. I want to optimize things, so I am trying to have it load hidden in the background when the db first starts up, this way it can be immediately called on when it is needed later. Please read further : I want to have a splash...

This bit of code from PBaldy's website seems to work. I only added the query at the DoCmd Open and its filtering properly now. Private Sub Command13_Click() Dim rs As Object Dim lngBookmark As Long lngBookmark = Me.FID DoCmd.OpenForm "frmRAW", , "qryCDRSign" Set rs =...

Ive figure out how to go to the record, and I've figured out how to apply the filter, but I cannot figure out how to do both.

The form (frmRAW) is for entering a risk assessment. Once all of the information is entered into, it is later checked off by a supervisor. So I have a table full of risk assessments (tblRAW) that are created by this form (frmRAW). Some are approved, some are not. The supervisor opens the...

Thank you, I want to not only go to the record, but also set the main forms recordsource as the same recordsource that the continuous form's query uses, when the main form opens. I would assume the recordsource is specified by the continuous form onclick event of the button on the continuous...

Here's an easy one, although I've never had to do this before so I am a bit unsure. I have a continuous form that lists a group of records in a main form based on a query. On each line of this continuous form, there is a button that can be clicked to open the main form based on that record...

I found something that works great, in case someone else ever stumbles across this. After fighting with several queries and VBA, I ended up going with Allen Brown's "Duplicate the record in form and subform" off his tips and tricks website. I used the exact same code on that website...