Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.01 seconds.

  1. Many thanks for the code. I have just heard from...

    Many thanks for the code. I have just heard from the client and you are all correct it was a network mapping issue. While I had checked the drive I required for the application, apparently the...
  2. It works until the station is rebooted. The...

    It works until the station is rebooted. The strange thing is that it has worked perfectly from the first time they called me in at the beginning of February. All I did then was to give each user...
  3. Unfortunately remapping the drive did not work....

    Unfortunately remapping the drive did not work. The drive is mapped to R:, path = \\server\ar_data\ which should be OK. When trying to load the front end the message states that R:\back-end.mdb is...
  4. Thanks for the response. It is an Access .MDB...

    Thanks for the response. It is an Access .MDB file and I have tried turning off Compact on Close to no avail. Each user has their own copy of the front-end. However reading your response I suspect...
  5. Win7/Access 2003 Backend link problems

    I have a very strange scenario. I recently implemented some changes on a clients network where there are 4 users. Now, on only two of the four computers, the link to the back end database is lost...
  6. Wendell Thanks for your reply. I had done some...

    Wendell

    Thanks for your reply. I had done some other research on the web and tried a few things that did not seem to do anything - hence the post. However I had not rebooted. The overnight reboot...
  7. Access 2007/Win 8.1 Very slow control properties display

    Is anyone having a problem with displaying and moving through the properties of a field, control etc. I am running Office 2007 on a Win 8.1 with a fast computer, lots of RAM etc. When I click on the...
  8. Replies
    2
    Views
    693

    Thanks John, that solved the problem perfectly. I...

    Thanks John, that solved the problem perfectly. I now create a tmp table of CustSiteIDs in the onOpen event and use that in the combo box. I can then copy some of the info from the site selected into...
  9. Replies
    2
    Views
    693

    notinList event adding two records

    I have a combo box based upon a query. Limit to List is set to yes and the On Notinlist event allows the user to add a new record if they wish. The problem is that the new record is being added twice...
  10. Replies
    6
    Views
    3,415

    Many thanks for your reply. I have been out of...

    Many thanks for your reply. I have been out of the country hence the delay in getting back to you. The backend is in .mdb format. The front end is developed in 2003 but they have now shifted almost...
  11. Replies
    6
    Views
    3,415

    Many thanks for your replies. The code does not...

    Many thanks for your replies. The code does not have a space in it, that must have been me in cutting and pasting it in. I have tried your suggestion John and it made no difference. Patt, I did not...
  12. Replies
    6
    Views
    3,415

    Access 2003/2007 -requery problems

    I have a database that was developed in Access 2003 and is now running mostly under Access 2007. I have made some changes to one of the form/subforms. These changes include implementing bookmarks so...
  13. Replies
    6
    Views
    950

    Many thanks for the info. The record size is...

    Many thanks for the info.

    The record size is not that great as there are a lot of Yes/No fields.

    The problem I face is the selection criteria required by the customer. i.e.

    I could design a...
  14. Replies
    6
    Views
    950

    There are currently over 17,000 records and yes...

    There are currently over 17,000 records and yes almost all fields are used. It is an engineering job tracking system which tracks the requirements for each job: specs, dates etc.
    There are some...
  15. Replies
    6
    Views
    950

    No. of fields in a table

    I know that the maximum number of fields in a table is 255. I have one table which is now at 211 fields and I am wondering whether this many fields affects performance. Should I separate into...
  16. Replies
    4
    Views
    1,139

    I have a table containing data by week no and by...

    I have a table containing data by week no and by year

    I need to export this data with the weeks spread across the rows and curr yr, last yr and last yr-1 . There will be a total of 10 rows.
    ...
  17. Yes I had already tried that and the error...

    Yes I had already tried that and the error occured after all the code had apparently executed.

    I have now solved the problem by going back to the version of the edit forms prior to any changes.....
  18. Tried that and everything looks OK. I have even...

    Tried that and everything looks OK. I have even tried creating a temporary list form that has almost no code in it other than opening the edit form in readonly mode for a particular Quote - same...
  19. I tried that Mark and no luck. However I have...

    I tried that Mark and no luck. However I have finally been able to track down an idea of the cause. If I open the form directly (i.e. from the forms list) everything appears to work correctly....
  20. I should have added one more thing. If I open the...

    I should have added one more thing. If I open the form in read only mode all the calculated controls work perfectly, but if I hit F9 the error occurs.
  21. I am using Access 2003 fully patched. I have a...

    I am using Access 2003 fully patched.

    I have a form with a subform and a sub-subform. Prior to the following changes I did not get this problem.

    I had to move the form footer controls onto the...
  22. Many thanks for the replies. Yes of course the...

    Many thanks for the replies. Yes of course the code to set up the fields has to be run before the values change and that is what I forgot - me brain was in sleep mode
  23. The combo box is correctly loaded at the start,...

    The combo box is correctly loaded at the start, however I tried a requery and it did not solve the problem. I also tried refreshing the screen and alos no louck.

    I suspect I was not very clear in...
  24. I'm sure there is probably an easy way to do this...

    I'm sure there is probably an easy way to do this but...

    The database deals with cabinet manufacturing quotations for rooms in a house. When the user selects a room I set up default values for a...
  25. That is the problem. The headings are not in the...

    That is the problem. The headings are not in the data. The headings are required to be Location #1, Location #2, Location #3, etc. to the maximum number of Locations of the plants selected. i.e. some...
Results 1 to 25 of 136
Page 1 of 6 1 2 3 4