Search results

Its possible, but unlikely. This is no more or less secure than our current Excel based system...

Will give this a go, thanks

Hey Sorry for so many posts but google isn't helping because it's sending me to sharepoint which we dont have... I need to add an approval button onto a form that once clicked will in fill in various properties... easy. However I need it to look at who the logged in user is (computer login...

Sorry for the delay getting back to everyone, was working off site. Unfortunately I can't share the database due to the nature of our company and it has confidential data in it, I would like to learn how to do the combo box's as filters because I am going to need to do this on multiple...

This needs to be done with the form, the front end of the db only allows the users to access the forms that are relevant to them. This is fantastic but I need it to be like Excel where you can see the values that are available and select them from a combo box not type them. Sorry to be so...

I have done this but each time the next filter is selected it resets the first filter. I dont know how to get it to keep the previous filter regardless of what order they are clicked. I want it to behave the exact same as Excel would behave with multiple filters

Hey, I have done lots of googling but dont understand what its telling me:confused: I have a continuous form, lots of records, working great, but we need to filter it within multiple columns (same as excel) For Example filter by 'Open / Closed' to show all the open records, and then filter...

Thanks for the advice guys, will give it a go and let you know how I get on.

The best way I can think to describe my problem is a like a customer order. The customer details are the top of the form and the order details are at the bottom, The order will have multiple items all of which need to be linked to the information at the top of the form. I was thinking a...

Hey, I know this has a simple answer but really cant remember how to do this. Still attempting to move the majority of our forms / logs / etc to access I have a form that someone fills in, the form will relate to multiple part numbers. Currently we use excel so you have the main details at...

Amazing, thank you so much. There is no way I could have figured that one out on my own.

Hey, Thanks for the code, I tried it out and unfortunately this isn't suitable because it is taking a screenshot. I need it to only show the form. I will create a report that looks like the form and see if that will email the images etc over as expected. Thanks for the help so far guys Cat

Fantastic, Thank you. Will try it today and let you know if there are any issues. Thanks again, Cat

An image is fine, as the email is notify the core team there is an issue. The issue would be dealt with and closed out from with the database. The code I wrote previously was for excel and it simply selected the cells and used the MailEnvelope function within VB. We are using outlook for all...

Thanks for the welcome. I haven't, I was aware I could do this but was hoping to do it in one step within VB, and save myself some time creating a report as the report would only be created to be emailed, and I dont think many people are even going to look at the email.

Hey, I have been tasked with trying to migrate our systems from Excel to Access I have created a form which has a couple of fields and 3 images in it that the user selects via a browse macro. I then wish for that form to be emailed, exactly as its shown on the screen to the user to certain...