Search results

Vince Im very new to VBA stuff and im not sure how to programmatically import the data into a table. e.g selecting a line from the text file and import it into Access. i would be grateful if you should me how to do it your way or any code would help. thanks again.

Any help on this would be very much appreciated: I would like to open a text in access via EXCEL VBA, and save the file as Comma delimited format. I have the following code below: it produces the following error message: Expect Function or variable: Dim objXL As New Excel.Application Dim...

Mile-O-Phile I have checked by going to Tools and Options, it's currently set to Shared. the message that comes up is Couldnt use 'C:\myfile.mdb' file already in use. help please.

people folks any idea why two people cant access MS ACCESS at the same time.. or run the access database at the same time? thanks in advance

Thanks for the reply... it's perfect.. thanks again

I would like to send the results of my recordset (i.e Access records) to Excel but everytime i send it to Excel, it opens a new Excel application. Can anyone tell me how to send it to Excel without launching another Excel applicationand how to launch/open Excel if it's not running already. for...

may be this will help may be this may solve your problem.. UPDATE tblTempUsers INNER JOIN concate ON tblTempUsers.UserName = concate.[Concatenate 1st & 2nd Name] SET concate.UserID = [tblTempUsers].[UserID]; SELECT tblUsers.ID, tblUsers.UserFirstName, tblUsers.UserLastName, tblUsers.UserID...

this should do the trick, assuming that you have multiple entries for Fred. i.e Name ComDate Fred 02/02/02 Bob 02/02/02 Fred 03/02/02 SELECT Test.Name, Max(Test.ComDate) AS MinComDate FROM Test GROUP BY...

i have a code which splits any given text up into words, if you're still interested....send an email to this address and i'll reply with the attachment. mrxdotcom@yahoo.co.uk

this may help...the best way around this problem is to write a query to count what ever you wish to count i.e. SELECT Count([T DEFECT DATA].CrankNumber) AS CountOfCrankNumber FROM [T DEFECT DATA] and then create another query to combine this query with the new query.. ie...

Thanks Pat thanks for guiding me....i have solved the problem. if anyone else is interested.. this is how i solved it.. Set myQuery = db.QueryDefs(cmbDisplayQueryName.Text) ParCount = myQuery.Parameters.Count

is there anyway to find out if a query has a parameter(s) programmatically. for a example, i have several queries and i wanna check the queries first before passing a parameter(s) to the query. any idea will be useful. Mrxdotcom

Hi is there anyway to find out if a query has a parameter(s) or not? any feedback will be welcomed. MrX