Search results

You can move/size any form with VBA Create a new form Add 2 toggle buttons - tglSize and tglMove 1 list - lstForms 1 button - btnRefresh 1 textbox - txtMoveBy Copy the code below to the form's module. When you open the form all open forms will be listed. If you open another form click...

Yeah. Silly way to go. But. I've enjoyed my time here. Hope I haven't upset anyone too much and helped a few...

No, I haven't lowered myself to your level yet. LOL It was a genuine question. I can't say the problem is solved because I don't know what the problem was in the first place. You have a problem with my writing style. (Or something?) Well that's not going to change. So, we just vow to ignore...

What matter would that be?

I deleted the post because I got sick of your pedantry in the other thread. You seem to be finding it funny. I just find it boring and slightly annoying.

A subform control can only contain one form. A form can contain multiple subform controls.

Chr() and cstr() are two completely different things. If you concatenate any non string datatype onto another string, or assign it to a string variable the value should be converted automatically and the results should be as expected based on Windows default formatting. This makes no sense to...

String & i will always result in the integer being changed to a string.

I just tested this and it's true, this doesn't work DoCmd.SearchForRecord , "", acFirst, "[ID] = " & Str(Nz(Screen.ActiveControl, 0)) But this does Me.Recordset.FindFirst "[ID] = " & Str(Nz(Screen.ActiveControl, 0))

Access has great saving and loading functionality already built into forms. Heed The_Doc_Man's words. I had a go at cleaning your code. (Untested) Public Sub Define_Arrays() Dim ProductCHK_Aboo(1 To 50) As Boolean Dim ProductCOD_Astr(1 To 50) As String Dim ProductUNI_Aint(1 To...

I get the feeling you're just being a troll so I'll leave you alone. Let's hope the Windows update gets sorted.

It does feel like I'm speaking a different language at times. :)

If the OP had been here to discuss database design I probably would have written something like that. ;) But he wasn't so I didn't. I have no idea who 'smiley coder' is. Probably you. "I haven't seen any empirical evidence IN MY OWN work as of yet." isn't "Very clear disagreement." I also...

I've read that thread twice and don't see any disagreement at all. :confused:

Memo fields have never been safe to use. I don't need to provide evidence because it's always been common knowledge and the post you linked doesn't argue otherwise.

Subforms can only contain one form. If you have 2 tabs that switch between Form1 and Form2, if you've set it to Form1 you can't refer to Form2.

You wouldn't be processing any records individually at all. That's the point. You would be BATCH processing.

Not going to solve your problem but this is all I needed to hear. The fact you haven't had issues before is amazing. Anything that could impact your network performance could tip your Access database over the edge if it has even one memo field.

How many memo fields does the database have?

I don't disagree. As with everything to do with databases and VBA it depends on the number of records involved. If the sample is representative then do as you like. If lots of records are being exported from 2 tables in unison then using built in functionality would probably be faster even if...