Search results

Hi Everyone. I have a table and one of the fields is a date field. I need to create a query based on this table such that only records from the current year is displayed. So I need to retrieve the year part from the date and compare with the current date. I m not too sure on how to do this esp...

Hello Everyone! I have a table with with details of a site. Each site is identified by its siteid. Each site id might have a few records. I want to get the latest record for each siteid. Like I have a field in the table which shows the date. I wan the lastest date for each site id. Is this...

Hello everyone. I have a table called payee table. It has the following fields: payeeID payeeName payeeAddress Postal Code accountNo type The thing is I have created a form such that it allows the user to add a record into this table. PayeeID is actually autonumber and primary key for this...

Hello Everyone! I have an form. The function of this form is that when the user clicks on the save button after entering some data, it should be able to go and store into the table. Does anyone have any idea how I can insert new record into a table through vba coding? Thanks for any help :)

Hello Everyone. I am having a small problem. I want to open a second form from the first form based on a criteria. stLinkCriteria = "[PayeeName]=" & "'" & Me![PayeeName] & "'" And "[PayeeID]=" & Me![PayeeID] & "'" DoCmd.OpenForm stDocName, , , stLinkCriteria initally when I just set...

I have a code as follows that I have put behind a button: Private Sub Command4_Click() 'Declare you variables Dim dbs As Database Dim rst As DAO.Recordset Dim Counter As Integer ' set up a updateable recordset of your table Set dbs = CurrentDb Set rst = dbs.OpenRecordset(cus, dbOpenDynaset) '...

Hello. My problem is that I have table containing products and the person who is managing the product and his address. One person might manage more than 1 product. Sometimes this person migth move to a new location and change his address. Thus, the form I have created now would ask the user for...

Hello! I have a search form where user can search for details about a site. The site details would be displayed in a sub form. I have a button which would open up a report containing some of the details abt the site. I am facing a small problem here. The form has 2 conditions to make. One is...

Hi, I have search form. When I click on a button for a particular productID that I had searched earlier, the folder containing more details abt the product will open up. The code is such: Private Sub DisplayDrawing_Click() DisplayDrawing.HyperlinkAddress = "d:\Autocad\" & Combo31.Value End...

Hello. I am currently working on a project involving access 2002. I have a search form. I need to put a button on the search form such that when the user clicks on that button a image will be displayed. These images can actually be found in the D drive of the computer. The user can only search...

Hello everyone.I have search form that is created based on a query. The query has 2 tables called maintable and info of contacts. In the search form when i search for products, it will say who is the contact person for that product is. I have designed it in such a way that I would allow the user...

Hello.I have a search form.It contains a subform which will display all the details of the product that the user will be searching. I am using a combo box for the user to enter the product they have to search. However, when I want just the record that is displayed, it does not simple print that...

Hi Everyone! I think I have asked this question before but I still do not have a solution for it. I have written a query to generate the report I want. I have also managed to export the query to excel(This export is done thru vba coding). However, I would like the the exported excel spreadsheet...

Hello everyone. I am a newbie in access. I would actually like to import like only certain rows and columns from an excel file into a table into access. As the excel data would be changed dynamically, I have decided to use a linked table instead. Is it possible for the linked table just to...

hello everyone.. I have created reports in access and would need to export it to excel with proper formatting .. like for example the the font for the header shouldbe bold etc.. I have managed to export the files successfully by coding but I am not ableto do it with proper formatting. I am a...