Recent content by opopanax666

🙄 No, they were not... Changed it to an IIF-function, and now it works as intended. Thank you for the speedy response!

hi everybody, I have a column "EndDate" with some dates filled in, and some null values. I want to create a new column with the filled-in date-values, and the null-values need to be 31/12/2999. So i tried EndDate2: Nz([EndDate];#31/12/2999#) but no go, null-fields stay empty. What did i miss?..

Guys, i'm sooooooo sorry, and i'm such a dumb*ss. I was looking at the wrong piece of code, that's activated by an other set of buttons, and when activated by these buttons, it works as intended... So, no problems, everything OK :o Thanks for looking into it, and again, so sorry for wasting...

[SOLVED] help with recordset "Fields" Hi everyone, not familiar with the "Fields" attribute (I think that's the problem), so asking the experts :) Excerpt: Select Case intDAG Case 1 strDAG = "MAA" Case 2 strDAG = "DIN" Case 3...

After some tinkering got it to work. Apparently when switching from "acViewPreview" to "acNormal", the criteria are not forwarded anymore to the "OutputTo", and that screwed everything up. Got this code to work as intended: DoCmd.OpenReport "rptMagazijnbon", acNormal, , MyFilter, acHidden...

Sorry, hit the wrong button 8) So, the above code works, but still shows the preview. So I would need to use "acNormal" & "acHidden" but then the "OutputTo" is not filtered... How can I get this to work? TIA, James

[SOLVED] Print and save hidden report with dynamic filter Hi everyone, I need to generate a report with a dynamic filter, print the report without preview, and save the report as .pdf. The following code works, but doesn't do all of the above: DoCmd.OpenReport "rptMagazijnbon"...

I was planning on rewriting the whole thing this year, so I'll definitely have a look at your advice. Cheers! Problem is, that when running alone it works perfectly. What I am going to do, following your idea, is to create a new table, and hope this stops the problem from occurring. The lock...

Hey guys & gals, Been running an Access front-end on 3 computers with linked tables to a SQL-Server instance for about 4 years now (remember this!). Once in a while, I would get a 3155 error for a couple of hours, and then it would magically go away (e.g. 09/11/14 from 12:38 to 15:33, 04/17/14...

God, no wonder I had no clue! :D I'm gonna try this, and I'll keep you posted... Edit: Yes, works like a charm. Thanks both of you!

Yes, it has an "id", but how does the listbox return it? I.e. what vba-code do I use to return the id of the selected item? I planned on using an update-query, but have no clue how to "get" the record on which to run the update-query (see quote above)...

(solved) Use listboxes to organize records Hello everyone, I have a form with 2 listboxes: 1 to show the name of the products having a code "v" (recordsource query), 1 to show the name of the products having a code "a". 2 arrowed buttons (left-right) would make a product "jump" from one to...

Yep, this did it, works as intended!

This would only be a problem if the date was stored as a string, but it isn't, it's stored as a "date". If I only put a date in the criteria (so no time part), Access (and SQL) only checks the date part. Works this way in several of my other databases, nothing impossible here...

I tried some stuff in a test db, and it seems the problem comes from the fact that I need the time part of the "Now()". If I use the variable dteDATUM without delimiters in a sql-string, it's going to throw an error (because there's a space between date and time). If I use string delimiters ( '...