Search results

thanks, I Chose SQL server2008 express, now the upsizing part is the problem. do i need to convert anything to SQL statements for me to start using it? My app has many tables/relationships to other tables and queries...will it be difficult to Upsize? ..because I only need the back-end to hold...

I have the following questions regarding this topic: 1.I want to upsize my Ms-Access app to SQL server back-end and then PACKGE AND DISTRIBUTE it. So after i upsize my app, how will i distribute it in one package and or "server and client" the issue is how will i package the back-end which is...

I think i have resolved the issue after careful consideration of data normalization as spikepl suggested, mh! needed just to think a little deeper, :D on to the next " :banghead: "one

thanks spikepl, i have normalized the tables, but the problem comes in when entering records. you see, i have to make a report-card for each student that displays there results....i cant figure out how that would be done!!

I want to create a form where by the user can select the fields he requires and the table is created. example: i have a table of subjects like maths,english,french,chemistry etc, the user can choose what subjects are available in that particular school and therefore a table is created based on...

mh!..i thought about it and decided to make a (one to one) relationship, enforced ref integrity and allowed cascade deletes/updates. This solved the updating problem in the tblStudents_information, Since i wanted the updates to reflect to the tblAccounts_information on related fields, i simply...

I have 2 tables, Students information and Accounts information. the two are related with the field "Admission number" which is common in both tables, which also acts as the primary key in the 2 tables, i have Enforced ref integrity,and also enabled cascade deletes and updates. the two tables...

thanks Hartman for your rep, this is an app am developing not homework,all am asking is guidance on how to make it better for instance, if you saw the video and maybe downloaded the app. You could spot the lagging, forms taking long to open..etc am looking for someone to tell me on what to...

hallo, I have succeeded in creating a complete standalone ms access app, of-course using the run-time Access 2010. I am looking for professionals who i know are all over this forum to help me fix bugs and improve the app. any help will be highly appreciated. thank-you very much guys.