I am using Access 2007. I have created a table that represents a data log. At daily intervals, data from a instrument is logged. There are three fields in the table: Tag, Date_Stamp, and Tag_Val. The transmitter name is in the Tag field, Date_Stamp is the day it was recorded, and Tag_Val is...
I need to update a true/false field to true after I have changed a date field. I have forgotten to do update the true/false field in the past. Automating this would save considerable effort. The data accessed via a query.
I thought I'd attempt to trouble shoot some more. It seems that whne I try to print only 1 page out of many the picture does not appear. If I print all the picture prints as expected.
It's still a problem but I have a work around in place.
I have a report that I've used for several days with a picture I (it's a company logo). I had copied the form from another and then modified it. I remember I had viewed properties to find where the picture was located so that I could use the picture in a third form. I realized the picture was...
I have several reports in which I have used data from a query. In the "conditions" of my "System No" field I have set up [Enter System No] as the parameter value the user enters. I would like to simplify my effort in printing reports such that the error "you entered an...
Kramer,
It works! I tried it just as you had presented it. When I looked at this the first time I was getting hung up on the "me." part of the expression.
Thanks again,
Roy
Thanks for your quick reply.
Sorry, but I was unable to get this to work. I made the strike out line and renamed it. But I was unsure about what to use in the On Format box. There are three selections; Expression Builder, Macro Builder, and Code Builder. I am way behind the times in regard...
I re-read my post and need to clarify some things. I have records that are not deleted in Access but have a field where I indicate a record has been eliminated from the scope of our contractors work. This field contains a flag that indicates no longer in scope.
What I am desiring to do is to...
I have a report that I would like to indicate records that have been deleted. I am trying to show the word "DELETED" over the fields in the record that is printed on the report. I have tried this by having my deleted field over the existing records on the report form. However when I...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.