Search results

  1. gemma-the-husky

    Show Tables in query design not working

    If it WAS that causing it, you would most likely see scroll bars either at the right or bottom of the screen and you could scroll to the hidden region. If you don't see scroll bars, it's unlikely to be the cause. That was what I meant.
  2. gemma-the-husky

    First event of a Database

    I would leave the form to open in the database settings as blank. Do everything you want to check and setup in the autoexec function and then docmd.openform "myfirstform" I didn't actually realise the open with form opened before the autoexec macro run. Or maybe I did a long while ago, which...
  3. gemma-the-husky

    Show Tables in query design not working

    I didn't mean that. I meant could it have been positioned on a virtual screen somewhere off the visible screen. I doubt it, but it happens to me with some forms (other than system forms) occasionally. The add forms window is not locked in position, so I think it could be moved. I can certainly...
  4. gemma-the-husky

    Show Tables in query design not working

    I doubt it, but could it be hidden off the screen somewhere? Do you have scroll bars on the form when that happens? It is supposed to be there on A2010, I presume?
  5. gemma-the-husky

    Office Version 2205 Build 15225.20204 - Anyone having issues ?

    @isladogs Thanks for the advice Colin. I can dip my toe back in the water now.
  6. gemma-the-husky

    Office Version 2205 Build 15225.20204 - Anyone having issues ?

    Does anyone know if this is issue is sorted yet? Can the normal update process be re-started?
  7. gemma-the-husky

    Is Recordset Set

    maybe it's for the above reasons - most examples I see test for the negative if not myrecordset is nothing then use myrecordset end if
  8. gemma-the-husky

    is there a way to save and Don't save bounded fields?

    The standard behaviour of access is to try to save changes automatically. Personally, I think trying to prevent that standard behaviour is very difficult to do. Experienced users won't expect to explicitly click "save". It's rather like removing the standard buttons at the top tight of a form...
  9. gemma-the-husky

    Ubound does not work

    if there is one element in a (zero based) array, then ubound will return 0, as the highest element eg, an array {1,2} will return a ubound of 1, not 2, and the elements are arrayname(0) and arrayname(1)
  10. gemma-the-husky

    If less than 5 digits in VBA

    A number is a number irrespective of the leading digits. If you need a string then your need to manage differently. eg 007 0007 00007 000007 are all number 7. If the leading zeroes make a difference (as with a phone number) then you need to treat it as a string.
  11. gemma-the-husky

    What is the cheapest way to get the Ms Access installed on our system?

    It's not just the cheapest way. It's the legit way. I imagine a database includes details of the development environment somewhere. If you are developers, aren't properly licensed it might be exposed somehow.
  12. gemma-the-husky

    Office Version 2205 Build 15225.20204 - Anyone having issues ?

    Thanks for all of these links. It's been useful. Would anyone know if run-time access gets affected. Would that actually be automatically updated, or would the installed version be untouched? Maybe run time access doesn't display these issues.
  13. gemma-the-husky

    Grabbing XML field

    Maybe the text has a character at pos 19 that is being interpreted as an eof? Something like that. Try getting len(rst!xmlfield). or len (rst.fields("xmlfield")) I am not sure without testing, but maybe rst.fields("xmlfield") is not exactly the same as rst("xmlfield") I generally use the ...
  14. gemma-the-husky

    Really struggling with cleaning this excel data when imported to Access

    Converting bad excel data into well formed relational data can be a nightmare. You do need to thoroughly understand the excel data first.
  15. gemma-the-husky

    Is there a contemporary match for this Book?

    Among the others, my favourite Access books were O'Reilly Access Cookbook Alison Balter's Access Book VBA Developer's Handbook O'Reilly DAO Reference. I haven't got them to hand and can't quote all the authors. IMO, a lot of the A2000 and especially A2003 ideas are still relevant. It's just...
  16. gemma-the-husky

    Solved Hi, Can anyone guide me how to make an accounting database?

    I don't know about that. It's a pretty big and costly tool for someone who could easily get by with Access, (or if necessary SQL Server or MySql). Maybe it's not. Maybe it's inexpensive and easy to use.
  17. gemma-the-husky

    Solved Hi, Can anyone guide me how to make an accounting database?

    I actually think a general ledger is a pretty good learning tool - probably single user, although in principle it would be multi-user. Ditto, for a decent plant register and depreciation calculator. Treat these as non integrated exercises, and you are looking at no more that a week for each to...
  18. gemma-the-husky

    Not Equal To VBA

    is the field name Status, or is that the name of the bound field? I would generally use a look up table, rather than hard code text, so option 1 might be "family member", option 2 "friend" and so on, and then you don't get a problem if you want to change "family member" to something slightly...
  19. gemma-the-husky

    Unbound vs Bound Forms

    @Pat Hartman Sorry, there isn't an afterdelete event as far as I can see. Form.Delete event (Access) | Microsoft Docs This says in the first line "Occurs when the user performs some action, such as pressing the Delete key, to delete a record, but before the record is actually deleted"...
  20. gemma-the-husky

    Unbound vs Bound Forms

    I was just looking for an event. I didn't expect one on the main form, but I couldn't find one on the subform either. I couldn't find any way of signalling that a record delete had just taken place, so do something. Once it had taken place, I need to re-process the entire order, As I say, the...
Top Bottom