Did you ever get your email issue to work? I'm having the exact same problem. I read through the threads on your question but I couldn't quite figure it out. If you got it to work and could explain it to me I would be most thankful.
captvideo33065
Wayne,
You posted this:
I want to set a conditional format as follows
If control-B < control-A then set forecolour of control-C to blue
Did you ever get this to work? If yes, would you please explain it to me. Does the code go in an EventProcedure?
Francis,
I read your post regarding LEFT not working. I'm also using Access 2000 and I can't get that function to work either. This is the code I'm using: I'm typing this into the FIELD box, "Left([Port Speed],2)". I get a message that says, "this function in not available in a...
To Wildhare:
Your suggestion seems to be right on the money...The date is aligned to the left. However, the DataType is marked as Date/Time. Is there a way to change the field to a true Date/Time without having to reenter the data. The table contains about 5000 entries.
To jhall:
Below is the SQL you requested. Thanks for your help.
SELECT [Completed Frame/Private Line].[Billing Circuit], [Completed Frame/Private Line].[Location-Street], [Completed Frame/Private Line].[Location-City], [Completed Frame/Private Line].[Location-State], [Completed Frame/Private...
To Wildhare:
I assumed that that was the problem but I don't know how to verify it. Is there a way to tell whether the conversion actually changed the field from a text field to a date field.
When I put #'s on either side of the dates Access puts quote marks around them and makes the whole line a string. This results in no hits on the database.
I'm trying to select transactions between two dates using the Criteria line of an Access Query. The format of the field is mm/dd/yyyy. When the records are selected it produces results by month disregarding year. Example: If I select transactions between 11/01/2001 and 11/31/2001, I get dates...
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.