Search results

Thanks a lot every body for taking your time to reply and try to help. Thanks again.

Thanks a lot for the suggestion and also for the offer to fix the db. Fortunately, this db was quite new and data was present only in 4 tables that were not affected by C&R (fortunately) and I exported these 4 tables into new BE with other tables in place already and now C&R do not affect this...

I checked the query and there is no table with type =6. However hidden tables have flag value -2147483648 and there type is 1 (not 6). The tables that were not hidden by C&R have flag 0.

Thanks all for replying and sorry for delayed response to your queries. When I open the file (BE file with only tables, no code form or query) before C&R, it shows all the table and after C&R tables are hidden with no option to get unhide or even open the table. No, I didn't use db hidden in my...

Hello, I have a backend of an access split database which is giving me this issue. When I use compact and repair on this file, a lot of (almost 80 - 90%) tables got disappeared. Initially I though that these are deleted but when I turned hidden and system items on, those are hidden with hidden...

@Gasman thanks for reply. I didn't try resetting the seed value. I use looping through recordset method now as suggested by @June7 to achieve the purpose. Thanks all for reply and suggestions.

That is right but how could a user run compact and repair of encrypted backend every time he undo a form.

That is exactly what happened when I tried to replicate and fix the issue in another table. I'll use recordset method for this purpose. I am using function to undo subforms which copies the whole recordsource table on form load and when user click undo button, put back the copied table. Now if...

Yes, it is PK indexed with no dups. I removed the autonumber and used another function to get unique next available number. It didn't give any issue (atleast not until today if source of failed query is this PK field).

Fields are number but while seeing the properties, I noticed that PK field is a number too (not autonumber, I changed it to number to get rid of some other error few months back) and I guess it is being left blank while Inserting the records and and that's why insertion of records is not...

Thanks everybody for reply. @theDBguy, No ClassID is not PK of the table. I cannot add studentID into where claus because sole purpose of this query is to promote students into new class no matter who the student is (provided he passed the exam) in a specific class. Values are pulled...

Hello, I'm trying to use following query to insert records in the same table with different ClassID but it's giving error similar to "xx records fail due to Validation rule". Can someone please see where I'm doing wrong? INSERT INTO tblStudentClass ( ClassID, StudentID ) SELECT...

@arnelgp thanks for this universal code to set property. I've bookmarked it and will be using it in the future instead of the function I shared in post# 10 (which I posted before seeing SetProperty part of your code.

Hi, I hope @arnelgp sample db have solved your issue. Attached is an alternate approach that I usually follow for enabling and disabling AllowBypassKey property. I disable it on the OnLoad event of some Main form (frmMain in attached db) which is set to auto open on opening the database using...

Hi, Have you tried following code befoe running your code to set the AllowBypassKey property. This property doesn't exist in a database by default. You need to create and spend it to db properties. Just put the following code in a standard module and press F5 while your cursor is inside the...

Thanks @theDBguy

PMJI, does this code handle password protected backends too?

Thanks for reply @arnelgp. I want to switch keyboard layout while entering specific textboxes. As per @MajP suggestion, I used =function () in OnEnter Event property. Thanks again for everyone who put their input for helping. I'm obliged. My issue is solved now. Best Regards Abdullah

Thanks for reply @The_Doc_Man. I couldn't, due to my little knowledge of programming, understand how this will handle/run same code or function on multiple controls on the form. Thanks for reply @Ranman256. Right now I am away from PC, I will check this method. I don't have to apply the...

Hello, I'm trying to trap OnEnter event of multiple textboxes on a form and run the same code. The same will be applied to number of other forms. So I tried to write my own class to achieve the purpose and tried few other methods but none was successful. While searching across the internet, I...