Search results

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?..

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

[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"...

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

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

(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 " &...

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

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

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

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

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

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

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

Hi guys & gals, Let's say I've got a table with factories, and a table with products. Several of the factories make several of the products, so M:M. BUT, some of the products of one factory are resources to an other factory, and since I want to show (in a form) what each factory needs and what...

Hi guys & gals, First off, I'm pretty good with Excel, but a total newbie to Access. I believe in steep learning curves, so to get to grips with Access, I'm trying to understand the logic behind a M2M database. But I simply can't seem to work out what's involved :( . Let's paint the picture : I...