Search results

I want to display some data in an array to an unbound datasheet form. Usually the data would be in a table and the Form bound to it. BUT can this be achieved without a table - i.e write to the Form directly as it it were a spreadsheet? How could you move to each new record or row?

Thanks for the answers. Doc_Man I have that working and like it. I follow the error logic, but didn't think this was an error. Only if its Set does a certain routine have to run. and If the popup can interpret it, perhaps the code should as well. But I totally get what arnelgp means.

When mousing over a recordset Name in a Function, a popup shows it "= Nothing". Debug.print recordset Name gives an error. (91, not set) Can vba test for this without needing an error handler?

Thank you. I don't know why DISTINCT is there, but something is weird. It still didn't work for me with DISTINCT gone so I tried yours - and it was ok. Yet the SQL was identical in both. I then deleted and recreated the query - and it came good. Then I put DISTINCT back - and it still works...

Apologies not answering sooner, but somehow the error vanished and had to give up trying to replicate it. But it still wasn't working until now. Yes it wants a string and Crystal was right. I'd first left out the .OrderByOn =true, then had put it before the '.Order By =' which prevented it...

This isn't something I've created but am helping someone with. I always thought if you opened a query if would display as per its design. But Dupes in the attached db shows in a different order to the Demo in module 1. Why is that ? I can't figure it out at all and would like to.

Could I have an example of the correct use for .OrderBy ? Currently giving error Invalid use of property Oranges is the control source for textbox Text0. It is a Number field in the Forms RecordSource table DoCmd.OpenForm "frmShow", acFormDS With Forms![frmShow] .ShortcutMenu = False...

Well worth knowing, and some good info here. It must have been the Open View text change I was looking for (in design view). Thank you both.

Thanks for the replies. Still digesting it all.. not easy as things do vary. For example I spent hours looking how to change the font (hence my initial question) because I knew I'd done it somehow and NOT in code, which contradicts what CJ said. ... but could not remember how. Now I have it...

Crystal, it isn't a different font per column wanted, but the same one for all columns. As you say design view doesn't show any columns. Just text box controls and their label controls. I did try changing some properties but it had no effect. Which one were you using?

CJ, am I correct - datasheets properties can only be set in code ? I ask because I appear to have some forms with varying fonts, but no corresponding code to set it up. Suggesting there must be some other way. Thanks Crystal, it's certainly working but I've a suspicion it's not the full story.

Ah, I have figured it out. Private Sub Form_Load() Me.DatasheetFontHeight = 9 Me.DatasheetFontName = "Tahoma" End Sub I suspect the Ribbon or Design Mode is not what you use, even though it seems it should be. Maybe someone can expand on that?

Thanks for the suggestion, although I didn't try it now. I'm adding to a db with existing forms that somehow have different fonts and I didn't want to risk changing them all and maybe losing their layouts. So I copied a Form that had the font I want, and replaced all it's controls. It took ages...

Gee I think so. I have saved it several times since though. In design mode the controls reflect the font chosen, but when Opened at run time it is the font used by the system (Calibri). Yet some other Forms aren't using calibri. So all a but puzzling. Thanks for the welcome :)

That is what I thought I'd done. Could you define the correct steps please?

I've used the Form Wizard to create my form then DesignMode-Format-SelectAll and selected a Font and size from Font area. It changes to the one required. But if I close the Form and open it from the Navigation pane it uses a different font. How can it be altered so it sticks? The form uses...

I have made a Union query showing various fields from 4 different tables Is it possible to add a field showing the Names of each table into just the query? That is without adding a Name field into each table ?