Search results

  1. U

    Sort order:General problem convert to 2003

    Older post? :ROFLMAO:Worked for me 8 years later. Thanks.
  2. U

    Displaying related value (not sure how to phrase it)

    Thank you to Gemma the husky & The Doc Man, I've joined the tables through a query and it seems to be working although I'm not sure if I've done the right thing. Time will tell.
  3. U

    Displaying related value (not sure how to phrase it)

    WRT the nature of the PK, I read this earlier today - obviously stuff on the interweb is to be taken carefully but if one doesn't know, it's hard to sort the wheat from the chaff... " 3. Never update the primary key. In fact, because the primary key has no other purpose except to uniquely...
  4. U

    Displaying related value (not sure how to phrase it)

    Thank you both. Will work on implementing this now.
  5. U

    Displaying related value (not sure how to phrase it)

    Hello, My main table contains a foreign key NCAID from tblNCA, which is a lookup table with five records, with two fields (primary key) NCAID and NCAName. The NCAID fields between the tables are related. It seems to me the purpose of the tables/relationship is to store the NCA as a code...
  6. U

    Splitting big table to smaller ones

    Hi UncleGizmo, Thanks, this is a large landscape assessment database with many justifiable/valid fields (assessment of many characteristics of the landscape). It may once have originated in Excel and possibly outgrew it, but I know as a database it has been used like this on previous occasions...
  7. U

    Splitting big table to smaller ones

    Hello, I have inherited a database with in excess of 78 fields and I gather I need break this down as it may be causing the "record is too large" error. There are sections which lend themselves to this: there are field prefixed "susc", "val" and "vis" but I can't see how to select these in a...
  8. U

    Hi

    Thanks for the welcome.
  9. U

    Duplicating current record

    Thank you all very much for your help. I was out of my depth here, but have now emailed the DB off to my client. Hope it works OK at his end :D Serious brownie points if it does and possibly ex-client if it doesn't. My main work is GIS & this was peripheral to it, using data I'd geoprocessed.
  10. U

    Duplicating current record

    Hmmm. Converting may have worked - the record count goes up when I click the button. :-) Now to see what the fallout of the other conversions is. Thanks for that. Hopefully I'm over the hump.
  11. U

    Duplicating current record

    Looking at that now thanks & to Pat. Just tracked tdown the convert macro button. FWIW, the acCmdPasteAppend wasn't available in the RunMenuCommands
  12. U

    Duplicating current record

    Thanks. The button wizard creates a macro for this and Access disables it as unsafe, flagging up the RunMenuCommand. Just been looking in the Action Catalog and trying to work it out. This has grown somewhat beyond what I thought I was gong to be doing...
  13. U

    Solved Major cockup with default form

    I just have :)
  14. U

    Duplicating current record

    I have looked and tried several solutions for this and cannot make any of them work. I understand the idea that copying records is bad, but my client wants it as the input form for his assessments have 40+ fields and many of the records differ by one or two elements. Some of the fields are long...
  15. U

    Solved Major cockup with default form

    It was nearly COP here when I wrote that.... I would have a drink but I've now been shafted by MS breaking the "duplicate record" button which is a key component. There is a great deal on the web about this and a million solutions which I need to sift for my own basic situation
  16. U

    Solved Major cockup with default form

    Panic over. I found a macro called "autoexec", which opened the original form. Which is how, I think, when I'd set the Access option/current database to be "FrmMain", it was displaying that title but the "MainForm" content. A very unpleasant hour that has been.
  17. U

    Solved Major cockup with default form

    I was sent a database to repurpose for a new project. I last used Access in about 2009... So far, I've got through ok, albeit slowly in places. I added my tables & forms into the old database, so I could copy the formatting etc. I used a different naming convention so they're all separate...
  18. U

    Hi

    Hello, I used Access a fair bit over 10 years ago but haven't touched it till now but have been asked to do some stuff in it & I am soooo rusty.
Top Bottom