Recent content by txaccess

One way around this to to make the pop up warning msg form a dialgog form and set its movable property to FALSE. This way, your user cannot drag the form no matter how hard they try!!! I haven't failed, I have just found 10,000 ways that it won't work!

I have a report with a grouping on Record Owner. There is a line on the report that shows a series of number. When I come to add up the series in the group footer using the Sum() argument, I get the following error; "The Expression 'Sum([Field1]+[Field2]+[Etc.]) is invalid Aggregate...

I have a form within my app that queries Outlook 2003 and displays email msgs. This works great in the main. However, if the user is not connected to the Exchange Server, closing the form takes forever as the app is trying to query Exchange before it performs any other functions. Is there a...

Thanks for the star. It's appreciated. I haven't failed, I have just found 10,000 ways that it won't work!

Put it one line below the code that changes the backcolor say to yellow - on the next line you change the text to yellow too. Don't forget to turn the text back to black I haven't failed, I have just found 10,000 ways that it won't work!

Try changing the text color to the same color as the background me.status.forecolor = vbSameAsBackground I haven't failed, I have just found 10,000 ways that it won't work!

Thank you - I will have a tinker with that. I haven't failed, I have just found 10,000 ways that it won't work!

You need to use the DateAdd Function DateAdd("d", 8, me.RecordField) I haven't failed, I have just found 10,000 ways that it won't work!

I have a MouseMove Event that opens a popup form and another that closes the form. I would like the form to open in a specific position on the screen (i.e. directly underneath the label with the MouseMove Event). Is this possible, and if yes, how can this be done using VBA? Thanks I haven't...

Let me see if I understand - when you click on the New Customer control, the current record remains in place - i.e. nothing happens? It may be that youe Event Procedure is not attached to the control if this is the case & you are therefore not really adding a new record. I haven't failed, I...

As soon as I read your response I kicked myself for nbeing so dumb!!!! Duh!!!! Thanks a lot, that makes a whole heap of sense. I owe you a beer. I haven't failed, I have just found 10,000 ways that it won't work!

DoCmd.GoToRecord , , acNewRec Add the above code to your new customer command button and the form will clear all fields in anticipation of a new recoprd being added. Any fields with a default value will display the dafault value. I haven't failed, I have just found 10,000 ways that it won't work!

Hmm, interesting. My first thought is that your data structure does not look normalized. It is usually a clue when you have fields that need to be suffixed with a number eg reason1, reason2, reason3 etc. You might want to try normalizing your table structure which will make the queries more...

Frank - it is slightly more convoluted I am afraid. An Account can have a Master Account, so where there is a large company with many susidiaries, or Franchises etc, each can be listed, assigned to a rep and linked back to the Master Account. What I dont have is the code to check whether the...

I have developed a sales force automation app for my company. The latest feature is a lead tracking mechanism. When a lead comes in, I would like the user to type the lead company name and then the d/b will look to see if the lead company already exists in the db. If yes, then a msg will...