Search results

I got it.. DatePart("q"; ([Date])) I missed ; and used , instead of that in the query

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

It displaying the values in the year column as #Name?

For the year part am using Year([End Date]) but it's not working.

Hey, Got it..... I succeed with the month column. thanks for your guidance. Could you similarly give me the formulas for finding out Year and Quarter too.

Thanks for the reply For month I have seen that "MonthName (3)" But in my case, How cane we refer to our end date in the open brackets.

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

can anyone help me out please.......

Thanks...... Am done with your suggestions and it is fine.

I have a Main form which consists of two subforms. The two subforms has the default layout of Microsoft. I just don't want the layout to the subforms. Is there anyway to get rid of those default layouts. The default layout of subform consists of "Total Records and a small search box"

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 CJ_London, Am not getting AuthorLink while I was trying to set the subform2 linkmasterfield to AuthorLink. AuthorLink is not getting in the options overthere. Could you kindly have a look into this.

My 1st subform "Results" displays all the searched results and the output of 1st subform looks like below Results : ID Author Title Publication Keywords ContributedAuthors 1 xx xx xx xx xx 2 xx xx xx xx xx 3 xx xx xx xx xx 4 xx xx xx xx xx If you click on ID 1 in the 1st subform then the...

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

Thanks. It worked for some bit. Am Novice to MS Access. I ahd attached my project with this post. Could you kindly have a look into this and let me know how to achieve my requirements. I mean there should be a text box for that dragbox. We need to enter anything in that text box and then we...

It is a combo box whcih contains the name of the columns.

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