Search results

  1. S

    set checkbox to true with 10 at a time

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

    Adding a subreport with columns set to 10 (Across, then down)

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

    Use a form to add samples to 1 project

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

    Append Query not working correctly when opening it through VBA

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

    Function LEFT

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

    SUM of fieldname holler when fieldname area has the same value

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

    Excel SeriesCollection 2003 vs 2010

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

    Workbook_SheetChange(ByVal Target As Range) event suddenly not working?

    Hi guys, Last week a friend of mine asked me to write a little code to change the font color of a certain range when the conditions of that certain cell are met. So i wrote him the following code and everything was working fine: Private Sub Workbook_SheetChange(ByVal Target As Range) Dim c...
Back
Top Bottom