Search results

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

Stumbuled on this: https://www.access-programmers.co.uk/forums/threads/detail-section-of-continuous-form-too-big.156542/page-2 - looks like nothing can be done if using tabbed windows for the database, which is my preference. Does anyone know what controls the "zebra stripes" on the form view...

Just checking back, does nobody know how to fix this. I figured out I can use a continuous form instead of datasheet view and that let's me set the forms width correctly with no scroll bar, but the height is still much longer than the number of records, but not as bad as the datasheet form. I'd...

Different issues - I have another thread about issues with a datasheet view in a pop-up form. Sorry for the confusion.

I prefer the look of the button to the text box, although I suspect the text box could possibly be made to look the same. I'm not sure how to use the sub query in the form record source. This is not the record source for the form. The button on the form is visible if a separate query has...

I'm going to post this as solved, but I used an odd method and perhaps not the best one ... I'm adding an audit trail to events on a form: https://www.access-programmers.co.uk/forums/threads/audit-update-of-a-field.329588/page-10#post-1909410 I have a command button that displays the audit...

Please see the attached database. This is ultimately pretty minor, but I am having problems getting the datasheet view pop-up form for my audit log results to center properly. I found ten or so threads asking the same types of questions, but nothing that really resolved the issue. Audit Log...