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