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

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

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

oh ok. yeah access gives me back an error message not able to append the duplicated record. For instance Open Open the second open would come up with the error

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?

ok I dont know why but for some reason that was confusing me so I just added another query that is just for date. SELECT Jobs.[COMPLETION DATE], * FROM Jobs WHERE (((([Jobs].[COMPLETION DATE]) Between [Enter From Date] And [Enter Thru Date]) Is Null)); I just confused becasue it seems like...