Search results

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

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

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

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

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

Morning all, Am trying to create a really simple form where the user can select one of five fields, an operator (just =, Not, <, and >) and the values are pulled from whatever field is chosen. I have the form down and can populate the values list based on the field however now i need to use...

Hi all, Having a problem when trying to create DAP's using Access 2003. I get the above mentioned error message when using SAVE AS to save an access table. If i try to SAVE AS with a form it says "could not find field" I guess this is some kind of obvious connection problem, if so could...

Hi all, i hope this is posted in the right place first of all :) apologies if not.. I have about 8 individual databases which will be used simultaneously by users. I wish to be able to have full control over these databases from a 'master database' including being able to delete the data in...

Hi all, I have a database with about 7 forms, from the main form i want to open an address/status updater.... however when i navigate from the main form to the updater the appropriate Account number and customer name are not pulled through as well, meaning i will be updating the address for...

Hi all, I have a database with about 7 forms, from the main form i want to open an address/status updater.... however when i navigate from the main form to the updater the appropriate Account number and customer name are not pulled through as well, meaning i will be updating the address for...