Search results

Hi Guys. Racking my brains on this one, been at it all day... and just can't figure it out... I want to pass the Combobox value of one form to a textbox on another using the where condition. Using the break in VBA, the value of the combobox (in this instance "two") shows as null. Have I...

Hi JHB, not condescending at all :D It mostly happens with continuous forms, so at most you'll only ever see 5 rows in total (page header & footer), along with form header and footer, and the form itself... in design view at least, where in the detail section you can only adjust the width...

As I understand, custom sound VBA codes are different from 32 and 64Bit OS's of Access. We do an incredible amount of Excel work, so opted for 64 bit Office 2013 which is paying off remarkably compared to 32 bit. Sadly, I would have opted for 32bit Access, but this isn't possible to run side by...

Some forms it does work, some it don't. If you save the form then go into design view, it loses the previous save, and outsizes again when you view in form view once more. I always use the DoCmd.MoveSize on the forms load... The size are Twips - (Twentieth of an inch points) so even @ 5200...

Perfect. Thanks JHB.

I have an Undo button : [btnUndo] and would like it hidden until someone starts to enter data, where it will become visible... what code would I use? and where would me.btnUndo.visible = true be triggered? As always, many thanks for your help.

Thanks Spike. I had that design originally, but was wondering if it was possible to tidy up a bit so I played around a bit. I now have a form and subform to do just that, with no popups, and no data to carry over from one form to another. Just the two forms linked with the ID.:o

Hello. I have two simple tables tracking Transactions...(attached) One is used for tracking single transactions, and the other is used for tracking multiple Transactions... TblTopLines (used for single transactions) TblPostMultiples (used for multiple transactions for a continuous form) I...

Spot on! That's the one!... I'm stuck on where to put the buttons code to override the vba on all the other fields.:o the tables are marked as Not required, and the codes I'm using for the text boxes are... if isnull (me.fieldname) then msgbox "Message here", msgboxtype etc etc...

A simple one I'm obviously missing something... One form. Several fields which are required using event 'On exit' - "If isnull" statements for each one. Button on form to close said form... Where on the form would I put the event for the button to override all other events...

Sorry about that. I'm no designer, and would never be, but this is something I can 'experiment with', however, I was just after some ideas on how I could do so. I don't have a wallet for each month, and can see why the design would not be based upon this, but in my insights on gathering some...

I've been using an old trusted 2D budget sheet I created in Excel a couple of years ago, and it's served me remarkably well up to now. I need to incorporate something 3D in to Access, and was wondering how best to do this. I'll need to extract spending by Category and Sub Category per month...

I'm no Guru! but heading up with what CJ mentioned... I'm truly thankful for what you guys have done in regards to the help, guidance, and more importantly.. [Patience]:banghead: I'll try not to bug you too much in the future.:rolleyes:

Welcome to the forums!

Now I know us mere mortals on Access can be a pain in rear for those that have all the knowledge. But I was thinking... What was it/ what choice did you take to become so successful in Access? Is there any structured method of learning VBA, SQL etc? I'd like to know as it's something...

Bingo! :banghead: I just needed to add the Account ID field to the mainform and hide it. Then used the AccountID in the open args in the other form. All works perfectly. Thank you:) and sorry! but It's really is appreciated.

:( sadly not as it's a textbox

Awesome.. this works! It populates the combobox no problem. However (you didn't know this was coming:rolleyes:..) cboAccountSelect has two columns.... the first is the ID (hidden) and the second contains the name... how can I bind the openargs to column 1 (given zero is the accountID)...

Sorry.. does this help? dblClick highlight field on one form;frmMainMenu to open up and populate cbo on another form; frmMain... Forgive me if I sounded a bit stupid :(. I forgot that subforms are also controls..

Hi CJ. Many thanks again for your prompt reply. My apologies. I wasn't clear enough in my original post. My current setup is... frmMain - (Currently loaded by a hyperlink on frmMainMenu)- in the header sits an unbound combobox; [cboAccountSelect] and all it does is list a number of accounts...