Search results

Thank you for giving me credit for my code. I'll never understand why someone would want to take credit for the work of others, but there are lots of people who do just that. In my mind they are losers who will never really succeed in life. They will have to lie about their own worth when they...

You have to set the Response pararmeter to kill the error message. Private Sub Form_Error(DataErr As Integer, Response As Integer) Select Case DataErr Case 2113 Dim varRet varRet = MsgBox("You must enter a date in text box!", vbOKOnly) If varRet = vbOK Then Me.Text0.Undo...

Binx Join the newly created query to tblParks. Then add the Sum field to the grid along with all the fields in tblParks.

Hey Chris Hope all is well with you. DropBox is a file backup/sharing site. My impression was that Spike wanted to use it as a means of a multi-user database. But I don't see it as being possible since only one person (the owner) can update the BE.

I can see some pitfalls with that setup. For one thing, it appears only the owner of the folder can sync to it. Therefore, whatever changes someone else makes to the loacl BE will not be sync'ed to the DropBox file. Even if the BE is read-only for the other users, they would have to download...

Binx DSum() functions can pull a lot of overhead. It would probably be better to create an aggregate (Group By) query with the ParkSite in tblCollections as the Group By and the CollTotalVol as a Sum. Then you can join tblCollections and the new query on ParkSite and use SumOfCollTotalVol for...

Carrie I assume there is a query or table for the Listbox's RowSource. You can see the RowSource property if you open the form in design view, click on the Properties icon and then find the RowSource property. When you find the RowSource click on that line and you will see a little builder box...

You're very welcome WJ (Your name?). And thanks for the plug.;) If you have any questions about the tools I made feel free to contact me directly though my Contact Us page.

I glad you like my code! I just happened to stop by here because PBaldy told me you posted a question about my script. I think the probelm lies in the file path containing spaces. Try surrounding the entire path with double quotes. WSHShell.Run """" & cLOCPATH & "\" & cSCName & ".lnk" & """"

Just a suggestion...Did you install Office 2007 SP1?

Just an update of sorts...I haven't received any feedback from the MVPs yet on this issue. I bumped it to see if it stirs up any more responses.

Thanks, RG. My Yahoo group is only one place I lurk.:D But it is my #1 priority when it comes to forums and news groups. Paul's just as busy, if not more so. He moderates my group and at least one other that I know about.

Just to let you all know, I've posted these findings on the Access MVP newsgroup for feedback before reporting it as a bug. (I'm Paul's buddy...until I owe him money).