Search results

its a long shot....im trying to import data from a 600mb text file into access the text file has had its headers removed.. so i have created a new table with the same column headers but when i try to import the text file to the table created i keep getting "invalid argument" I cant see any...

Sub Reg() Dim TeamVar As String TeamVar = Range("TeamVar").Value Range("B8:G24").Select Selection.ClearContents With ActiveSheet.QueryTables.Add(Connection:=Array(Array( _ "ODBC;DSN=MS Access Database;DBQ=S:\Access\dB\Details.mdb;DefaultDir=S:\Access\dB;DriverId=25;FIL=MS...

Hi im a newbie to access i have a column with entries in it what im looking for is, lets say everything NI* and when it finds all that is NI001, NI98 etc etc it changes the NI* entries to FIN my column is called Region, thanks to all who post and i hope you can help :confused:

hi all I have a db that does some basic queries and outputs an excel file, now the problem is; everytime i run the db the db size increases i am upto almost 450mb i delete all records at the end but to no avail please help and many thanks to all who post :confused:

Hi all I’m a newbie so any help would be very much appreciated I am handling large text files With more than 65000 rows is there a way to import the text file and when the rows go over 65000 it would then move onto the next sheet and put the rest of the data there. Hope you can help many thanks...

If I have a declared variable lets say “tuesdaydata” And I get random text files put in a drive lets say 123.txt, 548.txt etc etc But some of these files have “tuesdaydata” within the text files as a title is there code that will let me on my form opening go and look through the text files and...

onm a form i have a link what is the code to attach a file to an emai many mnay thx newbie :confused: l

hi im using this Private Sub Label9_Click() Set oEmail = Nothing Set oOutlook = Nothing Dim olApp As Object, olMail As Object Set olApp = CreateObject("Outlook.Application") Set olMail = olApp.CreateItem(0) olMail.To = "marc.seenan@bskyb.com" olMail.Subject = "BP Schedule" & TabName...

hi i have lengthy macro process and was wandering how i put a progress bar on my userform nay ideas?? desperate as per usual :confused:

hi i have a lable which opens up outlook, how do i populate the subject and message area Private Sub Label9_Click() Dim Subj As String Link = "mailto:seenan.marc@bsksyb.com" On Error GoTo NoCanDo ActiveWorkbook.FollowHyperlink Address:=Link, NewWindow:=True 'Unload Me...

hi all on a userform i have a combo box with values, what i need is; if i were to select a value in my combobox, this would populate my input box below will with a value, please help getting ,mega pressure at work :confused:

:confused: i have a column with usernames and numbers i.e rja01, 8765, sngg03, jkljkl344 and so on what i need is to remove all after and including the comma, please help thanking you inadvance