Search results for query: *

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

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

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

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

Someone please help. Firstly, im sorry for cross posting. Im trying to connect attachmate to a database table, id like it to write to one of the fields in the table in the database. But i cant work it out. This is what ive got so far. Sub Main() Dim Sys As Object, Sess As Object Dim...

Someone please help. Im trying to connect attachmate to a database. open a table and have attachmate loop through the records, obtain some info from each account and then write it back into a field in the database. But i cant work it out. This is what ive got so far. Sub Main() Dim Sys As...

Is there a limit to the amount of queries that can be linked from Excel to Access? Ive used 'Data' - 'Import External Data' - 'Import Data' and then the wizard. Ive linked the workbook up to various queries in my database, but now its just stopped with 5 query links. when i try to do another one...

Not sure if ive got the right forum. Starting from the top... I have a mac. I bought a PC cheap. the PC had a 250G hard drive my Mac had 80G. So I swapped the drives reformatted the hard hard from NTFS to HFS and installed OSX on the Mac, no problem. So i now need to install XP on the PC. Ive...

Ive created a crosstab query in a database, the database got too big so i decided to import all the objects into a new shell, but now a crosstab query has just decided to stop working. it works fine in the original database but not in the new one. i get an error "the jet database engine does...

Does the eMac require a specific operating system? Ive tried starting it from 3 iMac install disks but the eMac wont start from disk. It just thinks about it for a bit, CD drive spins but then just gives up and the eMac goes back to starting from the hard drive. Ive tried all the 'secret' key...

Does anyone know of any way to get stuff off an iMac and onto an iPhone, im running OS 10.3.9, and so far i keep getting errors telling me that i need OS 10.4.9 at least. "Children are smarter than any of us. Know how I know that? I don't know one child with a full time job and...

As the subject suggests Ive got a field in a table set to date and time, but i need to group on the field to return figures for each day for a report. The records sort fine in the query but when i view the report the records seem to sort as number i.e.- 19/03/2008 18/03/2008 18/02/2008...

A bloke has asked me a question. His Dell PC running XP keeps shutting down. It was working OK but then started shutting down for no apparent reason. Every time was random but it then started getting worse. Now it doesnt even start but he gets an error message "there is a problem with windows...

how do i format this :- (Right([TimeDivision],Len([TimeDivision])-2))*60 as a number? i tried Format( (Right([TimeDivision],Len([TimeDivision])-2))*60) as integer but it didnt work "Children are smarter than any of us. Know how I know that? I don't know one child with a full time job and...