Search results

Hello, I have this code 'code.... Dim tdf As DAO.TableDef Dim fld Set fld = New DAO.field sql = "select * from t_import_agence" Set rst = CurrentDb.OpenRecordset(sql) Set tdf = CurrentDb.TableDefs("t_import_agence") If Not rst.EOF Then...

Hello everyone, I have a weird issue with my app. I use only popup forms, one main and some secondary ones. But sometimes they get cut off on the right edge. I don’t know why this happens. For example, original form: Shrinked: Sometimes it doesn't even care about the buttons and eat a bit...

Hi everyone, I put one of my codes in Bing Chat and asked him to help me refactor it. It did, but in the end, instead of throwing my Error Handler as it was, it did it like this: Form_Load_Error: ShowErrorMessage "Form_Load", Erl End Sub Public Sub ShowErrorMessage(ByVal strProcedureName...

Hi everyone, I found this function here. Option Compare Database Option Explicit Private Type FourBytes A As Byte B As Byte C As Byte D As Byte End Type Private Type OneLong L As Long End Type Function DecToHex5(ByVal H1 As Long, ByVal H2 As Long, ByVal H3 As Long, ByVal H4 As...

Hi, I have this code to upload files to a server. Option Compare Database Option Explicit Option Private Module '------------------- 'API Declaration '------------------- Private Declare Function InternetCloseHandle Lib "wininet.dll" _ (ByVal hInet As Long) As Integer Private Declare...

Hello everyone, I have a few access apps for my users, but all those apps open in just one icon in the taskbar. Is there a way to have one separate icon for each one of my applications ? Thanks.

Hi guys, I'm creating an access+mysql app and everything is fine except one part. The app will upload/download files to/from a ftp server. The problem is that those files can weigh up to 10mo. Bandwidth is really not good around here and in a previous app that I built, downloading files was...

Hi everyone, I have and excel file attached and I want to open that file directly from vba without saving it first. So, after the file has been filled, I set it visible to the user whom can decide to save it later. I'm using late bidind and know how to open and manipulate file but never did it...

Hello everyone, I need to increase the line spacing in one the textbox in my report. I've already increase the font size but the line between text are still too small. It would be great if someone can give me a workaround. I'm on it for few hours now and haven't found anyting on this.

Hi, I have a form with many buttons. I need the labels of those buttons to be align on the left so I have this code on the load event : btn_1.Alignment = 1 btn_2.Alignment = 1 btn_3.Alignment = 1 and so on... How can I loop through those buttons to set this one time and for all. I don't want...

Hi everyone, I hope y'all doing great. I'm starting a ms access apps with MySql as BE. It will be over the internet. Now I don't have problems with open an ADO Connection or a Recordset. What I need to do is to create a module to establish the connection at the start, so I'll not have to repeat...

Hi, I've create a relatively small application with Access 2013 and MYSQL. The BE is on a local server and everything works just fine for all the users. Now I need to move this app to a distant server (an online hoster). It has 10 tables (the largest as like 20 columns), 25 views and all rows...

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...

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...

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...

Hello everyone, I have a text box where I would like to restrict the entry to numbers AND to the sign "-" (minus). The options I can think of are: - either we type a character other than these, it receives an alert, - or if we have typed the numbers AND another sign than the "-", in the...

Hello everyone. I'm trying to move my backend to MySql (I posted another thread for it) and the future users asked the possibility of attaching pdf files to the records on one of the tables. The files will be approximately 2 to 3 MB. I read that it should be loaded on a server and only display...

Good morning all. Advancing as an autodidact, I'm finalizing a small Access application that must be used by a few users (15 max). At the start, I had in mind that the database was split and that the BackE was on a server and the Front on the workstations of the different users. But for certain...

Hello, I create an order report but the ranges must not be static. This is just an example to illustrate my concern. Food names are labels and quantities are controls. I would like that for the empty quantities (or equal to 0) the line disappears, the control and its label. For controls, the...

Freuzo is my name and i'm from Cameroon. I'm now creating my first database and already took advantage of the advice on this site to get where I am.