Search results

Date between Hi there! Just read this thread and directly pasted your code into my db too... Your code is simply awesome and so easy to just paste :-) As my source however, I have selected a query, that includes a condition (Where date Between [forms]![salgsrapportperiode]![tekst1] And...

Hi There! In my query i can easily write "ORDER BY coaching.date" in my SQL. But instead I want to order by the output of a dropdown menu... I want the user to select what he wants the data ordered by! I have tried ORDER BY [forms]![coachingstatus]![dropdown], but that doesn't work! Help...

Well, it almost works... :-) Hi again! Now I've run into a very small but yet important problem, that I've spend some time on trying to fix: The [employeenumber], [firstname] and [lastname] in my query are only showed if the employees have been coached at least once before. I've made a...

Thanks so much Hi there! Sorry I didn't answer you before, but I just took a small vacation. I started my programming just 35 minutes ago, and I tried your suggestion right away... And it works!! You don't know how many hours of blood, swet and tears I've spend on not comming up with a...

You're right Hehe... you're right!!! Thanks again

Didn't work! Hi again! No, that didn't do the trick. Now it opens a box where I can manually enter the date... I think I might be thinking it all wrong. So now I'll tell you what I want and you may come up with an idea :-) I've got two tables: Table - Emplyeedata: [employeenumber]...

You're my heroes :-) Hi guys! Thanks for your replies... And so quickly - WAW! It tried you version suggestion first, Matt - It seemed easier. But I couldn't get it to work (probably did something wrong :-)). Jibbadiah - Your suggestion was the winner :-) Thanks again!

Hi folks! When you fx make a button to open another form, you can choose to open it only containing data where a variable is equal to fx a textbox in the form where the open-form-button is placed. That's what I want my report to do too. But i don't get that option, when I create an...

Still can't get it to work Hi again! Well, I just tried your idea, but I still can't get it to work. The error is allways the same: "You have tried to run a query, that doesn't include the given expression "" as a part of the aggregate function" (my translation from the danish version of...

Okay. Thanks! I will try that! // JR

Thanks! Hi and thanks! In the Danish version of Access that I use the Wizards are called Guides... But wizard -> magic wand... Yeah, should have figured that out!!! Thanks again! // JR

Hi! I'm currently facing a strange problem! When I want to insert a command-button, a drop-down menu etc. no userguides appear anymore. I like to do the most basic work in design-mode, so I kind of miss then a lot... How can I make them come back??? JR

Hi! I'm currently facing a strange problem! When I want to insert a command-button, a drop-down menu etc. no userguides appear anymore. I like to do the most basic work in design-mode, so I kind of miss then a lot... How can I make them come back??? JR

Thanks! Hey thanks so much! You f********* rock! Don't know how much trouble that little line just spared me... :-) // JR

Hey Guys! I have a problem concerning the ability to make a reference to another column in the same query. I have two columns. Column 1 works perfectly, but in column 2 I want the outcome of column1 (coachingdato1) inserted instead of #17-07-2006#. How is that done??? Thanks in advance...

Hi folks! I have a listbox in one of my forms with the following RowSource: SELECT fsVisbetalingsprocent.navn1, fsVisbetalingsprocent.betalingsprocent1, fsVisbetalingsprocent.fradato1 FROM fsVisbetalingsprocent WHERE fsVisbetalingsprocent.sælgernr1=forms.vissælger.sælgernr ORDER BY...

Thanks so much In my desperate search for a solution I tried quite a lot. Putting numerous "s, 's, &s, ()s and []s around the 'month'. But I never thought it would actually take 3 x "s, 1 x & and 1 x &s to get it right :-) But now it both works and I've improved my knowledge on the subject :-)...

Another problem... Hi again! Thank you so much for your reply... It really helped me understand the basic background-knowledge. I've been puzzling with it for a while now and I've encountered two problems: 1: I couldn't make it work without inserting 'DOA' in front of 'database' and...

Hi there! This should be an easy question. The billingperiods are stored in the table 'billingperiod' containing three columns: 'month', 'fromdate' and 'todate'. After update of a textbox called "navn", I want the 'fromdate' of the month 'july' displayed in Tekst18. This is my code: Private...

... why didn't I think of that?? HAHAHA!!! Yeah... You're absolutely right. Why didn't I think of that??? I'm quite new to this stuff. But you've probably allready figured... Thanks so much!