Search results

Wayne Tks,i looked under cells also under hyperlinks. thats stuff i s close but not quite what i want,(Or im missing the point on its application) So if u could post up the example it would be appreciated

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

MM-UK U r a genius :) Tks heaps mate it works great Captnk

Tks Jack. I was afraid that would be the answer Captnk

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

U could try doing that with a .bat file. I use a few bat files to manipulate external files. U just then need to shell out to the bat file,and possibly include a chdir or chdrv staement so the bat file can find yr external data

Tks Mile-o-phile. Good idea.Seems to work fine now Captnk

Yes ! I know it loops continuosly that why I posted. I,m fresh out of ideas,and looking for some alternative suggestion Tks

Thats noted Mile-o-phile. HOwever its NOT MY CODE...thats a straight cut from a previous posting by "AXA" on a thread in this site. yes it is annoying specially when u want to test run it

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

Think I have answered my own question,with a little help from some code posted by charityg. for the line in question I have replaced it with f Listxx.ItemsSelected.Count=0 then MsgBox "yyyyyyyyyy" Seems to work fine

I found the source for the following code from an early thread started by Jenny Peters," How do i make multiple selections in a list box". The code has been modified slightly to suit my arrangement,but for some reason the first part does not work and produces a syntax error in the row 'if...

Tks the replies. I seems to have solved my problem by placing the strvalue in a textbox on the form with: me.textxx =strvalue and then using a query to append to a temp table and looping it all as suggested by Pat. May not be the most elegant way of programming,but it works,until I find a better...

I have a listbox,multi, (list63),based which at its final point gives me a concatenated stringvalue. eg :strvalue = "4/06/2003melb" This is an identifying code used in another table/field. I then run a query based on this code. In a single select list box this works fine,however I need to...

Many tks Dgar...It works fine now Captnk

I am having a problem getting the syntax of this right,can someone pls help my syntax is: DoCmd.TransferText acExportDelim, , "Tablename", "d:\directorya\directory2\directory3\" & filename, no Filename is derived from a table field,and it does show up the correct table name. I need file as a...

R u sure Xl has actually shut down in windows. ctrl alt del and check if its still there after the first macro run. I had a problem with XL staying open in windows for a while.It shows under processes if it still there not applications Just an idea !!

Interesting i just had a similar problem getting access to find the data. Anyway as to timing u need to put in something to make it wait straight after u shell to yr bat file,or the vb code moves on before the results come in Their r 2 ways i do this. If yr bat file is a single run..just put in...

Many tks Shadez I think yr probably right. The problem actually seems to be with the windows folder \..\My Documents which of course is well past the Dos 8 characters. The dos bat file appears to have some problem with that. As I mentioned I can work around by using my db folder as the default.I...

I recently put in a batch file which runs from a code shell. However initially it wouldnt run. The bat file would run perfectly if that was cliked,but would not execute from code. after much research it became apparent that it was looking up the wrong directory (default directory) e:\my docs...