Search results

So I have 5 staff members that are each assigned patient cases based upon the last name of the patient, but their assignments will also be calculated off of the total cases. So if there are 94 cases, each staff member gets 18 cases. So I calculate the total staff cases load automatically in...

I need to count the total records on a form that is filtered by Staff Member and then within that filter, I need to total all records where the expiration date is 1 week out. I filter the form based upon the name in Column "A" using VBA Code. I can Count the total records on the filtered...

I have been exporting reports to excel, but it brings over all the formating. Is it possible to just send the data that has been filtered in ascii text only to a excel workbook? Here is the code I am currently using. The Form from which the data comes is filtered by a series of 5...

I have a report that I send out each day about Staffing and Metrics. The email staff names and Metrics categories rarely change only the actual numbers. What I need to do is find the previous report in the Sent Mail folder by finding it by the Last Date Sent where the Subject has the Partial...

We collect data on patient transfer in a worksheet name 2022-11-01 Patient Transfer one sheet for each day. We use the CELL("filename") function to read the file name and parse off the date from the file name. From that date we calculate How many days spent in the hospital. We did this...

I was trying to do a quick query that would allow a person to be prompted for the date they wanted to see data... I tried using... "#" & [Enter Date] & "#" but it doesn't work. Can I give a user the ability to select a specific date with a quick query prompt?

So I have a form built from a Cross Tab Query (qAccmpTotCounts) that counts all records for a given Event. [tAccName] is the Event [tEvAccCat] is the Category that the event falls under [CountOftEvntID] is the total number of events the cross tab query calculated for each [tAccName] Now, I need...

I have a form "fStaff" that is populated by a query "qStaff" with over 3000 records. The user can click a button "bCITC" which sets a filter to only show the records for employees who work in CITC. Once they click that filter button on the form to isolate the records to a subset. However, the...

I am trying to attach the current workbook to an email, but when I use the method shown online, it replaces the spaces with %20. I tried building the name and attaching it using the built name but get an error on that. Here is my code. Any suggestions or help would be greatly appreciated...

I have a Named Range of values that I need to lookup a value in as my SumIf identifier for the total. However the Table can have additions and deletions and then be resorted so that the direct reference becomes a different value. I am summing three different values to get a composit total...

I have a spreadsheet that I build a file name from the date and the user and then need to store it to their network folder. I have tried numerous things but can't get Excel to change the current folder prior to executing the xlDialogSaveAs command. Here is where I am... any help would be...

I have a continuous form that is based on a child table so that all records are present. When I use the Count(*) function in an unbound text box on the form it gives me the total count of all records that are displayed on the form. However, I also need to know how many Parent records exist...

I have two buttons on a form that are designed to clear my multi-select list boxes. I was trying to call the first macro from the 2nd button so that I wouldn't have to duplicate the code. I tried the CALL statement which works in Excel but then found a post that said in Access VBA to use...

I have a From that shows a quick list of totals for various aspects of Patient data Table and it's child records. See image below. They are asking now to be able to filter these totals by month or by quarter, and by Pathologist. So my thought is to provide a start and end date and tally the...

I have a form that has 2 unbound text boxes in which I enter vDateSt and the other one vDateEnd I also have a third combobox that looks up the last name of a Pathologist vGetPatho. I have a report that is designed to show all records between the two above dates and the select Pathologist. I...

I often use a timed MsgBox to advise user of events that happen during code execution and always to let them know who wrote the Database or Excel App with a contact email and phone extension. The most common vba code I use is CreateObject("WScript.Shell").Popup vMsg, vSec, vTitle...

I have a form and when I open it, I set the value of my lookup field to a value that intentionally has no records to force the user to click the ComboBox and choose their Department. The line of code being used to accomplish this is: DoCmd.SearchForRecord , "", acFirst, "[tDeptAbbrv] = " &...

I have an Excel Macro that Maps several drives automatically. However, every time the computer reboots, they disappear. I noted that a manual mapping of the drives there is a box to select to "Reconnect at Signin" Is there a VBA command that allows us to select that option?

I am trying to pass the filtered results of a Form to a Report. The Form has a Combo Box that obtains it's data from the tDept Table which has two fields. tDeptAbbrv and tDeptNm Sample Values: tDeptAbbrv tDeptNm ANC Ancillary Testing Autop Autopsy...

I am trying to pass the filter from my from that I selected from an unbound Combo Box to a Report. The Unbound Combo Box obtains it's data from the tDept Table which Sample Data: The code to select the Department is below: '------------------------------------------------------------ 'Show...