Search results for query: *

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

...[FBR] " & _ "FROM tblMain LEFT JOIN [qryAccGroup] " & _ "ON tblMain.[FBR] = qryAccGroup.[FullReference] " & _ "WHERE (tblMain.[STATUS] Like 'pen*') AND (qryAccGroup.[FullReference] Is Null);" Set ThisDB = CurrentDb() Set WMFRecSet = ThisDB.OpenRecordset(strSQL, dbOpenDynaset) Do Until...

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

how would i check a string variable for a prtial match? ------------------------------------------------------------------------------ Ambition..........If you dont use it, you wont lose it

Please someone help. I want a macro to write into a field on a web page. The page is a login page with two fields; Username and Password. But it wont put the username or password into the page fields. Sub Main dim objIE as Object, objApp as Object Set objApp =...

I have a macro that imports an access table into a recordset. It works great, but id prefer if i could use one of the queries instead. When i set the recordset variable to the name of the query i get an error :- Microsoft JET Database Engine: Invalid SQL statement; expected...

CautionMP, Thanks for the reply, I didnt know about the rs.Update Ambition..........If you dont use it, you wont lose it

I managed to solve it, so i thought Id put my solution here for others. Global g_HostSettleTime% Sub Main() '''Declare Variables Dim Sys As Object Dim Sess As Object Dim Conn As Object Dim RS As Object Dim D_Base As String '''Set Objects And Sessions Set Sys = CreateObject("Extra.System")...