Recent content by scottian

Access does it automatically. DoCmd.TransferSpreadsheet acExport, 8, "MyStoreQry", "C:\My_Database\Store Data", True, "Store Number 1" That above will create an excel file with a tab called "Store Number 1". If you run another query (e.g named "Store Number 2") it will create a new tab in the...

Thanks Skip, ------------------------------------------------------------------------------ Ambition..........If you dont use it, you wont lose it

is it possible to compare part of a variable? i.e a = "question" b = "my question" If a is like b Then msgbox "Yes You Can Compare" End If ------------------------------------------------------------------------------ Ambition..........If you dont use it, you wont lose it

is it possible to start a macro, have an info box pop up but have the macro thats runing to continue to run? ------------------------------------------------------------------------------ Ambition..........If you dont use it, you wont lose it

is there a way to quit MS Office Paint app using a button in access? ------------------------------------------------------------------------------ Ambition..........If you dont use it, you wont lose it

When i try to navigate to a jpg file in explorer and choose to open it i get the error :- access to the resource 'yada yada yada' has been disallowed ------------------------------------------------------------------------------ Ambition..........If you dont use it, you wont lose it

I apologise. I was just trying to keep my post tidy, but i made a mess of it. Here is the code :- Dim varList Dim varItem varList = Me.ListFiles.ListIndex varItem = Me.ListFiles.ItemData(varList) Application.FollowHyperlink (Dir$(z() & "\Pictures\" & varItem)) That will work if im trying to...

I have a form in a database, on the form is a list box. I click a button and the list box fills with all the file names in a folder. The next step is to select a file from the list and open it. im using the 'FollowHyperlink' method for this. This works:- Application.FollowHyperlink...

Im trying to retrieve dates from a system using Attachmate. The date is displayed on the screen as "12/11/09" its copied to a variable and then pasted into a cell in excel. The problem i have is when the date is in the first 9 days of the month, e.g. "09/11/09". For some odd reason the date is...

Sorry, the error pointed towards this line strSQL = "SELECT * FROM Table1 WHERE index is null" ------------------------------------------------------------------------------ Ambition..........If you dont use it, you wont lose it

Can anyone spot what went wrong. Im trying to update a couple of fields in the main table of a DB. But when i try to run this query i get an error "Runtime Error 3075" "syntax error (missing operator) in query expresion" Function WorkFM() Dim ThisDB As DAO.Database Dim WMFRecSet As...

This works for me DoCmd.TransferSpreadsheet acImport, 8, "tblTABLE_NAME","C:\Untitled\MyFile.xls", True ------------------------------------------------------------------------------ Ambition..........If you dont use it, you wont lose it

Check the internet for an app called AppZap ------------------------------------------------------------------------------ Ambition..........If you dont use it, you wont lose it

Sorry about the vagueness of my post. The debug window opens without a problem. The action im trying to do worked in the past without a problem. But the base unit was changed, now it doesnt work. I dont get any error message, nothing happens. But I remember a few years ago having a problem and...

For years now ive used the debug window without any problems, but recently it stopped working (my base unit was changed). I was pulling my hair out for a couple of days but i suddenly remembered about the reference tools. I think im on the right track but not certain. Can anyone tell me if im...