Search results

just add the Format YYYY/MM/DD to the Format property of those two textbox in Design view, no need any code on afterUpdate event.

I always got that thought that most, if not all (except George of course), are pedophiles..:unsure:

why do you think Access is a bane to you?

you can do it on the PrintPreview of the report (only). plus you you will have extra space on the bottom. see Order report (Detail_Format vba).

you may also try to Paste this on SQL View: SELECT tblConcernFormSubmissions.* FROM tblConcernFormSubmissions LEFT JOIN tblPlaceConcAll ON tblConcernFormSubmissions.ConcernID = tblPlaceConcAll.FormID WHERE (tblPlaceConcAll.FormID Is Null)

yes it will. most of the time RecordsetClone will fail, so better use Recordset: With Me.Recordset .FindFirst "ContactID = " & lngNextContactID Me.Bookmark = .Bookmark End With

the question is how do you Requery when a record is updated? you should only requery the Recordset (not the Form), so that the recordselector stays on it's position.

open ReportParam form and select which employee and start of week to print (report). select start of the week based on what records you have on your table. you also need to Re-Link your tables.

he only wanted this task.

i changed the code, in case there is only Morning or Evening puch (undertime).

I only calculate on two records (am and pm punch), as explained in post #1 of the OP. there will be max of 2 records for each emp per day.

you create a function (see Module1) on the demo db. then you call the function within your Query (see Query1). note the Query is Sorted on EmployeeID and TimeIn.

on Table design, change Outcome to Short Text.

goodbye my friend it's hard to die..🎶 just make frequent backup. just remember it's your db, you own it, nobody tells you what to do. and if it is not broken, don't fix it. at the end of the tunnel, there is light and i'll see you there..

that is very small number i would say. Aim high, the more the merrier.

try to analyze the code. the first PixelsNavPaneHeight is the height of the "Tab" of the form (tabbed form). then on the last it add it to get the "real" navigation pane height. i cannot find the original code from the author since he already retires from msAccess.

sorry I can't replicate such error. Many have downloaded it, but only you mention such error.

minor change, adding background color to the form and changing the font of the listbox (on frmMVF) same as the font on the combobox. still working on the pop-up placement (the pop up should not go beyond the bottom of the screen).

i think, in real life, you will only select small number of items. i made a demo, somewhat same as you post on the snapshot.

i tested it, and it did not occur to me the foreign characters. although the string is truncated in display. there is a Note on the ConcatRelated function, have you read it? also, we are using combobox and not textbox. for combobox, i don't know the limit of text.