Search results

Hi All Ive created a spreadsheet which garbs data from an Access database using ADO. However, half of the users have MS Access installed and the other half dont. Can those who dont have Access installed still get data using Excel ADO via VBA even though they only have Excel installed and not...

Hi All I know that Access probably permits around 20 or so users to simultaneously access the database before it start to become unfriendly. However, I have a database that would require 200 or so users grabbing around 1,000 rows of data via an Excel ADO connection to the backend tables. So...

Hi All I have a Memo field in my table. I have changed the Text Format property to Rich Text. I can now change the formats etc of the values in the field. However, I now want to see the Markup HTML tags in the table fields i.e. <b>test</b> in order for me to make changes manually as well...

Hi Can someone tell me whats the main purpose & benefits of an Enum? Thanks

Hi All Can someone explain when Public and Global variables lose scope and pros and cons of using both? Thanks

Hi All Can someone give me an explanation as to what the difference between the two variations of using the New keyword to create a new instance and using the Set. I mean Code 1 would always be better because you dont have to ever use the Set keyword 1. Dim wb As New Excel.Workbook 2...

Hi All Can someone explain Cursor Types in ADODB VBA? Ive looked at at articles and its something along the line of moving through returns rows of data sequentially. But the following types of Cursors seems to do the same thing for me i.e. I can still MoveNext, MovePrevious, MoveFirst etc...

Hi All Can some explain the concept of Cursor Types when opening a ADODB.Recordset i.e. adOpenForwardOnly adOpenStatic adOpenDynamic adOpenDynamic* adCmdTableDirect* adOpenKeyset Thanks

Hi All Is there any point in creating a Let Property in a class without having the Get Property to go with it? For example Private sConnectTo As String Public Property Let ConnectTo(ByVal Value As String) sConnectTo = Value End Property Sub GetDataFromSQLServer() Dim...

Hi All This is regarding ByVal ByRef Its taken me over a year to try and understand this concept as I feel either I just dont get it or people are not explaining it to me very well. Am I right in saying that ByVal and ByRef only matters if the called sub or Function changes the values of its...

Hi Can anyone help me as im trying to put tabs between charcters in a query and I use Chr(9) for the tab but the tab goes to the end of the text. SELECT 'Tab-->'+Chr(9)+'<--Tab' I need the tab to be between the 2 arrows i.e. Tab--> <--Tab Many Thanks

Hi Can someone tell me how I can open Command Prompt and start writing command lines to the Command Prompt window in VBA? e.g. This opens the Command Prompt window but I need to write lines to it via VBA Shell ("cmd ") Many Thanks

Hi Im trying to format one of my Crosstab query that has 0 decimals and the theousands seperator Rate: Format([Testing Rate],"#,##0.00") I have used the above function to format other fields in other query that are not Crosstabs. Can someone tell me what im doing wrong or how I can...

Hi All One one my Toolbars is not docked and is allowed to float anywhere on the screen. However, I have 2 computer screen and when I drag and drop the Access database from one screen to another then the toolbar doesnt move with it. Is there any way which I can get the toolbar to float in...

Hi I was wondering if someone can help me with a passthrough query. 1) I have setup an ODBC connection on my system from my Sybase Server 2) I have tested this connection by linking some tables via OSBC from the Link Table manager 3) I have set up the connection correctly in the properties...

What I am trying to do is I am trying to be able to have a control supplied to a sub which then makes changes to the control At the moment I have something like this Public Sub updateListBox(ByVal lstbox As ListBox) 'Stuff to lstbox is carried out here End Sub What I am struggling...

Hi All I have the following code that tried to connect to SQL Server via Access but doesnt work as it returns the following error "Error HRESULT E_FAIL has been returned from a call to a COM component." Dim oAccess = New Access.ApplicationClass() Dim sDBPath As String =...

Hi All I have SQL Server 2005 on my local machine. Im trying to use the upsizing wizard onto the SQL Server 2005 but I get a message when I click the upsizing wizar that says "ODBC-Call Failed" Can someone tell me how I can fix this problem? Thanks

Hi All I have two forms in my access application. Form 1 is a listview that is populated with unique Customer IDs. When the user double click the listview on the particular Customer ID then it loads Form2. Form2 has many listviews within it such as a listview for the Customer telephone...

Hi everyone I have 10 people running using 1 database on a network drive. Its painfully slow. Can someone advise me and help me urgently as its hampering my companies performance. Please Thanks