Search results for query: *

Hi, I'm trying to query a remote DB with a password using SQL only. Ie no linked tables, no VBA just the SQL. I can do this for a DB without a password but can't seem to do it for one with... here's what I mean: SELECT * FROM table1 IN "C:\remote_db.mdb" That works great when the DB isn't...

Hi, I've got an odd little issue... Where I work we have a number of Access DB's all split in a Front End/Back End config via linked tables (Access used for both, FE is in MDE format). This has been working great and all DB's work fine... except... We had a new user start the other day and...

Hi, I'm trying to write an update query but its not working as i want it to... i'll explain! Table1: ID, Day1, Day2, Day3, Day4, Day5, Day6, Day7 Table2: Date, ID, Unit, SellingPrice Table1 contains unique ID's and then price data for the past 7 days. Table2 contains actual dates in the...

Hey All, I'm trying to export the result of three queries to an excel file. The sheets that the queries need to end up in are named sheets... lets call them apple, pear, orange. Below is the code that i'm using: strSql = "select query here" Set rs3 = dbs.OpenRecordset(strSql...

Hi, Recently at work we have decided to make the move to Access 2003. We are now running with Jet 4.0 Service Pack 8 and as a lot of you will know that now causes problems with unsafe expressions. For us we now have a business critical database that wont run... Now in the short i have...

Hey Guys, I'm writing a program in Excel and it needs to use a macro written in a different Excel spreadsheet. Now the problem is how to call that other Macro. If i set a reference to the other sheet and call it like this: Record_Count = CountNumberOfRecords(varFile2) CountNumberOfRecords...

Hi, I thought this would be simple, but i'm having issues getting it to work! Basically i'm trying to create a macro in Excel where i give it a folder and a minimum file size (Mb, Kb, b, it doesn't matter) and it looks through the drive and lists in columns a and b all the file names and the...

Hi, I was playing with a spreadsheet that had a number of random numbers in. I then thought i wonder what autofill makes of the next number so i did it. I then tried to work out how it came to that number, but have no clue, so does anyone know how or why it chose it, below is the list and...

Hi, I've just started a new job and they use Novell programs on windows 2000 machines. The question is can synchronize my files with my laptop so that they are offline as i used to do in my old job that had a complete MS network and ran Win XP on all machines? If you need more details about...

Hi, I i apologize in advance for any lame questions i ask, however i am totally new to GWise (and Novell systems for that matter) and have used Microsoft all my life (and as much as it pains me to say i generally get on very well with there whole office suite). Anyway i have recently changed...

Hi, Firstly can i say i am very new to Javascript and have only been using it for a week now. I have created a Google Map using there API that centres on a place and puts about 30 tags on the map each that have descriptions. That was relatively easy as a lot of the Javascript needed is...

Hi, I have 30 workbooks, all formated exactly the same and i need to take the contents of certain cells out of each of them and collate into a single workbook. However i can't get the following piece of code to work, it keeps saying "object doesn't support this property or method" For Each c...

Hi, I have a file that has 15 sheets. 13 of them record data for all staff in an organisation and record 21 different items per member of staff. The most number of staff at any one organisation is under 1,000 so i have given each sheet 1,000 rows for data entry. The problem now is that it is...

Hi, I need to perform a query on Ebay using a specific API call. It is the Getsellerlist one. Now i have quite a bit of experience with VBA, but no experience with API calls. I have done quite a bit of reading over the past couple of days but am still not sure if it is possible to use VBA...

Hi, It would seem to be a simple problem, and i have a working solution, however as with all things it don't work properly (or at least how i want it to) The problem is that i have 2 spreadsheets that i need to compare. Both have the same column headings and both contain a table that is...

Hi everyone, I have a "dangerous" question, as if i can do what i want to do, i imagine the same or similar code could be used maliciously. Anyway i'll get on with the problem and let you guys decide. 6 weekly i need to send an e-mail to around 40 people, with there bosses cc'd in. The e-mail...

Hi, This is a question to which i have an answer but it is by far not the best. Here goes: I want to use an one array to look up values in others, ie Num1 = 0 Num2 = 0 Array1 = array("Pink", "Orange", "END") Pink = array("1", "2", "3", "END") Orange = array("4", "5", "6", "END") Do until...

Hi, I have a set of worksheets and i need to sum the same cell in each of them together. I was at first using THREED that i found in an excel add in on the net but then realised that when i distribute the file anyone without this add in wont be able to use it properly and seeings as the users...

Hi All, I'll get to the point. I am using lists in a spreadsheet to force users to select only valid entries for cells. I have one column of cells where the users enter a code. I would like the cell to columns over to have a list that is dependant on the first cell. I have created a macro...

Hi Everyone, I've been coding in VBA for a little bit now, but still consider myself a beginner, basically i get most things done by recording a bit and then adapting that code to what i need. This works well and i can do a lot of things this way except i don't really understand the errors...