Search results

Hello guyz, am currently havin a problem with a report but i fink the main problem is with the relationship between my tables!. so i have built a scholarship system. I have details like school certificate,A levels result and degree information. i have built a report which retrieves the school...

Hey guyz, i just wana query about 45 fields..i dnt know why Access 2003 is tellinn me to remove some fields and generate the report again..i dnt have 255 fields.lol...Is there any possible causes for this. The data is coming from 4 tables! Hope to get ur help!

Hey guyz, i built a query with many fields...wen i try to generate a report, it tells me report cannot be generated ..remove some fields ect??...Is there a way to force the report to generate the results? kind regards

Hey guyz , i have built a system in access 2003 and i want to install it in such a way so that different users can use it to add and update records. How to i install the system with a centralised database that will unable different users to access it from their pc?? What record locking issues...

Hello ever1, I have created a form with some commands like add new record ect. In my system the user must save the current record before moving to another one..i have included some validations that disable and unable buttons on my screen. i want to include a cancel button that will undo...

hey guys, am actually building a scholarship system...i have report that generates the field of study of particular candidates. A candidate can opt for one or more subjects. Among a maximum of 3 he/she may just opt for 2. I have 3 textboxes. The fing i want to du is that i dnt want to disply...

kool that works thanx for ur great help. great mind think alike, lol

Hey thanx paul. i wan t to ask u another thing. If i want to generate a report for a particular scheme and a particular scheme year...can i du it via the criteria stuffs again?? i.e i'll put [scheme year] under criteria for year! Regards

hey there, hpe u'll help me throw more light on this ....i have build a query for a report. I want to generate records based on a single text input...my system is based on scholarship 4 students. i want to generate all records for a particular scholarship scheme. In the Critera below scheme...

I fixed the problem!.thanx Hey buddy , actually i made a little mistake by puttin the criteria for another field rather than the date field. Thanx nyways 4 ur help. regards

hey buddy thanx 4 replying. It isnt working.lol. i'll make u get the whole picture. i have a subform on a tab which has a textbox(out of several textboxse): date of application, on another tab i have a command button..so wen i click u get 2 prompts to enter 2 dates to get the report.... i...

Hello guyz, i generated a report based on a simple query that i've buit and all the records are displayed accordingly. But wen i parametrised my query in the Criteria(e.g:Between [startdate] AND [enddate]) of the query that will generate report between 2 dates input by the user the report...

hey thanx 4 the reply, well actually the message boxes arent important as such..i just wana give the user a way to enter dates..thats all...sme1 told me that u can fix the problem using parametrised query. do i need to include the dates in the Criteria option in the query design??

hey buddies, am generating a report containing fields from various tables which ive selected from a query in wizard view. First of all i want the user to input 2 dates from a message box..and then the report displays the records for the period!. how can i approach this problem?? many thanx...

Heyy sory i was so stupid i actually found that out. thanx nywayz

Hey guyz, i want to hide or disable the default navigation buttons that appear on the form when we create it from wizard or design view!!. Is there a way to do this. I have other navigation controls which i have created...i dnt want the user to go to another record unless he saves the current...

Actually i fink your query might just have some problem: Try SELECT Date_Range.[Month] FROM Date_Range ORDER BY Month The format works fine: SELECT [Column_NAme] FROM Table Order by Column_Name; Checked the locked property and rowsource property aswell. Regards

Hello ever1, am stuck with a small problem. Actually i have about 6 tabs on a main form which records information about scholarship for students. There are table which have one to many and one to one relationships. The fing that i want to point out is that when i input information bout certain...

Hey guys, I developed a system for Scholarship. i have one main table:Applicant and all other tables(Like school certificate results, Alevel result,Scholarship...) join to it thru the applicant_id foreign key. i want to generate a report...the format is given below. All attributes on the forms...

Problem Fixed, Thanx!! Heyyyyyyyyy, i was able to fix the problem. Actually i had so set focus to the Applicant_ID field(Foreign key) on the School certificate form. Nyways thanx 4 the great help! cya :)