Recent content by GoatieEddie

Thanks a lot for the reply. I will check it out tomorrow and use the other forum if need be. If it works or comes close I will even come back and give you a star! thanks GE

Thanks MajP but Re-reading my explanation I think I may not have been clear re what I am comparing Perhaps better with an example For each day there is a record for a client, I want to compare the value column with the value from the nearest previous date and check for it being over a...

Hi all, I think this should be easy but just think where to start! I have a VERY large file that includes a bunch of clients and the daily value of their account. So three columns: CLIENT, DATE, VALUE For various reasons, the extract isn't run each day so the dates will not be consecutive...

I should add that it only happens on this database. I have opened another, imported the same text file and the field names come in fine....

I do this all the time and it has never been a problem! BUT today, when trying to import tables, the field names aren't being brought in. This is despite them being shown in the import wizard. Has anyone come across this before. Have I accidently ticked something. Is it a bug? Is my db safe...

Sorted! Had nothing to do with it. Some other reference was missing. Thanks for the tip.

I know where the menu options are. It seems to be bombing out of the compile whenever it hits upon a built-in function eg Date or Left. I am running this at home for the first time today rather than at work. Is there a reference I need to include for it to understand built-in functions?

Aah. It appears not to like Date. Getting a compile error saying "Can't find project or library". Am I missing a reference?

Hi Guys, Found this which is very useful to what I am doing. However what I can't work out is how to compare the filedate to today's date to check they are the same. Easy I am sure but having tried Date=FileDateTime("...") I am now stuck. Many thanks in advance, GE

Hi PHV, Indeed I have but I cant work out the simple syntax from the examples. Is it as simple as qt.connection = "C:\temp\mydb.mdb

Hi all, I have a spreadsheet with several worksheets that each have a msquery to access various bits of info from an access database. I then needed to change the location of the access file and so programatically changed the sql in each query to access the correct file. However, I now need to...

Hi all, I like the look of DTPicker and want to use it on my form. All works well. What I want to do is gray out values which don't exist in the table ie only allow valid dates to be selected by the user. I can't find anywhere to set this property so am I hoping for too much? At the moment I...

Many thanks! I had to use .FindFirst but otherwise it was all very helpful!!

Hi guys, I have been struggling with this and now giving in to the masters! I have a table in a database containing customer details that imported from our central system. Occassionally (and if I get this to work properly it could end up daily), I re-import this to ensure it is up to date...

Got it to work. Thanks!