I've been searching for a way to transfer/export data from an embeded excel sheet of a custom form in outlook. <br>
<br>
<br>
Does anyone have any ideas? <br>
<br>
<br>
Thanks, <br>
JazzMan
I have been trying to connect to the sql server in access. I tried doing a connection string in ADO, RDO, and DAO, and I just couldn't get them to work. <br>
<br>
<br>
If anyone can help, I would appreciate it. <br>
<br>
thanks,<br>
JazzMan
I just wanted to let you guys, <br>
know that I figured it out. <br>
<br>
It took way too long for this little bit of code, but here it is for any of you who are having the same problem.<br>
<br>
<br>
Private Sub cmdtimesheet_Click()<br>
On Error GoTo Err_cmdtimesheet<br>
<br>
Dim ol As...
Hi,<br>
<br>
I am trying to open a custom form that is located in the organizational library in Outlook,<br>
and I need to open it from Access. <br>
<br>
If anyone can help I would appreciate it.<br>
<br>
<br>
Thanks <br>
JazzMan
Hi, <br>
<br>
If you would try making a new form for your monthly calendars, and then publish it in your personal forms library. and that should work. Also when designing a new form choose new mail message, and that should give you the option of sending to others. <br>
<br>
<br>
<br>
you guys, <br>
<br>
I just would like to put my two cents in about auto numbers. They can really be a pain in the butt. I would like to recomend using just a number and then write some code to generate the record number. In my opinion it is a bit easier than working with auto number.
Ok, <br>
<br>
Try this:<br>
Look at the event properties of the last field that will be updated and press the build button (...) of the afterupdate property. Then select build code, and then enter this code. This should do the trick.<br>
<br>
Private Sub Text2_AfterUpdate()<br>
On error goto...
Never mind everyone, I figured it out. I found a simple solution. Instead of using two list boxes. I used one text box and list box. When I select an item it is then listed in the current benefits text box. <br>
<br>
This is the code:<br>
<br>
Dim items As Recordset<br>
Dim myform As...
I would like to list the current benefits of an employee (which are in a benefits table. Each benefit is a seperate field with a yes/no type.)<br>
<br>
I would really like to be able to refresh the list box for each individual employee. <br>
<br>
Is this Possible??<br>
<br>
Thanks JazzMan2
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.