Search results

kool I understand it now thanks alot but what really forces it to use the UserID instead of putting the actaully name in there.

yeah I will do that. This db was originally started by someone else so I am using the ideas from it and learning new tricks, also how do I get it to save the user id number instead of the name, but still show all the into like I have. Rob

the way I did the name is Like "*" & [Enter your last name] & "*" now for the dates I have WHERE ((JOBS.[PC-LAN REP] Like "*" & [Enter your last name] & "*") AND (JOBS.STATUS="COMPLETE" Or JOBS.STATUS="CLOSED" Or JOBS.STATUS="CANCELLED") AND (([JOBS].[COMPLETION DATE] Between [Enter From...

check out what happens if I select a user. I have it after pressing tab to auto input info. Now I just got to get it to work with saving the user id instead of the actual name

shouldn't I keep track of what helpdesk calls get assigned to each user or do I not have to relate it, isnt that why I need a foreight key in the HelpLog???? I am confused.

The way the helpdesk works it we recieve calls first writting them down becasue it often difficult to type them. Also one problem one person. So if we receive multiple calls we know it an entire are and we just work it out and only log it once. So if we dont have a helpid what should I use a...

I am in the process of making a new helpdesk at work but I got a question. HelpLog Table HelpID Initials of caller User Name User Table User ID HelpID User name(first, last) I am going to have them link by HelpID. Correct? if so and say a user leaves the company but...

can you explain what that does, becasue I didn't have to do that with the name?

I have a query that allows me to enter a person's last name. Then Between [Enter From Date] And [Enter Thru Date] If I leave the dates blank it won't find anything. I thought you can leave these blank and it will find anything.

k thanks alot

ummm now that I think about it should it just go to onload?? Rob

opps

can someone tell me when I was to Search for A at the beinging or end of a word my query doesnt work? Like "*A" Or Like "*A"

I just put that under On Current and it didnt go to the last record?

I want to be able to open a form so that all I have to do is type and it would create a new record, instead of scrolling to the end.

I would like to know is there a way to keep track of who was in a database? Is there also anything on password protecting the database design?

k

I want to jump from a subform to the main form when an error occurs. I looked in the help menu and it states Note Enter only the name of the field or control in the Control Name argument, not the fully qualified identifier, such as Forms!Products![Product ID]. I tried using this identifier...

Problem solved

yeah the report is open in print preview. Then the user clicks on teh print button and selects ok. The defaul number of copies is one but I am guessing there is coding somewhere.