User Profile
MariaBarnes
MVP
Joined Nov 20, 2017
User Widgets
Recent Discussions
Re: Adding a total to a form
I think you need a 2 step process. #1 develop a query that has parameters that filter on 3 fields on your form and returns only the hours for that participant during your reporting period. Something like the below in SQL format PARAMETERS Forms!frmParticipant!txtParticipantID Int, Forms!frmParticipant!txtReportingPeriodStart DateTime, Forms!frmParticipant!txtReportingPeriodEnd DateTime; SELECT tblParticipantHours.HoursSpent, tblParticipantHours.ParticipantID, tblParticipantHours.ParticipantDate FROM tblParticipantHours WHERE tblParticipantHours.ParticipantID = Forms!frmParticipant!txtParticipantID AND tblParticipantHours.ParticipantDate BETWEEN Forms!frmParticipant!txtReportingPeriodStart AND Forms!frmParticipant!txtReportingPeriodEnd; Then on your form have an unbound field to display the total hours thus far for your participant. In the ControlSource field use something like =DLookUp("Sum(qryParticipantHoursPerPeriod.HoursSpent)", "qryParticipantHoursPerPeriod")1.1KViews0likes1CommentRe: Transfer ACCESS file to new ACCESS on new computer
The computer that you had the ACCDB (or older MDB) files on has those files stored on it. Who did you buy your new computer from? Usually a vendor can help you transfer data from an old disk on a broken computer to a spot on your new computer.1KViews0likes0CommentsRe: Access automatic calculation is wrong
Unfortunately Access 2007 is out of support. These are the older charts. You are likely out of luck getting any support as to why the trend line equation for logarithmic is not the same as Excel. You do not say how you are using this inside of Access. Have you considered linking to an Excel workbook and displaying that graph instead? Or exporting your data to an Excel template and updating the graph end series?3.8KViews0likes1CommentRe: Primary key sequence defined by selections from a Lookup Table
You should be able to use the BeforeInsert event of your form to accomplish this. You will also need a Seed table where you store the last used value for each of your sequences. On the BeforeInsert event, get the appropriate Seed number, increment it, and use that for your primary key. You probably do not need me to tell you this, but the type of the Primary Key should NOT be autonumber...768Views0likes1CommentRe: Create Outlook meeting from Access VBA
Jill, you should be able to set the following items to make the meeting use a recurrence. This assumes you have already set the .Start to a 2nd Monday date. FYI the GetRecurrencePattern returns either a RecurrencePattern already setup or a blank object and then you can fill it. Dim oRecurrence As Outlook.RecurrencePattern Set oRecurrence = myMeeting.GetRecurrencePattern With oRecurrence .RecurrenceType = olRecursMonthNth .PatternEndDate = "12/5/2022' End With Also see https://documentation.help/Microsoft-Outlook-Visual-Basic-Reference/olobjRecurrencePattern.htm for more info about different types of recurrence4.8KViews0likes0CommentsRe: Create Outlook meeting from Access VBA
Jill, I think you are very close. Instead of calling Application.CreateItem, create the item directly using oFolder.Items.Add So instead of Set myMeeting = myOutlook.CreateItem(olAppointmentItem) try Set myMeeting = oFolder.Items.Add(olAppointmentItem)4.9KViews0likes5CommentsRe: Balance with Max
The approach you should take is a two step approach. In the first query, leave out the Balance and just group by letterofcreditID. Then join that query to your qrybalLC query on MAX(qryBallLC.ID) = ID to get the correct Balance and the ID for the letterofcreditID.1.9KViews0likes0CommentsRe: 03 Access output to Excel truncates data
Sorry Donald. I was on vacation last week. On 4/5 the team did respond to me. They say "there are some issues here we need to investigate. I can’t give a timeline for addressing them, but I can say that I was able to reproduce the problem, and that we will investigate." That may not be exactly what you are looking for, for the short term, but the fact that they can easily reproduce is a good indicator that it will get fixed.5.3KViews0likes1CommentRe: secondary Axis problem
Good morning! Microsoft has a nice writeup on modern charts with descriptions on how to use a secondary axis. I recommend taking a look at https://support.microsoft.com/en-us/office/create-a-chart-on-a-form-or-report-1a463106-65d0-4dbb-9d66-4ecb737ea7f7 and if this does not fix your issue, reply back with screen shots of what your chart setup is.1.1KViews0likes0Comments
