Search results

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

you are right one record is one row. just to clarify further: Table1: ID, FullName, Address, Mobile, Desc, Note1, Note2 Table2 (Same fields): ID, FullName, Address, Mobile, Desc, Note1, Note2 Form1: a form for Table1 entries Form2: form with Table2 entries and 1 dropdown with FullName Values...

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

thank you :)

Because the first table contain the default values and the 2nd table have each User with the given values, I query the values based on the Number criteria from the 1st table and store them in the users table (rather then manually input them)... Do you have an alternative method?

INSERT INTO Table2 ( Code, Grade, User ) SELECT Table1.Code, Table1.Grade, [Forms]![frmTest]![User] AS Expr1 FROM Table1, Table2 WHERE (((Table1.Number)=[Forms]![frmTest]![Number]));