Search results for query: *

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.

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.

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...

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...

I want to make sure users flag one and only one address as home address. I am using &quot;1&quot; in AddressType field of tblAddress to indicate that the current record is a home address. If on a second record for the same person the user enters &quot;1&quot; in field AddressType I want to pop...

XP Developer Package Wizard error I get Error -2147319779: Method '~' of object '~', when I try to create runtime version of Access XP apps, even when it's a very simple database (1 table 1 form). I checked on MS site and found that this error means a library is not registered. Any ideas?

Error -2147319779 with runtime package wizard Hi I get this -2147319779 error with no meaningful error message when I try to create a runtime of my Access Xp app using the packaging wizard of XP Developer. My app is split front end/back end, I launch mail merge (MSword) and Excel spreadsheets...

How do I add a row number to a report? I want to add a field in addition to my report fields that will contain a sequence starting at 1 for each row displayed in my report. Thank you

I am using Access XP for an application split in front end and back end. The front end is distributed to 6 users, all writing to a single back end on a server. Occasionally the users get &quot;Unrecognized database format&quot; error, at which time they have to exit the application and run...