Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: geralf
  • Content: Threads
  • Order by date
  1. geralf

    Color cells in Excel spreadsheet using Access?

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

    Making an ODBC connection from Access to Interbase tables?

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

    How to share one network connector/connection?

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

    Snapshot format not available in Access XP

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

    Transfer speed?

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

    Missing tab in 'desktop-properties'

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

    Open protected workbook from Access

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

    Autosave transfered Access records in Excel

    Hi, I'm transfering records from Acces to Excel (using the Excel 9.0 library - not TransferSpreadsheet Method). The filename of the workbook is construv\cted based on month and year, for instance Feb2003.xls If the file don't exist, I'd like it to be created, but without the user being able...
  9. geralf

    On starting 'any' application, notepad is the app that starts?

    Hi I have a problem with my Win XP Pro. If I try to open almost any application, the notepad opens and displays a cryptic document. It seems like notepad displays the exe-file/document that gets double-clicked I'm trying to start (Excel,word,Outlook Express etc.). Even on insertion of a CD-Rom...
  10. geralf

    Format current record on cont. sform when moving to another sform?

    Hi, In my continous form (sub form as datasheet) I have a field which when receives focus, jumps to another subform where data can be entered. This works great, but I'd like to get the row in the first SF, to be displayed in another color. This to indicate which record in SF1, data is being...
  11. geralf

    Command button on main form to add record on subform

    Hi, Is it possible to have a command button on the main form, which adds a new record to a sub form when being clicked? Something like the DoCmd,,acNewRecord ? Thanks in advance Gerhard
  12. geralf

    Return value from function?

    Hi, I have a query as source for a form. In the query there are several expressions that calls different functions in a module. These functions should all return numeric data, but are returned as string/variant types. So when I use these expressions run in the query in a form, and try to format...
  13. geralf

    Change how Long Date is displayed

    Hi, I have a field which has it's default set to =Now(). The format is set to Short Time. So the data is displayed as this ie: 16:15 If I clic in the field to edit the date/time-field, I get to see the Long date format ie: 07.03.2003 16:15:04 When I click in the field I would like to have it...
  14. geralf

    Change screen resolution from Access?

    Hi, Is it possible to change the screen resolution from a button in Access? Thanks in advance!
  15. geralf

    Where to locate mdw-file?

    Hi, I have a db running on a secured and split db, running on a NT Server. I use a shortcut to open the secured db. I have placed the mdw file at the same location as the backend on the server. Is there any recomendations for where to place the workgroup file? Thanks in advance

Part and Inventory Search

Back
Top