Search results

The problem is the list is thousands of records long. I want to place a row of buttons along the top of the form, one for each letter of the alphabet. Then you could click "M" for example and it would scroll the continuous form down to the first record beginning with "M" Like how you could...

I'm fine with putting the buttons in the form header, but what action do I make the buttons do to scroll the detail part?

I would like to create some command buttons to making scrolling through a long continuous form simpler. As anchor tags in HTML, listing each letter of the alphabet and when clicked would scroll the form down to the first record beginning with that letter. Been googling but can't seem to find...

I'm heading home for the day.. Hopefully have some time to work on it tomorrow.. thanks for all your help guys..

Getting this...

:\ DoCmd.OpenReport "reportname", acViewNormal is automatically printing the report?!?

There is no OnLoad for Reports. I've made the recordset a global variable. Something is not quite right though as i barely see the "outputting report bla bla" screen and it isn't generating a word doc. Will try just opening the report.

Since this code is in the command button on a form, as opposed to the subreport itself.. Can I try putting something similar in the subreports OnOpen event? or OnLoad?

As such? Getting compile error, type mismatch when setting reports recordsource to the recordset. Option Compare Database Option Explicit Private Sub runrpt_day_Click() ' Process date Dim qryProcessDate As String, qryProcessDateTXT As String If Not IsNull(Me.qryProcessDate) Then...

that's got to be it. done a quick google, should I be setting it in the reports onopen event? or can i do it in the same VBA code? Reports!subreportname.RecordSource = rstSC

That is exactly what I thought I had done, and the parameter popup still appears. Private Sub runrpt_day_Click() ' Process date Dim qryProcessDate As String, qryProcessDateTXT As String If Not IsNull(Me.qryProcessDate) Then qryProcessDate = Me.qryProcessDate Else MsgBox ("Please enter...

lol.. uh that's exactly what I was doing.. and I am trying to avoid that parameter popup since it is the same parameter across all five queries.. i will figure out some combination of bob's suggestion. thanks.

No i understood :) but I have quite a bit built and if I can use that with some changes will be faster & less effort than starting nearly from scratch.

not exactly, just that the query w/ parameter popup is fine for one implementation, while I want to set the parameter programatically in another. I may end up going that route anyways, but will hold off to see if what Banana can show me can be implemented more easily than creating new forms and...

I just decided to try setting the parameters in the VBA code because the queries are re-used in multiple places and I'd have to duplicate every query once with a parameter and once with the form's control. I may have to go that route, but am trying to avoid duplicating the queries.

I've defined the parameters in the query, but setting the parameter needs to be dynamic (ie. set to the date in my forms textbox)

It was the only way I found to apply a the parameter to the query.

That line stays red, says it is expecting an = I've tried fixing it to; rstSC.OpenRecordset qdfSC, dbOpenDynaset or rstSC.OpenRecordset "qdfSC", dbOpenDynaset and am getting an "Object variable or With block variable not set" error.

Not that I doubt you are correct, but could you maybe explain a bit more? I set a querydef, then use the openrecordset method on that querydef, why do I need to assign a query again? That change has also given me a "Data type conversion error (3421)"

Does this not set the query? Set qdfSC = CurrentDb.QueryDefs("00ChkSanity")