Search results

I know why this happening now. I would appear that on the last table the code loses refernce to the variable tmpName . Do you know why this is or how I can prevent this. Thanks

Thanks Cogent . Ive tryed what you told me and it still misses the last table in the loop. I cant understand why??

The excel part simply format a file before importing it. the reporting date is derived from the file name sSql deletes null values in the imported table sSql1 add the reporting date to the end of the table sSql2 creates a new table where some of the fields have to be changed from text to...

I have a looping code that scrolls through tables and updates a ref table with three fields. reporting date , tablename, and ESS spreadsheet. The problem is that the rs.edit part of the code misses the last table in the loop. I cant understand why as when i debug it passes all the variables and...

Thanks

sorry it should have read Converting String to a Date sorry it should have read Converting String to a Date

I want to update a fiel in a table with a derived reporting date ie "25/06/2002". The value is text so im trying to convert it to a date . the fiel i end up with looks like 00:04:28. My code is can anyone show me where im going wrong strRepdate = Mid(ImportDate, 1, 2) & "/" & Mid(ImportDate...

Reports suddenly dont fit Thanks Guys, the poblem was indeed the print settings on the printer been set to letter instead of a4. cheers

I have built several reports in a db and mysteriously they dont fit on one page anymore. It is also happening on another machine so its not just the settings on mine. i have checked the default settings in tools/options and nothing seems to have changed. Can anyone shed any light on this as i...

I want to relink all excel files(Linked tables) in my database from a monthly directory to a daily directory ie C:\cadproj\MONTHLY\input\Manual to C:\cadproj\Dailyrep\input\Manual I can do this for linked tables and text files but not for excel files the code for the text files is below...

I have a report with graphics lines and code which i need to convert to html. as you all probably know acees exports just text to html files so the report look terrible. I dont have any web design experience so i was wondering if there was any software packages to specifically convert access...

Problem sorted. Th for was opened as readonly which disabled the calender control

I have a clander control on a form which untill recently worked. Now the control will not work on the form when the form is opened first. The users cannot click on any of the buttons. the problem goes away once the form is closed and reopened. I have tryed re-regstering the control to no avail...

I want to query a database on a network and return a constant property stored in the database ie version number. I have tryed to do this from a similar database stored on my c drive but when i query version on the network database it returns the value stored on the local database. Ultimatly...

I need some code that opens all excel files in a directory and formats columns j to l to have no decimal places. i need to do this from VBA in access as the files are created via transferspreadsheet method and are new files. I cannot use ouput to as i need to have several worksheets. Any help...

Does anyone know how to convert a server name ie \lonc11g\controlling14$\to the relevant drive letter on the users pc ie S:/ thanks

Many Thanks

does anyone know of any software which could integrate access with lotus notes. I want to be able send tables automatically to perople. I know who to do this with outlook but i dont with access. Thanks

Im a trying to write a function which will change the colour of a label on mose moves. the sample code i have written is Public Function funMouseBehaviour(strName As String, strAction As String) Select Case strAction Case "Down", "Up" For Each ctl In Me.Controls If strName...

Thanks