Search results

that is it, thanks 🙏

a follow up question, why the textbox has a white space after it? Thanks

Thank you guys it is working. first, it wasn't the name I tried others but didn't work. @arnelgp your code worked as it is, and really is no need for the cn even I forget to pass it to the rs.open. and after playing with your code I found out that the issue was lock type, I didn't have to...

Hi guys, I am trying to create an in-memory ADO recordset and bind it to a form, while I am able to create and bind the recordset to the form, the textbox will not bind with the recordset field. Is this possible at all or I am doing something wrong? Dim cn As ADODB.Connection Dim rs As...

Thank you Doc, those books will gather all the concepts in brief form and this is what am looking for.

This is the problem, there is a lot of material and topics that exist and this is what confused me. I am looking for something not going into much detail that an IT/Programmer can use as a reference.

Hi Guys, I hope you are having a nice day, I am looking for advice, and what better place to look for advice than the AccessWorld great community. I like to hear your suggestions on a book about cryptography, practical cryptography. a book covering day-to-day use cases in the IT domain with...

I noticed if I open one, the extension of the lock file is .laccdb The user FE (there is admin FE) doesn't have a C&R most likely the issue is that multiple users have the same FE. I will make a copy of FE for each user and disable C&R and see if I still have them.

No, it exists in a normal folder. Yes, multiple users working on the same FE 🫣, and this setup like this for almost two years. I know I have to separate them There is a couple of admin FE exist but the majority is the user FE and this confirms it.

Actually yes, I have a separate FE that I am using to update some tables periodically and it's configured with C&R.

Hi guys, Do you have an idea why my backend has those .mdb files? The app is a multi-user two tears (Front and back) application and shared using windows remote services (both FE BE on the same device) BE and FE are created by Access 365, using Access Runtime for production on a windows server.

Thank you for this info, I had a problem with access in regards to separating dependency this is very helpful.

The way to access data (or pass data to VBA) is to use recordsets. it's the way VBA is designed to work with data but it's a bit unnecessarily complicated for non programmers. For me, I am using the DAO (Data Access Object) model, other may use ADO (ActiveX Data Object). An example in order...

Programming an inventory management system isn't an easy task, especially if it's integrated with warehouse management or a full document cycle (sales/purchase). but if you need a stand-alone and simple inventory system you can look into the Access Northwind database, you need may need to do...

side note: I hate this issue with access that you can't generate controls at runtime.

I want to make it clear, that I don't recommend the use of any versioning system. Access is very tied together and you can't apply the separation of concerns principle to allow multiple developers to work on the same app.

I give it a thought a while ago, I think there is two way you can do it. first, you can put the whole front end in the VMS (version management system), but in this case, I can't see the benefit as you can't use the system features like comparing two versions of codes, etc. the second option, you...

actually, I am kicking the user out when running the script as a safety precaution (it's not a big deal to stop users for 30 sec but manually it takes more than an hour to update). but for the sake of the argument, I am deploying the changes in one big transaction. should this lock all that...

PS. Actually, also I found it neater to deploy changes this way because I am making a lot of changes in the test environment DB and it's easier to run the script than remembering what I changed when deploying.

Because the DB is on a server using Access RunTime, any update to the DB I am trying to use SQL and DAO when I can (I do not copy the DB to another PC to not interrupt the users).