Search results

Please forgive as I've only just yesterday acquainted myself with a sample TreeView db, never having used that ActiveX control before. :confused: I'm having trouble envisioning what fields you are keeping with each table, or how for instance [employee], [effective date(s)], [(relevant...

FoFa, Your DB sounds very similar to what I'm aiming for. Right now I'm conceptually trying to think of something more clean and less cluttered than having a table for each hierarchy level and a bunch of intermediate tables - maybe something like one 'Assignment' table (no matter what level)...

Dusting off the rust and mental cobwebs after being away from development for some time . . . Looking for any pointers or suggestions about how to setup a personnel db that will yield an accurate reporting structure as-of a given date. The 4 levels of reporting, from lowest to highest are...

I'm guessing you're using the BeforeUpdate event on your option group. For Cancel, Me.(OptionGroupName).Undo should 'De-select' the chosen option if it's a bound control. HTH, John

Tricks of the trade Autoeng, Thanks, the *.ldb should allow me to gradually work out the machine assignments by trial and error from here. John

I'm attempting to diagnose record-locking errors. Was wondering if there was a way to tie the machine ID to the user's LAN log-on ID. Example: So, I'd like to be able to get the LAN log-on ID that corresponds to 'QTPNTCB557'. Any help greatly appreciated.

George, Glad that worked - I just noticed that Nouba was basically suggesting the same thing as me with his 'debug.print' statement (your solution being just to substitute in the '.ActiveCell ... = control.Tag' for the 'debug.print'). Anyhow, with respect to '.ActiveCell.FormulaR1C1', why not...

Have you tried: .ActiveCell.FormulaR1C1 = .Tag At a first mental glance, it would seem to me that a successful reference to your control set in the 'For Each control' line should pass those control references into the loop implicitly, therefore you wouldn't need to re-reference them...

DoEvents As Michael suggested above, have you tried implementing "DoEvents"? He did not miss your point. And ghudson did not miss your point either but was offering a suggestion to make your life easier - which was to ditch the DOS batch file and just use the "Name" statement to carry-out...

chewy, Check out the KeyPreview property for the Form. You'd use this in conjunction with: 1) Module-level string variable (to hold a running concatenation of keystroke characters) 2) An 'If/Then' comparison of that string variable with your special word in the KeyDown event for your Form...

casey, not sure if you're still pursuing a remedy... Even though your RecordSources between main and sub vary, from what you've explained, a user choice from the sub can be cross-referenced to a record on the main form, so you essentially have a one-to-one relationship? Again, I would suggest...

To my knowledge, a named range can't consist of multiple sheets, therefore you'd have to run the TransferSpreadSheet method for each 'table' in your Workbook. Of course Excel supports 3-D references, so you may want to have a play around with that, but then you'd be talking Automation in terms...

Just had my first bout with a corrupt db today, split exactly as yours, with both ends on the network rather than f/e resident on each Client workstation. Luckily I was able to create a repaired/restored/compacted copy of the b/e and just copied over the corrupt b/e for starters. This allowed...

KulasCage, I noticed your other post on this subject. Be advised that re-posting the same topic is frowned upon here. You'll want to avoid doing this in the future, otherwise people whose time you waste with the extra post will just ignore anything else you post to this forum, myself...

Sub Combo60_AfterUpdate() Me.Filter = "[File Number] = " & Me.Combo60.Value Me.FilterOn = True End Sub

You should be able to just use (paste) the formula Mile-O-Phile provided in your ControlSource (in the Properties box on the 'Data' tab) for the text box where you want the calculated date to be displayed, preceded by the '=' sign: =IIf([Priority]="High", etc., etc.

Check out the Filter property in the Help file. For your AfterUpdate event of your unbound ComboBox, you'd set your Filter based on the chosen value, then apply the FilterOn property (also in the Help file) => Me.FilterOn = True. Use Me.FilterOn = False for the Click event of your...

Unbound Main Form? Not knowing how extensive your control setup is on your main form, you may want to consider leaving all those controls Unbound. Especially since the main form's purpose seems to be for editing. This will alleviate your problems with the cursor when transitioning between the...

Doc_Man, Many thanks for your response. I'll try to diagnose from here. On your first comment, yes, my main data-entry form is opened in Hidden mode on launch of the app, then obviously becomes Visible on user command, which is when error is triggered. On point 2, I'll need to read up on...

I've been getting the following error on my A97 db even before deployment, but now of course is still unresolved and has become a nuisance to users: I'm only using 2 forms, and the error only occurs when opening the main data-entry form (which admittedly is pretty loaded with controls). Any...