Search results

Personally I would not do it for the dates, but the customer is a good idea. I know that you will have many reoccurrences of dates & times within the Visits table but that is expected. I would have the date/time entries in the VISITS table, and two lookup fields to customers and salesperson...

When you create the fileds in tblVisits, use the look up feature. Then go into relationships and edit it to have referental integrity. It will then display as one to many. You can edit the field lookup as well to change the display of the data from 2 fileds to one.

You’re on the right track, but have to correct a few things. I have attached a sample for you to look at. In the tblVisits, look at the fields and their relationships. The tblVisits is linked to the other two, which normalizes the database and eliminates the need for many to many relationships...

Many to many is never the answer. You need a junction table. From the description, I would call it tblVisits. The table would contain a key from both the customers and dealers. The new table would assign a unique ID to each visit, and contain the customers ID as well as the ID for the dealer...

This may seem to be the easy answer, but seeing my son before I leave for the day is about it. He would be my sole inspiration.

Go to FILE - PAGE SETUP when the doc is open. Under the Layout tab you will see in the middle options for HEADERS AND FOOTERS. Select the DIFFERENT FIRST PAGE check box and you can set up the first page as you want, and then have the remaining pages set differently.

Recently I had the opportunity to speak with an individual long in the political arena. He was very informative and actually well connected in the game. It is so interesting how both sides of the fence view each other, and how both sides get it primarly wrong. Do I mean the Liberals and...

I have used 3 types of scanner input devices (4 counting that Qcat thing from Radio Shack :rolleyes: ). One of these units was strictly USB, and once it was connected it worked in the same fashion as the PS2 connected model. Once connected, I was required to selected my barcode type/standard...

Sorry for placing my faith in spell checker.....:o I think the Gov should not attempt to legislate morality. The biggest issue the right to life group has is based on religious beliefs. Isn’t it generally the same religion that believes that we as people were given free will to make decisions...

I love to see the heated debate over this. Ironically those who demand freedom and choice overlooked conscious. Those in opposition seem to demand their will be followed. I always said it is the choice of an individual that has to be made based off of their circumstances, faith, conscious, and...

It has been my experience that the standard scanner gun will work via the keyboard port and enter its "read" as text.

Only 2 cents.... Well, for once I full agree with you Pat. You have stated the case very well. What I feel everyone is overlooking is the whole of the statement "Illegal Alien". The first of the two words says it all. These individuals are here illegally and are no better that any other person...

I am truly sorry for a slow response. I was in training and failed to check my e-mail. There is one note that I would like to mention, you should base forms and reports off of queries instead of directly off of tables. This will give you greater flexibility for all changes you make in the future.

You should be able to go to the properties of the form and there you should see the data source as the table that you have selected. Click on the ellipsis to the right of the field containing the table name and you will invoke the query builder..... Since all three tables are already linked, you...

Sorry Pat, I thought that was what I was attempting to get across. BTW, were involved in a WebEx meeting this morning? I saw that a Pat Hartman was listed and was cuirious if that was you.

Ahhh, Pats old nemisis, the access application. Pat is correct here, but if you are looking to aviod paying for access on every machine that needs to access the database, then the developers edition would be something to look into. I have used it in the past, and it is useful in certain...

I am not declaring innocence or guilt for the parties being held, but these were not random people who looked crossed eyed at "SNATCH SQUADS". Just as I cannot pass judgment on their guilt, you cannot pass it on their innocence. These were people involved in terrorist activities or bearing arms...

I must agree with Scott. Those detained at Guantanamo Bay have given reason to be there. You cannot hold one side of a dispute to a set of guidelines that the other fails to even acknowledge. Where is the declaration that the terrorists are unfounded by attacking civilians? Where is it stated...

Sorry I didnt get back sooner, but Smart has it right. If you are going to run the code to get the proper date, assign it to a varible and then run the comparisons against the varible. Like Smart posted Dim Whattime as date Dim Whichday as string Whichday = format([Yourdatetimefield],"dddd"...

Easy answer is yes you can. The difficult part is determining the criteria of day/time in your code. You will need an if statement on the forms On Open event. You would define variables that you would assign the current day/time to and then if they meet your criteria you would assign either...