Search results

Yes, that is correct.

Hmm you guys got a point there... Maybe i should just keep it as it is.. Thanks for the quick reply though.. Really appreciate it!

Good Afternoon, I made a database for our people in the laboratory, which contains data of and results of different tests. I made a seperate secured workgroup, which stores all the login info and the different security levels. Yesterday ive added a new Module in the VBA code, which...

Good morning, After the disaster with the initials ive decided to let it go for now, and work om something else.. I would like to track changes made to tables using forms. In order to do that ive created a table named 'ztblDataChanges' with the following properties: LogID Autonumber PK...

The thing is.. When i replace the textbox 'Afkorting' with a dropdownmenu linked to tbllaborant, which is a linked tabel, it works fine. I can select the initials from that dropdown menu, and add new a new record... No problem at all.. But that is THE thing i am trying to adjust to where...

Thanks for your clarification, but theres just one thing i cant seem to understand. How come i can edit the existing data just fine, but i can not add data to the existing table. Is it because the query is "read-only"? But that would mean that i cant edit existing data right ? Or is it...

Try opening this one.. I stripped the database to where u can only see Bitumen instead of all the other tests.. Well, basically i made a new empty one and imported the necesarry stuff. Anyways, i hope u can open this, if not, could u tell me what msg ur getting ?

First i have to say i appreciate all your help and patience. I know i am not the best one when it comes to programming, and especially in VBA, so therefore thanks for having the patience. Anyways, this is what i did : Changed the Table Bitumen, first for Laborant, it looked into tbllaborant...

Thanks man, ill have a look, thanks again for ur help.

Well, I have a form called Bitumen, with dataentry from labtests with Bitumen(doh). And in order to gather all the information needed i made a query which combines 2 tables. Table Bitumen and Table Labgegevens (Labdata) The primarykey is Labnr which is a unique number for the tests in...

Right, so is there a way to link a table record to the strEmpName? Cause right now i have a table with data-entry of labresults, and at the end of that table i have the Initials of the person who did the tests, named Laborant. Currently Laborant is linked to tblLaborant which is a table with...

Good morning, Ive been working on the database over the last couple of days and i made a form where people from the lab can enter data.. Currently, the person using the database has to choose his/her initials from a dropdownmenu.And everything will be put into tables. Since the string...

OMG OMG OMG It worked :cool: Thanks a lot man! I couldnt have done it without your help.

Good morning everyone, its me again :) Ive tried to put the : strInitials(Me.CboEmployee.Column(2) On all the forms to see whether it should work or not, but i cant figure it out.. Am i supposed to put it in the AfterUpdate() of the cbo box? Or am i supposed to define the textbox on...

Thanks m8, ill have another go at it.. And ill let u know what the result is ;)

Nice ! And how do i show the result of the dropdown menu on Formulier1 as Initials isntead of the EmpID? Because the whole idea behind this is that the initials of the user who logged in, will be linked to a textbox so he wont have to select the initials himself. Right now the people in...

Ok, i dont know if its helpfull but i put the forms and table in question into an empty database, so i can attach it to this reply. As you can see the result of the dropdown menu is EmpID, and saved into a public string(module1). Which is being used on Formulier1 Then it checks if the...

Thanks Janr, i will have a look.. But when you replied i edited the original post with a different code i made earlier today :P I still have the one u replied too though so i will have a look at that aswell, thanks!

Howdy, Ive been trying make a Login form for our people in the lab, so if they enter data, their login initials will be automaticly entered in a txt box. Just so we can keep track of who is working on what etc. Ive found the following code from 6 years ago that is pretty much what i had in...

To be honest, i havent.. :D Can i do that by using de DoCmd.OpenModule command ?