Search results

Hi Pat, generally you would want to check if the passed WHERE argument is null or empty before you send it for execution to a report. You could simply protect against the Null argument by "EmpID='" & Nz(Me.cboFName.Value) & "'" and then in the report check if you have a "No Data"...

Have you triedMe.frmServiceContinuity.Form.chkContinueYes.Value = True? Best, Jiri

You could put the buttons inside a frame on the form (eg "frClickedDate") and then extract the value of the selected one in the frame's Click event simply as SelectedDate = "d" & Cstr(frClickedDate) How to set up a frame : https://msdn.microsoft.com/en-us/library/aa241724(v=vs.60).aspx Best...

You can't have two values in textbox b. You'd have to create an event (Button click ?) that modifies textbox b, like textboxB = textboxB + Eval(textboxA) Best, Jiri

It is possible, sure, an it's a good idea. But if an expiry date can be calculated by a formula (the life of the product seems to be a constant from what you write), and it is say the last day of the month that is 12 months from today, then you don't need to enter anything. The date could be...

Paul is correct. You will not be able to get the unbound textbox carry a value dependent on the current row. The quickest fix would be to redefine the field as "calculated" bound field if you use A2010 or later. Best, Jiri

In the alternative, you may pass the variable (that you extracted with the Input box) in as the "WHERE" argument for the report, e.g. DoCmd.OpenReport "myReport", acViewPreview, , "[Route Number] = routenr" where [Route Number] is the field that you want the report on and "routenr" is the...

Hi Carl, for starters I doubt that the DCount statement as you presented it would execute at all: DCount("[ID]","Works Orders","Operations Confirmed Date=[Forms]![Work Orders New]![Operations Confirmed Date]") You need to use square brackets for fields that have space in their names. The...

Doc, this is arguing past my point. Can you give me one example where, a) the bang used with a form does not signify a member of its default collection, i.e. the form controls, and b) where the notation Form!Control does not return the same thing as Form!Control.Value ? Much obliged. Best, Jiri

Right! :D I am trusting by nature! Best, Jiri

You are welcome. Best, Jiri

Is the Form [Invoice Payments] loaded? Best, Jiri

FYI, jleach: this is incorrect! You never need to use the .value property when using the "bang" notation to an object. Read here: http://bytecomb.com/the-bang-exclamation-operator-in-vba/ Best, Jiri

Darrin, make sure you consult some sources before making categorical statements ! https://bytes.com/topic/access/answers/900155-how-run-procedure-database-code-another-db bah, see above for an example. Best, Jiri

I am with missinglinq on this. Use the form's BeforeUpdate event and cancel if the text is not entered in the individual controls. Change the code to the following:If Nz([First_Name])= "" Then ' catches Null and zero length string MsgBox "Please enter your first name.", , "...

Run this in the form's BeforeUpdate event: Select Case Left(Me!Myfield,1) Case "5", "8", "9" 'Do nothing Case Else MsgBox "Field may only start with '5', '8' or '9'" Cancel = True Me.Myfield.SetFocus Exit Sub End Select Substitute...

It's not as bad as that Doc, is it ? :) ' Function generates next code in sequence ' to a passed argument in the form of ' ZZ-000001-0001 Public Function GenInvCode(gnIN As String) As String Dim oo As Variant, a As Long, b As Long, pfx As String, om As String pfx = Left(gnIN, 2) a...

Some questions to consider: 1) Does the data on the surface supersede data in the main database. In other words, if records with IDs exists in both dbs, which are the records that prevail ? 2) Do you have the cutoff points for all tables (IDs) after which the databases were separated ? 3)...

Yes, I would recommend creating a table with the tanks as rows, e.g.: ID, Tank Name/Desc Opening Balance Date (of Opening Balance) Your second table then would register all the transactions against the tanks, i.e. the date, transaction description amount added or consumed. You could get the...

Hi, to begin with, you would be much better off to redesign your inventory table to have each tank as a separate row in the table, and not as a column (field). Best, Jiri