Search results

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 ( '...

"dteDatum" is filled in the code by "Now()", that's it, nothing else. Result of debug: 02-jun-2014 02-jun-2014 SELECT * FROM tblGEPRODUCEERD2 WHERE Weging_datum = #06/02/2014#

Yes, tried the second method, and get an error-3075; It's not a different table, variable "strTabel" contains "tblGeproduceerd2"; The manual queries were only created to check whether it was a "locale"-problem (so US date against international date); I absolutely need the time part, date-part...

Thanks for the quick reply... but now I get an error-3075 when setting this recordset

(solved) VBA date problem (American <-> local) Hi everyone, I work in Belgium (date format dd/mm/yyyy). I have a JET table with a date field (format date/time) I use this code to get the date and write it to the table: Set dbs = CurrentDb Set rst = dbs.OpenRecordset("SELECT * FROM " &...

Holy Tangent Thinking, Batman... Thank you so much, Paul! Does exactly what I was looking for, not difficult to take it from here...

[SOLVED] Display random image from folder (i.e. not embedded) Hello everyone, I'm working on a database for my holiday pictures. The pictures are organized in folders per trip/date/location. When viewing the data of a particular trip, I want the form to display a random image from the...

Absolutely right... Thanks!