Search results for query: *

Great! Thanks Zion7, I will give it a shot and let you know how it goes. Have a star for following up!

Thanks Zion7 for your response. I am not sure Outlook would work in this case as I am using ASPMail to broadcast emails to multiple recipients. Does Outlook allow you to send emails to multiple recipients?

I am using aspmail 4, with Access XP, and calling sendmail function from a form. The function presents an attachment dialog box where user can browse and attach documents. However I have been able to do only a single attachment to each email; is there a way to do more than 1 attachmment per...

Is there a way (or function) in VB that will correct the case on proper names (upper case on first letter in Last and First names)? Thanks.

I am using aspmail v4 (from ServerObjects.com) with Access 2000 on Windows 2000. Worked fine until recently for no apparent reason it is generating a timeout error. Anyone seen this yet? Any resolution? Please help.

Hi Jeremy Not sure what you mean by securing the backend? Do you mean setting users/passwords and permissions? Thanks

Thanks Quehay, the toggle works great. You deserve a start! Users are not able to open the backend and see the tables however they can link to them from another instance of Access. Any ideas for blocking that as well? You deserve a start!

I was getting records corrupted when updating data between form and subforms. In my case I added a save command before closing a subform. Has anyone found other causes to this problem? Please share so everyone can take preventive measures. Thank you all.

I've tried several of the suggestions made here so far, I still cannot effectively prevent my users from seeing tables and queries, is there no way to lock the back end yet still allow tables to be linked? Same for seeing tables and queries on the front end. An .mde does not prevent the user...

Hi Jeremy Great tips on your site! I reviewed your security document. I think I am following the same process with the Access security wizard, however I am having to give some tables and query permissions to users otherwise they will not able to run action queries, insert/delete records etc...I...

I am struggling with which most efficient method to use to secure data in my database. I have an application split BE on server and FE on users workstations. I have already set up user level securit but users can still see the linked tables and queries from the FE and can also access tables on...

I want to exclude in my query any record with a date prior to the current month. I used [<datepart(&quot;m&quot;, date())] which worked fine for all previous months until I hit January. I suppose when Dec (ie 12) is compared to Jan (01) my statement does not work anymore. Any ideas? Thanks.

It's been a while since I visited this thread...The best thing of course is to prevent the corruption from occuring. In my case, edits were not yet committed when the user was moving to a new record. I just added a save command before executing the open command of the subform. Did the same for...

HI MarrowGenx But are you deleting valid records that got corrupted? Or do your records recover with the values that got replaced by the Chinese char? Please explain. Thanks

I am able to open other Access databases from the current one as long as the path does not contain any spaces, as in stAppName = &quot;C:\Program Files\Microsoft Office\Office10\msaccess.exe C:\FolderName\DatabaseName.mdb&quot; Call Shell(stAppName, 1) But the call does not work if the...

You're absolutely right dhookom, an update query works fine in this case. Thanks to all for your help and suggestions, I am still working on a subroutine solution. I will post it when I get it to work.

I use the statement below to open the spreadsheet; I have queries on my spreadsheet that are set to refire and refresh data when it is open, I suppose you can do the same with a macro. Call Shell(&quot;c:\program files\microsoft office\office10\excel.exe C:\folder\filename.xls&quot;, 1) Good luck.

Thank you both for the help, but still not working. I am not getting the error message but still not getting the values in Rank to change. Thanks Here is my code again (edited): Private Sub CmdRank_Click() Dim rank As Integer Dim Rs1 As DAO.Recordset Set Rs1 =...

I am creating a rotation of numbers from 1 to 20. With the code below, I trying to the update the field RANK of table tblRanks with value from 1 to 20, everytime a user click on cmdRank button. With each click, each field value is incremented with 1, unless the current value is 20, then reset it...

Sorry Duane but I am not sure I understand your suggestion. I am using a main form (say with name info) and the addresses are in a subform. I want use the subform events to update the other database whenever a user updates addresses in mine. Thanks.