Recent content by striker

I have a database which contains 1 datatable which is imported from excel on a weekly basis. I have then used Access to seperate the data by using a number of queries and produce repots on these. What I want to do is have a form which details the 'headline' data. which updates on form load...

I have a report which is by necessity very cluttered. I want to format the text from an individual record according to the value in a field within that record. My question is, is this possible and briefly how can I do it.

formatting teiben, I assume that you can't sort the report so that the newest date is the first record. If you can't then you will have to sit down and think up some formula to work out the most recent date. Give me some info on the size the report is likely to be ie how many records. and...

I've searched the archives and I can't find any info on converting a given date ie 29/07/03 to a number of days. What I want to do is check overdue tasks and group them in less than 30 days overdue, 30 to 60 days overdue and greater than 60 days overdue. I don't want the aggro of putting the...

IMO, Thanks for the help works like a dream.

Fraid not good old 97.:confused:

What I want to do is change the attributes of the font for a record in a table when a certain criteria in that record is met. The question is how do I do this. Thanks for any help or a pointer to the right approach. Cheers Steve.

I done a reasonable amount of research and I do't believe I can do what I want within the report. I have a task outstanding report and want to format the text differently depending how far out of date the task is. ie under 30 days late in bold between 30 and 60 days late in bold italics over...

Now I am completely confused. Ho do I set that then.

IMO, Works a treat But, how do I get the change to show up on the form when the change is made and not only when you move between records. Cheers.

I've tried various places for thst code but I cannot get it to work at all. Am I being particularly thick or is the code not right.

I have two date fields in a table DateRaised and ReviewDate. The ReviewDate field should be filled at data entry, but this date may not be known at the time. What I want to do is add a default value of a review date six months hence in this field. For information the DateRaised is not...

sql code formatting If you wish to format the sql in vba so that it reads easily on the screen use the underscore character _ this is a line continuation character in VBA.

I have developed an database application which sends a user filled out form by email to a supplier on a button press on the form. Whilst testing this using internal email addresses it works perfectly. However I forgot to consider the fact that all external emails have to be digitally signed...

i am using Access 97 and I want to email a user filled out form from a database. I want the form to look the same in outlook as it does in the database. I have tried to use sendobject but just end up with a table in the email. Has anyone managed to do this and if so your help would be...