Search results

I have been evaluating a move from Excel 2007 to 2010. (32bit) When I run a macro in 2010 I keep getting the message "This workbook contains links to other data sources, Update/Dont update/Help" I have ticked "enable all macros" in the macro section of the "Trust Centre" I have ticked "enable...

I use the command line version of 7za (7za.exe),to extract some data via macros into Msaccess. Currently in Windows 7 32bit I have 7za.exe in the windows system32 folder so that it is simply called in the macro by just using "7za.exe e...etc" Im about to move to the 64 bit version.(Windows 7 pro...

I receive some data in LZH format (No choice on format) which has worked satisfactorily for years using .LHA or LHARK in a batch file. eg:d:\Directoryname\RBLHA\lhark e c:\download\Filename -o d"\Directoryname\RBLHA Ultimately the extracted file gets imported into MSACCESS This works fine in XP...

I have been running Office Xp for years. In one (Access) application/form I have a small field that only shows the the first 4 numerals such as 26.46 Of say 26.46789 Decimal places is just set as Auto but the field is only wide enough to display the first 4 numerals No prob However in trying...

I have been experimenting with Access 2007 using Windows 7 It takes a long while to close the current existing screen and open the new one (Some macros/script run on exit) In Office XP/Windows XP the close/open was almost instantaneous but in 2007 it takes ages to run the existing data before...

Is there a way to find the DATE of the FIRST SUNDAY in OCTOBER in a query. (Australian daylight saving commences on the first sunday of October in any year so it is a variable) Sure the PC time calculates ok with the various MS updates,but I need it to apply to existing data in an access table...

I want to export some data from Column A in a spreadsheet as textand save it ,without adding a " ",to the data. For instance the current data (say in sheet1 ColumnA) reads like: "name1","name2","data3","data4","etc", Exporting as text results in getting...

This code works fine in 2002,but just hangs in 2007 It appears to hang on the "ReSizeForm Me!myform1.Form"..in fact nothing happens at all. Quote Private Sub Form_Open(Cancel As Integer) ReSizeForm Me ReSizeForm Me!myform1.Form DoCmd.Maximize DoCmd.GoToRecord End Sub Unquote Taken a while to...

I need to look up a cell in another sheet using a row/cell reference in a different sheet. Ok so in say Sheet2 Column AM,in row 1 I have "D5" I need to look up cell D5 in Sheet1 (Sheet1!D5) At the mom its looking up the cell reference AM1. VLOOKUP(($AM1),Sheet1!$A$1:$BM$1000,3,FALSE) How can I...

Is it possible to set up a situation that say (depending on time of day,0900-1200 or 1200-1500,etc,)that a different splash screen will be displayed on opening of the Db. Captnk

I want the opening Splash screen to wait until the password is entered before it closes and goes to the programs main page I have tried using the .bmp with the same name as the .db which works fine (although just a quick flash),but I really want it to stay displayed until the password popup is...

I have an append query that simply appends to a table. When I run the query manually all fields in the query are appended. However when I run it thru a macro,it fails to append 1 field. The failed field is derived from an IIF statement in the query. However it doesnt make sense that it works...

Xl contains a function +proper(...... This converts the first letter of each word in a text string,to a Capital (upper case),with the balance of the word as lowercase. (very useful function) I can Access options for upper/lower case but this appears to be an all or nothing situation. Does...

Apologies,but this is a repost from excel section. Think I need more specialised VB help So I have the following bit of code (recorded with a macro) Cells.Select With ActiveWorkbook.PublishObjects(1) .HtmlType = xlHtmlStatic .Publish (False) .AutoRepublish = False...

I am having a problem exporting in the manner I need. Fields with a value are exported as: "name","make","etc", However where I have an empty text field it is seperated only by a comma: "name", , ,"make", I need to get the empty text field to read as follows "name","","","make", How can I get...

I have been experimenting with exporting,delimited text files. I have noted that despite the fact the originating table is sorted in "date descending order",the resulting delimited text file appears in a random format (not in same date order),although it keeps groups of items (in this case...

I have a "private sub Commandx_click() created In this Vb script (amongst other things),I create a "filename" comprising a name&filedate. I need to create a bat file that will let me run the compression prog LHA using the created filename. eg: lha a "filename" *.* Is their a way I can create...

Is it possible to reference a single spreadsheet cell (XL) from a form field. I want to change a percentage figure in the spreadsheet figure directly from a (textbox?) field on a form,so that the spreadsheet calculates the new percentages. I dont want to import or export the spreadsheet data,i...

Is it possible to change the underlying color (the grey/black) under a datasheet. Note: Not the datasheet itself

I am running the following simple bit of code "Private Sub Command70_Click() While "tauto" <> "" DoCmd.RunMacro "tauto2" Wend End Sub A query strips off the "first" table item on each loop,until nothing is left in the table. Tablename=Tauto. It loops perfectly,and processes each entry,BUT...