Search results

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

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

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

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

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

I have a MS Access 2003 database that is getting corrupted frequently. I am following all the rules to avoid this problem but it keeps boring me with "Access can´t recognize this database format" and I lose all my data. I´ve sent the db to experts to try to recover it and they told me that it...

My MS 2000 Access application is crashing and returns a msg something like this: "Your Access application caused an error and Access must be closed" This occurs only when I execute some forms; always the same forms cause the problem. Somebody told me to copy the .mdb to another place in my HD...

As I could see in "Comments of SQLExpress", final paragraph (http://www.databaseadvisors.com/gazette/sqlexpress.htm) "....FWIW, the Access team has moved away from recommending ADPs as a front-end to SQLS apps over the last year or so, based on several public talks given by team members at...

Sometimes some of my Access 2000 forms use to crash the DB. Somebody told me just to change the name of the form. I did it and it always works well! Any good reason for that? Thanks a lot Renato

I'm trying to use ADP as front-end and SQLExpress as back-end. The tables importation worked well but I can't make queries: I receive a msg telling that my MS Office version is not compatible with SQLExpress. My MS Office version is 2003, my Windows is Win XP Pro SP2. Any ideia? Thanks a lot pozzo

Hi everybody! I have a form (form1) with a listbox (lstSelectContacts). This listbox is based on table1. To fill this listbox, form1 calls another form (form2) which is a special form for filtering. After filtering, form2 fills table1 and calls back form1. The listbox in form1 now shows the...

I have a label report based on a table with 1222 records. It should show me 41 pages - 30 labels each page, but it only shows 17 pages - 501 labels. The table really has 1222 records. This hapens only when I run the report clicking a button in a form that calls a procedure to print the report...

I have an Access application that calls Outlook and sends emails for selected clients. My problem is: after sending the emails I need to call Outlook outside Access and click Send/Receive to send them and then click Sent Items to be sure they've gone. Is there as way to do all that from Access...

I heard somebody say that it's possible to audit the tables of a DB using the system objects. I know how to audit tables using form events. It would be great if you could create a kind of "trigger" in Access tables! Any answer? Thanks a lot Renato :)