Search results

There was a site with this table <TH id="a6" axis="location">San Jose</TH> to categorize cells. Can this be worked into my recordset table?

Thanks, theDBguy, I saw it after I posted that very long code :-)

Thanks, theDBguy, I will look at the link you sent!!!

This is what I have: strTable = "<TABLE Border=""1"", Cellspacing=""1"", Cellpadding=""2"", Width=""100%"">" & _ "<TR><TD colspan=""10"", Width=""100%"", Align=""Center"" Bgcolor=""#D8D8D8"", Font Color=#000000><b><Font Face=""Courier New""><p style=""font-size:16px"">---- Ledger Detail Report...

Apologizes, Minty, so <fieldset> would not work to group?

Thanks, Minty~I am working in Access to produce an Outlook email,~mjc Yes, plog. It displays the CCTR and ACCT and under that, it displays all records that fall under those columns/rows. It displays as a table header rows with columns and rows under it. Thx~mjc

Thank you~plog. That is where I got the first code and the table is very good, but now I have to group accounts and I am no sure how to use <fieldset> to make it happen. Any advice?

I have a vba code that displays a table in an email body, but now I have to group accounts so it looks like: CCRT# 1234-01 ACCT# 4567 Trans# | Trans Date | Item | Reference | Amount # | x | x | x | $ CCRT# 1234-01 ACCT# 8970 Trans# | Trans...

Good Day~ I have a Contacts table with these fields ID Company Last Name First Name E-mail Address Job Title Business Phone Home Phone Mobile Phone Fax Number Address City State ZIP Code Country/Region Department Office Display Name Alias Name. I have a form with a command...

Good Day~ Yes I want to bring one Outlook contact information into an Access table. It is bring in the basic information, but I need it to capture the Alias and Display names also. Thanks so much~mjc

Good Day~ I have used the DoCmd.RunCommand acCmdAddFromOutlook, but it does not capture every field value. Can the acCmdAddFromOutlook be ran in a vba code? I want to get one contact's information into the access table. Please advise. Thank you in advance~mjc

Good Day Mr.B~ Based on your database sample, I achieved my code: Private Sub SII_Click() On Error GoTo Err_Handler Dim ctlLB As Control Dim strAstCount As Integer Dim lngRow As Long Dim strFull As String Dim strFormal As String Set ctlLB = Me!LstUnwanted strAstCount =...

Thank you so much Mr. B The database will not appear???? Please zip and upload. Thanks so much~mikki

Good Day~ I have a form with two listboxes. Each list box is based on a query and changes values when selection is change. Only the first column is visible and there are 3 more columns I get values from to update a table. I need a vba code to get one listbox column values so I can put it in...

Thank you for your reply. Will the filter make it print by the individual? I want it to print all forms for Joe Doe then move to Jane Doe print all, then move to Sam Doe, etc. Thanks again~mjc

Good Day~ I have a class roster and need vba code to print a first day package of forms. I want them to print each person's package then move on to the next person until the roster has printed each person's package. Any help would be appreciated~mjc

Thank you for your help. How can this look up be done on a specific ID number? Thanks again~mjc

Good Day~ How can I search through a table and if the record on a main form has certain words it will save a note in a record on another table Any help would be greatly appreciated~mjc

Thank you. I am working with Access is it the same code?

Good Day~ I want to send an email to each division with a pdf attachment. I have output each division's report into a folder but now I don't know how to send each one to each division's email address and attach each of their report. I want to send one email with pdf to one email address...