The error is? It is likely associated with incorrectly referencing the combobox properties, although this looks like it may be the first error encounterd in the code you posted:
What is the rowsource for the cbo eName? If it is multicolumn note the order of columns, even those that are hidden...
Try this reference: Forms: Refer to Form and Subform properties and controls (mvps.org)
The two subforms appear side - by - side? Or is subform 2 a subform in subform 1?
If the latter then possibly:
If ename.text = "Tour De Lis" then ' the value for the combo is assumed to be an ID and not...
Normally an item selected for sale will be selected from a catalog, in which a price is set. A quantity is then used to determine the price to be charged. A discount can then be applied to that amount - it may be that the item is discounted 100% and so the amount charged is 0. Do you need to...
That will be determined in a court, I expect, if it ultimately gets to court. However clearly he was seeking to get the result changed and suggested means which did not involve a recount. You give everything Trump says and does the most generous interpretation.
Yeah I think he is stupid, and...
Cmon Pat:
"All I want to do is this: I just want to find 11,780 votes, which is one more than we have," Trump says, according to audio of the call. "There's nothing wrong with saying, you know, that you've recalculated."
Who does not listen?
Are you using the dateadd function? DateAdd function (Visual Basic for Applications) | Microsoft Learn
Use "h" for interval and -number of hours). If you need to deal with minutes then you need to convert and manipulate in minutes.
The time column is assumed to be a date/time data type...
Unsure as to where the text comes from. Are you expecting Dude 2 row in Drivers to have the value "3(W.S.F)" in cell D3, and Dude 6 row in Drivers to show the value "2(F,W) online" in corresponding cell (column D) where Dude 6 is listed, etc?
It would be helpful to attach a copy of your...
You might try comment out the me.dataentry property
The default value for this property is "False" which means that Access opens the form and shows the existing records. However, if set to True, the Data Entry property of the form specifies that the form will only show a blank record. Suggests...
In simple terms - you have two separate databases. They may be structurally the same (table and relationships), I assume. You add/edit/delete data in each. Then you want some kind of merge function where changes made in each (or in one - the laptop) are applied to the other. Then if successful...
Do you mean not to display any records on a form until after the user selects an option on the combobox which filters the records in the forms record source?
Your form on load could have this set
Me.Filter = "(False)"
Me.FilterOn = True
then when you use the cbo ... after update .. you...
A control which presents a calculated value, will carry out the calculation as specified. It cannot be reset to 0 without overwriting the method of calculation. Why do you need to reset to 0 if the calculation is based on a calculation /algorithm which is accurate? To change the value - alter...
If you are able to construct the simple queries, then combining them - finding which phraseIDs are common across the queries of interest combined together should be straight forward. Configurable queries - where you supply a filter value from the form are also viable - you need to think about...
Emma - your form has a recordsource, to which you may be applying a filter to display the required records. The CLEAR button, as proposed would perform an update query against the records in the form, so that the Weight in each of those records is set to 0. Be sure - each of those records in the...
The total weight as Sum(Weight]) is a calculated value summing the weights entered for the records in question. The Clear button would need to delete (set to 0) the weight entered for the records that you are summing. This could be done a an update SQL statement of the on click event of the Cear...
We are very close to a precipice, wearing not a blindfold, but virtual reality goggles. Enjoy your chocolate, watch the show. Hope it does not end up in a shambles when the goggles are taken off.
Duh!.. do you think Trump is stupid and did not understand how the mob would interpret "If you don't fight like hell, you're not going to have a country anymore." Irresponsible at least. You hold him in such high regard. YOU decided to take the view he is dumb then?
You seem to be obsessed about...