Dear all,
I have the following problem. We have a vba prcocedure that automatically send an e-mail.
I need to insert into the body of this e-mail a text that that has a red font.
Please assist me in how to insert this.
I belive i shoul use the font.color = vbRed property, but i don't know how to insert it into the procedure.
the text is something like this:
"hellor...
Kan09
Last Activity: Nov 8 '13, 08:45 AM
Joined: Aug 4 '09
Location: Romania
-
Color certain text in red
-
the data in the table's column looks like this:
ColumnHeader
00:39:43 <- END
08:21:19 OPERATOR DOOR OPENED
08:21:30 OPERATOR DOOR CLOSED
08:21:43 OPERATOR DOOR OPENED
08:21:45 OPERATOR DOOR CLOSED
08:21:58 -> START
08:21:58 order number: 8651124563357
i need the query to check every row and if the row contains "order number :" in it, concatenate only part of the number... -
Find and replace in acces query
I have a table with a single column that contains various data.
Among that data, certain rows contain characters that need to be replaced.
ex: order number: 8651124563357 (the numbers are different for every row)
I need to find all the rows that contain "order number: "and replace 6 characters starting with the 19th:
ex: order number: 86511******57
How do i build that expression?
... -
MS Access forms
I have an MS Access database. The main switchboard has 3 forms witch the users access according to their needs.
The thing that i need to do now is prevent a user from entering a 2nd form or a 3rd form when he already has one opened. Basically i want the end user to be able to use only one form at a time.
Any ideas on how to do that??
Txs -
oohh..sorry.
They are text boxes used on the subform to display the data enterd into the table behind the main form.Leave a comment:
-
problem solved:
i've done a little permutation in the code:
I'm not prompted twice for the save button. Now i recive a ca't go to the specified record if i clik no on the prompt button...but that's...Code:[Stop time] = Time [TotalTime] = Diff2Dates("hns", [Start time], [Stop time], 0) DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70 DoCmd.GoToRecord , , acNextLeave a comment:
-
[start time] when the user starts entering data into the form the time() function inserts the data into the [start time] field
[stop time] then the user cliks save the stop time uses the time() function to insert the prezent hour.
[total time] - calculates the [stop time] - [start time] trough the date2diff function and inserts it into the table.
...the stop time and the total time update the tables.
i diddn't know that...Leave a comment:
-
msg box YesNoCancel - pops up twice
I introduced a YesNoCancel button on the before update event of the form. So now the user gets prompted if he wants to save the record or not.
The form has a subform so if the user enters data in the main form and then clicks the subform it gets the YesNoCancel msg and decides what he wants to do.
The problem lies in the save button on the main form. When he clicks it the msg box pops up twice. Why is that?
code for... -
I solved the problem by recreating the two subforms. The problem was probably something from A2000...because the subforms were built in A2000 and i'm working on 2003.
ThanxLeave a comment:
-
Requery and move to last record on a subform
i'm having a problem with the requery and move to last command on some subforms.
The subforms are used to view the data enterd into the table. I have 3 forms that use subforms. On 2 of the subforms the requery is made and the data can be seen on the subform ,but the subform does not go to the las record enterd, the user having to search for it.The data seems to updated by user...but there is no ordery by statement.
On one form... -
I found the prblem the next morning. The record loks property was at fault for the problem.
Thank you for the helpLeave a comment:
-
Kan09 started a topic Error Executing the command or ..could not lock table becouse it is in use by..in AccessError Executing the command or ..could not lock table becouse it is in use by..
i have (another) problem. The database i've been trying to design has been going trough a bit of testing. During those tests we've noticed that when trying to access a form from the swich board the "Error Executing the command" occurs (this is happening only when a user has allready accessed the form and others try to do the same). This is strange because the other 2 forms on the swichboard don't have this problem...and their design is... -
hmmm
yup it was obvious but i didn't see it. It works now. i'll do some tests on it as soon as i can find the time. Thank you very much NeoPa and i'm sorry you had to edit my previous post.Leave a comment:
-
First of all i need to specify that i'm not a programmer. The first time i've seen access or any other relational database was 4 months ago...so i'm kind of a beginner at this.
i've tryed implementing that code like so:
...Code:SELECT * FROM MakeTableUniteQuery AS tA LEFT JOIN Customer_Calls_In AS tE ON (tA.[Start Time] Between DateAdd('n',-1,tE.Ora) And DateAdd('nLeave a comment:
-
OK
This should be a customer support application. The users receive a phone call from the client and they start entering data into the dbs. There are three tipes of activities: phone calls recived directly form the clients (one table) , phone calls made or recived from the branches (one table) , and other activities (one table). Data from the 3 tables is entered via 3 forms.
Originally we wanted to make a timer so that we can...Leave a comment:
-
I'm sorry for the confusion. The current time is inserted into the table using the time function. This gives me for example: 13:24:52 in the "Start Time" field. In the Time field of the other table the value imported looks like this: 13:24:00. Every imported value has the 00 seconds.
I'm thinking i need to make the Start time field show the time without the seconds. I ca't think of any other way i can make this matching..takin g...Leave a comment:
-
matching data in access
In a table have a column "start time" that is populated with the present time (hh:mm:ss) when a user starts entering data.
We also receive an Excel doc that is imported into the database. The Excel has a Time column and a total time column.
I need to match the 2 columns "Start time" and "time". How do i do that? The start time has the format hh:mm:ss while the Time column has the format hh:mm. -
The form is in single view with a subform atached witch gets requeried every time data is enterd into the main form and the cmd button "save" gets clicked (the subform is there only to show the last entries made by the user).
I don't think there's anything wrong with the code...it works perfect for the admin users or the full permision user group...the problem occures only when i try to enter data logged in with a user form the...Leave a comment:
-
can't assign a value to this object
i made a mdw file with the user level level wizard and asigned a few users to the new data users work group.
When inserting data into the forms a pop up msj appears with the "can't assign a value to this object". The object in cause is a "stop time" column in the table with the time function in the vba code. The users form the full data users cand input that kind of data.
Why? and what do i do?
...
No activity results to display
Leave a comment: