Search results

Thank You @Pat Hartman. This is a very important information.

Excelent work dear @cheekybuddha. It WORK's.... Great Job. Thank you very much.

I chose to use a UserForm, and everything worked out fine. The purpose of the [AllControls_Change()] procedure is to validate whether the conditions are met to activate the [Cmd_Ok] button. I want to Thank you all (@arnelgp, @theDBguy and @cheekybuddha), it was with your help that I was able to...

Can you say if, in Access UserForms, the (.Value) will have the value updated in the Change() event?

I have build it as an excel userform and all works well. Can I use it inside access database? And if yes; how can I open it with VBa?

Hi @arnelgp, thank you very much for your answer. There is no way to make it work without having to create supporting text boxes? If, in the Change() event, you change (.value) to (.Text), this event works, but the [AllControls_Change()] procedure does not perform the correct validation. Your...

Hi, I have two text boxes in a login form, and both have the same issue. I'm using the [Change()] event to check the number of characters typed manually to change the Text Box's background color. The problem is that the (.Value) property doesn't reflect changes made while the focus is on the...

Thank you very much @Pat Hartman. I'll stick with your sugestion. Seems to me the best aproach fir my problem. Thank you all in this post for your brilhant knowledge and support. Can you tel me please, what I need to do to close this post, as solved? It's my first post...

Smart words and smart advise @the_do. Answering your question, no, there's no process going over the intermediate query. At this point I will create the table in order to ferd the excel ms qwery, instead of create an CSV for that purpose. As Gasman said, the advantage of using the table is to...

Many thank's to you both @Gasman and @Minty.

Ok. @Gasman and @Minty, I've tried your sugestions, and I decided to follow that path. Regarding the question of using DAO or ADO, can you help? I've tested with DAO and worked fine.

Ok @Gasman. My best regatds. I'll wait for someone to answer my initial questions to build the complete orocess of extraction from passthrough. And as you nentioned, I'll use allways the same, created manualky, instead of creat the passthrough every time it runs. Thank you once more.

So, sumnarising your idea for my last question, first create table from passthrough query, and then export to csv using your function. Your function doesn't work on exporting directly from passthrough query? Thank you once more @Gasman

I'll try your ugestion @Gasman. Even so, can I ask you the best way (vba code) to export from access table to CSV? And wich is faster; export from Access temporary table or from the Passthrough?

The extraction will ocurr in a daily basis. So @Gasman, in your opinion, regarding my question "Would it be better to not export to CSV or link the MS Query directly to the Access table?" there's no need to export to CSV; It's better to Link directly to access Table wich seems to be faster...

I need to export data from an ORACLE database, and I'm using Access VBA. This involves running SQL via ODBC, using a Passthrough query that brings in about 1,300,000 records and takes about 15 minutes to run. I need to find the best way to do this. I'll describe what I did, but I'm not sure if...