Search results

HI all, I am trying to make a graph using the wizard but i am having some difficulty. I am trying to make a bar graph were at the bottom is has the month of the records and it count each record in that specific month. Are there any good tutorials or any suggestions?? Thanks in advance. Rob

It seems like my database got corrupted. It won't let me repair it. The Microsoft Jet database engine could not find the object 'Databases'. Make sure the object exist and that you spell its name and the path name correctly. Any ideas????

I would like to know is there a way to remove the feature of right clicking on a field. Users keep using filter and it messing with the form.

Like "*" & [Enter your last name, or leave blank for all Rep's to be Shown] & "*" when I put this in the query and then run a report with it. The statment doesn't all show up. Is there a way to make the text fit on the screen

Is there a way to check in macro where something is not equal to a text value. like Status is not equal to complete

I have 2 tables and 2 forms. One is called help and one is job. The helpnumber can be in the jobs but no always. I have a button on the help form and I want to open all jobs that are associated to that number. [Log Number]=[Forms]![frmLOGENTRYJD]![Log Number] but it doesn't work.

I have a helpdesk and jobs table I have also 2 forms A helpdesk can turn into many jobs. A job can be by itself how can I create a link where a helpdesk can have muliple jobs and how to I force it the job number ? I creatd a table called HelpJobRef with helpdesk and job a a field which...

I am now pretty much finish with a database that I am converting over from 2 to 2000. The question I have is I don't need all the data but would like to keep the unique primary key which is an autonumber. The other data will be archieve onto backup tapes, cd and will still be able to be viewed...

I am trying to open another form based on a number from another form. There is a job number that can be associated to a helpdesk call. So on the helpdesk form there is a field called JobNumber and on the job form is the same. I want to be able to open the form based on a button. I thought...

I wanted to know how to make a query that will take a specific field and append it to a new table. But it has to be unique. If a word is repeated it should only show up once. What I am trying to do is make the tabe have a relationship instead of having a repeated field. Thanks

I have a table calle PurchaseReq PurchaseID User Name For now I have been having the user name being type in manual but now i want to change it so it is linked to a table and the autonumber from that table gets inputed instead of the name so it related corectly. How do I fix this?

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

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.

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

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

I have a report from a db that seems to print 2 copies when printing. I am trying to find out how to stop this. This is the only report that does it. Is there a setting I can look for?

When I open the database, it opens fine. Then I click on the button to go to the form. But, when I close it if you look at the top where the form meets with the access windows it seems to kinda jump a little. Not sure how I can fix it? Rob

can someone take a look at my subform database that I created. I would like to know if I go into the cell tabel under the field number and search for the number 3333. Why does it not go to the second record in the db since that number does show up? IS there a way that I can search for...