Search results

Hi, I am using Access2007 and working on one query in which i need the instructor's list but only those who are new and teaching the courses first time. So I have one list in which i have terms, courses, instructor name and few more. so is there any way to do it because may be one instructor...

I have one database in .accdb format and i have another in .accde format.. both are different and as I can not go in the design view in .accde, so I need to know that how i can make some changes in that file with the .accdb file I have. What I need is to make some change in VB Code written in...

What is MS SQL reporting services!!!?

Hi I am simply working on MS Access Database. Created one table and exported to the excel. Now each time if i append the latest data to that table which i have created in Access then I want excel worksheet to be refreshed when i hit the refresh button in excel. What to do in that case!!!!

Hi, I have one .accde access database. It has already crossed the limit of 2 GB size and now I am trying to compact the size by doing the compact and repair but its not workin. After compacting it remains the same 2 GB size. What to do now!!!!!!!

Hey friends, I want to know that what is the procedure to link one table of access to the excel. I export that table from access and then i went to dataconnection tab and by giving that path of access i hit ok and after that If i try to update soemthing in access then It wont update in excel...

Hello Friends, I just wanted to know that if i want to export any file from access to Excel (which I know) and then if i want to connect it with that main table of Access so once I enter any new row in it then I will have the new data in Excel once I refresh it in Excel. What I tried is ...

I have a table in which i have three columns. first columns contains semesters, second column contains enrollment count. third column contains department. there are three different semesters for example 2008 spring, summer and fall. departments are electrical engineering, mechanical engineer...

I am using MS Access 2007. and now i am trying to learn Forms. I have one table which is related to one college information. I want to create a form in which i can have three boxes (one of them is combo box) so in the combo box i ll have three semesters Spring 2008 summer 2008 and fall 2008 so...

I am using MS Access 2007. and now i am trying to learn Forms. I have one table which is related to one college information. I want to create a form in which i can have three boxes (one of them is combo box) so in the combo box i ll have three semesters Spring 2008 summer 2008 and fall 2008 so...

Hi all, I am using MS Access 2007 and in one query what i need is to add @yahoo.com to a list of 2000 users. i have already joined their first name and last name but now i want to add @yahoo.com after their name. reply me ASAP. Thanks Arpit Raval

I have exported table from Access. Where I do have option of Access dates, Dates by week, Dates by month. So i can see the month and data in between that month instead of going date by date. But now i have exported that table in the excel and now i can not see the date by month. it is coming up...

Hi, I am using MS ACCESS 2007. I am new to forms. i tried to learn something by my self but not the whole thing. My boss did create one form in which he has selected few tables and queries in it. What it does is, every day it puts the latest date automatically once we run it and according to...

i have a list of the 5000 users whose email addresses are firstname.lastname@yahoo.com and now i want to convert it to firstname.lastname@sify.com so please let me know if there is any option of doing it through query design otherwise its pain to do it manually. I have seen the concatenation in...