Recent content by vistor

No, this is not the answer. There is a the contact and meeting tables do have a relationship

I have a combo box that looks up a contact from the contact table and then fills in the contacts name, address, etc. on the form. Pretty standard. The primary key on the Contact table is ID, an auto number. The foreign key on the Meeting table is ID, a number Relationship is From the Contact...

If you want an off the shelf package: Using the dbSync software, you can sync the FrontSupport's MS Access database and create a thinkDB database on your Palm handheld. This thinkDB database on your Palm holds all your support data so that you can access this data using the Palm without having...

slreynolds, I found it helpfull to me. I had never come across a good explaination of using QueryDef (even in this excellent forumn), and after reading this article, I was able to write a good piece of code to send out emails to everyone from a query pull. I hope it is helpfull to others. Vistor

I don't feel they are inadequate at all. I've seen other posts on tips that site other forumns and web sites. I didn't know you had to have special permission to do so.

Here is a good site that explains how to pull records sets using a query parameter. http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsmart00/html/sa00e19.asp

Would having the the SSN input mask defined in the field before import take care of this problem?

Thanks Epoirier!

Hi, We'er expanding a local db to more users on the intranet. I'm to set this up and haven't done it before. I know I will have to set up work groups, permission levels, etc. How do I split up the db so the data (tables) are on the data server and the forms are on the general server? How will...

I've tried using this code and gotten as far a having the emails I want in the To: field, but must find a way to have the mailto: removed. Private Sub btnEmail_Click() Dim db As Database Dim rs As Recordset Dim qd As QueryDef Set db = CurrentDb Set qd = db.querydefs!qryFilterByCampus...

Try single quotes "c:\Program Files\Microsoft Office\Office\MSAccess.exe' 'z:\Shared Data\Databases\Access97 Databases\Accounts.mdb"

The %20 is just a general rule that seems to be basic knowledge, I don't know of any documentation on it. Try a google search under removing spaces in file names Also never have a space in a field name in a table, If you want to use a seperator, use an underscore. Customer_FirstName.

Sorry, That has been my solution. Can you rename the files and take out the space?

Wouldn't you want to Build relationship tables between your tables? tblRel_Business_Customer Business_id = Primary key Customer_id = Primary key Then create a Select query. Pull both fields from the tblRel_Business_Customer Pull Customer_Name from the Customer table Pull Bussiness_Name fromt...

Try putting %20 where the space is: R:\templates\my%20file.doc