Recent content by bertusvanrooy

  1. B

    Access/Linux

    Hi there, hi there. I have been using a dual-boot Windows / Redhat Linux system for many years now. Compatibilty between windows and linux apps have certainly come a long way since the first release of the windows emulator for Linux WINE. I run the Lotus Notes 5 windows client under Linux with...
  2. B

    Back-End / Front-End Issue

    Thanks for the input. Maybe just to make it more clear, when I disconnect from the network the BE is not available anymore. So if I work at home on my laptop computer how will I be able to make changes to the BE databse structure etc.? Thanks,
  3. B

    Back-End / Front-End Issue

    Good day to you all. I have developed an application and run it with a backend database on a server with the front-end application running on users' workstations. Is it possible to implement design changes, both forms and database, when off-line? If so, how would one approach it? Thanks.
  4. B

    Deployment of Access Application - Roaming Users

    Hi to all, I need some help on deploying my application in a mixed environment. APPLICATION DETAILS: I used MS-Office Developer XP to design the application. The file format is Access 2002 and I would like to use the packing wizard to install the application for users as they do not have...
  5. B

    Take the KeyDown challenge

    Works fine with Access 2002 on WinXP
  6. B

    Selection List -> Transfer to table & Filter

    Relationships Here is the graphic for my relationships. Thanks.
  7. B

    Selection List -> Transfer to table & Filter

    Relationsships & Filtering Thanks for your reply, you have definately put me on the right track. Let me tell you what I have done. I used a LIST "lst_Available_Options" to display the items I need to select from. The list is filtered based on the value of a Combo Lookup called [Machine Code]...
  8. B

    Selection List -> Transfer to table & Filter

    My problem relates to a multi-selection that has to be made from either a ListBox or Table [Available Options] and the values then to be transferred to another table [Selected Options]. The ListBox with available options then has to be filtered to omit the values that has already been...
  9. B

    Problem with Replica on network share

    Hi, I hope someone can help with this. I have developed an application where I would like to keep the Design Master on my desktop PC and have a replica on a shared folder on the network. I have created a replica of my application to a shared network folder and have tested the replication. It...
  10. B

    How do I evoke email automatically

    Sample argument Hi, Below is some sample code that will invoke your mail client and use the e-mail address contained in the [EmailAddress] field and pass it on to your mail client together with a subject line and some body text. Ensure that you have a field called [EmailAddress] on your form...
  11. B

    Count of records that have been filtered in a query

    That's correct. See the attachment for a sample. Cheers,
  12. B

    Count of records that have been filtered in a query

    I think a simple way of doing this would be to add a TEXTBOX control on your form or report and setting the Control Source property to "=Count(*)". This should count all the records in the active recordset and return the result to your TEXTBOX control. Cheers,
  13. B

    Relational problem: Record selection that depend on others

    Sorry, here is the attachment Sorry, here is the attachment
  14. B

    Relational problem: Record selection that depend on others

    Options - Sub_Options Questions Hi Sambo, Sorry for only replying now, I have been away for a while. Thanks for your idea, it looks as if it could be the answer. I just have one or two questions about the practical side of it. Seeing that I will have a Master Item i.e. the PC, with Options...
  15. B

    unsecuring a secured database

    I also had to do that a while back. Seee below comments from MS-Access Help Start Microsoft Access. Open the database that was secured with user-level security. Log on as a workgroup administrator (a member of the Admins group). Give the Users group full permissions on all tables, queries...
Back
Top Bottom