Recent content by james_liv

  1. J

    Records missing from form view

    I've ended up having to incorporate the customer database into the main database. When I was searching for invoice numbers the system seem to switch the customer each invoice was for. I think it was because both the booking system and the sale system used their individual job numbers as joins...
  2. J

    Solved Copied form from another database does'nt show all records

    ......I...errr...I had the tab stop set to no! School boy error!
  3. J

    Solved Copied form from another database does'nt show all records

    Sorry, I fixed this. Well, I actually fixed the original error. Feel an idiot now.
  4. J

    Solved Copied form from another database does'nt show all records

    Hello, Im in the midst of writing a database and something went wrong somewhere and I started getting an error. Rather than struggle to work out why I just reverted to an earlier backup which didn't have the strange error and copied a form across into the backup. The form works and I can see...
  5. J

    Search multiple fields

    Ahh, filter by form. Yes, that works well too. Thats great, gives me a couple of options. The only reason I am intent on this style of search is the users are not computer literate and the current system searches like that. The more I can keep this new system the same as their old one the less...
  6. J

    Hello

    Evenin' I've asked for help a few times on here recently and so thought I should try to contribute and hopefully give something back. So this would be my hello. I'm a 44 year finance manager. 25 years ago I worked in our small family business and my non computer literate family needed a...
  7. J

    Records missing from form view

    OK, so I think there's a misunderstanding here. My fault. The customer ID and Job number are fields which are used to join. They are not optional and they both autonumber so they always match - obviously these are system generated for every record. Originally the idea was for the postcode and...
  8. J

    Records missing from form view

    Thanks, Tbh what that join was meant to do doesnt really work and so I might remove it. What I really wanted was when I typed a postcode and door number it would auto populate the rest of the address if there was matching records in the customer information database. This never worked and so I...
  9. J

    Records missing from form view

    Both of the ID's are autonumbers when you first type into the form so should be ok. Ill happily change it if it would help thou but how do I do that? Do I need to given they are both autonumbers? Many thanks
  10. J

    Records missing from form view

    It was turned on and that seems to have resolved it. Ill try to experiment some more. I'm sure its still losing pieces of information but ill experiment. They are auto generating numbers. I've just checked however and yes, they do match. So in short, I think I had the Data Entry Property as...
  11. J

    Records missing from form view

    In the main form (as there are many) if I go into the property sheet of the form and then go into record source it states, SELECT [tblCustomerInfo].[Surname], [tblSalesSheet].[Job No], [tblSalesSheet].[BkgDate], [tblSalesSheet].[BkgTime], [tblSalesSheet].[AM/PM], [tblSalesSheet].[Staff Init]...
  12. J

    Records missing from form view

    Hi, Can anyone offer any help. I've got a multipart database with several links. I enter a record into the database form and then try to see it later and its gone. If I go into field view then all the data is there but the record is nowhere to be found in the form. I'm puzzled and...
  13. J

    Collate information from a form and search for it on another

    Thanks all, took a bit for me to understand how that worked but like most things, through trial and error of the solution arnelgp suggested I did manage to get it working. Cheers
  14. J

    Collate information from a form and search for it on another

    Thank you, I think this has provided the solution. I put together a quick test database and it worked so I'll try to implement it tomorrow and post back an update
  15. J

    Collate information from a form and search for it on another

    The time element is just AM or PM. Im not sure what you mean. Do you have an example?
Top Bottom