Recent content by Spira

hi does anyone know how to disable the ACCESS control box? thanks

THANKS JON !!!!!!!!!!!!!!!!!!!!!!!! PROBLEM SOLVED!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! :D :D :D :D

Thanks but this still doesnt resolve the blank results!!!!!!!

this has been giving me a headache. if there is no profit for a particular date then nothing appears. i have tried the Nz() function but keep on getting errors i have attached the D.B the query concerned is QryProfitMonth after this is completed i would like to output the result to the dates...

ok, ive tried implementing this Nz() function but its still giving me a headache as it doesnt work. here is the SQL and where would i put the function to give me a 0 instaed of nothing SELECT Format([Date],"mm/yyyy") AS ProfitMonth, Sum(tblJob.Profit) AS SumOfProfit FROM tblJob WHERE...

jus askin a quick question. if the user does not have the directory c:\mybackups then the backup comes as a .file. is there any way that a folder can be made if there isnt one or is there an extension for a file folder that i can use?

thanks for your help, the problem is resolved !!! :D

im not very good at queries- how would i do this :confused:

the sytem im making will be installed on a different computer than the one ive got at home and the directory that it may be installed is variable- Is there a way of overcoming this problem like having \Mydatabse.mdb in the code rather than c:\path\mydatabase.mdb? thanks

thanks for your help- one more problem, if there is no profit for that particular month can you get the sum of profit to display 0.00 instead of not displaying anything???

yes it is- i made a different message appear to each user when they logon. have a User table that hold the attributes Username;Password;CustomFormName create a query based upon this table and in the criteria for username/password use a parameter to obtain username/password e.g forms!your...

how? but i would like to copy the database preferabily on the click of a button

thanks for your help on my previos post. the new problem i have is that i would like to know how to backup the database ,on click of a button or at the end of the week. is there a way to chose a directory to where you wish to copy the database file to, like an installation program??, thanks

whats 'HAVING' ?

i have attached the database. the query concerned is qryProfit what i intend to do is record the amount of profit made by the business every month jan= £1000 Feb= £1100 .etc from this i would like to make a graph to show the changes in profits over the year. thanks :D