Search results

Hi, I have a field which has already contain the product name as : EnchSG100ml, EnchSG100ml+RomaSH50ml, EnchSH250ml+RomaHB100ml, RomaSG700ml+EnchSH120ml, RomaHB250ml, (Where Ench/Roma are product brand, SG/SH/HB are product type & ml is the product volume & "+" means the it banded together as...

Hi This is a simple question : How to write a formula in a table without running any query? A table consist field of [Qty],[Unit Price] & I would like the table automatic have a field call [Extended Price] which suppose to be [Qty] * [Unit Price] but I am not running with query. Thanks

Hi This may be asimple question to most of you & I really need help. How can I create a form (with sub - form) & update the data to a table? E.g When I receive a Invoice which consist field of [Date], [Inv No],[Supplier] on the header with sub form of [Item],[Description],[Qty], [Unit Price]...

Hi I have a DB which pull through the company ERP system . Later I made a query (so call Qry1)which simplyfy all necessary fields which I need . One of the field in this query is Customer. There are two major group of the Customer call Internal & External. I do not want to make a query to...

Hi I am using an append query to append my data from my company ERP system (use ODBC) to a table. It had all the same field. However, how can append only those non duplicate data to this table? Thanks jiajian

I am retrieving data from my company ERP system with Access .One of the field which mean for date [SDADDJ]was appear as 6 figure. E.g 102365 mean 31th Dec 2002. I am able to convert it with expression in the fields : DelDate...

I have a DB in Access in my company & I would like all / part of my staffs in various department to view it. We have had the intranet for the company ERP system & mail servor to run. Question : (1) How can I allow other people to view without purchase more copy of licence siftware? (2) Is...

Hi I have a DB with date format "mm-dd-yy". How can I total up all related record in Month e.g Jan02, Feb02...Dec02. Any sample you can share which I can presented it in graph? Thanks jiajian

Hi I would like to build a DB for my company stock transaction for managing the goods IN & OUT. (1) I have a table for goods coming in call IN1 which have field [Date],[Item],[Ref No],[Qty] (2) I have another type of goods coming in call IN2 which have the same field too. (3) I have a table...

Hi How can I add a new record in a combo box? I had an example: http://support.microsoft.com/default.aspx?scid=kb;EN-US;q197526 but what should I amend in this VB. My combo box field is [Name]. Please advice. Thanks jiajian

Hi I had a form with contain a sub-form. It is linked by 2 individual tables with related by 1 to many (but not in the query) & having a same field e.g. [Name]. (This relation is created when I use the sub-form wizard.) Q1. How can I make a bottom so that when I delete a record, both related...

Hi I had complete a DB & attached with a switchboard. How can I have this switchboard auto open when I open the DB? Note: I have also copy the two module from Northwind e.g. “Startup’ & ‘Utility” with I know there is VB written on it for switchboard but it don’t work too. Do I need to amend...

Hi My question is on how to add a new record in form & searching for a record in a sub-form. I understand that the simplest way is to add it in the navigation toolbar. However, I will have proble if I want to add it on the field which is located in the sub-form. E,.g : I have a table (tbl)...

Hi I have a bottom to delete a record in a table. How can I have a pop up messages box to ask for confirm? E.g “Confirm delete?” With option of [Yes] & [No] in this box. Thanks jiajian

Hi A simple one but border me as I am still new to Access. I had a form with [Name], [ID No],[Tel No],[Add] How can I create 2 search bottom for [Name] & [ID No] in form? How can I use the bottom tools to identify the field I want to search? Thanks jiajian

Hi A simple one but border me as I am still new to Access. I had a form with [Name], [ID No],[Tel No],[Add] How can I create 2 search bottom for [Name] & [ID No] in form? How can I use the bottom tools to identify the field I want to search? Thanks jiajian

Hi I have a table with [Name], [Address], [Tel No], [Date of Birth]. How can I view this table / query of personal information by key in the [Name] with Name 1 or / and Name2 or / and Name3……in a pop up dialog box. The number of Name depends on the requirement of cases. It is vary from time to...

Hi How can I have parameter query on a field where it is expressed in another field which has calculation? E.g: Due: DateAdd([AccessCode],[AccessInterval]*[Sequence],[TPLDT])…….date format DueMonth: Month([Due])………..month format In the DueMonth, when I put a bracket [Enter Month], it will...

Hi In a field of [Month] in query, I had put a open & closing braket with word e.g [Enter Month]. In the later part, I decided to cancel it but putting the parameter query in others field. Question is : It keep on prompt me the paarmeter messages [Enter Month], how can I delete it completely...

Hi If I have a table with field [Name],[Date Purchase],[Payment Term] where [Payment Term] could have 3 code e.g. A=annual, Q = quarterly & S=Semi. E.g. [Purchase Date] is 20th May 1997 with [Payment Term] =Q, the person need to pay on 20th Aug 1997, 20th Nov 1997 & 20Feb 1998. Question...