Search results

Hi All, I am playing around with some VBA code because I want to understand how it works and just make my MS Access Databases more "efficient". I really don't understand how varibles and constants get transferred around, like for a multi user database. I have front ends and back ends but no...

Thank you James!!! I'll look into doing that...it sounds much simplier but I am "not to good" at writing VBA. I'll give it a shot though. Larry

If msgbox("Are you sure you want to update the following records?",vbOkCancel) = vbOk Then DoCmd.RunSQL "Your code here" Else Cancel = true End if Try that!! :) (or some form there of)

Does the dialog box have anything to do with the strSQL? My thought is that the docmd.close (of the dialog box) may be the reason, if you are closing it before a value can be transferred. Just a thought... :)

Good morning!!! I have a form where we do "After Actions" on different case through out the month. I have an attendance form where we take everyone's name who is there... Once one record is done we move to the next record but I (nor does any one else) want to re-type all the names again...

Thanks Pbaldy!! I got around it by typing in the record source instead of referencing a query. it seems to be working perfectly. :) Larry

Hey Everyone!!! thought I would join this discussion....I love this code. But I only want to send a record base on the form they are filling out. When I put a parameter in the query...I get the error messege Parameter expected. When I take that out it works fine but will not e-mail the...

AWESOME!!! Thank you! Larry

Good morning, I have a form that I want to lookup a value in a table and based on whether of not that value is there I want it to run an append query or just show the table. What I would like When the button is clicked...check to see if a value is created in a table (using DLookup for...

Are you using the "Me" feature for you combo boxes on the subforms? I don't think you do that. It has to be something like Forms!SubformName.controlname.requery

Have you tried creating an Update or Append query? the have that run based on a command button.

I don't have Access 2007...but it sounds like you need to have your subform based on the Unique value in your combo box. Can you save it as a 2003 format so I can take a better look?

Have you tried writing a VB code in the after update event of the "checkbox" Something like: if me.[banned]checkbox = true then me.othertextname.backgroundcolor = red End if you'll probably have to play around with the syntax but I think that would do it for you.

Sorry I couldn't be of more help...I'll continue to see about a work around when I get some time this weekend. I looked at the tools hidden objects (tables) but must have missed the system objects. no worries though. :) have a good day! if I come up with a better solution I'll let you know.

I can't see any of the table in the DB... :( What I think you will have to do is this though... I think you'll have to create another query and form. Then when you click the "view" button, have it open the "new" form in datasheet view with the list. I really don't think you can do what...

Haven't forgot about you...I have some things to get done at work, then I'll jump all on it...like white on rice....to see if I can help out. Larry

cool...glad you got it working! Larry

Put this under the "Close" button VB code on the UpdateUser form. Forms!frmUserMaster.List30.Requery

Try this out... ignore the delete query in here...you can just delete that if you like. I put a "delete" button on the edit form

How about creating a "delete" query? So basically you create a query that has all the fields in it you want associated with the Phonelog ID and UserID. The create a button that will take either the "phoneLogID" or "UserID" and run that query. I think this will bypass the referential integrity...