Search results

Hadn't thought of that Plog. Would've been a lot easier to do it that way. Thanks anyway

Hi DB, I did have both values on the drop down list anyway, but the user was using the autocomplete function of the drop down which was leading them to selecting the wrong value as they were taking the "easy" way out. Sadly another example of manipulating a perfectly working database in a bad...

Thanks Minty! Worked a treat and I'll keep that in mind for future!

Hi all, I have an access database that lists numerous customers in a customers table. This is used in conjunction with a register form to list the customer that a record relates to. I've been asked if I can change the current drop down to change the customer name to add in the customer...

Please see attached

Hi Guys, I'm self taught on VBA and access and I have an issue that I cant figure out. I have 2 tables, one with the current progress of a user through a learning module. The second is a results table to show how many sections of that module the user has completed. I'll then join this to...

Hi, Can you help. I'm trying to open one of two forms based on if a record exists in a table. Can someone look at the code below and see where its gone wrong. the code doesn't do anything. If DCount("Holon", "tbl_Holonsecurity", "[User]=" & fOSUserName()) > 0 Then DoCmd.OpenForm...

Hi, Yes this wouldn't work as there is also permissions problems from the location it is hosted on. Whilst we need it to be stored in the location it is in, we also do not want to give all users access to that location due to sensitive information. Therefore it was deemed that the safest and...

Hi All, I have a colleague who wants me to build an access database for him. The aim is to use access to raise and store data on issues that are raised in the company, I.e a part has been manufactured wrong or sales have incorrectly specified parts to a customer. That much in itself is a...

Thanks Pat, but I have already thought about this and have it under control

Thannks thats worked!

Hi Minty, Doesn't seem to like it. I'm not on top form today though as I'm dealing with an illness. So my initials are in Combo35.Column(3) I've then tried in the after update ebent on the combo box: Me.initials = Combo35.Column(3) No luck.

Hi Guys. I have a form and 2 fields are related 1st is a Responsible field which the user selects the user that is responsible for the task. This is a look up value from Tbl_User. Once the user selects the responsible user the form stores the ID. I then have an initials field. This should...

Thanks Ranman, Think I was over complicating things. Thats Exactly what I want.

Hi Guys, I've put this here as I think its more VBA then queries. I have a load of queries that count the number of instances of where a record was sent to. For example how many records were sent to department X for processing. The Sql for this is SELECT Count(*) AS Quantity FROM...

Hi Guys, On my database I have a login screen. I used to open a form and show all subform results based on what team the users were on. Due to the number of records this is getting a bit slow. So I'm trying to rebuild using just the operators records. But, there needs to be the ability to...

Hi Guys, I'm having a compile error message come up for the below code. The code is good, and has worked for many months, but I've come to build a mark 2 of my database to slim it down after months of changes and improvements. The code has now stopped working Private Sub Label33_Click() Dim...

Thanks, Its still not working but i've made a work around.

Hi, Due to the way I've needed to sort something out I have the following set up. Main form 1 - Dealing with all work a department does. Tab control 1- 3 pages 1st page is stock - on which is: Subform 4 - Stock requests - on which is: Tab control 2 - New, outstanding and on hold I can refresh...

I can't get on with just copying and pasting. I like to go through it and make sure I know what it does and also as you say, change it to suit my situation.