Recent content by pozzo

CyberLynx Thanks for you answer. Sorry but it didn´t work yet. The combo choice is OK but I still need to select it manually from the combo. What code should I put in MyCombo_Click? Thanks Renato

I have a form with a combobox and if form "Mala_dir_para_Grupos" is open the code chooses one value under ItemData(1) as the combo default value. Else, if form "Mail_para_Grupos" is open the code chooses another value under ItemData(0) as the combo default value. See code below: If...

Here is a solution: http://www.vb123.com/toolshed/05_docs/stopoutlookmessages.htm

Avoiding Outlook Excessive Security Warnings - my code Banana Take a look at my code Public Sub Send_mail() Dim myoutlook As Outlook.Application Dim MyMail As Outlook.MailItem Dim Subjectline As String Dim BodyFile As String Dim AttchFile As String Dim fso As FileSystemObject Dim MyBody As...

Hello I´m sending email from Access. When Access calls Outlook I receive Excessive Security Warnings from Oulook asking me to choose 1 or 10 minutes of permission. How can I avoid these annoying messages? Thanks in advance Renato

ADP or Linked Tables Many thanks for your anwers, LPurvis and SQL_Hell. Now I have a better idea.

With MS SQL Server what is more efficient, Access Data Projects or Linked Tables?

I found the solution here: http://www.access-programmers.co.uk/forums/showthread.php?t=142744&highlight=mysql

Hello I have a MS Access application (Front End) working with linked tables from MySQL (Back End). I can link the tables manually using MySQL ODBC but I need to permit the user to choose which MySQL table he/she wants to link. For example, if he/she wants to analyse the month of september...

RG I decided for another approach. I´m using Navicat to add data to MySQL instead of using Access to do that. It works fine. Here is Navicat link: http://www.navicat.com/detail.html

It´s MySQL local to the PC. FE/BE Local.

My code: INSERT INTO tabelao1 ( cart_usu, nome_usu, data_realiz, tipo_mov, cod_proc_ins, desc_proc_ins, cod_prestador, nome_prestador, esp_prestador, quant, valor, mod, desc_mod, nro_guia, loc_atend, desc_loc_atend, conv, desc_conv, grau_depend, data_nasc, ano_comp, mes_comp, chave_unica )...

RuralGuy Thanks for replying. I´m using an update query. My Access is 2003. My OS is Win XP SP2. Keep in touch Renato

Hello I´m working in an application using Access as FE and MySql as BE. When I add some registers to this linked table, OK. Problem: When I try to add a lot of registers (700.000!) it does´nt work and the msg is that the computer does´nt have memory resources to do the job. If I try the same...

Bob Perhaps the problem is here: In the code I´ve downloaded in Public Sub UpdateFrontEnd() the line ' sets the restart file name strRestart = """" & strKillFile & """" (the file to be killed, not the one to be restarted) should be ' sets the restart file name strRestart = """" &...