Search results

Changing the text colour on reports I have a report in Accessrun against a query. In the report I want each line that starts with 'F' to be returned as coloured RED and I want all others return as GREY. Is there a way of doing this through Access functions or do I have to use some VB code...

Apparently the problem is that there is a fault with a patch that is installed to help solve my problem. however this patch isnt working correctly. Now having to import all table, queries, reports, macros and modules into a blank DB along with all references used.

I think even rebuilding them wont stand much of a chance now. Just redone one report and when it came round to saving it Access crashed. There could be a phone call to the IT helpdesk on the cards.

yeah that was done after every session.

That seems to work. Only problem is I have a fair amount of reports that are bringing up the same message. Looks like Ill have to redo all the reports! :mad:

Not doing anything other than attaching to the backend tables. Its got me stuck this one.

Network is fine. I was told to always compile my VB Code before returning to work on Access however I think i didnt at some point. If this is the cause, any idea how you reverse it?

When I run a report I created, a VB error box appears stating: - 'Error Accessing File. Network connection maybe have been lost.' Any idea what this means and how it can be fixed?

Cheers guys! Its been since school since I last worked with Access.

Wot would the code be if you wanted to know the date of all customer_codes created over a week ago. In other words not in the last 7 days?

Cheers, Just found out that this also worked: - >=DateAdd("d",-7,Date())

I need a query that will return values of a customer number that have been created within the last week. There is a customer_code field and a date_created field. Any help would be appreciated.