Shaft11
Last Activity: Jun 25 '10, 09:25 AM
Joined: Sep 11 '08
Location:
-
How do I call the function? -
Thank you for your reply,
However, It seems that the function is counting 7 weeks, not 7 days. Is there something that I need to change in the function or the code?Leave a comment:
-
Thanks,
It works, but if I add a name that is not in the list I get the 'Not in the list' Error
Other than that it works.
(Sorry it took me so long to reply, I had to buy a new computer due to a STUPID virus)Leave a comment:
-
DateAdd exclude Weekends
I know this is a 'dead horse' here however, I've searched this site and still can't get it right...
I have a field named [court_date] and a field named [serve_by]. The [served_by] date has to be 7 working days before the [court date].
I copied and pasted the following function from this site:
...Code:'********************************************************** 'Declarations section of the module '**********************************************************
-
MS Access autocomplete/autofill text box
I have searched and searched and cannot seem to find an answer that fits my needs. Hopefully you can help.
I have a database that stores names,addresses , etc. I am trying to get it to where I start typing the last name it will 'suggest' names that are already in the table. ex. If the last name is "Johnson", When I start typing "Jo" it will automatically complete as i type.
Any Idea's?
... -
How to remove reference to deleted field
I was creating fields on the table of my database. I accidentlly named a field, "MonthNAme" I now need the function, "MonthName" .
I deleted "MonthNAme" from the table, however VBA still has a reference to it as a textbox.
I created a new database and imported the information, however i still have the same problem. Is there anything i can do to resolve this?
Please help. -
The memo feild looks similar to this now:
What I would like to do is similar to this:Code:10/10/2008 11:30:00 Interviewed Subj while at Childrns Court. Subj stated same about the nails stated that the only reason that he pulled over was to check his tires and vic started TT to him. Advised will look into situation.
...Code:10/10/2008 11:30:00 Interviewed Subj while at Childrns Court. Subj stated same aboutLeave a comment:
-
Memo field formatting
I have a memo field that time/date stamps new entries to the field. What I’m trying to do is for entries that are more than 1 line, the second or subsequent lines are moved under the first line past the time and date stamp…Any code would be appreciated. Thanks -
Thank you this is exactly what I was looking for.Leave a comment:
-
Pop-up form to add comments
I’m sure that this has already been answered but I can’t seem to find the answer.
What I’m trying to do is when the user clicks on a button on the main form to add comments to a memo field, a pop-up form appears that allows them to add the comments, after they add comments on the pop-up form, the entry is time/date stamped and added to the memo field on the main form.
Any code would be appreciated.
Thanks.
No activity results to display
Leave a comment: