Search results

If you make your add record form Popup and Modal, then it will come up on top of all other forms, and will not let any other code run until the form is closed. Larry

In code you could do Format(MyNumber, "000000") Larry

See the article here on making a popup menu: Make Access Command Buttons Work Harder Then use this code to bring the menu up on a right click: Private Sub PictureFrame_MouseUp(Button As Integer, Shift As Integer, x As Single, Y As Single) On Error Resume Next Select Case Button Case 2...

Excellent! Glad you got it figured out. Thanks for posting the solution. Larry

Put the code that is run when you click the button into the AfterUpdate of your option list. Larry

What you have to do is define what the desired starting height and width are. Let's say you want each image to start out at 4 inches wide by 3 inches high. In Form_Current just put Me.cempic.Width=3 and Me.cempic.Height=3. That way when you go to a new record it undoes any changes made by the...

Do a search on Decompile. It has saved me from some strange errors before. If you can't find any good info on it let me know and I'll dig up some links for you. Larry

You would have to look at your code to see what it does to resize the image and then in OnCurrent set it back to its beginning values. Larry

Set the form's property to Data Entry = Yes. Larry

Make the following settings to the registry then restart the computer: [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared Tools\Graphics Filters\Import\JPEG\Options] "ShowProgressDialog"="No" [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared Tools\Graphics Filters\Import\BMP\Options]...

In the afterupdate event of your shipped date textbox, lock all the controls on your form. Put this same code in oncurrent so if user is looking at old records they will not be able to change them. If not isnull (me.shippeddate) then me.control1.enabled=false me.control1.locked=true...

Interesting problem. You could either create five different reports, each one with the fields in question removed, and print them one after another, or set up a variable on the form that calls the report, say PrintNum, that you check in the OnFormat event of the detail section to see which...

I have found that the export does not respect the setting for Can Grow = False for text boxes. I had to play around with the width of the text box to get it to look acceptable in both the report window and the exported Word version. Larry

You have to use "Select Distinct" in the rowsource for the combo box. Larry

Do a forum search on Cascading Combo Boxes. Larry

Use your form's On Timer event to change to the next slide. Larry

You need to tell access to use the value that you entered in the combo box to go to the correct record. The combo box used to enter the desired student id should be unbound. In the combo's afterupdate event put something like: dim rst as object set rst = me.recordset.clone rst.findfirst...

To create a two line msg box: msgbox "This is line one." & vbcrlf & "This is line two."

The only way I know around that is to create your own form as the zoom window, and bring that up on the double click event. Larry

In the properties for the subform, find the Order By and put Fieldname DESC where Fieldname is whatever field in the subform's recordsource you want to sort on. The DESC tells it to sort descending, or newest records first. Larry