Recent content by ITguy1981

I need the user to select a .xlsx file.

I've tried this code and the file picker opens, but I need it to fill my text box with the file path of the file chosen. Dim fd As FileDialog Set fd = Application.FileDialog(msoFileDialogFilePicker) With fd .AllowMultiSelect = False If .Show Then...

If I use the code you posted for explorer I can select the file, but it does not insert the directory location after selecting the file and open

They way it currently is it opens explorer and when you choose the file it saves the path\name in the text box. The user will browse and select an excel file. It puts the excel file path in to the box. Then the user can click update which will then run a procedure to update another table...

Basically I have a button that on click runs Private Sub ImportBrowse_Click() Me!BrowseTextBox = BrowseFiles() It opens windows explorer to browse for a file. It works in 32bit Office. -------------------------------- Public Function BrowseFiles() Dim sSave As String sSave =...

I was able to resolve the issue by using an If Statement and using the SafePtr option for VBA7. Do you have any insight on my next issue which is a Type mismatch for StrPtr. I'm sure it's related to the same thing, but not sure how to fix it. Public Function BrowseFiles() Dim sSave As...

I'm currently using a custom ribbon that gets a macro error when any of the buttons are clicked. It seems the issue is due to using 64 bit Office now. I've had help with the previous code so I have no idea what needs changed or how to fix the issue. Current Code: Private Const...

I'd like to be able to automatically send a report from Access through Outlook. Currently, I started with: DoCmd.SendObject acSendReport, "rpt30Warning", acFormatPDF, "myaddress@domain.com", , , "Expiratations in 30 days", "Please see attached PDF.", False I later found I can't use this...

I have a split form with a sum of totals in the form footer. The total shows as long as the fields are filled have data and as long the cursor is not moved in to the next bank field of a new record. How can I get the total to always show and calculate properly?

So after doing a lot of research I've learned that you can't change the main ribbon without reloading the database and I would even be okay with that, but there doesn't seem to be any way through VB to change the default on load ribbon that you would normally set through the database options...

Thank you for all of the replies. I'll post back when I get a chance to work on the database more. Hopefully, I can later today or tomorrow.

Thanks Arnel. I think I may try your option first as I just need a way to change the ribbon with input data. In my case I'll just use password in place of the username.

Thanks Ridders. The password could just be in a table and I really wouldn't even need that encrypted. I plan on hiding editing options and tables along with disabling the bypass at startup. Mostly I just want easy access for myself to be able to edit the database and disable it so users can't...

Currently, I do not have users logging in. In this case it would probably be easier to have an admin password option to unhide ribbon controls. Any help with this would be appreciated as I am new to working with ribbons.

I'm looking for a way to change the custom ribbon by clicking a button on a ribbon and entering a password. Right now my database has two ribbons. One labeled developers and one labeled users. Basically, the users ribbon hides all the ribbons, but the one custom ribbon. I would like to click...