Search results

It's not ideal, as the query updates on the fly, and gives the user an instant view of what's going on within the Posting list. I thought this would be a much simpler way of showing the posts are more than one per transaction, and easier to view which transaction it is

I can't think for the life of me, how to do this (Think of it as can't see the wood for the trees, but have searched through all posts and maybe it's there, just not worded as such) As you can see, I have a very simple query on an accounts form to show a running transaction history...

Re: Using a combobox "value" to copy whole record /create a new record...BUT Thanks for that. Didn't think of that method. Works a dream. Used the .visible = true on the combo box so it can't be clicked in error.

Here's what I'm trying to do... Let's say, I'm updating a record, and I have a combo-box that says transfer and another combo-box that states "where to?" - or words to those effect. Each record has a field for credit value and a field for debit value. What I'm having difficulty in doing is...

Idea scrapped! Thanks guys! I will use an alternative

I'm aware database servers don't support, but is it possible on stand alone applications?

Guys. I've been using mutivalued fields for some time now with no issues. It's time to expand my current database, and toy with some self learning stuff in regards to taking mutivalued fields further. Here's what I'm planning (if it's possible) hence why i'm here. Lets say.. I have "one" total...

JHB, Froth; no error messages at all. All was exactly how I wanted it to be... I just didn't have my database in the trusted location... Doh! All sorted now. Thanks guys for your help. Sorry to have wasted your time.

Hi JHB. I've just tried this on my laptop, and all is working fine, yet the same file will not work on my desktop!! Obviously I'm missing something in settings. I shall reinstall Access and try again! Many thanks for your time and help with this. It's much appreciated. Thank you!

Hi JHB. I didn't think the code was incorrect, "but" it's not working. I have 2013. Is there something in settings I'm missing?

Hey Gasman thanks for that. I've tried every possible combination given on the reference you gave. It's still not working. Am I to assume that what I want to do is not possible? However one thing still confuses me a lot about referencing a form / subform, and that's the use and placement of the...

So here is my zipped file. What's I'm trying to do is ; From the frmReconcileMain form, I enter details for when, say, a bank statement is delivered. I then go to the subform (frmreconcilesub) and the details of all transactions not yet reconciled appear here. What I want to do is click the...

Re: Clicking a Checkbox on a Subform to pull data from a textbox on a Mainform I should be able to post a "zipped" example within the next day or two. Many thanks for your help :)

Clicking a Checkbox on a Subform to pull data from a textbox on a Mainform I'm hoping someone can help. I've been trying all sorts but I can't get this to work, despite searching for days on here. I have a Mainform [FrmReconcileMain] and it contains a Subform [FrmReconcilesub] What I'm trying...

Hi Everyone! I've been using this site for a long time now, and I'm full of admiration for those that "know". Your patience is admirable:rolleyes: