Search results

THAT'S IT, THAT'S IT, THAT'S IT........... After weeks of searching for a reasonably simple solution to the problem, JHB has found it. Thanks a million, pal, for submitting the suggestion. I am a fairly new VBA beginner, and think i know how the code works (by remembering the...

oops sorry, wrong revison of the DB attached. here is the latest one.

Hi, I have a simple two-box Cascading Combo on my Form (see attached database and/or coding below). It seems to work fine, so far, but needs some fine tuning. So what I am trying to do next, is to work out a simple solution for the following situations:- 1. When TransactionType is...

duh - what didnt i try that??? i was trying drag and drop only which was a pain in the neck. cheers.

hi plog, thanks very much for your advice. much appreciated. how do you put the elements into the report? if ti is a one-off report, then the wizard automatically puts them in the correct place. but if it is done manually, do you just drag and drop them onto the form? is it possible to...

lagbolt, ah yes, thanks for suggesting to use subformas for the header (and footer??). this will keep the database slim. do you just put page numbers and current date in the footer? cheers.

Hi, I was wondering how people keep all their Report designs the same? I mean, how to make it easy for every Report to have the same text font, text size, logo header, same footer message etc etc???

Is your Command Button on a SubForm? I dont think DoCmd.RunCommand will work if it is used with a Parent property.

hi shadow9449 yes. i originally made my database in access 2003 and recently upgraded to access 2010. i guess you have seen this before in similar circumstances. at least i know i am not going crazy and that someone else has seen this too. i solved the problem by completely re-doing the...

hi boblarson, thanks for your reply. i couldn't get rid of the 'ghost' dotted square. i had to redo everything including a new form, new comman dbuttons and new coding. thanks anyway.

I have a Sub Form Menu (with various Command Buttons) in the Footer of my Forms. But at the very top left hand corner of the Sub Form Menu is a dotted square box. It is the same size as my other Buttons, but it is not actual Button. Please does anyone know how I can remove/hide/exterminate...

thanks again bob. the menu where the command button is located is in a subform. so the parent aspect is required. i will fiddle with it and get it to work. cheers.

hi Bob, thanks very much for your input. although i am not an expert!! the code certainly looks a lot neater now. i am learning where to put the EndIf statements. however, the Form is closing before the MsgBox appears. So it is saving the data all the time? not sure how to resolve this coz...

Private Sub cmdExitForm_Click() On Error GoTo Err_cmdExitForm_Click If MsgBox("Do you want to Save the record?", vbYesNo + vbInformation, "Please confirm:") = vbYes Then If Me.Parent.Dirty = True Then Me.Parent.Dirty = False DoCmd.Close Exit_cmdExitForm_Click: Exit Sub...

Pat, Thanks again for your very valuable guidance. Thanks to you I have managed to get the BeforeUpdate code to work awesomely - and the Form looks so cooooool now :) The "final"? coding is below. I was very interested in your comments that both the True path and the False path should be...

Pat, Everything seems to work OK apart from when I change the selection from "Cheque" to "Cash". It keeps the new selection in the Combo. I am hoping to have the selection revert back to the original selection. I thought maybe that is what the Undo selection was for? Please coudl anyone...

Hi Pat, Thanks very much for your reply and for the suggested coding. You have just taught a newbie in VBA a new trick. Cheers.

When Combo1 is updated, I check if TextBox1 is empty. And if TextBox1 is empty then I do NOT want Combo1 to be updated (eg. I want the original selection to remain). Please could anyone help me how to do this?

Hi, I am very new to VBA coding and would really appreciate any guidance you can give. I have a Combo Box (MethodMoneyInOut) and if anything apart from "Cheque" is chosen, I want to lock and disable a control called "Cheque No". But I do not want the new selection in MethodMoneyInOut to be...

many thanks for your input, guys. I didn't think something was right because the tblFinanceID primary key does not have a Relationship to any other table. And I thought if I added a "FinanceID foreign key" to the Contract Table, then this "field" in the Contract Table will just remain empty...