Search results

Hi I have a .csv file to import - it's correctly formatted and contains all the data VALUES I need. However, like a good boy, I have designed my access tables IDs - primary/foreign keys to other tables. So for example, I have a database that manages sports fixtures I want to import a csv of all...

Hi all Having trouble with processing the last record in a recordset. I have a nested loop. The code is working great - until the last row in the recordset. As far I can tell, what is happening, is that I have 'MoveNext', which eventually gets to the last row in the recordset, and then loops...

Thanks for any ideas on how to use a variable for the field name in an INSERT INTO statement! I want to have SQL INSERT INTO tablename, variablefieldname I have declared a variable and assigned a value, but the code just considers the variable name to be a literal field name. Must be some...

Hi My query returns all the details of a hockey match, on a given date e.g. Date, Place, Time, Team, Competition, etc, The hockey club has 10 teams, so for any given date, the query returns 10 rows with the above info. All fine. On the [FixtureDetails] form that is used to enter all this info...

Hi I have a fairly simple VBA procedure that uses the DoCmd.SendObject process to create an email which includes values pulled from a recordset (that was created by a query) - and it works fine. The email is to tell players and umpires in my hockey club when and where their next game is and the...

Hi, I'm Marvo I've done a little programming in the distant past and some Access db design before as a hobby or small projects to help out on things at work but I'm really a beginner. My VBA knowledge is very limited, but I have managed to some stuff in VBA by googling and adapting, changing...