Search results

thanks for your help... ive finaly achieved what i wantedf with your help and a few others on different subjects cheers

sure i had tried that last night pbaldy, but i must of messed it up somehow because that works perfect... cheers for the idea about the control source loop, i had always planned to do that, was just worried would never get it to work thanks again, you've saved my bacon several times now :)...

the albels are being updated ok. seems to be just the control source, is it because im trying to update them to dCdate which is a date ?

hi everybody i ned to make a reports record source and the control sources for a few text boxs a bit more dynamic, i have a report with 27 txt boxs going accross, the control source for these will change as they are named after dates, depending on a value set in a form.. they are named w1 to...

fldWeek i think

my current code has a running count and is now working to a certain extent, need to tweak it when its working out if a date is active as would like it to take into account the entire week not just that particular day.. just i feel the code is so big and cumbersome (and lazy, lots of if's)...

sorry lol im rubish at explaining myself the fields p1startdate|p1enddate are project1 start date and project1 end date and their are similar fields for the other projects the incremented date is checked against these two dates and if it site between the start date and end date then its...

hello, ive got a problem im wondering if any1 can help me with... im trying to achieve data to be displayed in either a query or a table in a certain way... atm im using a huge peice of code to sort the data and insert it into a temp table (which still doesnt workk 100% yet) to achieve what im...

right thanks guys, the hide know file types seems to have doine the trick thanks a lot :) scoobs

just changed my code to this If Dir("C:\Snipers MS2\logs\*.log") = "" Then MsgBox ("No New Logs") Exit Sub End If tested it works perfect on my access 2007, my friend still has same problem, still gets message "no new logs" even though their is definatly logs in C:\Snipers...

my first guess was user error, but ive been through it time and time again with him and he swears hes got the dir's setup correctly, ill try all your suggestions and report back cheers scoobs

i did in my first post, the bit of code that displays the message is first followed by the code for the module that actualy checks

hello, i run a small app to manage various stuff to do with our server, im running access 2007 and a friend of mine is running access 2003 i have some code that downloads logs from a remote location if they are present, theirs a small bit of code that test whether its downloaded any and if...

works a treat, thanks every1

think your onto something, they key is so huge a number the digits on the left prob wont move at all, ill try it but think it will work like you said :) scoobs

ill try that, just got to nip out for an hour or two then will give it a try, cheers scoobs

the number wont be saved in any tables, will just be displayed in a form thats it, basicaly its a number thats appened to the end of a url to display a persons personal page, that formula is a way of generating the id they use in the url from their authid

its a unique id, unfortunatly i dont have control over how long the number is, and the long number thats causing the problem is static, no idea why they picked that number, but since they using that as a key for how they generate the unique ids i cant change it.. bit suprised the windows calc...

hi i have an issue with what i thought was a simple bit of maths, i hae a formula to convert one sort of id to another, but because the key involved is a very large number, access doesnt handle it like i expected it to. is their a work around ? below is a quick example (145774 * 2) +...

tbh scrap that, getting somewhere me think will post later :) scoobs