Search results for query: *

raamzisaab.. Wow!!!! it works..with little modification...not in fieldproperty sub....thanx a log Shyam Shyam cwizshyam@yahoo.com

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

No, coz, I have to give option/Command Buttons to export to other data types like text format, excel and so on. Thanx...any advice Shyam cwizshyam@yahoo.com

Dear Mr. Herman Thanx, I think still I am not clear, the query is created dynamically and saved as a querydef. I can use this query as a recordsource. But if you are creating a form or report you have mention the field name..where in the above query field names are not same everytime... for...

Dear Mr. Herman Thanx, I think still I am not clear, the query is created dynamically and saved as a querydef. I can use this query as a recordsource. But if you are creating a form or report you have mention the field name..where in the above query field names are not same everytime... for...

Herman, Thanx for the reply. But u have to mention the fields in the form, the fields selection varies. If there is any other way..please suggest. Thanx once again. Shyam cwizshyam@yahoo.com

Sorry, I think I am not clear. I am able to create the query and I can show the query thru openquery. But I want to show it on the form/report on clicking the command button. I tried with flex grid, but I don't want to use Activex Control, because it is creating problems in clients...

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

micahel, Great...experience...thanx a lot..I am convinced to stick back to access yet. Shyam cwizshyam@yahoo.com

Hi Setirich, You want to return the value of that particular cell or control name of the cell. Pl. clarify Shyam Shyam cwizshyam@yahoo.com

hi, The developer version of MS access is bundled with packaging wizard, that will create a auto install exe file, with all dependancy files and runtime files. And, you can get the in-built help for this packaging wizard, no need of referring to any other books. Just create your mdb or mde...

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 maha12, I don't think, that u can transfer clipper code to VB, but the process for transferring dBase IV to ACCESS is, create a new DB name (StockDB) or whatever, select tables and New, and the import. Now select file type to dBASE IV and select the file to import, repeat the same for more...

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

Dear Daniel Thanx brilliant Shyam cwizshyam@yahoo.com

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

Ramani, Great tips, i am just switching from Foxpro for dos to VFP, may I bother u for more help. Thanx Shyam cwizshyam@yahoo.com