Search results

Sorry, earlier miss out on my code Private Sub btnsearch_Click() Dim strText As String Dim rst As DAO.Recordset Dim strSQL As String strSQL = "SELECT * FROM SearchStudent " strText = "1 " If Not IsNull(Me.[Name]) Then strText = strText & " AND [Name] like '*" &...

Hi, I have a search form with a subform. My search input is at the top while my result will show at the subform. However, most of my search works except for 1 or 2 records will always not found in the search. The information were in my table just now found when search. Any expert can guide me on...

Thank you for the advice

Thanks for the clarification. Appreciate it much

Thanks expert. I will try to work around with this and try using third party tools to try as well. Main thing is we have a dedicated PC for this Access file so all of my staff will use this PC to access the data. To make any changes, I will also made from that PC.

Sorry, what I meant was I added auto datetime (i set as not visible) and I recreate my backend. But I did not recreate the accde so my backend did not save the datetime

Hi, can correct me if I am wrong, I used the steps from "Remove ribbon menu items". If I used this, does that means I don't have to set password to my VBA code and encrypt my file since there is no way to view the vba code etc? Though I know that it is still advisable to do.

Alright, thanks for the quick reply. Now I know why it cant save my data. 😀

Hi, I got one question. If I made changes to my front end, do I need to create a new accde file? Or it will auto sync with the front end?

To update, i tried the method that @theDBguy suggested on my company main file and it is working. I still cannot figure out why it was corrupted. Thanks all experts for your tips for me to resolve this error. 😀

I only added new forms (navigation tab) for different department user and split the database. Initially, the form allowed all department to access the database and the database is not split.

I took over from my company database manager and he has been using MS Office 365. I also used MS Office 365. Is after I added in my company new requirement then it have this issue.

It seems to work on my end as well for my sample file. Shall test it on my main file tomorrow and update again. Thanks

How should I resolve it? I have already relinked. Have stuck in this for the past week.

I have attached my FE and BE file. The password to unlock VBA and BE is 123 One of the account login username and password is admin Anyone know where is the issue?

I tried relink and still the same

I enter the code using the login form to access the database.

Hi, I split my database. I set a password to my VBA and encrypt my backend access file. After which, when I tried to do a login from my frontend file, it shows me this error. Anyone can assist me. There is no such issue before I did set any password Run-time error '3031': Not a valid password

Thanks. It is very informative and I am still digesting with the info.

Ok thanks. Will see if my company want explore to SQL