Search results for query: *

Hi, How, to I send a parameter to an Access query in VBD. Ex: executequery ("query1") parameter Thanks, Albano

Hi, I have a ADABAS text file and I need to converto do csv file and then export to SQL, any one have a clue how can I do it. Thanks, Albano

Hi, I have a ADABAS text file and I need to converto do csv file and then export to SQL, any one have a clue how can I do it. Thanks, Albano

Hi, I need do open a PDF file (the name came from a DB), but it allwys give the error "The page cannot be found". The path for the file is "D:\Albano\app_GestaoRecursos\gestaoCandidatos\fichasCandidatos" and I need to pass the path to javascript to open the file in a new widow. I already used...

Hi, I have a form (continious style) that is bound to a tablle, and I have unbounds radio buttons that are created as much as the records. What i want is for users to be able to select just one of the radio buttons (meaning they select the record), now when I select one all stay selected...

Hi, How can I put a blank item as selected item in a combo box, this item is not part of the table data. Thanks, Albano de Sá

Hi, I have a form with list box's populated by query, and this records are updated by a pop up form, I need do requery the data when I close the pop up form. Thanks, Albano.

Hi, I have this query, and I need to order by all by a field except a particular text. this is the query, I qhant to order all by "CLINOME", but not include in the order the text 'Mostrar Tudo'. SELECT NULL AS USRLOGIN, NULL AS CLICOD, 'Mostrar Tudo' AS CLINOME UNION ALL SELECT...

Hi, Theirs any whay of traking, user activity by using only Access resources (not vb). I need to know, what tabes, forms etc where user enter and what actions they did (delete, update etc...) Thanks, Albano

Hi, How can I put a link to open a doc ou xls file in a list box item when is clicked. Thanks Albano

Hi, Whow can I chnge the index order of a option box in Excel to start at 0 (zero). Ex: I have 3 options box on a sheet, and they ave the values 1,2,3, but I what them to have the value 0,1,2 Thanks

I a Have this STP, it return de AVG, but return a round number, I whant to return the original decimal number round on 2 decimal places. set ANSI_NULLS ON set QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[STP_MEDIA_AVALIACAO] ( @pVISCOD int ,@pCLICOD int ,@pCICCOD varchar(10) ,@pLOCCOD...

Hi, Whow can I get table names of a expecific Data Base? Thanks, Albano

Hi, I need to make a script that excutes to sql server 2005 all sql(SP scripts) files in a folder. Thanks, Albano

Hi, I have a "Continuous Forms", and i whant to show a combox only on the new record, and hide on the existing records, can this be donne? Thanks, Albano

Hi, Thirs any whay of converting a string to command button object. I have this function, and i need to use the string paramenter aButton as a command button: Sub desactivaMenu(aTipoUser As Integer, aObjecto As String, aButton As String) Dim RSAcessos As DAO.Recordset Dim Dbs As...

Hi I have this sub called in a module: Sub getAcessos(aTipoUser As Integer, aObjecto As String) Dim RSAcessos As DAO.Recordset Dim Dbs As Database Dim StrSql As String Dim tipoAcesso As Integer Dim tObj As Form Set tObj = Forms(aObjecto) 'BD a ser utilizada é a...

Hi, I restore a old database to SQL, and now I need to make project server 2003 point to that batabase. how can I do this?

Hi, Does any one know, if their is any limtation of the number of tasks that project pro 2003 can open when linked to a project server 2003 Because I have a project with 2300 tasks, and the project client can't open it. Thanks, Albano

Hi, I have a form to make the login on the app, the username is stored in a public variable. Logging on the app whill send the user to a menu form, but when I retrive the value on that form, on the first time the value is the nothing or the last user that logged on. I thik theire is a delay...