Search results

well, that is a good tip! I'll try that out. Cheers!

Okay, thanks guys, learned some valuable information. I will treat the old database with care. Merci! ...en groeten vanuit Amersfoort ;)

Hi! I got a small question (once again). I have a fairly complete database which workes just fine. I have some modules that calculates stuff. Now these modules were set up by my predecessor, and she placed in the top of all of these modules: 'Option Compare Database'. As I am not an...

Thanks! Your shorter code is even nicer, I implement it right away :)

Hi! I have a tiny question which I am insecure about. I want to replace the following code: (the code makes a certain table empty) DoCmd.SetWarnings False strSQL = "DELETE FROM TestTable" DoCmd.RunSQL (strSQL) DoCmd.SetWarnings True by the following code: strSQL = "DELETE FROM TestTable"...

Hi, sorry for my late reply (well, it's late where I'm staying at the moment ;) ) You're absolutely right, flexibility is nice, but simplicity at some times even nicer. In my project I have several buttons (more than 2) that have to start processes which differ slightly from each other. So...

Well, yeah, that's true, however now that the main code is placed outside the button itself, you're less depending on it. So, now you could call the module from an e.g. button3 and tell the module you want a 'button1 treatment'. button3 can be a button on another form on a different page in...

Guys, thank you all for your input. I made it work with the solution RCurtin offered!! :) superb! :) Cheers, Willem!

Hi, I am a bit confused here, somehow I cannot see the way how I could do this. I have a form where you can enter several numbers, then you can press on button1 or button2 which both start the same module that processes the entered data. The button1 and button2 calculations are almost same...

Thank you MStef, I figured it out :)

Got it! I was obviously to soon posting my question, I just found the answer here. Just use something like this: MsgBox "line 1" & vbCrLf & "line 2" Piece of cake! :) Cheers, Willem

Hi! Got a small question, I looked on the internet but couldn't trace much info regarding my problem here. Is it possible to display a MsgBox with e.g. three lines of text? So, not: text1 text2 text 3 but: text1 text2 text3 My current code is: MsgBox text1 + text2 + text3 Where text1/2/3...

Then I will conclude this thread with a hurray for the Access-specialists in this forum! Hurray! Hurray! Hurray! Willem

Hmm, thanks, I was confused due to some publications on some other forums where apparantly it WAS possible to do such a thing. Perhaps those where meant in a slight different context (http://msdn2.microsoft.com/en-us/library/ms181765(SQL.90).aspx), I read global through the articles, so...

Thanks anyway Sel! :)

Aah, I can see my you do not understand my problem. I do not want to change colors or whatsoever, I've build a meaningless database that has a table with 'ColorID' and 'Color' and I want to make a query that shows all the ColorID's and when a Color = Green it displays '100' or else '0'. I did...

Hi, for the record, I am trying to build a 'select case' statement in a query in SQL. I think the code you've written is VBA-code. If I want to use 'Dim', Access is giving me an error 'invalid SQL-statement'. Is my problem clearer now?

Hi, I have a query which contains many nested IIF-statements. Due to that, my database is running terribly slow. I want to use a 'SELECT CASE' statement because I think this would be faster. In order to get used to the SELECT CASE-thing I created a new database and I implemented a query with...

Thanks Neil! My code works now! 1) I'm aware of the reserved words, however, I am using an English version of Access, so I can use the Dutch words without any problems (which is quite nice actually) 2) thanks for this! I assumed the Query could be partial based on itself, a bit like how you...

Thanks for your reply, my current code is: Datum: DateSerial([QueryTotal]![Jaar];[QueryTotal]![Maand];1) ('Jaar' and 'Maand' are Dutch words for year and month) However, when I let the query run, I get the same error, Access wants me to enter a paramater-value for the year (and probably also...