Search results

OK, I see you used an OnClick event to set the value of the TempVar. What if I were to want to store the value of TempVars!Greeting into a table, and have a DLookUp fetch it on the report? How would I store that TempVars in such a way that it would go fetch TempVars!TheName when called? I...

Is it possible to store a TempVar that contains another TempVar within it? For instance: I want to store a line of greeting in a TempVar, and allow this TempVar to fetch a person's name from another TempVar and embed it in the right place. Like this: TempVars!Greeting.Value = "Good...

Hi folks. I have a query that pulls a list of employees that have at least one call-in-sick date from tblEmployeeSchedules. The trouble I'm having is that this query shows me ALL call-in-sick dates for all employees, and I just want the MOST RECENT call-in-sick date for each employee. I tried...

I would have no idea where to begin with the syntax of building the querydef like this. Any suggestions?

Very well, I'll bite... what's the correct question to be asking in this scenario, then? If you're going to point out where I went wrong, why not also offer advice on correcting it? Is this forum not designed for folks to help each other out?

Hi folks. Here's an interesting situation, and I'm wondering if there's an easy solution that I'm not thinking of... I'm building a 'string assembler' form that allows the user to select items from several combo-boxes, and the resulting values get 'assembled' or concatenated together to form a...

Hey there hi there ho there... I have an Access web-database I'm working on for assigning students to classrooms based upon their choices. I have a table of classrooms and the max number of students per classroom, a table of students, and a table of requests. Students can make more than one...

I get Run-Time Error '3061': Too few parameters. Expected 1. I created a new module with this function: Function FetchValue(CardID As Long, CardTopLine As String) As String Dim dbs As DAO.Database, rst As DAO.Recordset If Not IsNull(CardID) Then Set dbs = CurrentDb Set rst =...

EDIT: Thanks, JHB, your method works great on this Single Form for displaying the value I need in that one field on that same Single Form. Now for my next wrinkle: Instead of a Single Form, let's say the form is a Continuous Form that lists all records in that table. How do I modify your...

Okay, I think I need to clarify a few things, and it's going to be a long post. Thanks to you both for the suggestions, but neither is what I need. I spelled out some examples above that were pretty poorly thought out. My actual database is too complicated to try and explain what I need...

Hi folks. I always have unique issues, and you guys are champs at helping to solve them. Here's a tough one (at least for me): I have a query that's fetching records. Works like any other query. In one of my query's columns, I want the recordset to return a value based on a variable column...

Update on this issue... the answer, as folks informed me above, is NO. Out of the box, Access isn't suited to connect to any kind of remote server in the way I was hoping to (at least, not that I'm aware of). Which means I MUST install a new ODBC driver at the very minimum. I chose the Access...

You know, I guess I can mark this solved, even though I never solved the original dilemma. What I did instead was shift around the location of the controls, and that fixed it. Before, I had a Main form with a Combo Box, and below that was a Tab Control with two tabs, and on each tab was a...

Hi folks. A brain teaser: I have a main form called frmMain. On it is a tab-control with two tabs. Tab 1, called INFO, has a subform called ctlPeople. Tab 2, called CARD, has a subform, called ctlCard. At the top of frmMain, above the tab control, there is a combo-box that's set to fetch...

For the love... I just figured out why it's not working for me, thanks to the post above's code example. I'm looking at it and I realize that he is using FORMS as his SourceObjects. The issue is that I was trying to set the SourceObject to a REPORT, not a FORM. When I created individual FORMS...

Nope. Created by me earlier this week on my Access 2010 PC at work. I have now modified the form so the 'CardPreview' control is gone. Now double-clicking the ID in the PersonList opens a popup form, the popup form has ctlCardPreview on it, and on the popup form's OnLoad event, I placed this...

Access 2010

Okay, now I get "object doesn't support this property or method" and it highlights this line: Forms!frmMain!tabPeople.Form!ctlCardPreview.SourceObject = "rpt" & [EmployeeType] EDIT: I tried changing the path somewhat, taking into account what another poster said about the tab control not...

That's just it, the report ALMOST has the same name. It's got a "rpt." in front of it. So if the EmployeeType is "Employee", it needs to send "rpt.Employee" to that control. When I do it like you suggested, I get an 'Invalid use of Me' VBA error. Is that because I put the...

[SOLVED] Set a Subform's SourceObject from a different subform on the main form Hi folks. I have frmMain, and on frmMain is a tab-control with a control called tabPeople. This tab-control has two controls, both on the same tab: ctlPeopleList (a subform control that shows sbfmPeopleList, a...