Search results for query: *

Hello, I have some emails that get sent from places where the email addressis not of a 'valid format' as far as outlook sees it. ie blah@blah therefore there is no dot so outlook does not think it is valid and therefore won't add it to its safe list. Does anybody have an idea to tell Outlook...

Hello, I keep getting a error message when i try and import some data via my forms. The VB that runs in the background imports some data via sql from some text documents, there is rollback used to. However, every so often I get 'Couldn't update; currently locked by another session on this...

Hello, I am trying to catch errors and rollback the data when importing a text file to my database. Hiowever I have two problems. 1. This occurs each time there is an error. An error table gets created with all the error rows in it. I don't want this to happen because obviously it will...

Hi, I have an SQL statement that brings back many records. For each record it brings back i would like it to populate the listbox using some other SQL I have passing the unique id for that record in to it. How can i do this (if it can be done)? I hope that makes sense. Cheers...

Hello, I have a text file storing comma delimted values. I would like to pull the string from the text file into a value. ie. Dim strIn s String strIn = (Line from text document) The text doc will never have multiple lines. Any help greatly appreciated. Carl

Hello, I currently have a form which imports my data from a text file into my database. It all works fine. I have a textbox which you just enter the path of the filename into and press 'IMPORT'. I have set it up so if there is a ';' it means there are multiple files so I can import as many as...

Hi, I create a report by using a query, in the footer i have placed a text box that i want to sum all the values of the balance column. ie £5.00 £2.00 ----- £7.00 I have set the control source to =Sum([SumOfDO_Balance]) but all I get is #error. Any help will be greatly appreciated. Carl

hi, I have two list boxes when one is pressed it filters the other. In the first list box (listFiles) you can extended multiselect. In the second (listPaymentBreak) there is no multiselect. When I have numerous files and select one in the second listbox a graph displays according to the...

Hello, On startup of my form run Access 97 database I currently check that the linked tables i have to other databases connect successfully. I also have a few tables that I link via a ODBC connection using a DSN called "CallDB". I has a username and password to access it. What I...

Hello, I currently use a stored query in a form which performs a function that I would like to use in other forms. Ath the moment I use: SELECT .. FROM .. WHERE Agent = [Forms]![FrmAgent]![AgentList] This works fine but I want to be able to call this query in other forms that use the same...

I currently have a query that takes some information from a couple of tables and displays the various information. I then use another query to perform mathematical functions on that data. I really want the query to happen in one go put can't figure it out. I have put the too queries below (they...

Hello, I have a pie chart that generates on the fly from information from a table in my database. I would like to be able to put another coloumn of colours in so when the pie chart generates each segment is a colour I have defined. However I don't have a clue how to do it? Any help greatly...

I am trying to open an sql statement that the vb code will loop through and add the ids to a string. However I can't even open the query. The query works because I use it to populate the rowsource of a combo box. It won't open the recordset. If possible as well could you tell me how to do this...

Hello everytime I try and run a command that assigns a value I get: Run-time error: 2448 'You can't assign a value to this object, etc etc.' I am sure you have seen this many times but I can't figure out what is wrong. My form is not read only. I have included the code from one sub below...