Search results

  1. D

    strange behavior in mixed environment

    Hi, I ran into this problem and it puzzles me a lot. I created a split database with 15 users on 5 different computers. All of them had Access 2003 and it ran without any problem for like two years. The other day our IT guys upgraded Access to 2007 on my computer. Now, if I use the database...
  2. D

    chart on a form

    Hi all ! I have a query that pulls all the data about a customer and a form that is based on that query to display that data. Part of it are visits that this particular customer made each month. Is it possible to display that data on a form as a chart (visits/month)? Attached is the picture of...
  3. D

    valid price inside date range

    Hi guys, It may be extremely simple, but I'm stuck here. I have a table with prices for two products that were valid from one date to another or are still valid ( picture will explain it all ). How can I get the prices that were valid between dates in textbox1 and textbox2? Desired output from...
  4. D

    query criteria from active form

    Hi guys, I have a form that displays information in a subform (manufacturer, serial number and inventory number) about slot machines that I need to repair. When I double-click on a machine, another form comes up, based on the manufacturer. I use those forms to input the counters for that slot...
  5. D

    update query updates first record in a table

    Hi, I have a problem with an update query. I have a table with a list of errors tbl_Prijave, where a user enters what is wrong with a slot machine, one field (Popravljeno) is set to "false" to indicate that it isn't fixed yet. There is a form with a checkbox where a user indicates that that...
  6. D

    getting average value of purchases beetwen two dates

    Hi all, I have a problem with a query. I have two tables, the first with customer ID's and contact data and related table with purchases for each customer. The second table has customer ID, date of purchase and amount.What I try to do is to display all the customers within given date range...
Top Bottom