Search results

Thanks a ton sneburg, it worked !!!!

Hello I would like to generate a chart on word document from access, following is mine environement. OS : windows 10/64 bit ms office 2010/32 bit Now following is code on my access form button just for testing I am playing with the code and seeing how it would looks like when actual...

Hello I would like to generate word report which would have plent of paragraph and around 40 -50 page of word document in that some data would be reference from access. Now my questions is that all the word report content are tend to change in future, so I would like to have whole report as...

Hello For example I have below two rows as below Name==> Token Number ==> part 1 ==> Part 2 ==> Part 3 row1->test1 ==> 123434343 ==> 60% ==> 90%==> 30% row2->test 2==> tttt ==> 40%==>40%==> 40 row3->test 3 ==> 123434343 ==> 50%==>32%==>43% here rows number 1 and 3 are same... so I would...

How come MainID as FK, one record in main table should relate to one record in user table is not it ?

I will explain you the situation as below. We would like to have a database in such a way that each user should be able to his/her record only super user can edit all records. I have table with 16 users in excel with details below information. First Name => Last Name=> Emaild ID==> Address...

You please dont worry about Importing and how it is done that is working pefectly. My concern is that everyuser which is being imported should have uSerID and passowrd so they can login into the system and thats why I would like to have usertable which would eventually will hold all first name...

I would like to have Login screen wherein user would be login with UserID and password from usertable but whenever data is being populated from excel to main table the same record should be created with first name and last name in the user table as well so eventually admin will only created...

Hello I have below two tables Main table: ID(PK,autonumber) => First Name => Last Name=> Emaild ID==> Address ==> Usertable : ID (PK, autonumber) => FIrst Name ==> Last Name=> User ID => Password=> Role=> Now my query is that when data is being imported into Main Table it should import data...

Hello I would like to generate 50 pages paragraphs report from access data and that too with spider chart or any other charts and then export the chart into PDF or word document. Is that doable ? thanks for adivce and any possible solution you can share Thanks

Hello I would like to access my client system sometime using remote system to solve their problem where they have access databases. My question is that is there any software which should allow me to access remote system without asking permission everytime ? TV is not a best solution, please...

Hello I have two sets of users supers user and user supers users are with admin defined in the master table with password as "admin" and normal users are defined as "users" in master table. Now what I would like to do is when database opens I dont want normal users click anywhere except modal...

Thanks CJ IT IS JUST current user or environ(currentuser) in field criteria.

Thanks but how to put this parameter in query designer I am not referring sql query here.

hello there, I would like to have query with criteria which should take input parameters/criteria from enviorment variable for example environ(username). Is that possible ? so what would be the statement for that. Thanks

Thanks Gizmo, I know how login works and all what I want is that I want my own record to be editable/updatable my only, only supper users can update/edit all records.

Hello I would like to create one database, where in at first place I would import 16 users with different data into one of the table and then I would like to create a login screen wherein user would be prompt to login with available users from drop down and password which would store in another...

Hello I have deployed the access db on shared drive, having all five users shortcut on their desktop, but when users modify/add/delete the data it is not visible to other users. Please note that they are not doing these actions at a time. Please let me know what is missing what should I have...

Hi I have below report rows in table and I would like to show them as one record Name --> Product Id --> Sub ID --> Product Invoice Number D1 --> 3209 ----> 21--> AE5 D1 --> 3209 ----> 21 --> AE6 Can I show this as below D1 --> 3209 --> 21 --> AE5, AE6 since Invoice Number...

Hello I would like to have twisties on column on the report which would sort the given column at anytime. I dont want the way we do it on grouping and sorting which is predeifined by our program, but need dynamic way and I should be able to sort any columns at any given time. Thanks