Search results

try this one: Me!MyTree.Nodes.Clear Put it before you load the nodes and just substitute your Treeview control name to MyTree.

try: DoCmd.SetWarnings FALSE you append/delete query goes here DoCmd.SetWarnings TRUE

pat's remarks is correct and practical, but maybe you can try this one. it's not efficient though and i do not recommend especially if the db is big. SELECT Main.quotenumber, nz(

any code behind forms/reports/controls??? try to check...

hi, i tried to make a duplicate of what you're trying to do and come up with a sample database, which i attached. pls. check if this is what you want. i use not code but query. hope is suits your requirements. your friendly embalmer, joey

check the following properties of your lstEpisode: 1. Rowsource 2. Column Count 3. Bound Column the Bound Column of list box should be relevant to ITURegNo.

i see no problem with your code, however, you may have forgotten to set the Key Preview property of the Form to YES. Key Preview = Yes

try: Private Sub btnCancel_Click() Dim ctl as Control 'checks if record changes after last save If Me.Dirty Then 'restore all controls (NOTE: types could be added) For Each ctl in Me.Controls If TypeOf ctl is acTextBox or TypeOf ctl is...

Try to check which printer do you spool. In the PRINTER group of PAGE tab of the PAGE SETUP form, choose the DEFAULT PRINTER button.

Hello (",) You have a vague description. if you could be more specific, i might help you. or, you can send me your program so that i can check every details. (if you do send, send a A97 version).

Loop through all the members of the Tabledefs collection. eg: Public Sub ListTables() Dim tbl As TableDef For Each tbl In CurrentDb.TableDefs Debug.Print tbl.Name Next End Sub this one displays all tables in the debug window, just customize it to...

with or without parenthesis, Garswoods' code will still run.

Billy, Surely you cannot disable the "X" button on the Access Application window with a simple code but you can set the the Modal and PopUp property of the main form to True so that they could be inaccessible. joie [This message has been edited by joeyreyma (edited 08-27-2001).]

try: PartialString = Mid$(MainString,5,Len(MainString) - (5+4))

check this statement: MsgBox "Wrong button!@This button doesn't work.@Try another.", _ vbOKOnly + vbExclamation it will print the first line in bold!!!

you can run an append query having criteria of the current record of the form when you clicked the duplicate button, then go to that new appended record. but make sure you have good control of the primary fields.

i've been reading this post since it started, maybe i can make some help. here's what i will do: 1. i will make a saved query that will contain the maximum for every family, eg: SELECT Left$([FamilyId],3) AS FamilyName, Max(CLng(Mid$([FamilyId],4,4))) AS LastMaxEntry FROM Table2 GROUP BY...

if the name of the form is in a variable, you can write it this way: Forms(CStr(VariableName)).Visible = False i use CStr just to force the return type of the variable to string.

not very sure, but: rst!DateDue = DateAdd("d", (I + 1) * 28, stDte) note: + 1 is used because you started with For with -1, result should be greater than stDte.

can't fully understand what you're trying to do but i guess that you want each detail of the report be numbered sequentially. if i'm right, then here's my suggestion: 1. position a textbox on the detail section you want numbered 2. set the Control Source of the textbox to =1 3. set the Running...