Search results

Thank's. I knew it had to be something simple that I was just over looking.

I have a text field that links to a memo in a table and i would like to be able to have the user enter multiple lines in this field but when they hit enter it just goes to the submit button instead of to a new line in the field. Does anyone know how to correct this?

It is not class work. That would have been 10 years ago. (now I feel old). Instead of having to scroll down or up in the sub form to find the submit button I just was told to move it to the main form. I don't know why but thats what higher up's want. The submit button does a recordset update for...

Thats another issue. I can't have it run as a macro or module, otherwise it would be fine. The button in the main form only purpose is to call the button in the sub form and without the use of a module or macro. Do you know how to do this?

I'm not quite sure what you meen by "sub routine". Are you talking about the event behind the procedure or something else?

I have been looking arround and can't seem to find an issue so I've come here to ask. I have a main form and a sub form. I would like an onclick on the main form and acctivates and onclick on the subform. i.e. When someone clicks on the submit button in the main form it, in turn, clicks the...

Thank you. That work perfectly. You rock.

I know there is a way of doing this because I've come accross it before but now that I need it I just cant find it. I have a table with a column called "Comments" I want the user to be able to type something into a form and upon clicking the 'add comment' button it will add to pre-existing...

When running this modual I'm getting an error saying veriable not defined at the LEN_OF_CASENOTE_NUMBER. Does anyone know of which veriable it should be defined as? Public Function GetNextAutoNumber() As String ' Function to Emulate Autonumber Generation ' Generates err 3262 if table is...

Hello, What I am trying to do is to have two SQL strings run at the same time so that the information all inputs into one row. Here's what I have. ' These lines start the SQL string to copy all the data into the table. strSQL = "INSERT INTO tblAllRequestData...

I am trying to pull the values out of a form and dump them into a table. When I try I get the error that my INSERT INTO statement has a syntax error but no error number or what is causing the error. Is there a way of getting a better error description? Can anyone see anything wrong with the...

I just fixed it before I refereshed this page. I forgot about having the me in the IF statment. I removed it and not it's working great. Thank's for your help.

I tryed what both of you said and still can't seem to get it to work. Here is what I have now. Private Sub Form_Current() Dim emploc As String emploc = DLookup("LocationNumber", "tblEmpLocation") If Me.emploc = 1 Then Me.txttesting1.Visible = True Me.txtTesting2.Visible = True...

I would like to have my from read the value of a column of a table I created and then check it against an IF statement. Here the code: If [Table]![tblEmpLocation].Column(2) = 1 Then Me.txttesting1.Visible = True Me.txtTesting2.Visible = True Me.lsttesting1.Visible...

I tryed CommandButton1.SetFocus on the on click and it does set the focus to the submit button but the original button stays hilighted. I'm still not quite sute what to do codeing wise. Please help.

OK. I get that but how would the code look?

I'm using Access 97 and I have a form with a button that increments a text field by one everytime it's pressed. The issue I am having is that when you click on it it stays hilighted and wont go back to it's normal colour. Here's the code I am using: Private Sub lblTrxType9_Click()...

I know, the title is cheesy but it work's so well to my question. I was wondering if it was possiable to create a 'master' database that could control all of the setting's of other databases. So, if you wanted to lock down a database, without having to worry about a password, you could open...

Hello, I don't know if this is the right forum or not but I was wondering if it was possiable to have an HTML page and when a user fills it out and clicks submit it dumps all the information into a database" table. I assume it would be and SQL call but I'm not quite sure how to code it. Can...

Ok. I figured it out. I neede to put the same >=[Forms]![frmDataUsage]![cboStartDate] And <=[Forms]![frmDataUsage]![cboEndDate] on the or line with the Is Null and it work fine.