Search results

Thank for replying SOS. So basing from what you've said; and most specially the corruption part, I guess I'm better off with splitting my database. But wouldn't a splitted database suffer in speed while gathering the data back and forth in the long run when we already have accumulated hundreds...

I'm almost done with my very first database I've made. There is no plan for any multi-user environment or networking whatsoever. The database will be used on just a single PC with different users depending on who's available just to encode loan transactions by the end of the day. Having said...

I've done this ok with my forms just set the control box on form properties to NO. But on the access 2007 application itself i haven't yet found it. I don't want users to close the database by using that "X" button on top of access 2007's control box because i have a command button named "EXIT...

I think my problem is getting complicated. I've browsed and tested different codes and have read many articles regrading this multiple field addition to combo box using not in list and I got no clear solution for it. All buggy and error prone. Or I guess this multiple field addition to combo...

Hi David thanks for your excellent suggestion. I have made a few adjustments earlier after I've posted this thread awhile ago. I decided to copy the on load event of the Northwind's Customer details form which is a macro using open args and put it on my client form named frmClients(this is the...

Good Day. I'm using access 2007 and I'm trying to find a way to allow users to add two or more "New Data" to a combo box, and then opening the client form reflecting the new data entered from the combo box. So that the user can add more fields that are required before allowing them to save the...

Thanks SOS! Your suggestion worked perfectly.

Re: Using VBA to Populate a Row Source that has a Value list as the Rowsource Type Thanks SOS I will try it as soon as i get home. This looks promising. :)

Re: Using VBA to Populate a Row Source that has a Value list as the Rowsource Type Thanks for replying speakers_86. Payment Summary is also a regular string stored on an unbound list box named lbxReports which happened to have a row source type of a value list as well. So my aim...

Using VBA to Populate the row source of a Value List as the Row Source Type. Good day to all. I have a list box named lbxReports with several report names on it and i want to specifically call a set of row source on the chosen report name to the combo box named cboFilterby using Value list as...

RuralGuy and BobLarson, Thank you for that super quick reply I appreciate it very much. I will now remove all of my tables validation rules as it appears it just takes one solid way to perfectly implement proper validation and the form level can do just that and as what bob had mentioned...

Good Day! I just want to ask since there are two ways to which we can implement our validation rules in general; One in Table and another in a form, how do you usually implement it? Are you using both form and table validation rule capability or just one of them and make it as solid as possible...

No,not an SQL executed from a VBA. He said it's an SQL Select statement in the Row Source which is as you described earlier is a hidden query.

Thanks for the feedback mate. I'm not sure if i get your opinion right mate but basing from your statement above this could be what my friend meant.. SQL statement = Optimization happens at runtime. Saved Query = This one is already optimized in its compiled state. So which explains there is...

Thanks for replying. Yes, that's exactly what i thought but a friend of mine said he had read a book that clearly states using a saved query as a row source is much more efficient than using the SQL SELECT since if you use the SQL as your row source it will be optimized by Rushmore on the fly...

Just a quicky question, Which is significantly faster when used as a rowsource for a combo box or a form; a query based inside the form(SQL) or a separately made query? Thanks in advance Note: Row Source Type are both Table/Query

Yes Thanks rainman mate, That Actually Worked! I also tried changing docmd.CancelEvent into me.undo but it didn't any good. Thanks again! Rep For you ;)

okay but still i can't replace it with me.undo because the only choices were 1.acSaveNo 2.acSaveYes 3.acSavePrompt and if i put me.undo there i'm just receive a compile error. I also have docmd.CancelEvent below which isn't really canceling because when i click "No" it still saves the...

Yes it did worked before or even with the new code you've suggested. Only problem is when i choose "No" it still ended up saving the incomplete data. it seemed to me that the acSaveNo argument has nothing to do with saving the data or not.

Private Sub cmdClose_Click() If MsgBox("Do you want to save?", vbYesNo + vbQuestion) = vbNo Then DoCmd.Close acForm, "frmReceivableT", acSaveNo DoCmd.Requery "" Else If IsNull(Me.Credit) Then MsgBox "Credit Field is empty" DoCmd.CancelEvent End If...