Search:

Type: Posts; User: woja; Keyword(s):

Page 1 of 5 1 2 3 4

Search: Search took 0.01 seconds.

  1. Report design, multiple 1-to-many relationships

    Hi, I have an Access 2010 database recording weekly staff interaction summaries, and there are several 1-to-many relationships. Each record in the main form is for 1 staff member for that week, and...
  2. Replies
    3
    Views
    3,864

    I thought DNS issues too. Original reason for the...

    I thought DNS issues too. Original reason for the IPCop box is as a firewall, also the ability to separate the wired and wireless networks for added security, however it seems to have become too...
  3. Replies
    3
    Views
    3,864

    Domain join wireless laptop

    Hi, I have a server 2008 machine, it's IP address is 10.2.1.200, running on an ethernet 10.2.1.0/8 network, and I can add XP or win7 machines to the domain if they are on that wired network. Gateway...
  4. Replies
    4
    Views
    754

    Thanks for all the replies. I believe I have...

    Thanks for all the replies. I believe I have this functioning OK now, once I started working through the steps things started to make sense - and I understood the first reply from John (which I...
  5. Replies
    4
    Views
    754

    Thanks for your reply. I have a workgroup...

    Thanks for your reply. I have a workgroup information file that has the appropriate users and group permissions already set up. The thing I am trying to prevent is the default situation of a new...
  6. Replies
    4
    Views
    754

    Hi, I have a database with user level security in...

    Hi, I have a database with user level security in place and this seems to work well assuming the Windows user has joined the correct workgroup file via the workgroup administrator tool, i.e. a...
  7. Replies
    5
    Views
    705

    Hi, thanks very much for the replies, I have got...

    Hi, thanks very much for the replies, I have got this working nicely from your code.

    Regards
    Roger
  8. Replies
    5
    Views
    705

    Thanks for your reply, however the current search...

    Thanks for your reply, however the current search method is working well, and from what I understand from your reply is very similar to what you outline. I will try to elaborate on what I am trying...
  9. Replies
    5
    Views
    705

    Hi, I have a search function that works correctly...

    Hi, I have a search function that works correctly as follows. The "search" text box on the main form (frmClientInfo) finds any occurrence of the string anywhere within a few fields (names,...
  10. Replies
    4
    Views
    394

    Hi, I have an After Update event running, on a...

    Hi, I have an After Update event running, on a date field, that automatically generates the "FileNumber" field data. [I've adopted the code from the earlier database my one replaces, written by...
  11. Replies
    19
    Views
    1,018

    Hi Hans, I am attaching another stripped version....

    Hi Hans, I am attaching another stripped version. I've attempted to back-track following your last reply, though have become confused as to where I am currently going wrong, I hope you might be able...
  12. Replies
    19
    Views
    1,018

    Could you post a stripped down and zipped copy of...

    Could you post a stripped down and zipped copy of the database?
    Here is a stripped version. The form to open is frmOldPupils, there are 2 tabs, the "Classmate Finder" has the featrues functioning...
  13. Replies
    19
    Views
    1,018

    Try SELECT DISTINCT qryClasses.year FROM...

    Try

    SELECT DISTINCT qryClasses.year FROM qryClasses

    You shouldn't include classID here because it is not unique within each year. You don't need an ORDER BY clause; this is implicit in SELECT...
  14. Replies
    19
    Views
    1,018

    Thanks Hans, that is a great article, I think I...

    Thanks Hans, that is a great article, I think I can see how to get this working. In some ways my situation will be easier since it is not from 2 tables and the same principles will apply.

    The...
  15. Replies
    19
    Views
    1,018

    And since you have predefined the room-year...

    And since you have predefined the room-year combinations, the user should not enter them separately, but select a combination from a combo box (dropdown list) bound to ClassID, with tblClasses as Row...
  16. Replies
    19
    Views
    1,018

    [quote name='HansV' date='29-Sep-2009 23:50'...

    [quote name='HansV' date='29-Sep-2009 23:50' post='795436']
    > First, I'd like to set visible=false when navigating to a new main record

    You can use the On Current event of the main form:

    ...
  17. Replies
    19
    Views
    1,018

    Thanks again Hans, this is coming along well. A...

    Thanks again Hans, this is coming along well. A couple more little questions if I could? First, I'd like to set visible=false when navigating to a new main record - which form event is the right...
  18. Replies
    19
    Views
    1,018

    The correct ClassID field is already included. I...

    The correct ClassID field is already included. I eventually realised the cause of my confusion - the problem is the list box that I created was only getting refreshed when opening the form. I added...
  19. Replies
    19
    Views
    1,018

    Thanks Hans for the fast reply. I have created...

    Thanks Hans for the fast reply. I have created the query as you explain and created a list box based on it. I see that I have more issues to resolve since the only name I see in the list box is...
  20. Replies
    19
    Views
    1,018

    Hi, I have a database recording pupils, classes...

    Hi, I have a database recording pupils, classes and teachers with the following fields and relationships: There is a many-to-many relationship between tblPupils and tblClasses via 2 1-to-many...
  21. Replies
    2
    Views
    385

    You might use a join table with PupilID, StaffID...

    You might use a join table with PupilID, StaffID and Year as fields for a composite unique key, plus additional info if needed.

    Thanks for the reply. In this situation the pupils will stay...
  22. Replies
    2
    Views
    385

    Hi, I have started helping someone who is putting...

    Hi, I have started helping someone who is putting together his first Access database and has already set about creating tables for pupils, who have involvements at school (eg sports, clubs), and...
  23. Replies
    1
    Views
    402

    Hi, I have been asked to produce a report on...

    Hi, I have been asked to produce a report on client appointment information, between a certain date range - which is simple enough on it's own (1 client can have many appointments). However the...
  24. Replies
    2
    Views
    471

    Re: sub report height - blank (2002)

    Sorry for the delay replying, yes I have set the Keep Together property to no avail. Time constraints and a pending holiday for a few weeks have meant I have not had an opportunity to anonymise the...
  25. Replies
    2
    Views
    471

    sub report height - blank (2002)

    I have a report with 5 sub-reports in the detail section. I have no report or page headers in the parent report, the header being a few fields from the "1" side of the "1 to many" side of the...
Results 1 to 25 of 110
Page 1 of 5 1 2 3 4