Recent content by Ross Hurrell

  1. R

    if primarykey value exists, bring up record

    Hello I am trying to figure out how to make my database check to see if the primary key value is a duplicate of anything ive entered previously and if yes, for my database to bring up that record instead of adding a new record. I know how to do bring up records using a separate combobox (find)...
  2. R

    PDA support

    I was wondering if anyone could point me to a good site or forum post that could help with connecting a PDA to my XP machine. I would like people to sign it and then be able to upload the signature to my Access form on the current record. It sounds like something someone might have done...
  3. R

    Check if duplicate afterupdate

    If DCount([BARCODE], "[Inbound parcels]", "[Barcode]='" & Me.BARCODE & "'") > 0 Then MsgBox "This Barcode has already been used" End If Hmm.. I am using that and now it seems to only let Barcodes with just numbers through the system, Some of my barcodes have letters and it shows: "Run time...
  4. R

    Check if duplicate afterupdate

    wicked thanks.
  5. R

    Check if duplicate afterupdate

    Im having real trouble trying to create some code to get this to work. So far I have: If DCount("BARCODE", "Inbound parcels") > 0 Then MsgBox "This Barcode has already been used" BARCODE is the textbox and "Inbound parcels" is my Table.
  6. R

    Check if duplicate afterupdate

    Afterupdate or beforeupdate. Not too sure. Like, I have TEXTBOX1 and i enter a number that already exists within TABLE1. I would like it to pop a message up "This number already exists" and would keep doing so untill i enter a number that doesnt exsit. Thanks
  7. R

    Check if duplicate afterupdate

    Hi, I was wondering if anyone knows the VB to check if a value is a duplicate afterupdate? Many thanks.
  8. R

    Bold within email body generated within Access

    Hey, I was wondering how I would tell Access to set bold on my email message. I use this code to generate the email: Thanks for any help provided.
  9. R

    Autofilling Textboxes with Table data based on a Combobox.

    Many thanks to everyone, I got it working.
  10. R

    Autofilling Textboxes with Table data based on a Combobox.

    Thanks for your help, I tried this and i get the error message: "The macro (or its macro group) doest exist, or is new and hasnt been saved" Click here: http://c0ld.homeip.net/error.jpg Sorry if im doing something totally stupid, all that I know is self-tault.
  11. R

    Autofilling Textboxes with Table data based on a Combobox.

    I am creating an Access program for logging in Parcels that are delivered and I am having some problems. I have a Table called 'Contacts' and within this there are 4 Columns: 'Names', 'Departments', 'Extensions' and 'Emails'. I also have a Form and there is 1 Combobox and 3 Textboxes relating...
See more
Back
Top Bottom