Recent content by jiajian

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

Yes. Qry1 is a date parameter query. I have another field as deldate to use as the parameter dialog box once it is been query.I need to have the date parameter to check the result. So, any suggestion on what shall I do? Thanks jiajian

Dsum Hi Thanks. After changing the = to Like, I still facing the same result e.g "error". Please commend. jiajian

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

Thanks I knew about using this. However, it can not differntiate the year if you have different year. E.g Oct02, Nov02, Dec02, Jan03, Feb03... jiajian

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