Recent content by RelapseWizard

The reason for keeping them seperate is the initial field ARRIVAL_DATE_TIME is unique to each individal so is required in the long run also the ovewriting it would create unimaginable problems hence creating another field would just make it easier to group in the database for reporting......

Hi all I'm trying to create an extra field in my table with a "month/year" data so its easy to group the data its a large amount by the way....this is the field I want to convert "ARRIVAL_DATE_TIME" 19/06/2009 14:31:00 The new field would be "ARRIVAL_DATE_MONTH" 06/2009 (mm/yyyy) I've...

Workbooks.Open Filename:="S:\DIM~8\test.xls" Application.Run ("test.xls!Refresh_test") ActiveWorkbook.Close I think I have found a way of doing it, I've set up a seperate excel sheet, then put this code so the macro "code" opens the file in its location runs the macro within that excel file...

I tried recording the macro initialy but for some reason when you go to another excel sheet the macro recording does not acknowledge the other opened sheet so there in lies my predicament......

I have a monthly report I run, the process is I have about 10 excel sheets each with its own macro I go into each excel sheet to refresh the data through running the macros. I'm looking at speeding this process up by having one excel sheet that opens all the excel sheets refreshes the macros...

Thanks namliam it worked, I'm just playing around with it now as I've run the initial query I use, and then run the modfied query with the DateAdd criteria, Its pulled out the same figures based on the links I've put in place but for some reason its not picking up 3 or 4 records here and...

The Access database I use is on a "update query" In the criteria is where I'm placing the the date spec and fomula so when I run an update query thats when the message comes I'll see if I can upload my database here.

Thanks for the quick reply I triedthis one >=date() And < dateadd("d",7,date()) but an error message came up saying unidentified function...same with this suggestion Between DATE() And DATE()+7 I think the query is expecting a function to look up the values of "date()" I'm sure this can be set...

Hope someone can help so here goes, I have a data quality database I run on a daily basis, however I keep having to go into the database query to amend the date everyday my object is to try automate this a much as I can i have tried this. "ADMISSION_DATE_TIME" is the field ">=TODAY() And...

Thanks a lot Mike I've used this one as query1 Left([Forename],1)+Mid([Forename],InStr([Forename]," "),2) for some reason it updates initials for everyone with a second name. I used this as query2 Where initial is Null Left([Forename],1) It worked thanks very much.:D

Initials____Forename J y________ John Henry Left([Forename],1)+" "+Right([Forename],1) I'm processing a survey and trying to Update Initials field on a query and have used this query above but the update that comes up is as above, I am required to put both initials on the field can someone...

WOW it worked thanks a lot Brian.....

I'm creating an excel sheet for one of my dep heads hope someone can help so here goes. What I want to do is when a user enters the date on the "referral date" field a code that auto populates the "referral month" field like example, hope some one can help its doing my head in arrgh all this is...