Search results

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

Ideally I would like to be able to enter players in one table, enter team data in another table, and be able to print do a query to print out rosters based off query information such as print rosters of only a certain division, conference, etc. If you can help me with the base tables and report...

Yay. That's exactly what I did minus the year, but I'll add that. I'm trying to do the relationships now, but the way the join type is worded is confusing. It was easier when I showed the infinite symbol on one side.

Actually, I don't know about a third table because even though I know what data I would want in it from both tables I don't have a primary key for a rosters table as rosters are more of a report generated from players and the team they play for.

Thanks for the reply. I'll get rid of the special character. I didn't like it myself, but they already had it that way and Access didn't complain about it so I left it. I don't believe they are doing much of the database for history, but more for just keeping track of current season rosters...

I'm thinking of just making a roster table and adding the primary keys from my current tables in it as foreign keys.