Search results

ok that makes sense, i shall do that now! thanks for your help chris, much appreciated!!

Haha, silly mistake, forgot about the need for # around dates :) :rolleyes:

Hi again, I've tried playing around with your code a bit but have seemingly run into a wall again.. Function ArchiveNumbers() Dim tdf As DAO.TableDef Dim db As DAO.Database Dim fld As DAO.Field Dim myDate As Date Dim lErr As Long Dim mySQL As String myDate =...

Chris, Many thanks for the response, This is perfect, i'd never used DAO before !!! i shall have to pull my finger out and get learning:) Mike

Hi, thanks for the reply. Yes for all of the tables i want to archive there is a date modified field, some do not but i want the code to skip over those (Msys*, queries, Linked tables etc) I meant auto as in AUTOEXEC, so each time the BE_database is loaded in the morning it will check to...

Morning everyone, Im using Access 2003 to try and create a sort of auto-archive function, (i will stick on AutoExec when finished) I have so far only managed to loop through all the tables but don't seem to be able to view the tables for fields like DATE or DATADATE. I figure the append...

DCrake: Ahhh, opening a recordset like that is something i haven't seen yet!! That makes everything much easier, thanks for showing me that! All replys much appreciated, thanks guys. M

Afternoon all , Im running 2003 with a BE/FE setup (all in Access) I have a piece of code which doesn't seem to work and wont give me any error messages. I believe it is something to do with there being no records in this recordset but no matter how hard i try to work around it, i cant...

hmm strange. i dont have the on error resume next in any bits of code. i have the options in vba set properly also. debug.print 1/0 gives the normal error. Say for example there is a bit of code with an if statement but no end if. (or any obvious error that vba always traps) the command...

Morning all, Im going crazy trying to work out why my access form is full of black boxes, each time i open the form it changes all labels so instead of white text on a black box, it is just a black box. Also i have two textboxes with control sources such as.. = Forms!Form2!txtAddress.Value...

Hi all, Im running Access 2003 and for the life of me i cant find out how to get error messages back. To be honest i dont remember ever turning them off, and if i ever use DoCmd.SetWarnings it for turning off SQL append/insert statements.. Is there somewhere (or is there some code) to turn...

much appreciated guys!!!!

Hi all, Im trying to write a query so that all data in all but two tables is deleted, not the tables themselves only the data. I keep getting these errors when im trying to build a suitable query.. COULD NOT DELETE FROM SPECIFIED TABLES or TOO MANY FIELDS DEFINED With any luck i'd like...

quit? me? never :D had to format the date inside the SQL statement and it works like a charm... thanks for the reply but sorry to waste your time :) Thanks Mike

omg, cannot believe it. :confused: changed all the formatting to short date (17-Jul-07) ALL dates are now in this format. When i select the values it even comes up as 17-Jul-07 however when i build the SQL statement it comes through with 17/07/07 format and doesnt work!? Why would this...

Thanks for all the replies guys!! Much appreciated :) It works with no probs with the new formatting. Can't say it's as nice to read but hey I won't even have to once it's finished so it's all good! Thanks for the heads up on the SQL American formatting as well, definately useful to know...

FearNaught: I thought i was just matching what value was in the table so the query pulls the correct date? In the table the data is just a date for logindate but there is also logintime and a logoutdate & time. Chergh: If i use CDate it gives me a type mismatch error...

Hi all, thought i had finished this one but apparantly not yet :) Firstly can anyone see a problem with this statement? SELECT Final.* INTO NewTable FROM Final WHERE LoginDate <> #02/07/2007# It works fine with non date/time values.. It's probably something silly i know but any help is...

Thanks for the reply, That was indeed what i was doing wrong... putting in a .Value when it wasn't needed. What a f00l :) Thanks!!

I posted the below at the msdn discussions page.. Was hoping someone on this site could help also. ********************************************************** Morning all, Im having a bit of a problem when it comes to setting some criteria for an If statement. Basically im trying to say if...