Recent content by schu7044

Avelino: your video's are spoken in English, but the database is not. Is this just an example?

I changed the function to a sub, and get the same message. I will attempt to attach the DB to this post. Thank you so much for your help.

I am attempting my 1st Ribbon. I have the USysRibbons table set up and I’m using the following XML: <customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui"> <ribbon startFromScratch="false"> <tabs> <tab id="tabEntryForm" label="Entry Form Options">...

I am attempting to sue an SQL statement to filter a query. I am using this statement: strSQL = "SELECT * FROM qryGroup WHERE Left([TxGroup],3) = " & strGroup & " AND ActiveInGroup = True" & ORDER BY [SSAN]; Everything works until I try to use the "Order By" criteria (this is where I get a...

Hi All: I am working on a report using VBA. I am able to open and filter it (finally). Now I am looking at adding some bells and whistles. I would like to have the label in the form header display the name of the group which is contained in a variable strGroup. I have tried several different...

I copied it right off your post. Don

Thank you Bob. It does simplify things to do it this way. However, I received a syntax error: missing operator Don

Hi All: I am attempting to open a report in Access and set the recordsource using VBA. Here is the code I am using: Reports!rptGroupNoShow.Report.RecordSource _ = "SELECT * FROM qryGroup WHERE Left([TxGroup],3) = " & strGroup & " AND CIANoShow = True " _ & " AND ActiveInGroup =...

Okay, it didn’t take me long to get stuck. Here is the code to set the RecordsetClone—which works: With Forms!frmGroupMain.frmGroupSub.Form.RecordsetClone I am receiving a “variable not defined” error on line 3 below. 1. Do Until .EOF 2. 'Date the Appointment was Missed 3. If...

Thank you! This worked beautifully! I will move to the next phase and let you know when I'm stuck again. Don

Hi Everyone, I am using a form and subform for user input. I have set the recordsource for the subform using VBA. This recordsource is based on user input entered via a combobox. The following code works very nicely to set the recordsource: Forms!frmGroupMain.frmGroupSub.Form.RecordSource =...

I am using a form and subform for user input. I have set the recordsource for the subform using VBA. This recordsource is based on user input entered via a combobox. The following code works very nicely to set the recordsource: Forms!frmCiaGroups1.frmCiaGroupsSub.Form.RecordSource = "SELECT *...

Yes!! Thank you! Sorry about not identifing the error line, but you nailed it. Thanks again, Don

Hi: I am new to this forum. I hope someone can help me out. I am attempting to set the recordsource for a subform using VBA. I am receiving the following error: Compile error: Syntax error I am using the following code: ' Ensure a group has been selected If...