Recent content by sachinvh

Where to use the code? I tried to use the code at the place in the on-click option of properties of a button on a form which on clicking asks for excel spreadsheet to be imported.But i doesn't work. So where to use that code. Let's say i've import button on a form which on clicking asks for...

I asked a question regarding this before. There is a field let's suppose Blood pressure.The values entered are 120/80 like format. I want to extract one value like 120 from this field and 've to do some calculation.So how to extract it? Rob replied me that if I make 2 fields in a table like one...

How to achieve this using code? You mentioned about the changes in code.So how to modify the code?

I've to insert records by importing from excel spreadsheet on a form.I created a macro for it in design view of form.But in Transfer spredsheet action of that macro i've to give fixed file name.I want to add flexibility such that when a user clicks that macro button on the form he should be able...

Thanks Robert Dunstan. Again one query! If a field has 2 values separated by a delimiter such that a Blood pressure field has a value like 120/80 and i've to perform calculation by taking one value from the field like 120 and another value from other different field then how to do this in access?

when a user opens a database he should be able to go to forms directly and he can edit info in the form but when he closes a form he should not be able to see the tables and other design of database.so how to do this?