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

Thanks for the help!!!!!! But the problem is, it is pasting some of the rows and after that it shows the error. Query is resulting into 166 records, it is pasting 97 records on the sheet and after that it is failing, I checked the values for the next rows they are same as the above rows...

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

Thanks a lot ajetrumpet.. UPDATE tblSubFlowForecast INNER JOIN tblPickCalendar ON tblSubFlowForecast.Delivery=tblPickCalendar.Delive ry SET tblSubFlowForecast.[Latest Replen Date] = ( SELECT max(Pick) FROM tblPickCalendar WHERE Type="Replen"); It is working but it is updating only those rows...

Thanks a lot asather.. It is working great.. :)

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

I have Excel2003, but I don't want any warning messages. Can I explicitly specify that I want to save the file in this particular format. Thanks

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

Thanks Jon, It worked, but just out of curiosity why does having a DISTINCTROW makes it working. Thanks

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

Thanks Dennisk. But my rows and columns are returned by a query which depends on some input parameters. Meaning the number of columns will be dynamic. In that scenario, what is possible?

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

Thanks a lot :)