Hi fantastic members,
I have created a monstrous calculator for work within my organisation. I have a user inoput screen to get a start and end date so I am pulling variables from there.
What i need is to be able to populate cells starting at A12:B12 with the start date in cell A12, then adding one month and getting that to populate into cell B12.
I need this to continue subsequently until the end date...
benny1983
Last Activity: Mar 6 '15, 02:36 AM
Joined: Oct 24 '14
Location:
-
Need VB code for excel to pupulate specific date ranges
-
A bit of further research and came up with the following which works perfectly!
Code:SELECT DISTINCT tblQAAuditRecords20141.Assessor, COUNT(Provider) FROM tblQAAuditRecords20141 WHERE ((([tblQAAuditRecords20141].[QAQuarter])=[Enter QA Quarter]) And (([tblQAAuditRecords20141].[QAReportSent])=False)) GROUP BY Provider HAVING COUNT(Provider) >9;
-
Using HAVING COUNT SQL to return specific results
I have an audit report that opens based on a query of reviews for a certain quarter that have not been sent.
The issue I am having is that I only want the clients name to come up on my report once the unsent audit count reaches 10 or more.
Here is my SQL so far which works fine - I just need some guidance on only returning the result when the count of audits reaches 10+.
I read about HAVING COUNT however... -
Have a good laugh at my code whilst reviewing it. I do have a current VBA guide I am reading through but I need a fix for this asap and unsure which sections to quickly refer to to get an answer.Leave a comment:
-
Ok, I take your point. Here is what I have done but can't get it to function properly. I didn't quite know how to set a record as active (given this function wont be all performed at once so the focus on an active person will move, the form will be closed but next time you open the form I want it to be the same active person it was prior to being closed).
Trying to think outside the box a little to try and get it to work as there is...Leave a comment:
-
Thanks mate =- coming back to this thread after developing some more of my database. I have a good idea of the VBA but would appreciate perhaps a working example?
Any chance you can write what the code would actually look like in VBA just making up the names so I can get a good idea on how to adapt this to my project?
Cheers....Leave a comment:
-
I'm really stuck on this. Here is my query in SQL used for the report (which I assume I will need given its an SQL part of the code). I just dont know what to enter after WHERE. Ther report itself is based on parameters entered from a dialog box I created so how would I work that into the code.
...Code:SELECT tblQAAuditRecords2014.QAQuarter, tblQAAuditRecords2014.Assessor, tblQAAuditRecords2014.QAConsultant, tblQAAuditRecords2014.[ex-gratia
Leave a comment:
-
Tried again and seems to be all saving now.
Thanks a million for your help!Leave a comment:
-
Scrap that - there is no error with the code (there was an error with my typing).
The only thing is that now, although the action runs smoothly, there is nothing saved in that field of the table.Leave a comment:
-
Thanks for the code. I tried exactly what you said however I got an error : "Object doesn't support this property or method."
Is there something else I need to do to make this work?
Appreciate your assistance....Leave a comment:
-
Saving unbound text box in Table for current record
Hi All,
I have an audit form which has a calculating unbound text box which displays a result at the end of the audit. I understand it's not best practice to save these in the table however I need to secure what the result was at the time of the audit.
I have managed to compile the code to place within the event used when I click the save button. The command button does a number of functions so this is just one of them.... -
Ok So I understand the concept here but I am stuck on what I put in the WHERE section.
To help, here is the code so far to generate my pdf. Once generated I need to update the checkbox box "ReportSent " in the table but only based on the records generated in the report.
Code to Generate the PDF:
...Code:Private Sub Command20_Click() On Error GoTo Command20_Click_Err DoCmd.OutputToLeave a comment:
-
VBA to check a box in table after a report is generated
Hi All,
I'm searching for an easy way to get this to work.
Basically, I have a database and when I run a nd generate a report on the entries so far, I'm after some VBA to check a box in the table to indicate that a report has already been run on that entry (so I can filter these out on future reports).
My code is fine for generating and emailing the report I just need the code to mark it off in the records... -
Works perfectly! Thanks....Leave a comment:
-
Override a text box with a certain value 'On Click'
Hi all,
I have an audit form which calculates a rating based on certain selections on the form.
The final rating is diaplayed in an unbound text box using the following code in the control source:
It works perfectly however, I want the user to have...Code:=IIf([txtScore]<51,"Below Requirement",IIf([txtScore]<100,"Feedback Required","Achieved Requirements"))
-
Sounds good, but I wouldn't have a clue how to do any of that. I have a concept of VBA but not much experience.
What should the code look like?...Leave a comment:
-
Sorry - no problems (still only new and learning).
I'm actually after alternating emails. So each time I send it for review it moves to the next team member and emails them.
Thanks for your help....Leave a comment:
-
Sorry - will be sure to use code tags in future.Leave a comment:
-
VBA to select random email address
Hi All, I have some VBA code attached to a button which populates a report to be reviewed by one of my team.
I somehow need to make sure these requests are alternated between the two team members and therefore cannot hardcode the email address into the code.
Is there any way I can alternate who the email is sent to? Currently I have something like this (note this is part of my code and ot the entire thing):
...Last edited by Rabbit; Nov 4 '14, 12:57 AM. Reason: Please use [code] and [/code] tags when posting code or formatted data. -
Perfect - Thanks very much!Leave a comment:
No activity results to display
Leave a comment: