Recent content by amarton

Thanks this is clear now. Thanks! I have very similar, without the roles, I kept them into separate tables. To only question is when a new site is created on the form with new site contact how it will update the table and how the names and the details will appear on the Site tbl... probably I...

The report is based on the siteID, that is driving the selection and I have the bound control for the date. I tired this 1st: Private Sub SaveAppendixTest_Click() DoCmd.OutputTo acOutputReport, "Monthly Appendix", acFormatPDF, "C:\Users\axyz\OneDrive\Desktop\" & SITEID & BILLINGMONTH & "-" &...

This is the only pending issue I need to fix, but it is in use. All to other functions are working fine (which are not included in the example). All the forms, exports, import, macros are perfect, only this name duplication is giving me a headache :D Probably because it is wrong to do and I'm...

I'm sorry, I don't 100% understand what do you mean. I have the site contacts in a separate tables (4 actually based on the contact type). The way I see it working is that when a new site is added, the company is selected from a combo box, to create the link between the site and the company...

Should not save company name in b_Site_Details, only company ID. = I know, but this is the only thing I can't convince the customer to get rid of Don't use spaces or punctuation/special characters in naming convention. CamelCase is better than ALL CAPS. = I'm working on this Don't build LOOKUP...

1 company have multiple sites

employee is a normal combo box, but I removed it from the db company field is lookup here it is! thx in advance

Thanks, I will send it soon.

Hi, I have a form what I would like to export out to PDF. I tried 2 different ways, both is working, but I get stuck, when I would like to include a date. The current code is this: Private Sub SaveAppendixTest_Click() Dim SITEID As String Dim fileName As String Dim pdfFilePath As...

Hi, I have the following issue and I can't find a satisfactory solution. Pls note I have not looked into VBA to solve this, so I might missed the obvious solution. I have a form, where I store all details about a site, including the parent company name. The original version of the db, which...

issue is resolve, partially. as I find out, the "Invoice" is not the invoice, so they don't need to be generated, just needs to be viewable. Instead of this, I created an Invoice export, what goes in to XERO, where the invoice is generated and distributed automatically. Thanks for you help.

You are right. What would be the best code to do anything like this? My problem currently is that the invoice report is not filtering for the customer and the date together. It only does one or the other, but no idea why.

You are absolutely right, but they are not there yet. The project started to replace the manual excel invoicing process with some automation, which is partially working.

The way I did it is the following: - created a site form, with all the details - created a subform, which collects and displays the billable activities - added a time filter on the form to select the date range - created a query, which is using the SITEID and the date range filter from the site...

Thanks, I will prep the db later today and share it.