Search results for query: *

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

What a big task! Bring all your workseets into one. In the single sheet, Maybe have your Excel columns like this: Assign a number to each contact, when you import the Excel file have Access define the primary key, which will become an Auto number field. Contact_ID - a number First_name - text...

Could this be a palm database extension? or CIFTr is an application program for translating files in mmCIF format into files in PDB format. CIFTr is available as source code and as binary form for several Unix platforms. Or All PathAway databases have a .pdb file extension from a google search

I've also been looking for this! Maq, where would you put the above function, in the onclick event procedure of the button?

Do you have a Macro that opens your main form? If so you need to add another action. Open the macro in design view. Add A GoTo Rrecord action below the OpenForm action. The action arguments will be as follows: Object Type: Form Object Name: the name of your main form Record: chose last or new...

In the Criteria put: Like & "*" - for any character in a string. Like "*" & [Enter any part of the name:] & "*" - For any word