Recent content by timark

Hi John, Thanks.... how could I miss that error.... Sorry another problem I have is that how do I generate report on multiple combo box. Thanks once again.

Hi John, I wanted to know how do you do the combo box . Is it by using wizard and selecting the TBL_UNCOUNTRY.... i did it that way but the code is not the same from yours. I do not know why I have the bracket , it still remains that although I had view it in form view. Actually I do not...

Hi John, Thank you so much for taking time in creating a sample DB for better understanding. I cant seem to get the combo box drop list. Your code is SELECT TBL_UNCountry.CountryCode, TBL_UNCountry.CountryName FROM TBL_UNCountry ORDER BY TBL_UNCountry.CountryName; What I do and get it:-...

Hi John, I had tried out your method but cant seem to figure out where I must input my criteria. I have the query ready. Pardon me for asking coz I had been trying but cant seem to get the answer.

Hi, Where must I input this code? I must create a button and go to the event procedure? If there are quite a number of files with almost the sam filename saved in that directory but I wanted import only the latest based on the date modified how should I input the codes? Thanks

Hi, I am a novice in access. I would like to a.)import data from an excel worksheet which the file named is not fixed but the file directory is.(c:\import) b.) After importing the file to a temp table named "Sheet 1". I want to append into the main Table " Table MAIN" and then I will...

Hi John, Thanks for your advise .... will try out your methods...

Hey John, Thanks very much for your help. This is more than what I want.... I do have a couple of questions to ask. a.) Am I able to generate a report based on the keywords that I had typed in the search box. If yes, could you please help me with the codes... b.) On a separate note, I...

Hi , I am a novice in access. I had a form which allows the user to do search based on the combo box which when the user click the a search button , it will link to a query which will capture what the user had selected from the combo box earlier. I wanted the query search to be display in...

Hi, I wanted to generate a report counting the no of orders that was sent by Truck no 5.The truck no source comes from a combo box. Combo Box list Delivery Date Truck 5 01/02/2010 Truck 6 01/03/2010 Truck 5 22/02/2010 Truck 7...

Hi, I am a beginner access user. I have a memo field which the data is very lengthy. When I tried to print from the form view. It also shows me whatever that the computer screen can captured. Is there any methods or functions that I can print this memo field from the form or I can only print...

Hi, I would like to ask whether how should I change a date entry to be display on the report header of name of the month. Eg: I am prompt to enter date range between 01/05 and 31/08 The header will appear Invoices submitted between May and Aug 2010. Thanks

Its just some reports entered in my another user. I need to extract out the names mentioned in the memo. Normally I will read thru line by line which is quite tedious

Hi, I was wondering is that anyway to highlight certain names (Eg: Searching the field memo for names starting with "LIM") in a memo field in a form and pasteing the highlight names to another form or table. Thanks.

Hi, dun quite get you as my knowledge of access is not that good. Could u pls elborate more. Thanks