Search results

that worked great, thank you :)

Hi, I have a column that contains some values with just characters, and some with a mix of characters and numbers. I want to split the 2 but the method i thought would fix it, doesnt :x not like ([*1234567890*]) Thanks for the assist

im not trying to make it difficult, im just looking at methods as i find them as i dont really know anything at the moment about this sort of thing. might you have another source for the switchs? im having trouble getting my head around the access help information

currently looking into batch files or a vbs to be run from scheduler, though having errors with vbs (not yet tried batch): vbs: dim accessApp set accessApp = createObject("Access.Application") accessApp.OpenCurrentDataBase("C:\Images.mdb") accessApp.Run "NewImages" accessApp.Quit set...

just thinking into things (the scheduler isnt an option because i will be running this on several machines). Is there a way to have a batch run the code once the user logs in? again im unfamiliar with batch files

i see what your saying with this and wasnt even aware of being able to access properties in a recordset so thanks :) however, is there a way to run this in an automated way? thats my main problem, running the code without the user touching the tool itself

if your pointing towards creating a recordset of the subfolders in that folder then writing to the table(an index) where they are different, that would work but would cause a problem in both processing time as the directory grew and instancing the code to begin (want to avoid a user opening the...

Hi all! Basically, i need a method for when a user is going to scan an image, then places it in a folder, allowing that folders name added to a table automatically once saved. Because independent from the scanning program (Imaging - Kodak) i need to find a way to run the code to update the...

sorry, i ninja edited the above as i had put solved prematurely. The error is database object is read only, which i dont get as the database is not read only :x i figure its going to change the value in the foeld first before creating the folder so guess at a database issue? also might a...

getting closer but i hit a problem :( If InStr(Name![aName], "/") Then Name![aName] = Replace(Name![aName], "/", "~") End If MkDir strTempFilePath & "\" & Name![aName]

Hi all, Tried finding a solution in this site but couldnt find one for searching a string for a specified character (if you see one, link me :x) Im searching through a column to create folders based on a field value. At a point i come across a field value that contains a date, so i wish to...

thanks for the input, i just cant work the syntax of what you say into my current line. Im using: strSQL = strSQL & "#" & .Fields("AB19").Value & "#," but i cant fit in the format comment tried: strSQL = strSQL & "#" & Format(.Fields("AB19").Value, "dd/mm/yyyy")) & "#,"

Hi, I have some code that retrieves data from a table via a query and then posts in a excel spreadsheet. However when the data is outputted it is output with a date field adopting the US format of (04/06/2009) instead of 06/04/2008) and i cant reformat it afterwards in the excel spreadsheet...

Worked a treat, thanks very much :)

so is it not possible to include NULL in "values that are not in A,B,C,D,E" ? It has to specifically be stated as a count all that are null?

Hi, this might have got lost in the other topic so posting a fresh, I have a formula to work with where as i want it to return the number of records that dont have the following Status entries. =DCount("[Ref_No]","New","[Status]not in ('A','B','C','D' )") However, i want it to then be left...

Hi, I have a formula to work with where as i want it to return the number of records that dont have the following Status entries. =DCount("[Ref_No]","New","[Status]not in ('A','B','C','D' )") However, i want it to then be left with fields where [Status] is ' ' i.e empty, nothing inside. It...

nevermind, its cause 3 of the many text boxes are linked to a table, i figure ill need to do an export to report or a button to open current record in print screen :(

Hi all. I have a form that displays some values in a report format (i know reports better than forms :x). When i go to print this form, it prints thousands of copys of the same form based on the number of records in the table its linked to. What i need is for it to just print one form, not...

Nevermind iyou had it right the first time, just a square bracket on B was meant to be after status =DCount("[Ref_No]","New","[Status]='A' OR [Status] ='B'")