Search results

[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!

Hi everyone, I have a main, a subform and a optiongroup on the subform. The subform-container is called "SubFrm", and is initially loaded with "frmTransportmiddel". When a button in the optiongroup is pressed, the container needs to load another form ("frmProductgroep"). The code: Private Sub...

Chris, cheers mate, and thanks to everyone else!

Okay, had a look around, and got this code working: Private Sub optgrpHOOFD_AfterUpdate() Dim rst As Object Dim dbs As Database Dim RecFil As Integer Dim strSQL As String Dim nCount As Integer Dim Counter As Integer Dim strButton As String Dim cCont As Control...

First off, thanks for the replies! I realize this is a very contrived way to approach the problem, but I have no experience whatsoever with recordsets, so I had to scrape together what I could find :o Do any of you know of examples of looping through a recordset (I'll do a search myself, of course)?

I have no experience with Treeview whatsoever, but I'll have a look at it this weekend. Although I believe that for the people working here, this setup would look and feel a bit weird. Understand that we are a non-profit, employing people who, for whatever reason, can't find a job in regular...

SOLVED: Dynamically created buttons Hi everyone, I am staring myself blind on a problem, I think, so maybe if I explain what I need, someone could give a fresh view on things. - This form will be used for stockroom-employees to quickly input what product they just weighed by clicking a few...

As I said: ridiculous... Yes, that did the trick and everything works fine now :D Thanks a million!

[solved] Absolutely ridiculous problem (kinda)... Hello everybody, Got a form with a textbox ("Tekst110") (default value 0), and 1 button on each side, resp. labelled "+" and "-" (you see where I'm going with this, dontcha). So when users press the left button ("Knop114"), the textbox value...

Thanks for the quick reply. The problem with templates (even Northwind) are that they are based on normal procedures in shops/stockrooms, and thus are based on "amounts" of a certain product. If that were the case in our company, I could look at it as they do in accounting, and create a...

Hi everyone, Difficult to find an appropriate title for this one :( Here it goes: I have a table containing all our produced goods. Since we are a recycling business, no two products are the same, so they all have a unique code, included in the "Produced" table. I have a table "Stores", which...

Hi everyone, Situation: I have a main form (see attachment) based on "tblOrders" with a continuous subform showing our products and their stock, and an unbound control to input the amount ordered. This subform is based on a series of queries that calculate the stock of every product, dependant...

Stupid, stupid, stupid :o Sorry guys, forgot about the "joins" in a query. When I set this correctly, I get what I need... Stupid, stupid, stupid, stupid,... :o

Hi everybody, I guess the problem will take longer to explain than the solution: Setting: I have a table listing all our products (tblProducten) and their default amount per package. For most this is "1", but some are "16" in a package... This table is linked to a table listing our production...

Of course. While looking for examples, I came across one that said that trying to close an already closed rs would give an "error 3420". I just didn't notice the ".Close"... Thank you for the quick response!

Cried victory too soon... When I press the button, the code copies the fields from the first record, and then gives an "error 3420: Object Invalid or no longer set", and stops at ".AddNew". I did a search on the net, but couldn't find an example for this specific case, and my knowledge of DAO...

Thank you very much. It's weird, because this is an example given somewhere in a forum, and it supposedly worked (to copy all records)...

Hi everybody, can someone spot why only the fields from the first record in "qryBestellingen_nieuw" are copied when I click the button, although it contains about a dozen records with "Status" = 1 :confused: Private Sub Knop21_Click() Dim db As Database Dim rs As DAO.Recordset Dim rs2 As...

Or is it this one?