Search results

That's exactly what I did. I had played with On Timer event before I tried GotFocus, your hint got me into the right direction.

This worked great! Thanks

Ah, that makes sense. I have these queries on the form also that I'd like to update. I can make a refresh button but if possible, I'd prefer it to be automatic or maybe even a set interval.

I created a landing form with `="Date: " & Date()` field that I would like to update automatically. After doing some reading, I found suggestions of using GotFocus() event and Me. Requery to update the form but it doesn't seem to be working for me. What am I missing? Here's the date I'm...

Noted. I'm the only user for now so I'm not worried about that part yet. If I get comfortable enough to create a project that involve other users then I would definitely try to avoid displaying the query and instead present a datasheet view form that actually makes more sense now that you...

That did it! Thank you. Just had to make sure to do the setfocus before my docmd.openquery.

I have a form with a text box that displays query numbers. I have it set to open the query on double click and that works. I just want to change the focus after the double click event so that the text box is not selected, maybe shift focus on the main form? This is after the double click event.

Thanks! I don't normally do that, just on this test so the report is listed on top :)

Hot dang, it worked! Private Sub Command0_Click() Reports("_rptTest").subrptSingleEmpRateList.Visible = True Reports("_rptTest").subrptSingleEmpTaxList.Visible = True End Sub

Thanks, I will try and mock up something to see if I can actually accomplish this. My ideas are not on same level as my access skills lol.

My first Access db project is a personnel db that includes the usual demographic info, rate, tax, license (expiration, etc, if any), notes and other bits of info. My first report I created had all this info in it and it worked out just fine. Then I needed another slimmed down report that does...

Thank you for this @arnelgp. I tried it and it worked like how I was expecting it to. Sorry for the delayed reply, had to watch some youtube videos on access vba to kind of get a feel for what the code was doing. I have a question though, what's the Const FP_LINES = 30 and Const NP_LINES = 32...

Woah, lots of activity to sort out. I appreciate it guys/gals, this will take me a bit to digest. Thank you!

Thank you for this, let me see what I can put together using your suggestion.

I am not sure if we're allowed to upload a sample db (I didn't search yet) so I just clipped it. This table may grow up to about 160ish in record count. What I'm trying to accomplish is to divide it into 3 columns. In this example, the query would have 19 records so I'll end up with 2 columns...

@SHANEMAC51, figure 2 is what I'm after so I'm definitely going to have to code something together.

My bad, you got me, see I told you I was a newbie. I meant report, not form! Let me see if I can edit the thread title. Edit: Also, I believe this thread should be moved to the appropriate section also.

I have a query that generates records from 100 to 140. I'd like to distribute the printout into 3 columns. I got as far as getting my result count into a variable but am not sure how to start the new column when my desired number of records for the first column is reached. I'm more comfortable...