Search results

Hello. I've been thinking about it for a while but I can't find the error. I have this code to create a table, where I want to put the unicode compression in the "Name" field, but I get a syntax error. I'm sure it's a silly thing, but I can't find any information on the Internet and the...

Thanks to all, guys. It's solved now.

Hi guys. I'm trying to make a loop that goes through the records in a table, but the program doesn't respond when I run it. This is the code: Private Sub CalcularImporte() Dim rstTable As DAO.Recordset Dim rst As DAO.Recordset Dim strSql As String Dim ManoDeObra As Double Dim Vehiculo As...

Thanks.

I understand you, but I don't want to have "two databases", and neither do the other two people, because they have little knowledge of computers, and it would be a mess to make them understand. That's why I decided to do it this way, because for me it has no consequences, since I've been doing...

Hi guys. One moment please. First of all, I don't like written communication because it lacks tone, body language, etc., and can lead to misinterpretations. So, Pat, I'm reading you and in my head I see you shouting (with an Andalusian accent): "Have you seen what this madman is doing? Have...

The database I attached is just an example of something more complex that I have. So, a split so I can get to the problem. I have a database configuration form so that the user can add a favicon, change the file folder path, the colors of the database, or create backups (and choose how many to...

I need this table to create backups, so I can store backups name. Therefore, users don't use this table.

Thanks a lot. I share final result.

How do I get this?

Hi, guys. I want to create a table by VBA in a accde file, but I get an error. I attach two files. First one is accdb file. It works fine. But if I convert to accde, I get an error. I don't know what's wrong. Can somebody help me? Thanks.

Ok, thanks for all anwers. Thanks.

I'm going to do what you are proposing, @Pat Hartman . Thanks for you help.

Ok, I've fixed it now. I did this: Private Sub Form_Open(Cancel As Integer) If DCount("*", "TTPV") = 0 Then Select Case MsgBox("Vas a generar tu primera factura, ¿quieres seguir?", vbYesNo, NombreBD) Case vbYes...

Please wait a minute, you either misunderstood me or I didn't do it very well. Main Menu --> Button to open the Sales Form --> Ask if you want to add a sale --> If the user says yes, a new record is added with the code of the sale associated with the record (this is already done perfectly)...

I don't get it. Here is the sequence Form 1 --> Button to open Form 2 --> Asks if you want to execute an action --> If you say no --> You have to close Form 2

Hello. I am trying to close a form from the Form_Load event when a boolean variable is True. If I put this: Private Sub Form_Load() If Cerrar = True Then DoCmd.Close End sub I get the following error: 2585 This action cannot be executed while a form or report event is being...

Solved: Private Sub CmdExportarExcel_Click() Dim xlApp As Excel.Application Dim xlBook As Excel.Workbook Dim xlSheet As Excel.Worksheet Dim strSql As String Dim rsDatos As DAO.Recordset 'Abrimos Excel Set xlApp = New Excel.Application 'Creamos un libro Set xlBook = xlApp.Workbooks.Add...

Maybe this xlApp.Visible = False Set xlSheet = Nothing Set xlBook = Nothing xlApp.Visible = True I suppose that if Excel is visible, Access can not continue the code and it gets an error. That's the reason I propose that. Only I don't know where I clean xlApp in end code. Thanks to all.

If I do that, the code doesn't work