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