Search results

I also tried your suggestion, but i had a syntax problem. Thanks anyway!

Thanks a lot! arnelgp It worked Here is the code if can help SELECT qry_busca_inversiones_Santiago_tags_mailchimp_crosstab.correo_persona, qry_busca_inversiones_Santiago_tags_mailchimp_crosstab.nombre_persona, qry_busca_inversiones_Santiago_tags_mailchimp_crosstab.apellido_persona...

Hi everyone, I have an issue creating a Cross Tab query and hope somebody can help. I´ve uploaded the crosstab result and hidden personal data for privacy reasons. Rows: Mail, Name, Last Name, Phone Column: Product: ("1+1","2+1","2+2"...). These numbers are product names Value: if any of...

Hi! I´m using this workaround and it has worked for me: Front end: Ms Access Backend: Mysql On the Before update event of a given field: Private Sub tbl_comuna_id_comuna_BeforeUpdate(Cancel As Integer) If Me.tbl_comuna_id_comuna.OldValue = Me.tbl_comuna_id_comuna.Value Then Cancel = True...

I found and answer. It is to rename the "public_tbl_users" to "tbl_users". All the forms are working.

Hi everyone, I´m new in migrating and splitting databases. I´m trying to use postgres but i think that my question will aplly to mysql so i´m asking here: In my access Database i linked via ODBC the tables froms postgres (should be the same as mysql) which were exported before from access...

You are right, should be 01-01-2018 for january 1st and 31-01-2018 for january 31st Thanks anyway

Yes it is, In our regional configuration either Excel, Outlook or any other program we use day - month - year. English speaking languages use month-day-year

It could be a reason, but the dates in my version of ms access work just as any other office program and considers regional configuration. Some time ago i realized that people with the Spanish version of MS access had trouble with the iif function written in Spanish (sii), you had to write...

I found the solution: wrapped the "minus one" in double quotation marks. <DateAdd("d","-1",CDate([Forms]![frm_contrato_arriendo_renovacion]![txt_fecha_inicial_renovacion])) I can´t understand why it worked because de DateAdd function requieres the interval as string and the number is a...

Hi everyone, I´m having a little trouble with the Date Add function in a query criteria and would appreciate any kind of help: I have English Ms Access and my local time configuration in spanish (Chile). I use 31-01-2018 for January 1st, 2018. In a query criteria when i use...

Hi there, I´m kind of new to ms access and vba in general. Did a course on the university and a lot of learning through youtube and forums like this one. I have a business major, nothing to do with programming but i´m learning in order to do a managment system for my startup:) I hope to enjoy...