Search results

  1. J

    Form Not Showing All Records From Table

    OMG!! Yes, THANK YOU!!
  2. J

    Form Not Showing All Records From Table

    Hi I created a Search Form which displays records from a table. The records in that table are being entered through another form by the users and now has 180 records and growing. This Search Form displays only a list of CandidateID, FullName & SupplierID (which is Foreign Key) I have made this...
  3. J

    Sorting & Alerting User that Subform has more than 1 record

    Hi all. I have a form with 2 tab/subforms, one for general info on a candidate and another for submissions details. The submissions tab/subform has the little navigation bar at the bottom with ability to add another submission for that candidate or move to next. The submissionsTbl is sorted by...
  4. J

    Can't fill in a subform

    Thank you!
  5. J

    Can't fill in a subform

    O wow that would be great! Thanks! I have fixed all those name space issues since moving it to SP, but I'm not sure how to do a fresh back up if the FE and BE are linked to SharePoint. Is there a way to do a local backup unlinked to sharepoint?
  6. J

    Can't fill in a subform

    Hey mike60smart ! Thank you! Firstly to say, I must have uploaded an older copy of the backup because I definitely do have the CandidateID PK Autonumbered. I make so many copies when I do stuff then I lose track of all of the backups!! Thanks for pointing out regarding the CandidateDetails...
  7. J

    Can't fill in a subform

    Thanks, here is a copy
  8. J

    Can't fill in a subform

    Update Maybe it's not too serious but not sure how to fix it. Turns out that it isn't the Supplier field that is the issue but the CallsLog tab, AND I don't have to actually enter anything, I just have to click on the tab before going to the Submission subform and that works!! I'm no expert but...
  9. J

    Can't fill in a subform

    Ya SharePoint has been a pain but in this case not sure it's the cause because I went to the lists online and entered a new Candidate record in the tblCandidate without entering the Supplier and it worked. I was then able to go into the tblSubmission list and look for the Candidate in the drop...
  10. J

    Can't fill in a subform

    Hi All Using Front-End local with Back-End in Sharepoint. I have a form that is split in 3 tabs, I think they are called subforms? First is the main form, CandidateDetails, the 2nd tab is Submissions and the 3rd is CallsLog In the CandidateDetails, there are fields for Address, phone, email etc...
  11. J

    Word Count Alert after reaching a number

    Hi everyone. Thank you so much for all you help. A lot to go over. Sorry about the 285 Words. It was just that I put in a Word count control from another database and 285 words fitted in nicely ! I also thought it gives the user more of an idea. I'm always so chuffed with myself when I design...
  12. J

    Word Count Alert after reaching a number

    Hello On a form I have a Word Count button for the user to click to get the number of words they are using in a memo/long text field,. We need to put a word limit because they do waffle on a bit but I understand that when using Long Text field you can't put a limit. We can't use the Text field...
Back
Top Bottom