Search results

Sorry, can't seem to read your attachment - post the first three paragraphs - that'll be enough to get started

If it’s the SAME AppNumber consider if there might be an AppNumber Table above and in a one-to-many relationship with both tbl1 &tbl2. In your example, if AppNumber 12345 can relate to BOTH Simpson Homer AND Stalon Sly? I think you need an AppNumber Table to record AppNumbers Yes/No boxes...

Bound is, for example, when a TextBox on a Form Shows or writes something to a Field in a Table An Unbound TextBox doesn't add or show data from a Field. You might use an Unbound TextBox to calculate and display a time that an inspection is due to be carried out based on when the last...

Hello Awake2424. PBaldy is right of course. But when I started out I didn't believe it because, Access lets you put LookUps in Tables - so I thought - I'll do that then! But I hadn't understood why it should not be done. It might be because the table stores only a number (from 1 to 5 (in your...

I had a similar problem with a subform which worked perfectly for new entries but stopped when I deleted some Fields in the sub form. You might try including all the Fields from the Table above in the Sub form but, instead of deleting the Fields you don't want to see, move them to the Form...

Thanks Beetle You’re right - as usual - there’s no LTM in Runtime. Also, you’ll know the link to the BE does not update. Thanks Pat Hardman I’m happy to force a user to keep the BE /FE together, I just need some vba to refresh the links on start up. I found some at...

Cool. Thanks PBaldy, Happy days. - I'll copy my FE/BE to a "Clean" computer that's never seen access and see what happens. I will report back with what happens in case anyone following might benefit

I’m probably making some incorrect assumptions leading to incorrect conclusions, so I’ve set out what I ASSUME is right and my conclusion – but you chaps will know better. Assumption I read somewhere that Access Runtime is like a database viewer. It is similar to the Adobe Acrobat Reader...

Tentatively. The Query Field criterion "Report_Date:[ Enter date for report]" will trigger an Enter Parameter Value box, Might it be better to have a Calander control on a Form? Date entry is easy for the user and an invisible TextBox can hold the vba to calculate your second date based on...

Phew! That's that sorted then. It took me a week (every spare minute) to copy across everything from db1 which couldn't be made into an MDE into a new db2 which can. I didn't use Spikepl's idea of splitting the suspect but in half and testing each half - I should have becasue, as well as...

Thank you ChrisO Your Module looks great - can't wait to try it. But first, I'll take an opportunity to learn what Modules are (I have a vauge outline from the IsLoaded Module I pinched (and use) from Northwind) it's something I need to learn. I will report back when it's all working for...

I didn’t say that TextBox1 is on a Sub Form called frmFormSub in Continuous View, so that I can have more than one TextBox1 entry for each Record in the MainForm How do I get TextBox2 to relate to the TextBox1 with focus? Next problem is, I’d like is to hide TextBox2 on the Subform and copy...

Thank you JBB that’s perfect – Form OnCurrent Event sets TextBox2 to read 255 and TextBox OnChange Event clicks TextBox2 down one with each key stroke. Thank you too Mr.B A year ago I would have glazed over at your answer. Nowadays, I can understand (I think) your Function. It’s brilliant...

You sound cross.

I cannot do better than Lagbolt’s answer. There is one only set of records (the real life transactions). You’re trying to find out what’s real. The tools you have are; your bank’s version of the transactions in Table1 and your own version of the same transactions set out in Table2...

Sorry wmphoto, I entirely failed to read your post carefully enough. I was confused by “Things” and “Groups of things”. My naming convention avoids all use of plurals because each record represents the only one of whatever it is. This helps me when thinking about a group or set of records, to...

TextBox1 has, of course, a maximum of 255 Chars. I imagine Unbound TextBox2 will count down from 255 with each keystroke entered to TextBox1 so I know when my limit is getting close. Can anyone point me to the vba for this?

I've not bought a book on access. The books I can afford are too simple, they don't have the depth of information and the books that do are like impenetrable tomes and cost hundreds of Pounds. There's plenty on the Net, get an overview there and post your specific questions on here.

Hi wmphoto, You have two tables called tblThing and a tblGroup If the following statement is true - A Group and have many Things in it But a Thing can only be in one Group That’s a one to many relationship. Another example of a one to many relationship might be one football team can have...

Thanks Spikepl. I didn't check back here for an answer before coming up with my own solution. Sorry. Of course, your answer is better than mine. I created a blank FE and began importing Forms with their Queries and Modules one by one (there’s loads of them). I’ve been creating MDE files every...