Search results

I think you basically answered it yourself didn't you? IF [PAYMENTS RECIEVED] = [PAYMENTS PENDING] OR [PAYMENTS BALANCE] = 0 then [PAY STATUS] = True Else end if

Use the "On Dirty" event.

Looks like I did.... I think the word "Requirements" threw me.

Maybe Im reading this wrong...... Your junction table represents....One record correct? So the JunctionID should be in both Agent table and Requirement table. One to many Junction to Agents and one to many Junction to Requirements? Well, thats not how your tables are set up.

If your using 2007, which you stated in your first post, you do not need any additional converter. 2007 has the ability to send in pdf format. I'm not sure how you would do this with a form.... Forms are to input and view data, not meant to be used as a document... Thats what reports are for. If...

What you are going to send needs to be in the "Docmd.sendobject" line.......for example a report...... DoCmd.SendObject acSendReport, "rptNameOfReport", acFormatRTF, Me!To, , , Me!Subject, Me!Message, True, ""

I would take it a step further and put a message box on the close event to make sure you wanted data dumped on close. As Missinglinq said... If you are the only one using this DB then.... whatever you like... But if you have other users this is REALLY going to confuse them!

That auto centers the form. Not what I'm looking for.

Trying to do a little something here... Most of my DB's do not maximize forms...BUT... this time I am working on an add on to some software....So I want to imitate the layout... Right now if I just do a maximize command on load I get a left justified form with alot of real estate on the right...

What do you do when you WANT to save the record.... I think what your getting into is looking for all fields to be filled or not save? Do a search on "Validation" Lots of info on this forum. With an "Undo" on close you would never have any records in your table....

Sounds like it's getting complicated :) Just a thought for you... you do know you can use an Excel spreadsheet as if it were a table and link your Access DB to it.....

No code or macro should be needed if the forms are linked. You should be going from a ONE (on your mainform) to a MANY (on your subform).. Check the "Link child field" and "Link Master Field" on your "DATA" tab of the subform....... You should see your PK of the main form.... Something like...

Isn't "Cancel" your option not to open the form?? And I think on your second question, on the default message, that would be setting the warnings to false.... I haven't done too much with setting warnings, but I know the correct syntax is in a few post here.... remember to turn them back on!!! :)

Well, if I understand correctly what you are saying... It sounds like your relationships are set correctly except you need to check the box for "Cascade delete related records". For example... I have a DB for orders.... I have an "Orders" table and a "Orders Detail" table. Set one to many from...

See if this is what your looking for....... http://www.databasedev.co.uk/print_multiple_copies.html

How bout the code on a different event.....

Having a bit of a problem... was wondering if anyone else has had this also..... I recently did a format and reinstall of XP on my laptop....Then installed Office 2003, then Access 2003 and then Access 2007. Now the problem.....When I hit Send receive on Outlook it starts the install of Access...

Not sure if I'm following all of this.... But how about a If....then... or a Select Case statement to change the size and appearance of the label that IS picked? Say changing it from a size 12 to 14 and change to bold or use color changes.

I would take a look at your relationships..... And look at the forms "Data Entry" property... There is NO reason a multi table query should not work. Sorry to say..... But I think a form for every table would be a nightmare for a user..... It would become confusing and very time consuming. I...

Look into using the "Tag" property on each control. Then you could run an "If....Then" statement to requery on controls with tags.