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

Thanks for your reply PHV. So i should not use make-table query, simply the select query ? but in this case i cannt modify/update. How i can add extra details in my selected tables through this form ? The two tables are linked with PackageDetails. Cheers

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

It means i got a big problem now, i have to use a bit programming stuff in VBA here, which is not my thing. i am not good in it at all. Anyhow thanks for your help Crowley16

Thanks for your reply Crowley16 Well, i agree with you. But i have to add some extra data in the linked database, like some extra tables. For example i have created one table by make-table query, which is part of a linked tables and some new fields( these new fields will be filled by hand...

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

Thanks a lot PHV.

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

Thanks for your reply Zameer, Yes you are right! Thats was exactly my question was. i am looking for a EXE file of my database link Forms so that i dont need to open my database. Just to click on an icon and then to be in working envirnment without opening Access Window.

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

Thanks Traingamer, But the first table does not have an autonumber key [sad]

Actually its a question my boss have asked me, i have told him to use count( ) function or set the field as autonumber. but he is interested in a query to get autonumber in Make-Table query. So that updating a table by running this query will not effect the Data in the new table. Any chance to...

Thanks Zameer, Its purpose is to keep the original data table in a side and make changes in a new table. Thats why in this new table autonumber will be an important option.

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 ?

Thanks for your help David, it will work but i have created a new table-2 from an existing table-1 by using make-table query. Here i want to add a field( by using count() etc ) which will create autonumber whenever new field is added in first table-1. any idea ?

Thanks dwlerwill, can you please try to explain me how to set it automatically to get a number added each time ?

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,

Leslie, i dont think that coffee will effect me, i am not a programmer like you guys. Actaually its a sum, the total number of orders.... Thanks again Leslie and PHV