Recent content by AccessNewbie2007

the AddPath application did the job, I noticed that it is storing the values under HKEY_USERS and it is working perfectly. Thanks a lot :) so now for each user, I am running the AddPath... I have another question if you don't mind, my application uses the MySQL ODBC, when logged in as...

Thank you for the reply, actually I tried to add the registry key, I don't know if my procedure is correct but for example let's say I logged in with "user1" when I try to open the registry it requires admin credentials so I use the appropriate credentials and do the reg addition... but the...

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

but as you know supplying accdb is not safe because you are simply giving access over everything (forms, modules...) , that's why I compile an ACCDE

If I eliminate the 64bit option by mentioning to the clients that only 32bit is supported. and I do the compilation under Win7 SP1 with Office 32bit with the lower Access version which is in my case 2007, how can I guarantee that it will work on other PCs?

Thank you for the reply, but PC2 and PC4 have the same specs both are running under 64bit (Win 7) and 32 bit of MsAccess 2007... honestly it is not always possible to manage to compile it on the user PC because I sometimes issue an update for the frontend so it is really a headache to manage...

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

I found it and it is working properly and I would like to share it :) details at: http://support.microsoft.com/kb/290136 Method 2

any help pls

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

thanks, it was called 'date' so I replace it and I used Format(yourdate, "YYYY-MM-DD") and it is working fine :) thanks

that's what I did but it is not merging the date

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

I am just selecting few records to be kept separately. concerning the filter I tried to make a filter but it is not working properly