Search results

yea but this is only a small P2P network with about 4 computers attatched, and no server, so each machine does have access to their local stores, and seeing as 2 of the machines are admin computers they need access.

Well the system is being run across a network, and in the main form there is a picture for each member of staff, and the ability to add a picture. And if the picture added is stored on the local computer, then for every other user on another computer that accesses the system, that picture won't...

Trying to return the UNC path of a file rather than the local. It works if I go through my network places which isn't a problem, but I want it to return the UNC path when the file is stored on the local computer. I have searched the forum extensively and found various responses, none of which...

Ok really confused now. It just started working :S God knows why but it worked. :) Thanks for the help anyway :)

Then yea it's bound. The data isn't be altered by VB at all. There is quite a bit of code in the form but nothing complex that should be stopping a record being deleted.

Just one form open but it contains a subform? When you say bound what do you mean exactly? It is based on one table (except for subform making it 2) and all of the fields are bound bar 3 (and command buttons) however I have another form that is doing the same thing which works perfectly?

I can delete the data straight from the table, and the queries that are running are deleting the data no problems. Just this is failing. The form is based on the table itself not a query

Nope, allow deletions is set to yes. I am deleting a related item but what it's doing is deleting the data from the linked tables first, and then being told to delete the main record, so there then isn't anything linked to it. It is working on another form I think in different tables just not...

The command button I have for deleting a record is not working. It runs a few queries to move data to another table, delete the data from the linked tables, and then runs the code to delete that record, however that bit isn't running. When i use the following code it simply does nothing...

Was you as well :) So thank you very much too :)

Hey guys thanks for the help. Turns out it was nothing to do with the queries at all, was coding from something else (another problem) that now is solved, which has solved this problem :) Thanks for all the help

Ok ignore that, got it all sorted. Thank you 2 SoOO much. Killed 2 birds with 1 stone sorting that out. The cause of this was causing problems elsewhere as well, so now this is working, the other thing is working, so thank you very VERY MUCH! :D

Any suggestions where else it may be suitable? That was the only place I could really think of :(

wo thanks. Didn't realise it was doing it quite that much. So how do I go about stopping it from doing that?

What exactly is the situation then? Are the fields bound or unbound? If they're unbound then that's probably why it won't work. If they are bound, then as someone has said earlier, it will automatically save the record when the form is closed or a new record is created. It really depends on what...

No problem, glad I could help :)

Brilliant. No problem, glad I could help :)

Theoretically either, but to save on code and confusion use the shortest. I've just tested it out and it works fine. You'll still need to give it a file in order for it to work though. Dim LResult As Date LResult = FileDateTime(Environ("USERPROFILE") & "\My Documents\[filename...

Try using : Environ("USERPROFILE") This will return you the path where the My Documents folder is, so you'll need to add the /My Documents after it, but it will be dynamic for every user, and windows being windows will have ever documents folder stored as My Documents so you can just add that...

Hiya. Sorry about all this, appears to be a lot more simple than i first thought Dim LResult As Date LResult = FileDateTime("C:\Downloads\NWind.mdb") Label139.Caption = LResult That code is currently set to run when a command button is clicked but can be used anywhere you...