Search results

I sure did, thank you. In fact, I released the DB a couple weeks ago and just gave them a few more features today. I have 2 more reports to go and it's done. A lot of it was fixed by using global variables to pass values and then having it write to the record as an append if new - show on...

Hi there - I would like the same ability in two different flavors. First is a situation where the User can export the reults of a MakeTable to a .txt where they control the name and file destiny with a dialog box. Second is a situation where I have a Macro built that exports two different...

I have a small Table that needs to be set up LIKE a CT Query in that I need the Elements to become Field Headers so as to have 1 record with Caseno and Result(s) by Element. Problem: I do not want them grouped as I really do need to see the result (not summed or counted) and the patient...

I figured this out - switched to SQL - something I am comfortable in and qrote the query the way I wanted it and then switched back into Access and saw how their design query handled it. Adds three columns on the end with my IsNull statements from my SQL where clause, then sets Criteria in the row.

Where all the fields are grouped? I have the two feeder queries Grouped on every field except Duration (summed).

I need help with a comparison query - Two tables [ClientTime] & [EncTime] Fields for Cost_Center, ClientNo, SvcCode, SvcDate, SvcDur. ClientTime has 374 records. EncTime has 50. I need to peel off those 50 from ClientTime. I have tried a simple join for Cost_Center, ClientNo, and...

In Access 2003 I am needing to make a report that has a row across the top which pulls from the field [Elements] and I would like them to display vertically. I have tried in both TB and LB. I also need [Caseno] to display down the side with no repeats. Might I be better off exporting...

Thank you all for your help. I was able to use code to change the source depending on which form was trying to build the report .

Here's what I have so far: From the Call to open the report. If Prepare_Report_Format(Me.User_Echo) = True Then DoCmd.OpenReport "Activities", acViewPreview, "Alt Activity Feeder Query" DoCmd.OpenReport "TimeStudy", acViewPreview...

I have a report that has a data source of the query "Activity Feeder Query". Week is defined as [Forms]![User Entry Form Tabbed]![Week]. That worked great until I needed to create an administrative interface where the report would be called outside of the user interface. I have duplicated...

Thank you so much for your reply - My DB is too large to post - even zipped. I made an append query for the MandatoryPOI data that needed to go to the Findings TBL and slapped an IF statement around it to look for the AuditItemsID to make sure a POI wasn't already in place. I already had all...

OK - I tried to post this Monday and everyone said I needed to have bound controls. That isn't going to work with a prefilled form. I have a form that has the following controls predefined based on a selection of a Listbox: Me.AuditElementTB.Value = CStr(Me.ElementLB)...

Hi Guys - So - I have a little form that needs to write to a table. The TBL name is "Findings" and is set in the form source. I am getting an error on the DoCmd.RunCommand acCmdSaveRecord - which I wasn't like 15 minutes ago. What did I change??? Nothing. Atleast in this module. The...

Paul - you are a GENIUS - and guess what? I do know who John Galt is. And if you are organizing the island - I am there. :D

Good Morning. I am trying to tackle a DLookUp with double critieria. Me.MPOIAuditItemsTB = DLookup("AuditItemsID", "FindingsElements", "[Element]= '" & Me.MPOIElementTB & "'" And "[AuditID]=" & Me.MPOIAuditTypeTB) I can get it to work before the And and if I strip it out, after the AND, but...

I have a database were employees log all of their daily activities for a month out of the quarter. This information is parsed and sent to Medicare for verification of services provided. I have a form named Update Staff. One of the Controls on Update Staff is a Delete cmd to be used if that...

Thank you so much. I saved it to my favorites!

Thank you guys - It worked and all is happy. So - if I have it right, if both are values (numeric) then they don't need all that single quote double quote stuff, right? But if they are strings then I have to have all that.

I am trying to get this DLookUp to give me a date. In the Audit Table, there is an Auto ID Field AuditID and of course the date fields for the beginning and ending Audit date ranges. CheckAuditSDate is a Global Variable needs to be populated with the start date from the Audit tbl...

Hi Bob - I wrote a macro and it's great. Thanks for all your help with this!!! I really appreciate it!!!:)