Search results

I have a Year field in the Told_Cost_LargeEntity query. I want to allow users to enter in the year criteria in a form and only values between that criteria will be visible in the query. Year 1 and Year 2 are two unbound textboxes in an unbound table. Years is a field in the query with a...

I have created a button to deselect all the option buttons on my form and I have written the following code to automate the button. The code is working in that it’s deselecting all the option buttons. My problem is that the option buttons have an embedded macro that is used to run update queries...

I have two checkbozes on a form. i need the checkboxes to be clicked or activated only if the user clicks the box. Right now if I click one box the other box is getting selected too. Any way around this?

I have a bound checkbox on a form. the checkbox is bound to a field in a table in access. The field has the Yes/No datatype. if a user clicks the checkbox on the form, I want the checkbox to tick only those records in the field based on the filter criteria I have set on the AfterUpdate event of...

Hi, I have an excel linked table in access that updates according to the excel sheet. I need to extract the update data into a new table and assign a primary key to that table automatically so that i can used the data obtained from the excel sheet into converting foreign currrency into CAD...

Hi! I want to add items from one listbox to another listbox. I have tried this code but the code is throwing an error. Can someone please help. thanks a lot! Private Sub cmdAddOne_Click() ListYesItems.AddItem ListNOFLE.ItemsSelected ListNOFLE.RemoveItem ListNOFLE.ListIndex End Sub

Hi, I have created a Text box to search and select the contents of my list box. I will be searching for multiple costs and would like to save the original selection when the search column goes blank. Eg: if i type china in the text box, the list box should list everything with china in it...

Private Sub ListCountrySE_AfterUpdate() Dim varItem As Variant Dim strSQL As String If Me.ListCountrySE.ItemsSelected.Count Then strSQL = "Select ID_Number, Nature_of_Fees from TotalCostsSmallEntity where [Country] in ('" For Each varItem In...

Hi! Can I use a form to simultaneously fill in multiple records in a table based on a single input ? Like if I put the claim number as 50 in the form, I want the Number of Claims in the table with multiple ID's to simultaneously update to 50. Thanks for your help!

I need help omitting a field from a report upon selecting a macro, using an expression or code. Report has a record source and the user may not require the filed sometimes. so I would like to have the field not displayed in the report through selecting a command. The field is a 'Fee' field...

I have a list box that has years (ListYears) in it and it is used to sort the years on the report based on selection. Currently if you want four years of data on the report, the user has to select 1, 2 , 3 and 4 on the list box to get that data. I want to create the row source of the list box...

Hi, is there a way to create cascading list boxes in a form? both the list boxes draw data from the same table and they are extended list boxes for multiple selection. List Box 1: Years List Box 2: nature of Fees. I want only those fees to be visible that are connected to the selected years...

This is the code Private Sub Command2_Click() Dim strCountry As String Dim strFilter As String Dim strYears as Long ' Check that the report is open If SysCmd(acSysCmdGetObjectState, acReport, "Patent_Cost_Forecast") <> acObjStateOpen Then MsgBox "You must open the report...

Hi, I have a database of patent costs in access 2016. I have created a list box on the report and would like to sort fields on the report depending if the list box says yes/no. Thanks for your help in advance.