Search results

hi, i would like to know how to make a query to hold information about the profits(money) made by my company every month. from this i would like to produce a line graph to show the rise and fall of profits over months and years. i have already created the profit from each transaction thanks...

Thanks very much for your help, problem solved!!!!! :D

no, on the input of a new record. if the record key is duplicated i wish to make my own message box to appear rather than the access one, thanks

does anyone know how to customise the "the changes you requested to the table were not successful because they would create duplicate values in the index, primary key or relationship" message box so that you can put your own message there ??? thanks for your help :D

thanks for your help :D

ive got a 'log off' button on the mian menu. when itis clicked the logon form is opened. Is there any way i can close all other forms other than writing separate close commands for each form? thanks

thanks for your help, it now works!!

where do i put this? is there any way of putting this in a QBE? ( i only know how to use this) thanks

hi, im making a computer repair system and would like to know how to extract the most frequent customer ID (integer) using a query. thanks :confused:

sorry for making myself unclear. When i click on a label i would like that label to exapand to diaplay the text related to that topic. On some forms i have about 10 or more labels to display, by doing it by the way you said it would clutter the screen up. i have attached an image to show what...

when i copy paste the code the "You must be logged on as the administrator" comes as parrt of the label i thank u in advance wayne

hi i have got a problem with a customised help feature for my database. when i click on the label i would like the label to expand to show the help feature related to that topic. I have to following code so far that displays the lables when clicked on cmdHelp. The text that i would like to...

if you want to check something then does that mean you r going to make that specific record invisible? if so there is no point beacuse the user wont be able to uncheck it as it would be invisible. if there are thousands of rows then is it sensible for the user to check all of the rows to make...

isnt this just going to a new record? docmd.gotoRecord,,acnewrec

The reason why the third table approach works is becasue it can provide a link between two or more tables. The third table allows you to enter fields that may be secondary or even foreign resultsing in one to many relationships. With a two table database your data is restricted therefore...