Search results

Excellent! It solved my problem. Thank you

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

Dim sCurrentPath as String sCurrentPath = CurrentProject.Path & "\"

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

Hi - I found the solution, I have to use the Call before the method Call updateListBox(me.List1) Thanks

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

Something like Private Sub btnLogin_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnLogin.Click Dim sPassword As String = "" 'Connect to the server Using con As New System.Data.SqlClient.SqlConnection(cs) con.Open()...

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 Many thanks for this but one thing i noticed that when the first instance of the form is closed then all the other instances of the form closes. Is there a way around this? 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 David Please see the answers below. Does each user have their own copy of the db on their workstation? We tried having the font end on each computer and have linked tables to the tables on the network drive but it made it even slower. Is the data normalised? Yes Is there a lot of...

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

Yes i did. Is there any other way of doing it?

Hi All Im using Access 2007 and ive linked my inbox to my outlook. Can someone tell me how I can important Outlook attachements on an email into Access? Thanks

Hi All I have linked an outlook folder to my Access 2007 database but when i try to open the 'Inbox' table from my access database it crashes. Any ideas why? Any help is appreciated. Thanks

Hi All I have linked an outlook folder to my Access 2007 database but when i try to open the 'Inbox' table from my access database it crashes. Any ideas why? Any help is appreciated. Thanks

Thanks that worked great!

Hi All Im trying to do a DlookUp in a query. My Query has 2 fields Field1: CaseID (Bring back the CaseID fom another query) Field2: DLookUp("[Date]","tblPayments","[CaseID]= [qry1InvoicedPayments].[CaseID]") ...So my question is that my DlookUp doesnt work as it doesnt recognise...