Recent content by Sniperbooya

Hi Arnelgp, Do you know if this is possible for a subreport aswell? Whenever i try to add a pagebreak and use the code it prints the same values across the board. The subreport's page setup is set to Column Layout : Across, then down with a max number of columns set to 20 (originally...

Hmm you know what, that might not be a bad idea. Thanks man, i will have a look at it.

Hi Guys, I have been messing around with some checkboxes the last couple of days and there's one thing I can not get my head around. I have got a popupform (continueous) with a a set of checkboxes and a identifier (in my case labnumber). At this point i select the labnumbers I would...

I think i have figured it out. The width of the columns were setup uncorrectly. Thanks for your time and help though.

Yes, i view both reports (subreport and main report) in print preview.

Hi Everyone, I am currently working on redoing a database i made back in the day (Access 2003 at the time) using Access 2010. I have a report with a sub report, and the sub report is set to 10 columns with the layout set to Across,then down. When i open the subreport itself it seems to work...

Thanks arnelgp. That worked like a charm!.

It has been a while since I did anything with Access and i have been asked to create a new database using Access 2010. At this point i have only got 2 tables; - tbl_Contact - tbl_Laboratory Tbl_Contact contains projectinformation and tbl_Laboratory contains sample information. I...

Well, the cmd.close is for the form that i want to close when the user clicks on OK. I think i have found what the issue is here. As mentioned in my Original post, the form contains checkboxes which gives the user the option to tick 2 of them. Whenever you tick the second box and...

Hi Guys, I have got an append query (Query_AppendTable_Bitumen_Gemiddelde)which adds data into a table. The user selects 2 items from the list. When closing the form the 2 selected items will be added to Table "Bitumen_gemiddelde". When manually running this query (double click) the...

Thanks, ill give it a shot. Only the letters A and B will be used so that wouldnt be a problem. Thanks again.

Good Morning everyone, I have got a question regarding Access' function: LEFT() I have got a record in the query named 'KernelNumber'. Kernelnumber 01A 01B 02A 02B 03A 03B What i would like to do is split the '01' from the 'A' and the 'B' Luckily i remembered there was...

Hi there, I have got a query which gives me the following output; Nr ----------- area ------- area 2 ---------- holler 14-1096-------1------------1-----------------5.9 14-1097-------2------------2-----------------7.8 14-1100-------1------------1-----------------13.4...

Hi guys, I have come across an issue with one of our sheets, which we (apparently) do not use that often, since i did not hear anything about it.. We have got a graph with a little VBA to add additional series to the graph. This works perfectly with Office 2003, but 2010 gives us an...

Hi guys, Thanks for all the replies. I just tried several things (including the codes above) and it still does not fire the code when the value changes. However, when i create a new Excelworksheet the code works perfectly. I am started to think the Excel file i originally used got...