Search results

That was my question. Will the linked tables be permanent ? I don't want to have to go set up the connection through control panel on every user's machine like I did with the previous app.

Hi everyone, I used the control panel to set the odbc and link my application to a MYSQL database and it work well. Now I'm about to create another application and want to make the linking through VBA. My question is when do I create the connection ? I guess it should be at the launch of the...

Not at all. I'll just try again and see.

Hi. Some forms did not open with the ACCDE version and the same forms normally opened with the ACCDB version. The same application. I forgot the error message. I didn't have time to deal with it at the time and just decided not to do an ACCDE version. I'll try again.

@theDBguy accde is a good way but some of my vba codes didn't worked work with that version. Maybe I should give it another chance and try to fix what's wrong. @isladogs thanks for the link. I going right away to read it.

By table, I mean some locals tables I made to perform some things. The back-end with real data is on a MySql DB I created. The potential intruder are some IT whose are interested in the application. I will offer them two option : buy the application without being able to modify the structure or...

Hello, I've created a relatively great application. For protection, I disabled pretty much anything : menu, nav, right click... So the users can only use the application through form. I've also disable the shift key to avoid bypass at start. Unfortunately an access application can be bypass even...

Your code helped me get it done. But what is really wonderful is that it send me to learn about manipulating recordsets in VBA, which is really powerful and helpful. Thanks a lot.

Thank you for the code. I'll try it.

so, the source of the report will be the same source as my continuous form but filtered by me.reference. and I will remove the where clause here hope I'll get it done

I think I understand what you mean. I'm going to try

The report and the pdf are fine, Now, I need it to work on each row in a continuous form, so the user doesn't have to click on each row to output them

hi, I think it's already done with this line in the code

Hi guys, I have a form and a button with a code to output a report. It works great. Now I need to print that report for many record. I built a continuous form wich display those records. Also I have a control box in each record where the user can enter data (references). What I want to achieve...

Hi, I did like you said theDBguy, a Binary data type. After some deep research on MySql as backend, I chose to create a blob field to save those pdf files into.

Hi, Just to close the thread. I choosen missinglinq's code because it is smaller and easy to understand. I even edit it a little. Thank you all.

Hi, I was trying to do something like that. Your code helped me a lot. Thanks.

The great thing here is that you guys always have a solution for problems. Thank you all guys.

I was talking about something like : 1-20-05 or 9864-06-19 or 345-13-54. Thanks to missinglinq for the code. I didn't use it yet (busy Sunday) but I have no doubt that it will work. 🙏🏾

theDBguy Yes I thought about it. But I didn't succeed to have exactly what I wanted. plog Yes I know about the numeric type but numeric type but I got nothing with it. missinglinq The format : some numbers (can go from one to five) before the sign, then 2 numbers, the sign again, and 2...