Search results

sounds like you need a form and subform... use the Master client table as your main form with the klantnummer as the unique ID Then attach the subform and link the fields for klantnummer on Main and Child form. Then you should be able to pick your client and the subform will show all...

You guys are great! Thank you for the insight! :) Larry

Hey Everyone! Why can you NOT use the ONCURRENT function in an Unbound form, with an unbound subform? I have form that is basically a dashboard look...it has a list box of donors that have expenses to them. When I click on the list box, I wanted the subform of the unbound form to change...

Hey David, How would I send the same report to Excel? When I put this in I get an "empty" excel sheet but the report shows just fine. Dim db As DAO.Database Dim rs As DAO.Recordset Dim strWhere As String Dim cn As ADODB.Connection Dim pad As String Set cn = New ADODB.Connection...

Awesome! Thank you David!!!

Thanks David!! i was wondering why the ReferOrg wasn't showing up correctly... So how would I set the report to the rs in the VBA? right now it's set to a query... or do I even need to do that?

Hey everyone, I playing around with search forms and would like to know if you it is possible to use the declared rs (recordset) as the base for the report. the Docmd.OpenReport doesn't seem to support this or i'm doing it wrong. Probably the latter. The rptPatientInfo is one query with...

My Bad Brian...you are not invisible! I apologize! :) Thank you to you both!!

I'm on it...I'll post some code if it doesn't work. Thanks vbaInet!

I have a report that people put a location in as county but labeled like this: Some type of event - Countyname County How do I get just the "Countyname County" so I can group on that in a report? Larry

Done... Thank you CBrighton!!!

Dang it!!! I had tried it that way but it didn't work, of course it works now!!! Thank you! I'll worry about the formatting next This is what came up... Please see list of invoices...

Hey Everyone! I have an email code that works but will not list the invoices that are due. I have a loop that looks at email address' and adds them to sToName line. I have a static message that will need to list the outstanding invoices at the end of the statement. That's where i'm having...

What about in the query for the report? I've deleted fields before that were on a sort and that field showed up in the "properties" portion of the query. may want to check that. :)

What about just printing the form? if it has all the information in it? (just a thought) I haven't upgraded either... :( (still on 2003)

I think I have it....there's been a lot going on with an Audit in the office and my brain has stopped for the time being. I'll post my solution to see what you think and/or see if there is a better way. No Perm: no permission for donation ME: medical examiner :)

There is no table structure yet. I have to build that or a view in SQL. Just looking for ideas on the best way to handle that. :)

Hey All, I have a spreadsheet that will no longer be used after this month due to the new year. We are capturing all the data now in an SQL database through a website. I need to re-create the report the Access but will be creating functions in the back end to count each "outcome" (column...

Thank you!!! I'll modify it to come straight from there.

Great! Glad I could help. This forum is AWESOME...lots and lots of good stuff here! (better than books!) Larry