Search results for query: *

Hi Programmers, i need a hint regarding form input data. First the selection of different fields by a user on a form and sending the selected Record for reporting(record) and saving it in a separate table ( for future references ) I have worked on it and used Command Button wizard as well...

Hi, I have created an Invoice Form ( looking for a report of a record which will be selected ) from a select query. In this query three tables have been used. PackageDetails ( PackageNumber, Description, ReferenceNumber, DueDate ) OrderDetails ( PackageNumber, OrderNumber, OrderDate)...

Hi Programmers, I got a problem in updating, i hope that you guys can help me. I have a linked database and i am applying some queries on the tables to get the required output. I am using make-table query as well. If there will be any change in the linked database then should i run every...

Hi programmers, I am not a programmer but i have to use some vba code in my application. I have a problem in selecting combo box values in reference to other fields. My table fields are like CustomerID, CustomerName, CustomerAddress these fields are selected in a form.When i try to select a...

Hi Guys, I have a problem, for you guys sure not a problem but for its now a big problem. There are 7 Fields in a table of a linked database. I have to sort them according to EmployNr such like EmpNr EmpName EmpAdd etc..... 23 23 23 23 24 24 24 25 25 25 52 52 52 75 75 75 75 76 The related...

Hi Programmers, I have a quick question, if you can help me regarding this. I have some forms linked with the main Form. And i want to have a User Interface (Main overview window)i am using Access 2000. So that i dont need to open Access everytime then to forms. I need here any VB code ? i am...

Hi Programmers, I have tried to read FAQs but i could not find my question's answer. I want to create one more table out of an existing table by using Make-table query. in this new table(in the query) i want to add Autonumber field as well. Benefit: Whenever there will be a record added in...

I have a table-1 ( for example ) and want to create a new table-2 out of it with the addition of autonumber field in it. so that whenever there is a addition of next record in table-1, autonumber would add a next number to it. should i use the function count(*) or append query for such a problem ?

Hi, Can i add a field( a column ) in a table, in which i can count or add automatically the entries ? like 1 2 3 4 . . . should i use count() function here, or any other fuction ? Thanks,

Hi, My problem is 1- Can I get number of orders according to Order_Nr (i.e for Order_Nr 100 I have here 3 Orders ) 2- Total number of orders at the end processed in the whole process. Serial_Nr Order_Nr Cost Date Count_Orders 1 100 20 01.06.04 2 100...

Hi guys, I have one application in Access 2000, there are some forms, queries etc. Is it possible to have a user interface ( i have a main form ). so that i dont need to open Access again and again, then go to Forms....... any idea ? Thanks,

Hi Programmers, Can you please me regarding such an easy problem ? for you, sure its easy but for me, i am stuck. Serial_Nr Order_Nr Amount Date 1 100 3453 02.06.2004 2 100 532 04.06.2004 3 100 32 01.07.2004 4 120 234...

Hi Guys, a quick question related to simple addition. i want to add many values like 12.83 233.88 233.23 124.93 213.93 .... it means till 2 decimal. But when i add all of these values i get the answer like 6323,8778734.... ( too many decimal digits) if i round them by ROUND(Sum(.....),2), is...

Hi Guys, My problem is that i want to add sold items in ACCESS according to Product name such a way that each Item must be added each time relevant to product name. Expected sum is also given at the end, that what i am looking for. Anyone can help me regarding this ? Serial_Nr...

Hi, I am new user for Access database programming stuff. My objective is to develop a secondry database out of main Database by taking out 4 to 5 tables to build a new secondry database. I have to link this secondry database with the main database. it did it ( by File ---> get external data and...