Search results

Dear All, Am trying to create a graph in excel with my values. The categorization of y-axis values are done according to my views and am unable to categorize the x-axis values. I need the x-axis categorization as 0,10,20,30,40,50,60. I tried by viewing many articles and videos but am not...

Hello, I have created a demo form where user enters the start date and the end date. The access should automatically display the month name in month column based on the date in end date column. For the control source in month column I have used =MonthName(Month([EndDate])) It...

Hello All, Am a Novice to Ms Access. I have a doubt regarding a project. I have seen a form which have a button. If we click on a button in a form then a ppt is opened. I have seen a code for that backend process and it's bit difficult for the beginners like me to understand it. The code is...

Hello All, Am a Novice to MS Access. I just created a demo sample (Let me explain in detail) I created a table name HEAD with column names (ID, Begin, End, Month, Year and Quarter) Begin and End are dates. I haven't entered any data in Month, Year and Quarter fields. In the table properties I...

Hello, Let me be clear on this. I have an excel sheets with tables (Numbers). I have inserted this excel files into PPT. I have a button on my page. I have linked the PPT path to that buttom (using hyperlink). So, when I click the button the PPT which contains the excel charts is opening...

Hello, I have a search button in my main page.. When ever I click on the search button it shows all the data and the relavant search options. It worked well until yesterday. Don't know what happened yesterday and today when I click on the search button in my main page. It's showing an box...

Hello Friends, Am struck with a problem in my project. Kindly help me out how to sort it out. I have a DB with Start Date (dd.mm.yyyy), End Date (dd.mm.yyyy) and Quarters. We have 4 Quarters (Jan-March, April-June, July-Sep, Oct-Dec) and extra columns of month (xxx) and year (yyyy) too. The...

Hello, I have a primary form. I just want to have the same Primary form twice (The 2nd form will have some design changes only). When I copy the Primary from and paste it then the copied primary form is unable to open. It resulting in some logical errors to open but when I open the original...

Hello, I have created a form in MS Access. I have added a button name "HELP" to that form. Now I wanted to connect a file which is located on the server to the HELP button. If a user clicks on the HELP button then the file needs to be opened. I have set the hyperlink address of the file...

How to hide the layout of subform in Main form?

Hello, I created a form which fits to my screen resolution. When I open it through an another computer which has different screen resolution then my form is opening according to my 1st screen resolution. I wanted to fit the form resolution to the desktop on which it it opening. Is it...

Hello, I have a main form which displays the results in the subform. My requirement : I have 1 main form and 2 subforms in that form. I just wanted to have a get focus function on my 1st subform and needs to display the focusing result in the next 2nd subform. In Detail : I had a main form...

Hello, I have multiple search boxes in my form like Name, Pages, Year, Email, University etc.... Instead of displaying all the search boxes with the names I wanted to create a dragbox for those search boxes. Dragbox (Should contain all the names of the search boxes) If we select "Name" in...

Hello, I would like to know how to add new records into a table from another table. I have 2 tables A & B. A is the main file and if customers wanted to add new data into table A and if he clicks on add records in table A then table B needs to open. So that they want to add records in Table...

Hello, I have created a form and a subform from a table. Initially I created a table with 11 rows. After completion of my project I added an extra of 480 rows to the main table. But the newly added rows are not coming in my subform. Attached is my project. Could you kindly have a look into...

I have a field named Location of type Hyperlink. I have copied the respective filepaths in those location column. The location filed looks like M:\New\1234.pdf M:\New\1111.pdf M:\New\2222pdf M:\New\4444pdf If the user clicks on this link then the respective file should be open I don't want...

Hello, I have created a from which consists of search boxes in the above and the table in the below. If we search for any in those search boxes then the results will be displayed at the bottom (The results will be displayed in the table which is located at the bottom of the page) I had...

Hello, I have created a 6 search boxes with names Author, Published, Language, Title, Keywords and University. If I enter "A" in Author search field then it should return all the 6 fields which contains "A" in Author field. It worked well. Am happy with it. My Requirement : The column...

Hello, I have created a table with name "Main". It consists of fields ID, Author, Title, Abstract, Page and Published. I have created a form named "MFORM" with text boxes Author, Title, Abstract, Page and Published,and then I created a search and clear parameters buttons below the text box...