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, You can do this: Dim qdf As QueryDef Set qdf = CurrentDb.QueryDefs("NameOfQuery") qdf.Parameters![@param1] = value1 qdf.Parameters![@param2] = value2 qdf.Parameters![@param3] = value3 qdf.Parameters![@param4] = value4 qdf.Execute The @param1 etc is what you parameter...

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

It does now, Thanks, there was no space between Line and Input. Cheers Carl

LineInput doesn't work I am using Access 97 is that why, is there an alternative way? Thanks

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

The query i use uses queries other queries and I pull the balance from that. I can't amend the query unfortunatley as it is used somewhere else. What should I do???

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

I'm good thanks, you? Cheers for that being annoying me all day!!!

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

Hi, Thanks for that. I have done this but get connection failed! Any ideas? Function LinkTable() On Error GoTo whassup DoCmd.TransferDatabase acLink, "ODBC Database", "ODBC;DSN=CallDB;UID=userSukonik;PWD=sukonik", acTable, "dbo.d_input_map_define&quot...

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

Thank you very much, there is a lot there and I appreciate it.Will look at it soon and let you know. Currently working on something else so haven't got time at the moment. Cheers Carl

Hi, I have not really wrote it yet so I am open to suggestion and change. Carl

Am I right in saying i should paste the SQL query code in a module and just call it each time? Just to clarify. Sounds good to me though.

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