Search results

You are right bob, but you know this database was created in Access 98 or may be may be 2000, this was used for years as a not splited database in one organization, till 2008 it reach its records to 200000 + and was used on large skill. then they asked me to work on it and to enhance the...

You mean you just want to print all the reports in one goal? if you design all the reports each for separate purpose then it should be printed separately, however you can print all the report check by through VBA code: Private Sub cmdPrint_Click() If Me.Check0.Value = 1 Then...

I have problem with the Access 2010, on 64 bit machine... the wonderful thing is that, when you compact and repair database, the Autonumber key got disorder. for example: before compact & repair: Autonumber key Field: 1 2 3 4 5 . . . 100 After compact and Repair: Autonumber key field: 1 2 3...

What code you are using to print the chosen reports? What reports do you want to print? May be you want to make a criteria based on the check boxes checked and then make a query for a single report to print....

As explained by BOB, actually you should aware of RDBMS (Relational Database Management System) google for it, where your Primary Key (PK) in your table should be connected to your other table as a Foreign Key (FK). This call normalization of the tables also, Which mean you can break your...

Another solution is: get all the data to any excel file and apply * delimitation in the excel sheet to break each row in the columns , after that import the file to your access database with the clear data.

Good idea SpentGeezer, I have my database based on contractual records, I have segregated my users to work only in their relative contracts. The OP should create a users list first and record their login entries in a UserLog table while login to the application, so whenever any user log...

Welcome to AWF, Yes it is possible to have multi subforms in a Master form. please have a look at my this post: http://www.access-programmers.co.uk/forums/showthread.php?p=944196#post944196

For Refrences: Check Tools>>>Refrences... in VBA code window menu. find for missing references. but before that you should Compile your application there would be something missing in your codes.

Did you debug compile your application? Menu>>>>Debug>>>>Compile application_name (in VBA code window)

The magician has done it overnight :p

waiting for 9 more... :)

A good reason is that I love the database no to be splited in parts.;) I believe UNITY is strength :p --- ke ke ke ---

Dear CBrighton! The idea which you use for checking the external file i used before, but then I realise that why I should not use a BIT in my table where aplication will check it and no worry for external file..... The second part---- I have more then 50 users working on different...

I use a table with a Logout all user bit in my Back-end database, I have a front end Administration panel from where I can control all my users whose online to which application. (3 front end applications attached with the two different databases) I can kick-out all or specific user from my...

Welcome to AWF! your question is not clear, you mean a subform on the tab? if you have a master form and child (subform) on a tab, it will not populate untill you give a criteria in the master form, so the tab will be empty with the subform-datasheet.

I always use me.requery instead of me.refresh to update my lists and subforms.

It's very difficult to re-connect the password protected database without the source code. you have to consult with the application developer (originator) to give you the source code and re-connect it with password protected database along with the password in the connection string.

very chalooo buddy :D

what’s this? Its sing for Victory or some dancing symbols?:p