Search results

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

Hi I would like to ask on how to generate a report on the stock movement transaction record. E.g I have 5 tables which: Table 1 as “Opening” which has the field as [Date], [Ref No],[Qtyl Table 2 indicate incoming to stock as “GRN” which has field [Date],[Ref No] ,[Qty] Table 3 indicate...

Hi I am new to Access in programming but had been use it for some simple appication on my office work. Recently I have accounter a problems on the "date" & really need someone to help urgently. I am writting a simple DB for an insurence agency for him to manage his work. One of the request is...

Hi I am new to Access in programming but had been use it for some simple appication on my office work. Recently I have accounter a problems on the "date" & really need someone to help urgently. I am writting a simple DB for an insurence agency for him to manage his work. One of the request is...

Hi I am new to Access no doubt had been using some basic application before. Here is a problems has really cost me a lot. I hope that some one can help me soonest. I am try to create a DB for an insurence agent. E.g I havea table [All Info] which contains many fields and the problems are on...