Recent content by N1234

It's the much-preferred view of my users. Alternatively, can you change the color of the record set "selector" of the datasheet view? When I select a record, there's a blue color that surrounds the cells of that record set, which is blending in with the hyperlink upon click.

Hi Mike, I appreciate the help but I need the database to be a datasheet instead of subform. Can you speculate why it's not working on the datasheet?

If you go to the "SB" form and select "Gen" under the field one dropdown, the hyperlinks should populate. If you go into the design view of the form, the color of the hyperlink control text should be red but the hyperlinks in the form are green. Thank you.

Hi Doc, The same themes were chosen for both computers. It is interesting because I have multiple columns with hyperlinks and each computer has its own colors (all purple text on one pc and all orange text on the other). I want to ensure that the color remains static on all computers and can be...

Hi Mike, I think I saved the changes correctly because when I close and open the database again and go into design mode, the Hyperlink control's text is the new colour but the text for the Form view and in the Table is still the previous color. Very confusing.

Hello again! I have hyperlinks on a table (datatype = hyperlink) that have a default font color of orange pre-click, but a font color of blue after click. The problem is that when a row is selected. the cells also turn blue, which makes the already clicked hyperlink text impossible to see. Is...

Hi Mike, Thanks for your response. I followed your steps and while I was able to change fore color in the design view, but for some reason, once I switched to the form view, the previous color remained. I can change the color of the inbound textbox from black to whatever color is available but...

Hello again! I have hyperlinks on a table (datatype = hyperlink) that have a default font color of orange pre-click, but a font color of blue after click. The problem is that when a row is selected. the cells also turn blue, which makes the already clicked hyperlink text impossible to see. Is...

This is wonderful! Thanks for your help arnelgp!

Hi arnelgp! This works great! I forgot to mention the "file already exists exception" overwrite feature. I,m worried that I may overwrite an excel file that may have the same name as a newly exported file. Is there a way to create that exception? Thanks again for your help! Much appreciated!

Hi arnelgp! This looks nice but the only thing is that the saved file name also takes in the folder name. For example if I save the file as "test1" in my desktop, the file becomes "desktoptest1.xlsx" instead of just "test1.xlsx".

Hello again! I have a button on my form that exports the searched output to excel as a generic name to a selected folder. I was wondering if I'm able to change the name while selecting the folder, similar to a "Save As" for Word for Excel: Thanks again! N

This is excellent. Thanks again for your help theDBguy! Much appreciated!

Was done by design. The main user is able to edit the data but the other users can return data but not edit.

Through my searchboxes and dropdowns (use VBA), they work in tandem to filter through my data. Unless I was confused by Isaac's comments, I thought he was referring to a form property for the filter, but I do not recall altering any form properties for the filter.