Recent content by RobinL

Hello everybody, My organisation runs a paper-based survey. I'm currently designing the database to put the data in once we receive it from our data processing contractors (they give us a uncleaned version). I've got a plan for this database, but I want to make sure I'm doing things right...

Thanks Bob. I couldn't find many examples on the net of the .move command being used. Your post explains why!

Thanks very much for the help. Sorry for it being such an easy answer! (I did try googling first)

Dear all, I would like to move to record number x in a recordset using me.recordset.move x, 1 However, I keep getting a "not a valid bookmark" error. The .move method only seems to take one parameter, contrary to what the following article says: http://www.w3schools.com/ado/met_rs_move.asp...

Thanks very much - I'm experimenting with your suggestions. I'm pretty confident I'll be able to get it to work now :)

Thanks very much for the quick response - what you've suggested definately makes sense to me. Could I also ask what's the best way to set up the queries for the two subforms? Is it preferable to set this up using the 'RecordSource' property (as an SQL string), or is it better to set up a...

Dear all, I’m looking for some pointers on how to solve what I think is a relatively simple problem. I’m experienced in programming VBA in Excel, but haven’t much experience in Access. I have two tables in a database, and I need to ‘match’ the records in each, based on several fields such as...

thanks, bben looking on the net for ages, i should have tried here first!

thanks a lot, its working now :)

I have got two tables - one of institutions, and one of contacts I am trying to make a query where the only stipulation is that there is a postcode and an institution name. (Im just using 'Is Not Null' for that. The problem is that if there are no details for a certain institution in the...

have you tried refering to it directly? e.g. Forms!subformname![control on subform] *im not sure of this, but its the first thing i'd try*

/EDIT I wored a different way round the problem using a query, still i'd quite like to know the answer :) I have 3 recordsets open, for orders, institutions and contacts I want to add information from each of these recordsets into individual records in a listbox e.g. Lstbox...

just to say thanks as well - i was just about to ask the same question :)

thanks yeah i take your point. I already have a validation system by which another tab loads up after you press 'done' and asks you to check the details. Not ideal, but it should be OK - the user is my computing teacher so he knows how to go into the tables and change stuff if necacery. Thanks :)

I have a table called tblLookupWizardOptions It basically contains values like 'Mr., Mrs., Ms, Miss' etc in one field, and educational authorities in anther field etc. Basically the table acts on various form to give defaul values that you can pick from combo boxes. The problem is that the...