Recent content by Gambit17

  1. G

    Default Value in a Form

    Some more info, I have been entering in the DLast function. e.g. =DLast("Field Officer","Cotton13/14") in the default value property box.
  2. G

    Default Value in a Form

    Hi I am having some difficulty with the default value in a form. I would like it to be the value in the previous record. I have been using DLast, but for some reason it doesnt seem to work for some of my fields. For the field "Station" it works but for the field "Field Officer" it returns an...
  3. G

    Using an Append query, but not adding duplicates

    Thanks Billmeye. What does SELECT DISTINCT do? Could you maybe explain your code to me in laymens terms if its not too much hassle. Is yours more efficient? Thanks
  4. G

    Using an Append query, but not adding duplicates

    Hi I got it work doing this. INSERT INTO [Cotton13/14] ( Station, AC, [Field Officer], [FO Code], [Lead Farmer], [LF Code], [LF Codec], [Organic Farmer], [OF Code], [OF Codec], Acre, [Yield Est], [Sub-County], Village, Contracted ) SELECT FROM [Contracted Farmers] WHERE (((Exists (Select *...
  5. G

    Using an Append query, but not adding duplicates

    Hi, I would like to use an append query that appends data from a union query into a table, but doesn't add duplicates based on a certain field. I have been trying to use this code, but it doesnt seem to work. INSERT INTO [Cotton13/14] SELECT DISTINCT [Contracted Farmers].* FROM [Contracted...
  6. G

    Form that creates a new record in a different table

    Hi at the moment I have a form that uses a text box to search for a specific record in a table.(Cotton12) This works perfectly. What I would like to implement however is if the user so wishes he can edit the data he is shown, whithout editing the actual data in cotton12 and then with this new...
  7. G

    Using a Query Within a Form

    Sorry I meant I have chosen access as the database program to use
  8. G

    Using a Query Within a Form

    Hi Plog, I really appreciate your reply and I think your suggestion of having the year as a field is a good one. I would like your advice, if you have the time, on my database. I have just arrived in Uganda and have been tasked with converting what used to be an Excel/paper database of about...
  9. G

    Using a Query Within a Form

    Hi I have a form that has a text box in the header and when the user enters the farmer Code into the text box the relevant record is displayed. I am using the following criteria in the query within my Form Cotton12: Like [Forms]![Cotton12].[2012] Now I have 2 tables Table Cotton12 and Table...
See more
Back
Top Bottom