Search results

Hi! I've struggeling a bit for a while now.... We have a big list of activities with different people responsible of executing these activities in a certain week. You'll probably get it already... I'd like to search for the responsible and a certain week to display a list of the tasks meant...

Hi Guys, Anyone know how to fix the " 'AOIndex' is not an index in this table" error? This stops all the work on the database. Fortunately enough i split the GUI and physical database. The problem is in the GUI. Not sure why it occurs since i was only doing simple vba programming without...

When i enter a value in a textbox, this value isn't instantly available in VBA as a value. If i set focus to another textbox by clicking in it and want to msgbox the input of the textbox i get the error "Unvalid use of null". I DO have to press enter to somehow acknowledge the value inside the...

Hi all, Can't seem to find the option or a work-around. For our company we need standardized footers and headers which should almost always be the same whatever the editor it is made in (word/excel). Is there any option of getting a single column header and footer? Excel forces me to use three...

My query runs twice instead of once so i always add two new rows where i want only one. Private Sub Knop59_Click() Partijnummer = Keuzelijst0.Value Behandeldatum = Tekst33.Value Behandelbeurt = Behandelbeurt.Value Norm = Norm.Value Doseertijd =...

Query result in textbox after changed Howdy! I have, i guess, a small problem with refreshing/requery a form when a value is changed. This is the situation: I have a form which where a processoperator can choose a batchnumber. Based on that batchnumber it should run two queries to obtain two...

Hiya, The search function already hooked me up to using DLOOKUP for getting a result into a textbox. For whatever reason it keeps saying the error #NAME?. I have a table as seen in the attachment as image. From this table i want to select only 1 column and 1 row. I do this using this...

Hi guys! Let me introduce myself shortly. I'm Stefan Kauw and working for a big international dairy company. To monitor some processes easier i'm creating several access and excel based "applications". This forum has helped me out with several problem by only using google and therefore a good...