Search results

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...

It has primary keys on all 3 with 1st being an autonumber. I was thinking of incorporating a checkbox in the form. When the checkbox is true, the record will query up later via combobox on the switchboard. If selected, the common fields from the old record will be appended into the new record...

I would consider myself at a novice level when it comes to VBA. Mostly basic functions, but not declaring variables much yet. I have a db using 3 large tables with 1:1 relationships. Before you question my normalization, I stress that these tables are strictly used to temporarily store user...

I am already aware that it is impossible to utilize digital signatures on forms or reports within Access. Digital signatures are my only option. I have created a 2 page report that prints and saves beautifully. I am particularly using .pdf as the format to save the report to. On the report...

I am actually on a gaming computer and still having the issue. I guess it is an inherent problem with Access that hasn't bugged anyone enough for them to fix...

I have searched with no avail for this simple and common and very annoying problem that I have seen on every computer I've used Access 2007 on: When side scrolling from left to right in the query window or on tables, once I start moving to the right, all the text in the fields becomes distorted...