Search results

Hi guys, I am trying to run a bat file from a 2016 access database and i get an error "INVALID PROCEDURE CALL OR ARGUMENT". The VBA code i am using is attached to a button shell ("path\import_1.bat) Am i missing something? is there a specific reference that is required for running bat...

Hi, Is there a way of preserving the formatting when exporting a report from MS ACCESS to MS WORD? Cheers V

Thank you ArnelGP. this is awesome...

Hi Arnelgp, you helped me with the email attachment post about 2 weeks ago at link below: It works really well! Can you please help include the vba code to set the default signature when a new email is created in outlook? thanks for you help! Regards Viren

Thanks you Arnelgp.This is exactly what i needed. Really appreciate it!

Hi Arnelgp, I am having trouble with the parameters in your code. for the below parameters sTable (string) the name of table where the attachment field can be found ' pkName (string) PK or fieldname that uniquely identifies a record ' pkValue...

Thank you for your prompt reply arnelgp. Let me try incorporate this in my database and i;ll get back to you soon. Cheers Viren

Hello, I am using ms access 2016 and have a table that has attachments as one of my data field s. Each record in the table has approx 6-7 attachments. What I am trying to do is add All attachments to an email in outlook when I open the form to a particular record and click a button. Can...

Awesome!! Thanks JHB

hi JHB, i am having another issue with the unmatched query and i cannot figure this out. i have attached a sample database. i am comparing the config with the inventory and this should bring up values that are not in the inventory but it doesnt. what am i doing wrong? Can you help please?

The query works!!!! Thanks JHB

Thanks for pointing that out JHB. I didnt realise that. Let me revaluate and see if it works after amending the records. Thanks again Viren

Hello All, The attached database has 2 tables, Master and MXI. there are 3974 records in Master and 3950 records in MXi. I need an unmatched query that looks at both these tables and lists the 24 unmatched records . I need to find the record for field "CONFIG_POS_SDESC" in table Master that...

CDate(Q_Induction_Date) < DATE() works.. excellent. thanks CJ _london.. Thanks for your reply Arnelgp & Galaxiom. regards V

Hello, I am after some help with condition formatting a date field in access. The query used for this field produces a date or "NA" based on the formula below. so when the date shows up as "NA" then i have set the condition formatting of the cell to grey and this works works well. but when it...

Hi JHB, The reason for different risks is that when a machine assessment is done it could return all 4 risks depending on the machine use hazards identified or in other instances a machine might show only 2 or 3 risks depending on the hazards input. I have atttached all the requested...

Thanks for your response JHB. I have formatted the bars in design view to represent the colours required for each risk. Your solution works perfectly if the query result returns all four risks., but If the query returns 3 risks or even 2 risks than it chooses the first two or three colours...

Hi, I have a bar graph on a report in ms access that represents 4 different risks ie count on the y axis and risk type on the x axis (low, moderate high and extreme) Question: How do i get the each bar to automatically represent the colour based on the risk colours below? Low: Green...

Hi I have got the export process from Project to Access working quit well. I have a macro that automates this function when i run this export macro it asks me , whether i want to "Append" or "Overwrite "the Data. is there some code that can get rid of this msg box and automatically choose...

Hi, Does anyone have a vb script to open a password protected ms project file ? Thanks Viren