Search results for query: *

Hi everyone, One of my users has a large spreadsheet (9MB) that consists of several worksheets. its used for budgeting and has iterations and all kind of clever things going on. With Excel 97 the calculations are performed very quickly, but with Excel 2003 the calculations take long enough for...

Hi, I have a really strange problem that I hope someone can help with. I have a cross tab query that uses a function to calculate the column headers, the function returns "1 - 14", "15-16" etc depending on the gap between certain dates. I have Column headers set to "1 - 14","15-16" etc to...

Hi guys, I'm driving myself slowly round the twist here. All I want to do is open a recordset so I can loop through and reset some of the fields. But I get a type mismatch error on the set RS line (last one below) maybe the set dbs isn't working ? Am I doing something wrong ? Sub setval()...

Hi I have a spreadsheet (Excel) with several data sheets and 6 report sheets with charts on them. (The data for the charts is on the data sheets). I want to be able to send out the report sheets without the data sheets, and without a message box coming up when people open it to ask them whether...

Hi everyone, I have a report with a subreport in the page footer. The subreport just shows a name and a number. I would like to be able to print this going across the page instead of down. I've done this in Access97 but now have 2000 and can't remember how to do it anyway ! Can someone help ...

Hi everyone, We have a database (Access97) on a server that logs requests for medical records and generates the required letters. Last week there was a power cut while a user was in the database. Since then she has been unable to print letters although she can print invoice proformas. The...

My friend is learning SAGE Instant Accounts at home. Unfortunately the PC crashed and had to be re-booted and now the SAGE software thinks she is already logged in when she isn't. I guess this is not the same software but as it's the same compnay I wondered if anyone had a way round this. She...

I have a function called UpdSubs which is called by the On Current event for a form. This references a subform which is displayed on page 2 of a tab control. Everything works fine if the user uses the record navigation buttons to move through the recordset. However, if they use the binoculars...

I have a form with some controls at the top and then a Tab Control. When the last control before the tab control is exited (lost focus?) I want it to go to the first control on the Tab Control. I have tried the Lost Focus event for the control (patname), setting the focus to the first field on...

I have virtually finished my database and have run into a slight glitch. When adding a new record I need the form to close if do data is entered in the first field. I have a check on LostFocus for the field which successfully deletes the incomplete record - but I cannot get it to then close...

Hello everybody, I've been asked to look at the rostering / annual leave requirements of a department. There are 85 employees, of about 6 or 7 different grades. There are 3 sites and each site must have a certain number of staff of each grade for each day. At the moment all the rota's and...

My windows 95 box insists on looking on the floppy drive when a: is not selected, usually when using Explorer to find files on the hard drive or mapped network drive. It also tries to read from a: when doing file open from Excel, Access, Word etc. This is fairly annoying as you can probably...

I have a continuous subform with a combo box which is dependent on the contents of another combo on the same subform. The problem is that when the second combo box updates itself this applies to all instances of the subform. Is there any way to get the update to only apply to one row of the...

I have a tab control with 4 pages. The close form control is only visible on the first page, is there a simple way of making it visible on all pages ? Any help greatly appreciated.

I have a subform showing details of requests that have gone off to consultants. When a request is added on this subform I need to update a control(ReqStat) on the main form. When I add a new record it updates the control Ok and then returns to the 'new' record at the end of the form. When I try...