Recent content by AccessMoron

You can not create a text box using VB on the fly, What you can do is put the text box's where you want them, then when required show them.

using Access built in security it is possible to only allow certain users to access a particular form

Using "" can lead to a problem with a null value. If me!cboItem = "" or isnull(me!cboItem) then msgbox "Please Select an Item First" Exit sub end if. However this can be shortened and is garanteed to work in 99% of cases. If Trim(" " & cboitem) =...

I think you man a combo box, to enable Combo box Number 2, after something has been chosen in combo box no 1 then the code would be place into the afterupdate event of combo box1 sub ProblemAfterUpdate() if trim(&quot; &quot; & Problem)<> &quot;&quot; then Problem2.enabled = true end if...

It would appear that the message you are getting is because the combo box is bound to a numeric field on your report.

If it is a bound form and you are using the docmd.gotorec function then you can do the following. Alter the form so that the users can not add a new record, (you can put a button on the form to allow them to add later). Now when they get to the last record and press the button an error will...

Yes, to call the field put it into [] so First Name should be written as [First Name] Also, it is bad practice to use the . to split up database field names, this is because the . means something completly diffrent in other languages sucah as VB

What version of Excel are you referencing? 8 = 97 9 = 2000 10 = XP Check that you are calling the correct one for the user.

Access 97 to my knowledge is no longer supported by Microsoft. If I was given a choice of developing a database using Access on any platform, I would go with Access XP. It is going to be supported for the foreseeable future. Further from what I understand Access XP will read 2, 97 & 2000...

OK I may be shot down in flames here but. A trigger is a stored procedure the lies on the server but is only run when something happens on the table upon which it resides (UPDATE, INSERT or DELETE) The main difference between a VB insert into SQL and a Stored procedure is where they are...

Why not let the users update the table as they go? seems you are making it far to complex

cheers worked a treat

Is there a similar command to VB's Left(string,length) that would enable me to chop off the last eight characters of a string? TIA Mike

Try Len(TextBox)

What is your Question?