Recent content by superrob5

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

in order to get the back up i need my coworker to do and that takes like half the day. I wanted to see if there was a way that i can repair it but it wont give me that option. 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????

sweet man. Thanks it worked.

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

I have not had any problems with macros in my database. i know most people don't like them but they havent failed til now. The statement is now ((Not IsNull([COMPLETION DATE])) And (([STATUS]<>"CANCELLED") And ([Status]<>"COMPLETE"))) the thing that was change was one of the or statements...

(Not IsNull([COMPLETION DATE])) And ([STATUS]<>"CANCELLED","COMPLETE") This is what I have and its not working.???

thanks, but does anyone know how to do it with macros?

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.

the other solution I came up is. Create an extra field in teh job table called Helpdesk number. So when I click on the button that I force the helpdesk number to the job. Becasue not all helpdesk are jobs.

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

for some reason this time it worked. i tried it about a week ago and got errors so no worries :-) thanks

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