Search results for query: *

Is the domain name constant ie is it always 'home/'? If it is just look up the VBA 'mid' command, it's an easy one to understand.

Hiya I'm firing the immediate window thru Access VBA (XP) and typing in the above statement. The object/collection exists as I'm getting a choice of which statements I'd but as soon as I hit return I get an unspecific error and Access closes. Any offers? Craig

Hiya folks, I'n need to access a view from within a SProc, to see if the view returns a recordset and if it does assign one the of the fields that the view returns into a variable. The syntax I'm using is as follows : SELECT TOP 1 @MyJobN = IJobN FROM MyView I keep getting an object...

I need to return a recordset that's generated by an SQL stored procedure back to an Access 97 database. And to honest I haven't got the faintest idea on how this is achieved. I've looked and looked but I can find hardly anything (anything I can understand at least). I've only just starting...

Temp table method worked. just populated on the table on form load and the On Click event of a button ran a update query. Update query just had the two tables linked together. No need for power code or complex SQL statements. Cheers matey. Nice 1

Jsteph, I'll have a whizz at coding that this afternoon. Let you know the results Cheers for the reply YC

To RiderJon : Can't use the AfterUpdate event because the form is shown in continious view, this results in all of the text boxes showing the new value. ie the same value over and over again. LambertH : I can populate an array on the way into the form but how can call these values on the click...

Hi all, I have a table called FinalResults which contains 1 field 'Result'. A form links to this table (in continuious form view) and when the form is loaded displays all the results in the FinalResult table. The user can change any of the results shown. What I want to be able to do is to...