Search results

Say I have a table with 16 records and 23 fields, and some of these are to be populated with data from a second table, how does the PK (or FK) or query put that data where it's wanted? e.g. so rows 2-8, col 3 shows "Fred".

Thanks Mike, just give me a little time to organise an upload. I'll be very interested in what your say as I've just found (although it works) at times the Forms are empty, when they shouldn't be, but I haven't yet found when or how. And if course, it always ok when you want it to show a failure.

It's very good of you all to be so helpful, thank you. Doc Man, Kris Wenzel's article was the most informative, and CJ's explorations. My table could be best described as an 'active' spreadsheet with some Access routines doing stuff better than say, Excel. There's no relationships or Primary...

Can you put in one sentence what normalisation is/does ? But another question please, is there some magic to putting a Form on a Form? I've got a Main Form called FormUE and two datasheet forms on it, frmUnion and frmEdit. I've spent over ah hour chasing these around the place. In design view...

Identifying the record is no problem, the issue was entering the data to update to. I've seen mention of "normalising" data but it's never made much sense to me. I've three different databases and sometimes want to see all (matching) records together for whatever purpose. At other times each db...

I have a datasheet Form with a Union Query as it's recordsource. So it can't be updated or edited. But I'm looking for some way to achieve this. My thoughts are to get the table and field target from a click event, update the table directly and refresh the Form But how to edit or add the new...

I kind of have it now, so unless there is a auto-method pse ignore me.

June the r-click layout option shows everything grayed out

I drag the control onto the Form and enter the wizards options There's 3 radio buttons and it places them vertically, with a orange coloued frame. There are resize handles but if I try to change height, they revert back to where they were. It will allow width changes. I can change the height via...

Is this really possible? I read online it was easy and you just resize the borders But (Access 2019) doesn't seem to work.

U

Thank you Colin, that worked treat. First in Form Load, then in my existing With-End With block which calls the Form and where the column is wanted hidden (conditionally). I had actually almost got there, but when the controlName did not appear in the dropdown, assumed it was a dead end.

Thanks Doc_Man That would be fine as the header isn't needed. But having some difficulty getting it to work, although no errors are reported, it just stays the same width. DoCmd.OpenForm "frmMain", acFormDS, , WhereClause With Forms![frmMain] .OrderBy = "[MyID], [iCost]"...

I wonder if this is possible? DoCmd.OpenForm "frmMain", acFormDS, , WhereClause With Forms![frmMain] .OrderBy = "[MyID], [iCost]" .Hide [A Column called iTemp] <<<<<<<<<<<<<<<< .OrderByOn = True .ShortcutMenu = False End With There is no .Hide but...

Great, thank you Mark. Nicely resolved. Changing to it immediately

Thanks for clearing that up dbGuy. June I'd never used either Filtername or Where before and it looks like Where is all that's required. I changed to that and got it working.

I beg indulgence as I try and ask about something I don’t quite follow. It concerns the FilterName passed via Docmd.OpenForm The Filtername here is a just-constructed Query at run time. The forms recordsource is a different (permanent) query. The Form opens showing all the fields in its...

It may be clearer if I show the whole routine. I see what Pat Says and can't explains why results seem to be at variance. But it is updating as desired (only with Me.Dirty= false included) Private Sub Location_AfterUpdate() On Error GoTo err_UU2 If Nz(aName) > "" Then If...

I figured out what it was. Even though this was in the After Update event the data had not been written yet to the table. After Me.Dirty- False the query worked as intended. But .RecordsAffected was 0 when it should be 1.

Another query is failing on one clause but only when run from the After Update event s = "UPDATE Table3 SET Location = 'France' WHERE (([MyID])=1446) AND (([aName])='A Story');" 'AND nz([Location]) <> 'France';" That works with the last bit remmed out. If I un-rem it, it tells me 0 records to...