Search results

Trying to attach the file....

How to attach? !!!! (Newbie I'm afraid!)

Do you mean send you a db with the problem showing? I'll make a new one and send it...

When I open a new db I have the same problem. Is there a default setting that I've changed inadvertently? Have you ever come across this before?

Thanks for such a fast response. No, there just isn't a window containing the new form. There is no way of adjusting the new form window to its content. Never happened before! The max min close buttons are enabled in properties but only the close is enabled.

I think this must be a fundamental bit of knowledge which unfortunately seems to have passed me by. I have spent hours searching for a solution and now must post this question: At it's simplest Open a blank form at design time. Usually it has it's own form borders which can be adjusted as...

No Isskint not 2 fields; 1 field; I have a field named NumberStatement3 and need to pass both the 'NumberStatement" and the "3" as variables to SET. e.g Variable1 = "NumberStatement" Variable2 = "3" SET [Variable1 + Variable2] = tagname These variables may change.

Thanks for response isskint but I need the 2 variables added together (makes the field I'm addressing) to SET. The tagName is the variable which is the value that I want to insert into the table. Like SET [Variable1 + Variable2] = '" & tagName & "' " How to add these 2 Variables is my problem..

The following code does the job to put tagname (a variable) into NumberStatement field in the table:- SQLquery = "UPDATE [lvrstatements1] SET [NumberStatement] = '" & tagName & "' " DoCmd.RunSQL SQLquery BUT I need; To SET the field in the table to Variable1 + variable2 (e.g to...

I have succeeded in changing the names and data control sources now. Thanks to all who supplied me with the clues.....

Pat, I am trying to achieve a process which will be flawless once, with the help of this site, I can get over one more hurdle which is to address the controlsource of a control and change it in code. Best wishes, Roger..

I think that is why I'm having the problems - I have changed the procedure on your advice and it seems to be the way forward.... Many thanks for your time.. Roger ...

Thanks for fast response Rain (bucketing down here in Colchester UK). This is my project: I have a series of user statements to follow up on . txtClientStatement1 optTrueFalse1 txtEvidenceNeeded1 otptEvidenceOKorNotOK1 txtAspirationalNow1 txtAmendAspiration1 Fields in Table Statements match...

I have a series of duplicated controls on a form which I need to rename. I have tried: Sub NumberTextBoxes() Dim objTB As TextBox Dim i As Integer DoCmd.OpenForm "Form3", acDesign i = 1 For Each objTB In Form3.TextBoxes objTB.Name = "Textbox " & i i = i + 1 Next objTB End Sub But no joy. Can...

The following code seems to have done the job: Forms("allocatedata").Controls(newVar).ControlSource = newVar1 Thanks Pat...

Thanks Pat - I'll give your suggestions a run in the morning. Much appreciated - I'll tell you if it is OK. This is, incidentally only to help with creating my forms. 20 groups of controls all duplicated but hopefully to automate change of controlsources for each group. and possily more forms...

Crossed posts Pat! - I have to do this in VB - as you see on previous post, I have passed the name to variable newVar....

Thanks Pat but it reports that it can't find the field newVar1 (the one to be changed) . Is this the correct way to address a field (as a variable). I need it to change the datasource permanently? I do this as a test: newVar1 = "Statement2" ' this is a field in the table as well as the name of...

Can I change the control source property of a control using a variable eg Forms("AllocateData")(newVar1).ControlSource = newVar1 where AllocateData is the table name and newVar1 is the name both of the control and the field in the table ? I get 'Object variable with block variable not set' I...

Microsoft Access database specifications Access database Number of fields in a recordset 255 That's where I got the info from. My need is this: Fields in a table (container) UserID; Text1;Text2;Yes/No;Text3,Text4,Yes/No etc to 500 fields So for the answers beyond the field size maximum...