Search results

  1. Y

    Making Data Secure

    I'm lost. If I don't duplicate the form, how does Management see all hidden fields but Consultant see only the non hidden?
  2. Y

    Making Data Secure

    Thanks. I think option 2 might be best and see how it gets on. 2 forms both identical, only 1 with hidden fields feeding the same table. I will give it a go. Thanks Will
  3. Y

    Making Data Secure

    Yeah good to be back. Would all the options below involve me creating a copy of the Contract Form for Consultants? If so I think option 2 is best. Is it feasible to have 2 forms linking to and from the same Record/Control Source? Thanks
  4. Y

    Making Data Secure

    Hi, not been on in a while but an old client has got in touch about something and I am a bit unsure of how big this job could be. Wondering you guys could help advise me better on whats the best way to do it...? The questions The problem I have is the first issue of only showing specific...
  5. Y

    Excel file for income and expenses?

    Hi, Anyone got any decent templates that they don't mind sharing? For my personal use.. Thanks
  6. Y

    Excel Sales to Mail Merge

    Any joy peeps?
  7. Y

    Excel Sales to Mail Merge

    Or is it possible in Excel to take a sales sheet and export each row to a Invoice Template within Excel itself? Click a button and it runs through each row creating an invoice for the data you need on the invoice?
  8. Y

    Excel Sales to Mail Merge

    Hi, I am attempting to create a mail merge or similar whereby I can take my excel sheet with a list of sales on and create invoices for each sale at the click of a button. In my head I want to export fields such as name, address, product, price etc... from excel to a Word Invoice template so I...
  9. Y

    Access onto Sharepoint?

    Can anyone help us with a solution to this? Thanks
  10. Y

    Access onto Sharepoint?

    Guess its a Nope? :-(
  11. Y

    Access onto Sharepoint?

    Anyone got any answers? Thanks
  12. Y

    Access onto Sharepoint?

    Thanks. The main reason for it being online is simply to access it from different locations outside of the workplace. I feel sharepoint is too extreme for this simple need. The database relies heavily on vba so browser is out of the question. I think the only ability it needs is to be...
  13. Y

    Access onto Sharepoint?

    Hi, I built a database for a client in Access and it works fine etc... Now they have come to me telling me they can not get in to go onto their Sharepoint site. Now I don't think anyone technical has tried to do it, rather just the admins in the office. I have never hosted a database on...
  14. Y

    Database in Excel?

    So I create the DB in full Access. Then if I need to split it, how do I go about that if they only have runtime?
  15. Y

    Database in Excel?

    Thanks and just to confirm that I can use runtime and they will be able to access that runtime file on multiple pc's that do not have Access of anykind on it?
  16. Y

    Database in Excel?

    I know but that's changed now apparently and they simply have to have it in Excel as no one has Access. Thinking on the fly, could I build an Access database and just allow them to have It locked down running on Runtime Access?
  17. Y

    Database in Excel?

    Hi, I have someone asking for a relational database but it needs to be build using Excel due to bugets blah de blah. Now as good as I am in Excel, I have never done this before. Always Access. Can anyone help me out where to start with this and are there any templates available that sort of...
  18. Y

    Web Scraping

    I can replicate his results for 1 page, but I dont see how its any use when I can copy and paste the individual course pages quicker. I would need a tool that scrapes the /courses/ directory but using his method he +1 increments the url nicely so its easy to do. If one course is called...
  19. Y

    Web Scraping

    I dont get how it can be done. From his example all the States seem nicely listed in a number sequence and all in one place. But my example I have to click Accounting, then click a course, then scrape the course page, then go back and click another course and so on. The web pages are not...
  20. Y

    Web Scraping

    Hi, its http://www.westminster.ac.uk/courses/undergraduate and I need to go into each Course (eg. Accounting, then go to each sub course eg Business Economics BSc Honours and then scrap the data from there. So essentially this page of data...
Back
Top Bottom