Search results

Love this website full of great information... I am trying to update an Excel spreadsheet through an Access Macro that is saved on a Shared Drive. As of now in the macro I have ImportExportSpresdsheet, but it doesn’t override the last spreadsheet. It’s creating a new tab on the spreadsheet, and...

I do have one more question, how can I make this DB for multi users? It’s on a shared drive and under options, advanced it shows default open mode shared, edited record.

OMGness... you are genius!! It worked it looks great. Thank you for having patience with me especially not knowing the difference between SQL vs VBA. I REALLY appreciate all your help!! THANK YOU

I am thinking....If primary responsibility equals hotline then run the macro. Alerting them to pick a tier? if that is correct I don’t know how to write it on the macro. can I set warnings off before the if statement?

Ok the message box is coming up, very nice. I honestly think that is what they are wanting. I do see the IF in the macro on click option. What would I put there? Thank you for your patience

Just getting back to work. Let me check... thank you

Got it thank you - really appreciate the patience and help. Now is there a way from choosing from the drop down box, if the selection is “hotline” to bring up the message box. the message box is to remind the user to go to the next field over and fill out what “tier” of the hotline the person is...

By selecting the responsibility field in design view, I put the msg box in the After Update on the property sheet. I only want the message to come up when Hotline is chosen - what would the If statement be and where in the design property sheet would I put it? All help is VERY appreciated.

I am not a programmer, and do not know SQL very well. So in the property of the combo box I am wanting a message to come up if “hotline” was chosen to bring up a message that says “input Tier in the tier field”

I have a form that I am needing to add a message box it a certain item is chosen from a combo box, without using SQL. I have the form open in design view, in the property of the combo box field. Any help is very appreciated!!

I am needing to know if there is a way, you could bring up a scanned document in Access by Employee ID via link on a main form. The document would be saved on a shared drive. Any help/assistance is greatly appreciated

Thank you! I really appreciate the help. I will have to fix it when I get back to work.

I have a form where the user will choose available or unavailable from a combo box. I want to automatically have another box that will have a field to show Yes or No depending on what they chose from the combo box field. How do I program that, based on the combo box?

Creating a form, one field is a combo box, either available or not available. Need to have another field to automatically update to yes or no based on the combo box. I do not know SQL. Any guidance is very appreciated.

Thank you Thank you... it worked, appreciate your help!!

Thank you I will try that when I return to the office. Appreciate your quick assistance.

Sorry I haven’t done that yet, but was thinking of merging the two together after importing into dB, via macro and then redesign the form. Just didn’t know if there was a way around that, to show the pic without double clicking on what the sub form shows “bitmap image”

I have which I would have to append the two tables into one, correct, via macro? Didn’t know if there was a way around that.

Two tables linked on employee number, one shows employee info the other employee picture. Employee information table is imported into the database, which is the main form. Pictures have been uploaded, this is the subform. As of now the sub form only shows the pic as bitmap image, when you click...

Thank you, I will apply all the suggestions when I get back to work, really appreciate all the feedback,