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.

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

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

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

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

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

I have a form which has 22 command buttons on it, I have written a procedure which formats the command button when it is clicked, but the way i see it at the momment I have to write 22 slightly different procedures i.e one for each of the buttons. What I want to do is write a procedure which...

Is it possible to format the colour of the text in a combobox. I want to use the colour of the text as a flag for priorities of task ie red for high, yellow for medium and green for i'll do it sometime. Ive tried using fontcolor but it doesn't seem to work, the only action I seem to be able to...

Is there anyone out there who has a method of compacting Access 97 databases during silent office hours. The only way I have found in the Knowledge base requires the database to be given a new name when you compact it. The problem I have is a lack of server space so I can't have two copies of...

I have two questions for the vb guru's out there: 1: How do I disable the close X in the access. The one in the top right of the screen. and 2: How do i hide the access system window the one that lists all of the tables forms queries etc. Thanks in advance Steve

Is there any way that I can count the number of times a particular text character appears in a text field and also the positions of that character(s) within its field and then use that info in a query.

This should be nice and easy for any access guru out there. In a union query can I have multiple criteria. for instance from the where clause. where field a = "some text" and where field b = "some other text" and where field c ="some more text" etc. If it can be done can someone please post...

I have a form which has been based on a table. I want the table to be created when I open a form and then I want to be able to delete the table programmatically at some point during an access session. The why's and wherefores of this are that I cannot get the data I want from a query. I've...

:confused: I have a Access97 database running in a NT4 environment which is secured by workgroup permissions (not my idea it is company policy). I have in the past been able to email the database to another site (who use Access2000) and they have been able to open it with no problems. This...

I have built a database around a main form from which all other things are accessed. On the form there are some command buttons for reports etc, and some combo boxes used to find records quickly within the database. This form is called up at the database start up. However to run on of the...