Search results

Perfect, is it possible to set function to other objects such as Combobox, Subform's fields ?

Thank you all for your advice. I agree with Pat, mostly there is not any orphan table in a database. all tables are related to at least on table in my database and not to all other tables. Given that there is not any data in the database so as The-doc-man mentioned I should move the database to...

All tables are related together, 1 to 2, 2 to 3-4-5, 4 to 6-7.

Ok, you're right, RI can be done only in one database. But I have to use tow backend databases and the child must be updated when parent table (Customer) is edited. What should I do ?

Hello everyone, For limitaion of access database which is 2 Gb, I splited backed database to two backend, but relationships between them has gone and Cascade option are disables. I also know I can use SQLServer databse instead of Access database, but for some reasons I have to perform it by...

It was useful, Thank you so much for spending time on my project.

Could you please attach an example from Class ?

Hello everyone, I've added a small code to OnKeyPress event of a Textbox and it works correct, but I need to assign it on all forms and all Textboxes of my program : Private Sub txtCustomer_KeyPress(KeyAscii As Integer) If KeyAscii = 1740 Then KeyAscii = 1610 End If End Sub I can put it on...

I did it, but nothing happend. The first record of the sufrom is still focused. (the datasheet is as a subform on main form and I created a textbox on the main form and make focuse on the textbox.) Could you please attach a sample .accdb if you've done it ?

Hi all, As you know the first row of datasheet is always focused and highlighted as default when we open a form, I'm trying to find a way to deselect the first row . Do you think it's possible ?

Hello all, Yesterday, I was working on my two MS Access projects and my system (windows 10) was crashed and restarted suddenly. After running system, the two Accdb files give this error : "Unrecognized database format ........." I also tried some recovery access database tools and I didn't...

Hi all, I'm using a continous subform on the main form and the scrolbar of the subform is full while there are some records (15 records) in it : Of course, the problem is solved after changing the scroll bar manually, it is just annoying on load of the form. Can someone tell me how I can...

Thank you for spending your time on my file, No I don't need the recovered data, I'm looking for "tbl_scala", It seems the table is not possible to recovery. Thanks to everyone for trying and spending time.

Yes sure, https://www.dropbox.com/s/4qvkbceum3zyzwn/MyDatabase.accde?dl=0 I need only "tbl_scala", if you extract my table plz send it in private.

Yes of coures, I have the original ACCDB, but it is empty, I mean there is not any data in the tables of the ACCDB !! my data is in ACCDE. I haven't used any hidden tables in my file, actually I don't know anything about hidden tables. I just made a simple forms and tables in access and compiled...

The file was 2.5 Megabyte before failure and now is 1.16 Megabyte (after failure) Actually I don't need to restore all of the objects (query, forms or data) , I only need a table that is stored my customers information.

Thank you for replying and helping, but I couldn't use the System Tables guidance. I think my case is error and not deep hidden.

What's commercial file extension ?

Thank you arnelgp, I forgot to mention that my file is ACCDE. I did your recommendations anyway and now the file has two errors after "compact and repair." :

Hello everyone, I have an access file with some forms and tables in it, I was entring data for monthes until it fialed some days ago and no forms and tables comes up. it only shows a table which its name is "MSysCompactError" and it contains some erros : What exactly should I do ...