English Deutsch Français Italiano Español Português 繁體中文 Bahasa Indonesia Tiếng Việt ภาษาไทย
All categories

I have a Microsoft Database in Access, I have a lot of Fields and reports to go through daily, is there any way I can set up a "Message Box" to remind me that a field had been left blank after a certain number of days. Such as, after I open a "case" after 30 days a message will appear saying that the case is still open. ...to remind me to resolve the issue...something along that ...if i cant do it in access is there any other database that can give me this "ticker" option?

2007-02-14 03:34:14 · 5 answers · asked by jim_d28 1 in Computers & Internet Programming & Design

5 answers

You don't say whether you have any programming knowledge or are just a user of the database. If you can program a little, I or many others here can give you some code to work with, but there's no point if you wouldn't know what to do with it.

Update your question with your skill set please.

2007-02-14 03:48:01 · answer #1 · answered by rod 6 · 0 1

You can run a paramertized query which will prompt you to enter a date (today) and will return a list of items which don't have a close out date and are over 30days old (since entered date)

MS computes dates and times from 1/1/1900 @ midnight. The decimal portion represents time while the whole number represents days since 1/1/1900. So subtracting the entered date from today will give you a number like 31.5 which is 31 days noon since the entered date. using the CInt function returns just the integer CInt(31.5) = 31 which strips away the time


The SQL query you can write is
SELECT MyDataTBL.*
FROM MyDataTBL
WHERE (((CInt(CDate([today])-MyDataTBL!CreationDate))>30) AND ((MyDataTBL.CloseOutDate) Is Null));


This query uses the parameter today for the current date and expects your table to have a date field for when teh record was created and a date field for when you close out your record.

Records which have been closed out by entering a closeout date wil not be returned

If you can code you can enter this query in a macor which can be run every time the database is opened, or use this query as the basis of a report you run daily.

The advantage of entering todays date is that you can enter a forcasted date to get a senso of how many records will need attention a few days from now ect..

2007-02-14 06:01:26 · answer #2 · answered by MarkG 7 · 0 0

My guess, and it's just a guess, is that the database may have been created with a different version of Microsoft Office. Although Word and Excel are mostly compatible, at least to a degree, across different versions, Access is not. Be sure you're opening it with the same version on which it was created.

2016-03-29 06:15:18 · answer #3 · answered by Anonymous · 0 0

This is kind of remedial, but it is supposed to worki:
http://www.techonthenet.com/access/forms/cond_format.php
However, some conditional formatting in Access, can be done with code. Off hand I don't know that side, but conditional formatting is the simplest way

2007-02-14 03:40:53 · answer #4 · answered by Mictlan_KISS 6 · 0 0

Note to Mark G: try this in the Immediate/Debug window...

print format(0, "mm/dd/yyyy hh:nn:ss")

2007-02-16 03:34:04 · answer #5 · answered by Sgt Pepper 5 · 0 0

fedest.com, questions and answers