Search results

Hello, I have windows 2008R2 installed with remote desktop where I have an MSaccess application (running under runtime 2013) and each user access the application remotely. the problem is that with Administrator credentials everything is fine but with other users I always have the trust...

Hi all, I know that the below has been discussed in a big number of topics but I am really tired of this situation... I have an access application developed mainly under 2007 with MySQL ODBC connector enabled to connect with remote tables and later on added some features under Access 2013...

Hi, I have a report with basic output on daily basis + a weekly summary. example: Date - Ref - Total - Total 2 01/01/2010 - a - 1 - 2 02/01/2010 - b- 2 - 3 03/01/2010 - c - 3 - 4 04/01/2010 - d - 4 - 4 05/01/2010 - e - 5 - 5 06/01/2010 - f - 6 - 6 07/01/2010 - g - 7 - 7 and in the...

Hi all, I have a table: date | in | out | whouse | wblock I have a simple query with a criteria for wblock that returns all the data sorted by date, I am trying to set a criteria w whouse to sum up the in and out based on date but it is not working example: 01/01/2010 | 12 | 15 | w1 | wb1...

Hello all, I am having a small issue with report and I would appreciate your advices. I have the following fields that I want to sum-up by week (7 days) and not 7 calendar days. Date - Total 1 - Total 2 - Total 3 when I am doing a sum and order by week it is taking the date as a calendar...

Hello, I have 2 tables with exactly the same structure (one full of data and the second empty) and 2 forms also the same, the only difference is that the 2nd has a dropdown with values from a field of Table1 (Full Name). I am using an append query to move record from Table1 to table2 based on...

Hello, I have an inquiry about using dlookup to retrive all fields from a table that are using the same criteria. Here's the table structure Table1: ID (Autonumber) Number Code Grade I have the following data: Number Code Grade 4 15 68 4 52 78...