Search results

Ooops sorry everyone has their OWN front end (though its the same file its unique on each machine but the same version of that if it makes sense) and the backend is the same. Its hosted on a PC in the building that I mapped a drive to and then linked the tables BEFORE distributing it. Seems to...

Hey all! I hope this is the correct place to ask my question sorry if its not! I've got an odd problem i'm trying to solve..... I have a fairly complicated form that is for handling Batch creation of products, adjusting stock levels and updating pricing. At the end of this process I use the...

Hey everyone wow thankyou so much for the quick replies! I'm reading through all of them and looking at the examples i'll come back shortly and reply to everyone with how its gone thankyou!

Hey all hopefully a quick question and quick answer. I've used plenty of 'yes/no' msg box prompts before but i'm wondering its its possible to change the text of yes/no to give slightly more control over the question i'm asking my user. I want to ask in my message box if the user wants to refund...

I'm so glad you think this way with variables to! Whenever i look at examples theres always really short variables with no description on whats being stored and its so hard to understand its use. I always have long variable names, but hey it takes an extra second to type them out but i know...

Thanks ! Always makes it easier to read haha, tends to be a nightmare otherwise, its also way easier to see comments, i think i tend to over comment my code but as i've been learning as I go its a massive help when i go back to optimise my code later on to see what my thought process was and...

Sorry i wasnt sure how to tag everyone i meant to set replies to all of you who had replied haha. Ended up writing my message and then forgot to add the extra quotes in so people got notified. Thanks :)

Oops sorry about that will make sure i do that in future! Ok so i've changed the module name to something else and its compiling just fine now thanks for that everyone!

Public Function LogOPSYSError(ByVal lngErrNumber As Long, ByVal strErrDescription As String, _ StrCallingProc As String, Optional vParameters, Optional bShowUser As Boolean = True) As Boolean Public function, created as a module. :)

Thats very true! I keep going back to make my old code better as I code but i love overcoming some of the challenges that I come up with for myself, I would never have imagined i could have done what my database currently does if i set out everything i've done now as a challenge back in January...

Hi everyone! I've tried searching the forum here and have been a fairly long time lurker but sadly i'm running into a bit of trouble understanding something i imagine is very basic for all of you experts :(. I've been working on a database for sometime now nearly every day and am trying to add...

Hi Everyone! I'm fairly new to access I started in January this year when the whole work from home phase happened and i used access as a little mini project for myself to learn to help my own workflow improve which has suddenly taken off to be used within a mini department at my work. I'm...