Search results

Thanks!!! it works now - Phew!

Hi all, My problem seems to be on such a basic level, but I can't for the life of me work out why it won't work!! I have creatd a complex for which is a menu page for various reports. I have tried to put information on the control tip text to inform the user certain details. I have entered...

HI, Thanks so much for that! I didn't relaise it was so easy! Cheers Ros

Hi, I have a query that gives an out put of 'worst offenders'. these offenders are in order of on field ascending (number of entries made per week) and another field descending (total sales). It is by the combination of the sorting of these fields that we have an ordered list of offenders...

Hi, I have created a form that is based on a cross tab query. I have a set number of fields in the form (1 day, 2 days, .....10 days). The problem is sometimes when I run the query some fields disappear. for example for no records have an entry in the '2 days' field. When this is out...

transfertext specification problem! Hi I need some help, I have a similar problem to this. There is a working Macro on one database that uses transfertext to import a text file that has come from SAP. The original query in the first database hasmany specification names available, but in my...

Hi, I have created a continuous form, and using conditional formatting I have mde the background colours of the cells change due to their value: <2 2<[value]<4 >4 The code I have seems to work but the whole column of values are the same colour depending on the top entry, other cells are the...

Hi, I've tried your formula, and the only fields I am using are LOADDATE(startdate) and DATUM (enddate) I have replaced these into the start and end date names in your formula, is this all I woyld need to do, or do I need to make other fields etc. Also I am having trouble running this in my...

Hi, I have been trying to calculate date difference not including weekends. I found this code to use in another thread, but am unsure of where to put it. I am quite new to using access, so a detailed description would be very useful!!! Here's the code posted: intDaysInPeriod = DateDiff("d"...