Search results for query: *

Have solved it. i had problems with the Range/Cells/Interior properties but found a solution. This is how I changed color in the desired spreadsheet cells: Do While Not rst2.EOF For I = 0 To rst2.Fields.Count - 1 CurrentField = rst2(I)...

Hi, This question should maybe be placed under Excel, but since the code is going to be run from Access, I've placed it here. Here's the question: How do I color a range of cells in Excel (bacground), using a variable, and not the Range("A1") reference through the Excel Object library from...

foolio, thank you very much for your thourough answer. I downloaded Borland InterBase 7.1 as a trial version , and got stuck when I tried to add the ODBC driver. I don't know how to configure the connection (DNS, UserName, Password etc.) As already said - the helpfile is very poor. It's much...

Hi I'm trying to access data from an Interbase database (.gdb file)from MS Access XP. I've downloaded the InterBase, and ibstalled the package (Tial version till this works!). I can add the Intebase ODBC connection driver to ODBC datasources, but don't know what to insert into each...

Thanks for the reply dietergW! I have mislead you guys here, because I spoke to the company that set up a server a few years ago. The technician there told me they used static IP addresses. The 'old' server has recently been replaced by the IT department of this company. I did not manage to get...

Thank you for your answer and link. I see I have a lot of reading to do, but I haven't found what I'm looking for yet. The network is using STATIC IP addresses. One of the computers that is set up, have access to the server. If this computer is connected directly to the LAN. If I connect a HUB...

Hi I'm new to this, so please bare with me for not using the right termshere. I have one network connection used for a computer. Now I'm going to install an additional computer, and get it on the network as well. I know I have to use a hub to share the connection to other computers. My problem...

Hi Roy-Vidar! Thanks for helpfulness, much appreciated! Now I have fixed it. I got help from Rob Cooper at Utter Access forums. He listed the registry settings for the snapshot format. I checked out mine, and they were the same, with the exception of the 'Snapshpt Format' which was a Norwegian...

Hi again! I created a new fresh database, made a new report and tried the same DoCmd.OutputTo, but still no game :(. Regards GerhardA

Hi Roy Vidar I'll stick to English so others can follow the thread also. Good to hear that it is working elsewhere, because then there is hope :). I've tried all your suggestions without any success, and yes, I've checked the references and they are set to the same. I'll start a new db from...

Thanks for your reply GHolden! As you suspected, it don't solve my problem. It works with other formats so non existing path or illegal charachter in filename is not the case here. I have the same error on another PC running WinXP and AXP (Norwegian versions). It would be great if someone could...

Hi, I have upgraded from A2k to AXP and converted the db file to AXP fileformat. Everything I've tested so far seems normal, except from this: When I run the following VBA code DoCmd.OutputTo acOutputReport, "rptChargeData", _ acFormatSNP, strS1, True I get this errormessage...

Thanks very much for your confirmation of my suspicion cdogg. I've tried it on two different video dvd's without any dramatic difference in transfer speed. I'm thinking that it might be a mainboard issue, since I've recently bought a new one. I see if I can hook up the old one and see how it...

I have a Samsung DVD-ROM (SD-616Q) which has a poor performance (I think). I used a freeware utility (FreshDiagnose) to benchmark the drive. I got a data transfer rate of about 2.5M Bytes/s. My mainboard is Epox EP8RDA3G with nForce2 chipset. I've updated the mainboards drivers, latest BIOS, and...

Thanks very much bcastner. I won't be able to check this out until late next week, before I'm back at the company with the server. My reason for this is that the headoffice of this company had some 'server guys' to replace the old server, and when they installed a new one, the settings tab is...

Hi, The desktop property sheet 'adjustments' (screen resolution, colors etc.) is not showing on a server running Windows 2000 Pro. Coul'd somene please tell me how to enable this 'Adjustments-tab' again? By desktpop property sheet I mean when you right-click on the desktop and select...

Excellent! Just what I needed. I have one additional question. I have a function that returns trur or false, whether an instance of Excel is running. How do I open a workbook in the same instance? Thanks for your help! Regards Gerhard

Hi, I'll try this here since it uses bothAccess and Excel. I have automated transfer of records from Access to Excel, using he Excel Object Library. I use the GetObject method to get access to a specific Excel file. This file is protected with a password (which is known). How can I pass this...

Hi again! I've just tried out the suggested solutions but no one of them worked. The refered Registry entry is EXACTLY as shown in linney's post. There are some applications working (an image program, Internet explorer and some solitaite card games etc. I'm not allowed to install any new...

Thank you both for your time and interest in this matter. I've not been able to try this out today, but I'll try it later this week. I'll post back then Regards Gerhard