Search results

nobody Nobody some insight in this? I only want the results from each query in text labels. So i need some insight in how you can get the results out of a query without setting it as a recordsource of a form.

getting results from queries and populate text labels Ok, i have tried and searched but could not find a good start to a solution for my problem. I have a calendar form, which shows the dates and under it text labels. Now whenever something is present in my table (tblKalender) on those dates, i...

Hi, I have been thinking about this since two day and tried everything, but no luck. I have a form with recordsource a query. A listbox contains all references and if you choose a reference, everything else on the same form gets updated. Now i want to avoid that two users edit the same record...

You lost me there Rak. Here is the code i use, fConlist is the function for gathering all the adresses. Do i need to make a table keeping track of the emails that have been sent? Is there no other way to reset that SendObject? Private Sub Knop267_Click() On Error GoTo Err_Knop267_Click...

Thanks Thanks Rak, was a great help. The insight i needed to have. But, maybe it is my access 2000, but the first time i press the button, it mails like it should, but when i press again, or even close access and open again and press, it says that it mails, but it does not. Is this a bug or...

Ok, am stuck on this one. I have a form with all the navigation keys and it also lists your own name which you logged in with. Value comes from a string called strUser. Now i have made a query (based on tblUsers) that returns me the user that is logged in and his status and acces rights...

got it working but... I managed to got it working, but i want to send the mail without the mail popping open and me pressing send in outlook here is my code, which calls a function for getting the adresses. When i add false or true, it gives a compilation error saying expecting: instruction...

Hi guys, i want to send an email to several people when someone else enters a complaint in my database. I have a form which displays the complaint with a reference number, recordsource is "tblKlachten". i have query that is set to return only those emails i want it to send to called...

never mind, found it

Hi guys, This may be the most stupid question asked :) Untill today, each time when i drew a button or listbox, acces asked what i would liked to do. Like when drawing a button, a screen popped up, giving me choices. Doing stuf with records, forms, ... Now since this morning, when i draw a...

Hi guys, Maybe this one has been solved somewhere, but can't find it. So here it goes. I have a form with some listboxes and a checkbox. I have written some code that checks if the fields are empty or not. I will explain for one field called "SelectId" . When it is empty, a string i have...