Search results

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...

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 =...

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 *...

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...