Search results for query: *

Hi techies, I have a database which is having around 20 tables populated with around 1400 fields. Around 600-700 fiels of number type fields. The default value for these fields are 0. But in our application 0 also a value. Hence we decided to put -9 as default value for all numeric fields...

Hi, I have a form which lists the fields for selected table. Then the user select the field(s), thru a check box to extract the data shown in the other form. The number of fields and name of the fields varies. Please suggest how to show/print the data for the selected fields each time. Shyam...

Hi, I have a form with more than 2 date fields, I want the user to select the date from the calendar control which is also in the form. Any help please. Shyam cwizshyam@yahoo.com

Hi, I have a database with 20 tables and number of fields ranging from 30 to 150. The field names are very lengthy, hence i have given numbers for the field names and tables for easy reference. (eg. 8.123 where 8 is table name and 123 is field name). And I have typed out the actual lengthy...

Hi Techie Guys/Gals, This is 3rd thread, seeking same help, so far 0 replies found for my previous threads. Please help. Thread 2 (recent) ******** I am developing Inventory system in MS-Access, I recently switched from foxpro for DOS to MS-Access. I need your help on this. Before asking...

on click event of a button, I have created a dynamic query, and open a report based on query. Now the problem is, in query a value is calculated from field a & field b, some times there is no value is given for a and/or b then the value is take directly from field c for examples if a <> 0...

Hi Techie Guys/Gals, I am developing Inventory system in MS-Access, I recently switched from foxpro for DOS to MS-Access. I need your help on this. Before asking help, let me describe how i designed the system. I have 6 tables namely Master Item, Ledger, Receipts,Receipt_item, Issues and Issu...

Hi all, I am trying to run this query and pass the value into variable and print it in the report. docmd.runsql &quot;Select count(*) as dcnt from table1&quot; and I am getting the error &quot;A RunSql action requires an argument consisting of an SQL Statement&quot; Please Help Shyam...

Hi techies, I am facing the problem on how to compare two tables, while going quality assurance check. - 10% of documents are re-entered in a seperate table consisting of fields ranging from 30 to 150. - Tables don't have primary keys and validation criteria is too tedious, as there are...

hi, I want to count the no.of records of a table, for unique field value where the field is not a primary key and the value appears more than one time, i tried with SQL grouping command that gives the result as below 1a -5 1b -3 1c -6 but the i want the result record count as 3 in the above...

Hi Tech Guys DoCmd.Close , , acSavePrompt is not prompting onclick even, am i doing anything wrong. Pl. Help Shyam cwizshyam@yahoo.com

Hi, I have recently purchased Office - XP Developer Edition. While running the packaging wizard, it fails to scan the dependency files like dao2535.tlb,scrobj.dll and other files which i don't know,and popup the following message Error.2147221163: Method '~' of Object '~' failed Any one...

Hi tech guys, I have a data entry form. I am calculating the weightage of that record and inserting/updating a value on one field of the record based on the values of other fields. Now my problem is where to put the event, if afterinsert or afterupdate or both. Pl. note, if the user is...

Hi techies, This is what i tried to search records on a table **************************************** Private Sub cmdKYGO_Click() Dim row As Integer Dim strKWQUERY As String row = lstCOUNTRY.ListIndex If row < 0 Then MsgBox &quot;Please Select Country&quot; lstCOUNTRY.SetFocus Exit...

Hi, I am able to use docmd.transferdatabase,,,,,,,etc.. to import tables from other database, but I need to append the data to the existing one with some criteria. Any help please??? Shyam cwizshyam@yahoo.com

Hi tech guys I have developed any application, and distributed to 4 peoples, the table names and fiel names are same for all the MDB files, but MDB file names is different, and information entered into the tables are different Now I have to present the data from various MDB files. I want to...

Hi, I have different MDB files for Different Locations, I want to select the MDB files according to the user's selection. And.... I want to show a Acrobat file in ACCESS (not inserting or linking an object in a field). Is it possible thru actives, if yes, what is ocx file name. Help...please...

While working with Access Database, i accidentally deleted a form which was having some buttons and code, then I have imported (thru getexternal) the form from the backup. First time it was working perfectly, but after that when i triggered a procedure &quot;Error network not avilable&quot...

Hi Tech guys, I am used to foxpro for dos and recently switched to Access 2000 and find to be very good. Now I need some help on the following I have the following tables Item table- it_code it_name it_balance Rect table -Rect_no Rect_no...

Hi, I want to deploy my Access 2000 application at customer's site, with predefined installation location,and also I want to know if i upgrade/modify my application other than the table, how can i upgrade it at my customer's site, without effecting the data table. pl. help thanx