Search results
-
A
Numerical ID vs Alphanumerical ID: practical advice needed on best way forward from where I am
Wow, I really wasn't expecting so many replies and with so much great advice. I'm very, very grateful. But my head hurts now and I really need to go away and have a ponder. That's a really good tip, thanks. Obvious when you think about it but I probably wouldn't have done (and didn't do on the... -
A
Numerical ID vs Alphanumerical ID: practical advice needed on best way forward from where I am
Thanks again, Mark. Yeah, one of the issues on my shopping list is to handle the memo fields differently; in fact, maybe quite similarly to the way you are describing. But, first, I need to get them into the new BE. I get the feeling, when you talk about an "Import" application, that we must... -
A
Numerical ID vs Alphanumerical ID: practical advice needed on best way forward from where I am
Wow, that was quick! Thanks for replying, Mark. So you're in the numeric ID camp? I get what you're saying and it was arguments like that which made me decide to start using numeric IDs. Regarding the follow up question, I do have a procedure for importing and which adds the new numeric IDs... -
A
Numerical ID vs Alphanumerical ID: practical advice needed on best way forward from where I am
Firstly, please let me apologise if what I have written below is too much chapter’n’verse: I don’t want to fall into the trap of providing too little info and then you guys having to extract teeth to get what you need…but, in doing so, I may well have fallen into the trap of being too verbose... -
A
Best way to add new records to table B when active form bound to table A
OK, plog, thank you for your time. I understand where you're coming from: I did try to keep it succinct, then I was told by jdraw to give chapter and verse, but that "wall of text" is, I agree, a bit overwhelming. It seems you can't win some times. I was hoping to get a steer on which of my... -
A
Best way to add new records to table B when active form bound to table A
Plog, many thanks for bearing with me so far. I have attached a snapshot of the table relationships as requested: this is actually from the current back end but I don't see this changing much as part of the spring clean (which isn't to say it couldn't be improved). You queried whether I was... -
A
Best way to add new records to table B when active form bound to table A
Plog, jdraw, many thanks for taking the time to read my post and respond. Point taken about lack of info but, in my defence, I'll just say that it's difficult to know exactly how much info is the right amount without running the risk of boring you all silly. That said, I've clearly not been... -
A
Best way to add new records to table B when active form bound to table A
Many thanks for taking the time to reply. Unfortunately, that hasn't answered my query. At some point I will need a subform to see all hours posted to particular customers and, then, I will need to do what you have suggested. But what I'm trying to do right now is find the best way to post in... -
A
Best way to add new records to table B when active form bound to table A
Hope the title makes sense. I'm really a beginner to all this so please do accept my apologies in advance if it's all a bit basic and / or just plain wrong. So, I have a main form which is bound to tblCustomers (table "A" in the title). There are various sub forms pulling in data from related...