Search results for query: *

What determines the different row sources? The tables: - EntidadesGestoras - Técnicos Did you have the query names in quotes or is that your actual code? The query names is in quotes

Data do not appear in combo box!

The Querys are this: query1 = "SELECT Nome FROM EntidadesGestoras Order By Nome;" query2 = "SELECT Nome FROM Técnicos Order By Nome;"

try: All 'Long' have to be replace 'LongPtr' Private Type tagOPENFILENAME lStructSize As LongPtr hwndOwner As LongPtr hInstance As LongPtr strFilter As String strCustomFilter As String nMaxCustFilter As LongPtr nFilterIndex As LongPtr strFile As String nMaxFile As...

Yes but I have a problem when I try to use the clause where! Besides I need to use at least 2 different queries in the same combo box because one of the queries is of different use. I'm trying to do this using the vba code: With Me.Nome1 .RowSourceType = "Table/Query" .RowSource = query2 end...

What I sent to you was an example of where you have to start. It is not easy but I will help you out. If I understand you're using an old work on a new access. work made in Access 2003 and 2007 to be edit in Access 2010 you have some problems of code not only for VB7 but so for references...

dhookom i'm trying to do that using vba code can you help?

The resolution for your problem is this code Option Compare Database Option Explicit 'Declare Function ShellExecute Lib "shell32.dll" Alias "ShellExecuteA" (ByVal hWnd As Long, ByVal lpOperation As String, ByVal lpFile As String, ByVal lpParameters As String, ByVal lpDirectory As String, ByVal...

Yes dhookom !!!

I am using sql database and a front-end access. If I use a temporary table that will increase the time. So I'm not interested in creating a temporary table! Thanks any way!

I've sql database and a access front end. In a form i'm trying to copy data from 3 distinct recordsets to a commonbox. I'm using this code to copy the data from one recordset to the common box : Set iconn = New ADODB.Connection iconn.ConnectionString = string1 iconn.Open Set rs = New...

If use ACCESS database or SQL database no doubt the second. In my opinion the SQL database is Faster, safer and more reliable for the user. But some points have to be applied by the programer: - Connection; - Permissions.

Well it's a good question! From the end of your post i believe that you are using the server in someone else machine. Therefore i wouldn't use the T-SQL for the reason of premissions and link problems. If the tables are large 'divide and conquer'. Then use inner join in the sql queries. Good work

Yes 'conc' it's the name of the control. And no I didn't replace the name of the form with the name of the subform. I gave the form a new name.

Thanks but didn't work. I tried your way and giving a new name but give the same error.

You're going the wrong way!!! For me if you are using a connection to a database, create and run queries from a vba code it's better and a faster way of working. If you need help to create the queries go to the site and look for examples. If you are trying to open an external Stored Procedure...

Did you use odbc connection or another? Did you use vba code if so you have to create a connection of this type: 'Set conn = New ADODB.ConnectionconSQL.Open "Driver=SQL Server; Server=xxxxxx; Database=xxxxxx; UserID=xxxxxx; Password=xxxxxx" If you are in a netework you have to create the...

Do you use some kind of code? Do you use 6 check boxes or one group of check boxes?

Hello I'm working on an application that has a form that is inside a tab control which is in turn inside another form with a tab control. The forms and tab control i use: Form:trab tab control:FRC Form:FRCdisp tab control:Registo Form:Registo subform:Predrust I'm trying to copy data to a...