Recent content by Somebody

hi is there a command or function that i can use to create a new database (.mdb) to a location that would be entered by a user I essentialy want to be able create a back-end and put tables in it i dont have a problem with coping table in a database but i cant create one with nothing in it...

WOW pretty clever, thanks fifty2one as for putting both imperial and metric, it would be the best but a big headache to figure all those details. The best would be for everyone just to convert to the same system... thanks and keep up the good work guys

hi i have a table where a field is a diameter of a pipe. This diameter is entered by a form as an integer or as a fraction of type : ¼ ½ ¾ i need to calculate the average of these diameters, but it wil take the fractions as text and not use them is there a function or setting i can use to...

hi i have two reports that are different but that i would like to be shown together. They are now as two reports so if i want to view them i have to open the two reports in different windows in preview mode. I would like them to open in 1 window and have one at the end of the other one without...

It tells me that i can't build a link between unbound forms when i click the ... button

the Source Object of my subform is " Query.qfltSubEstimation " "qfltSubEstimation " is the query in the subform and the child and master link fields are empty (in the "data" tab...)

George, don't worry i didn't use SubformName as the name of my subform, its just that the name was long and complicated so i put an example to simplify things banana, i tried that put nothing appears in the middle and right box of the Expression builder when i select my subform. in the form i...

wow thx George Wilkinson it helped me understand a few things but when i try to write the line pat gave me, the controls names do not show and if i put it anyway i get : " compile error : Method or data member not found" i used "Me.SubformName.Year" where 'year' is the control name as found by...

hi, it dosen't seem to work with that approch or i just dont understand how to do it or i didnt explained well how is my form/subform My subform refer to a query (source object = Query.QueryName ) so there are no controls in my subform, just fields like in a datasheet i included a picture...

hi, the form uses combo box and text box to find a type of euipement and then these items are stored in a table. The subform, wich is in the same form as the one to add item into the table, is mainly composed of a query that shows all the items depending of the combo box. what im trying to do...

hi i learned acces by myself so there are thing i really don't know how to do : i'm trying to get the information in records in a subform so i can put all the data of the record in differents textbox in my form. By pressing a button, the info of the selected record in the subform would be put...

thanx for your help but i found a solution to my problem using another table for the years and a dSum() with a condition between the table and the year specified in my querie thanx again and have great week -there is no recess in access

hi i'm trying to create a report that shows data by year but where the data repeats itself every year until the specified date. In the table where the data is, field is for the year until this amount has to be counted So if the data is set for 2011, it should be present in the report for 2009...

hello i have a subreport in a report and im trying to get the results of the subreport in my report. The problem is that i want to get the sub total that are calculated via the loop of Sorting and Grouping. So i want the result of 3 sums that are defined in the same control (text Box). I can...

it Works !!!!!! thx