Search results

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

I have an Access 97 Form, which replicates an existing paper form. The paper form is faxed around the bazaars for various people to action. When the Access form is raised it is filled in with part of the data and then when the paper form is returned the rest of the data is filled in from the...

Has anyone got an example of how to apply multiple query to a filter by form. I want to be able to do it in code. I get the feeling that i need to use the buildcriteria method but am a bit confused by Access help when it says that you have to run the build criteria for each field that requires...

Travis, There is only one mdw file on the network that my users can see anyway. On each NT box there is a batch file that runs at login to delete system.mdw if it exists. This was the only help our IT staff have been able to give us on this problem. The thought of having to recreate the...

Travis, Strangely Yes on both counts, Ive checked everything and the permissions are as they should be. I'm still looking for a coded solution.

I have a number databases for which I am sole administrator, one of them up until recently was read only access to all accept myself. As if by magic ordinary users seem to be able to write to the database although their permissions are set to read only. I have tried setting the permissions...