Recent content by lmcate

Thank you lameid. I can be more descriptive: 1) I create an online menu called company links (company.htm) which displays a menu to many sites, Google, vendor sides at the bottom of the menu is there a way to put local server links to open an ACCESS database like vendors.mdb on the same...

Hi There: I have a Web Page (html) with links to different sites and I will like to create a link to look in server and open it, rather than download it. any tricks will be appreciated. Thank you in advance, Sam

Hi There: I have a web page .html with links to open different site. On the same page would like to open an access .mdb file via a hyperlink. Any guidance? Also, we use office365- can I be done with a menu in SharePoint. If yes any examples. Thank you, Sam

Hi There: I have an Html FAQ Page with Questions and Answers like this I would like to to a collapse and I don't have the css/java code to do it. ☻ What are the fees for parking? ♦ The fees are $20 a day ☻ What are the store hours? ♦ The Store Hours are M-F 10-6 Sat 10-5 Sun...

Hi Lameid: My goal is to have each employer and their employees with stats written to a PDF what the report above makes 5 PDF's with all 5 Employers for each employee. Perhaps my query. This is my goal FIRST PDF Employer A.pdf Employee xx1 xxxxx Employee xx2 xxxxx Employee xx3 xxxxx SECOND...

Hi I have a report that will create multiple PDF'S per Agency with the employees data. and what I want only each Agency information per page and have a break. So each PDF (5 PDF) with each Agency and with their respect employees. What I am getting is 5 PDF with all 5 employee data in a single...

Thank you Andy, The debug don't display anything. I get 5 Individual PDF's with the correct PDF filename with every agency's information. (a total of 5 agencies Agency: A -- has the data of all 5 agencies B -- has the data of all 5 agencies C -- has the data of all 5 agencies D -- has the...

Hi I have a report that will create multiple PDF per Agency and what I want only that Agency information on each page. I am getting everyone's information for every agency. Here is my code: Private Sub Label315_Click() Dim db As DAO.Database Dim rs As DAO.Recordset Dim rsEmp As DAO.Recordset...

Andrzejek, Thank you again. The problem is that I generate a table on the fly with only 5 or 6 vendors. But the report aspect it picks every vendor. I would like to limit with a filter or do loop. do you have a sample? Sam

Andrzejek Thahk you so much. Do you have a sample of vba that I see?

Andrzejek Thank you for your response. The Employer names are reading in the VBA. However, when the report runs the data comes from a query. Also, I believed that query should be used instead of using the table in the database?.

I having problem getting the filter right. The table is Agency_hours and the field is employer. There are 5 employers with employees. The report runs for everyone. Thanks Private Sub Label317_Click() Dim rs As DAO.Recordset Dim rpt As...

Hi Andrzejek: Thank you, Actually I have a query I would like to use instead of the table (Agency_Hours). I just did the table because this is what I know. the query is called timecard_by_employer so I have 5 companies and my query makes 5 pdf's with all the information for all the employers...

Thank you in advance for guide me. I have a tabel called Agency_Hours The unique field is employer. My current script creates the PDF report with all the Employer totals, I think I need to validate if the employer is new. Here is my code: Private Sub Label315_Click() Dim db As DAO.Database...

Here is the Code that I have so far. I makes one Single PDF Private Sub timecard_agency_daterange_Click() On Error GoTo Err_timecard_agency_daterange_Click Dim stDocName As String 'Save report to local drive Dim strFile As String strFile = "W:\Call Center\Call Center...