Search results

The main issues I've heard with "Select" had to do with the macro recorder and Excel/Word Macros. It uses "Select" liberally, i.e. RangeA.Select, RangeA.Copy, RangeB.Select, RangeB.Paste, where the macro would work the same and be faster with the select statements omitted. It isn't that Select...

I know this is an old thread, but I had the same question and @The_Doc_Man has helped me out before, so I wanted to give back a little bit. Basically, the answer is a combination of: http://www.vbaexpress.com/forum/showthread.php?2512-Solved-Position-on-page - Start at the end. And...

@isladogs - Thanks, great stuff as always!!!

I feel stupid. It's there and it works!!!! I was used to only seeing Alternate Background Colors in design view and grayed out. As you said, when I changed it to pop-up > No and opened it normally, the Form Datasheet option popped out and there it was. I never would have figured it out on my...

I was going to post something sarcastic like "Of course, that was totally obvious", but it didn't even work???

This is the form (basically) that @arnelgp posted in Reply #20. I'm not sure if you would call it a datasheet form or not. It's a regular pop-up form with the default view set to datasheet view.

You aren't kidding. I don't see a Form Datasheet option. Even if I go to Customize the Ribbon, I don't see a Form Datasheet option that I can add. If I open the form in Design view, I see a Format tab and on that tab, there is Background> and Alternate Row Color, but it is grayed out and can't...

LOL - only took YOU a couple of minutes to create ... (Actually, creating the datasheet form was simple, it was getting it to size and position properly that was a headache.) Actually, no, I didn't. The datasheet form was always using the alternate row colors. I was having trouble with the...

@isladogs - Thanks, but I'm going to leave it the way it is now: I don't want it as a subform. Split form could work, but we (mostly the others in this thread) put a lot of work into this and the split form still has the first cell selected with a different background, it just gets rid of the...

Better - In Form Load, I added Me.REFERENCE.SelLength = 0 It still has the I-Beam cursor in the first cell, but at least the entire value isn't highlighted. I tried some of the other things that I'd done previously like setting focus on a zero-width and height text box or a zero-width and...

One last follow-up question. This is meant to be a display-only form. i.e I have additions, deletions, and edits turned off. Added records are inserted using data macros on the back-end table. In the example, the row1, column1 value is highlighted and I can move between the values (which I...

SUCCESS!!! Reply#20 Vertical Height works fine. Reply#22 Vertical Height has a vertical scroll bar. I used your instructions in Reply#22 and the demo in Reply #20 and got this: In ResizeAndCenterDatasheet Form, I also changed: NewHeight = (Form2Center.RowHeight * .RecordCount) +420 to...

Centering and vertical size is solved. Is there any way to get rid of the horizontal scroll bar? And everyone's effort is greatly appreciated!

Thank you - sample works now. Getting closer. Centering is fine. Still has a horizontal scroll bar, even though there is no data on the right. Now has a vertical scroll bar, even though all the records should be able to be displayed:

It has that line. Might be easier for someone else to re-work and re-post the example.

Thanks - now getting Type Mismatch here: Public Function ConvertPixelsToPoints(ByVal sngPixels As Single, _ ByVal sXorY As String) As Single Dim hdc As LongPtr hdc = GetDC(0) If sXorY = "X" Then ConvertPixelsToPoints = sngPixels * (72 /...

Wasn't thinking last night and just looked at the form code. This morning I tried to do a compile: It gives me a type mismatch in the module here: Public Function TwipsPerPixelX() As Single Dim DC As LongPtr DC = GetDC(HWND_DESKTOP) TwipsPerPixelX = 1440& / GetDeviceCaps(DC...

Sounds right, but I'm getting this: I commented out the .insideHeight line in the OnOpen event, but I still get the error. Otherwise, the code looks like it should do what I need, though!!!

Wouldn't have thought of Alternate Back Color - Thank you again!!!

My bad! I responded, but I must have forgotten to click "Post Reply". To reply to #2 - If you delete the centering code that I had, I think it will not display properly if you have two monitors and the primary monitor is on the left and the database is on the right, but I can't test that right...