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

Thanks for all your help. I've declared data types (oops) and changed the headers to start with alpha characters and all is working fine now ! Jane

This is the function Function CalcdayBand(NumDays) Select Case NumDays Case Is < 15 CalcdayBand = "1 - 14" Case 15 To 16 CalcdayBand = "15 - 16" Case 17 To 21 CalcdayBand = "17 - 21" Case 22 To 28 CalcdayBand = "22 - 28" Case Else...

I'd wondered if it was the numeric headers - will change it and see what happens ! Thanks

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 Medic, create a new module and paste the following. Note the field names in brackets need not be the same as your table field names. Ie could just as well be a.b.c and d Function SetAddr(Street, city, state, zip) SetAddr = IIf(IsNull([Street]), &quot;&quot;, [Street] & &quot; &quot;) &...

Hi, Think this will work as your calculated field. A separate user defined function would be more elegant though. readdress : IIf(IsNull([street]),&quot;&quot;,[street] & &quot; &quot;) & IIf(IsNull([city]),IIf(Len([street])>0,&quot;, &quot;,&quot;&quot;),[city] & IIf(Len([state] &...

Only way I know is to set up the table, use a query to append a record to it - append 39999 to the autonumber field, then delete this record. The autonumber field will then start from 40000 J

Hi orechet, I have had this error in the past and think it is likely to be the speed of the Pc that is the issue. IIRC dBase uses the clock speed to assign temporary file names and if th clock ticks over too quickly then these become corrupt. You need to slow your PC down, I did find a...

Glad you got it sorted !

Have you tried doing as Tatum suggested ? i.e. additional single quote before the AND [Dish RA ~] ?? txtvalue = DLookup(&quot;[Serial#]&quot;, &quot;[Dish Defective unit]&quot;, &quot;[Dealer ID]='&quot; & [Forms]![Entry Trip DM]![Dealer ID] & &quot;' AND [Dish RA #]='&quot; & [Forms]![Entry...

Hi John, Thank you, thank you, thank you. It worked a treat. Jane

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

Thanks Cosmo, It's all coming back to me now!

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 You could try a Save Record command as the first action on the Button Click J

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

MCEVOY, I use 100, have to be careful not to slow the machine too much otherwise dbase takes forever to load !

It needs to go in a module. start a new module, copy and paste my code from &quot;Function&quot; to &quot;End function&quot; then save the module - doesn't matter what you call the module , I usually call it Utils. J