Search results

Running this code the application throws an Error 91: "Object Variable or With block Variable not set" when it hits the "Set rst to..." line. Viewing strSQL in the Immediate Window, "Me.cboDonor2Report.Column(0)" is resolving to a valid ID value. If I create a new query and copy the strSQL...

I've changed computers and all the buttons in existing applications, AND newly created ones overflow their bounds with style. Why? and how to fix? See the attached image.

I have an Access 2013 application created on a PC. Can it be run on a Mac? If so, what steps are needed to transfer it?

Can't figure the SQL to UPDATE a table (tblAccomResv) with columns: AccomID and DtBooked. It will be an empty table. I need to populate it with one record for each record in tblAccomodations (ID) by each record in tblEventDts (EventDts). Like: Room1 Dt 1 Room1 Dt 2 Room2 Dt 1 Room2 Dt 2 etc.

Let me try this again... On a form I will have a dozen or more checkboxes that determine if specific documents are required for this client. Each checkbox will have "associated" with it one or more other controls that hold data about when that document was sent, received, the score, etc. The...

***SOLVED*** see end of thread Three tables: 1) People with all the usual demographic fields plus a "Selected" field 2) Groups: ID, GroupName 3) PeopleXGroups: PeopleID, GroupID I have first set all "Selected" field in table 1 to False I need to create an update query that sets the "Selected"...

I allow the user the option to set a header image (Company logo) in their reports. To implement it I dynamically set the values via the Report's Open event. Here's the code: With Me.imgLogo .Picture = Application.CurrentProject.Path & "\" & TempVars!LogoFile .Height = TempVars!LogoH...

The Report prints Contributions by a single donor within a date range. It has an "Addressee header", grouping on DonorID that displays the company's address block, the Donor's address block, and then column descriptors. The detail section prints below that. On all pages after page one the...

I'm in need of a bit of report layout wisdom. The pertinent database tables are Donors and Contributions. The Goal is to print out a report for each donor listing their contributions for a defined date range. Each donor's report will have a header naming the non-profit doing the reporting (all...

In a Report I'm using DAO to pull some header data from a Company table. Assigning the value of a field (like Company Name) to the Caption of a label works just fine. But one field is variable text and may need to grow, so I'm using a textbox (txtDescription). The code below throws an error...

Two queries acting as RecordSource for a report: 1) gives donations for all donors within a pair of dates 2) is further restricted with second WHERE clause to only show 1 donor The report (when using the second query) pops up a modal box asking for the value of ContribDt. Why?? Here's the...

I know I've seen this, but can't find a reference... I've just added a new Name to a clients table in a modal popup form and want to grab its Autoincremented ID value to return it to the calling form.

I'm adding a field value (Addressee) to some text in a Label... Label.Caption = "Initial text " & [Addressee] Problem: If the name contains an ampersand, like "Joe & Sally" the "&" shows up as an underscore. Tried to escape it... no joy Tried "Joe " & Chr(38) & " Sally"... no joy I can...

Just ran across a function that has these lines of code... What is the "@" doing? Const Thousand = 1000@ If (N = 0@) Then

Assume a form (myForm) containing a combobox (cboName). Also on the form is a tabControl (TabCtrl18) containing a subForm (sfrmItems) on one of its pages is a textbox (txtName) I have successfully set txtName = cboName.Column(1) when the user clicks on the containing page of the tabControl...

Got an unbound textbox holding a date with an onChange that updates the WHERE clause in the RecordSource to show only records for the set date. Works perfectly if the DatePicker is used, however, if the user enters the date by hand with each keystroke I get an error msg. WOULD YOU... 1) dump...

Is the Btns() an anonymous function?? Can you point me to the correct description for it. It was in a great bit of sample code by forum member r.harrison for his formatted Msgbox: BtnPressed = Btns(MsgBox(.....) Select Case BtnPressed Case Btns(0) etc