Search results

Sleepless night over this one, Help me out Guys. We have clients who have a fixed anniversary date. This date never changes but comes up for renewal every year and is stored in an anniversary table linked by the form. Every year we create a new record for the client, run through the processes...

the control is on the subform with the button also being on the subform. i am a novice on access and GTHs last comment doesn't make make any sense to me.

I am getting Syntax error comma in query expression. here is my line in the updateline of query. cant seen to see what would be wrong with this. Round([Standard_Rate]*(1+Nz(0.01*[Forms![Rates_Templates_Mainform]![Rates_Templates].[Form]![Percentage],0),2))

Thanks, yes it will be a form control text box and an update query so they can input the percentage in the txt box and click a button to run the update query and change the values.

I am looking for the correct syntax in my query to add a percentage to a value. so i have a [Standard_Rate] in a table and i would like to have a column showing the percentage increase based on a field in a form. so if i insert 2 into the field, the query will return the value + 2%. i can...

Worked a Treat.. THANKS!!

Any help out there!!!

I am exporting some query data to a word document using bookmarks. I can export text fields fine but rich text fields are problematic showing the HTML formatting when inserting into document. I need help with my existing code to convert this to text. The field in question is [CV_Intro] Here is...

PBaldy, yes this worked by adding Eval to criteria in Query.. thanks everyone for your input.

yes the query does have a par to a form. I am not familiar with the eval() Fails here: Set rs = db.OpenRecordset("Select * from Qualifications_Selected_Individual_For_NEWCV")

I have a module which looks at a query that has 3 records. i am trying to input this data into a single word document setup with bookmarks. Getting error 3061 too few parameters. Expected 1. Any help would be appreciated. Public Sub ExportCVToWord() Dim wApp As Word.Application Dim WDoc As...

Thanks for the pointer.. got this working by creating the cross tab query with value grouped by "last". This gave all values on the same line and i simply added this query to the existing query feeding the form then added the fields. Thanks Again

I have a query feeding a report that shows an individual with different Courses and dates. On the query it shows each certificate as a record. E:G Joe Bloggs, Induction, 10/01/19 joe Bloggs, First Aid, 12/02/18 Joe Bloggs, Manual Handling, 05/11/17 I am looking for a way to show this on a...

Worked Perfect.. Thanks You !!:D

I am trying to set criteria of query2 with the value from a combobox. At the moment the code will fill the criteria with the form field location but i need the criteria to show the actual value. so if my combobox shows value 193 and i run the code, it would add 193 to the criteria. can you...

I have code that looks at query 2 and extracts all the email addresses into outlook. The code does not work when the criteria in query 2 reads [Forms]![Personal_Details_Form]![Job_No_Combo] it will only work if there is a static entry like say 100.

I am trying to use code that will change a static criteria value in a query depending on what is selected from a combo box value in a form. I know i can have the criteria field looking directly at the form but this doesn't work when i am looping the query. The code below looks at the query1...

I have a macro on a button that exports details in a query to excel. Is it possible for the macro to enable column filters within excel when exported? currently i am having to do this manually.

Tried that Application.FollowHyperlink "C:\Program Files (x86)\Google\Chrome\Application\chrome.exe" - -profile - directory = "Profile 3" but get the error: Run-time error 13 type mismatch

I am using google chrome profiles and setting up about 15 profiles. each profile has a shortcut link that opens the webpage. Instead of having shortcuts on the desktop i thought i would create a form in access with buttons. each button will be linked to the corresponding shortcut. cant get...