Search results

Hi All, I am using a Tool box control on my work sheet (Not form control). I am facing one problem that when ever i select an item in the list box my selection is not getting retain, it changes to the anothjer item and item and then finally what ever i selected will remain unselected. It is...

Hi All, I have 1 query which is taking very long time (in hours) only for certain data. I have 4 data bases, for 3 data bases it is working fine but only for 1 data base it is giving an issue. When I compared the size of the data base it is lesser than one of the data base for which it is...

Hi All, I have to export one report from one excel to another excel which includes even some(8-10) imges. When I export, only text is getting export. I want even images to get export. These images are in different sections, one image and under that some of it's details then space, again...

Hi All, I am going mad:confused: with this error, please help on this. Some times I am getting Copyfromrecordset object failed and some times I am getting Automation error with the same error number 2147467259. Here is my code: Set rng = pwksRpt.Cells(lngNext, 1) pdb.QueryDefs.Refresh...

Hi I want to have Preview toolbar when my report is opened on click of button from front end form. What I am trying is, I have specified a query as the record source of the report. And in front end form on click of button I have called a macro that opens the report (Open Report) I have...

Hi ALL, I have command buttons on my form and corresponding lables with them. I want command buttons to be locked and unlocked depanding on some condition, i.e., User should not be able to click on command buttons. I don't want to use Enabled=False property as it disables the text. I want...

Hi All, I have a table with the fileds Style#, DC#, Reciept Date and some other fields. I have two similar rows having all the columns same but one row has Receipt date NULL and one row has some value in Receipt date. If for same style# and Dc# combination two rows exists with Reciept Date as...

Hi ALL, I have 2 tables, trying to update one table filed by using max(onefiled) from other table. my qyery is as follows: my tables are tblSubFlowForecast and tblPickCalendar I have to update one field in tblSubFlowForecast by taking max(onefiled) from tblPickCalendar. UPDATE...

Hi, I have a file which is in Excel2.0 format and need to save the file as Excel2003 format using a macro. Would just opening the file and saving the file will do the trick or is there a special way of doing it ?? Thanks a lot

Hi, I am very bad in queries and need your help on this one. I am trying to run a simple delete query having an inner join but it gives an error every time. The error being "Specify the table containing the records you want to delete" here are the details of the simulated...

Hi , I have a csv file which has rows more than max length(~65k) of Excel. I need to delete the first row in this csv. So now when I open this csv in excel the rows greater than than the maxcount gets deleted. Is there a way of doing it without getting loosing the data.? Can I delete the...

Hi, I am working on an access report. My requirement is to display 3 columns at a time. My query returns around 40 columns and for each column some 30 rows. I have to display first 3 columns and the entire data first, then the next 3 columns and so on. I am bel to put the first 3 columns and...

Hi, I have two databases in Access. One of the database acts as backend i.e it has only tables including some Linked Tables(which are linked to some third database) Other database is an executable in which all the tables are linked to the bakend database. I am not able to link to the...

Hi, What are the tools which are available for Version control of .mdb files. Microsoft VSS maintains the versions of .mdb files but doesn't Show Difference between 2 versions. I would like to know which tool facilitates that. Thanks in Advance Sreedevi

Hi, I need a help. In my Store table I have Store# and MaxRange. In my CenterStore table also I have Store# and Max Range. Data in Store table will be like Store# MaxRange 10 1 20 2 Data in CenterStore will be Store# MaxRange 10 A 20 B The...