Search results

Oh right ok. Ignore my last post then :)

If you put the following line of code into the OnClick event of your close command button, it should save the record that you're working on. DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70

Sorry, should've made that quite clear. Yea it was getting a bit late RG so sorry for the delayed response. Open up the tables tblNVQ, tblAppraisals, tblTraining, and tblSupervisions, and delete any blank records that are there (some don't have any data, but others don't even have a value for...

I'm using 2007 here but most of it was written while using 2003. Yea i know the code is pretty bad and extremely repetitive, just didn't know any other way of doing it :P

ok managed to shrink it. Took out all the forms completely un related. Ok in order for this all to work you'll need to copy the .bas file and the .dll file into the same folder as the main db. The backend will be updated when the database runs (it will prompt you to update) You HAVE to login...

Alright give me a sec. I'll upload it to another server, bit big for here and seeing as i'm not certain which part is causing the problem i'll leave it all as is

whoops sorry. Have a look through here: http://www.cpearson.com/excel/FileTimes.htm Has loads of vba codes including that one

Ok had a quick look through, and now it's creating 3 blank records each time! :(

Ah yea sorry my bad. Try looking for a function called GetFileTime() which i believe is also built into the access VB so it SHOULD work. http://msdn2.microsoft.com/en-us/library/ms724320.aspx Have a look on there, it gives you some more details on it, but you should be able to get that to...

Alright I'll take a look through all the code (could take a while) and post back if I find anything or if not to try and figure it out. Thanks

Well i've got a lot of code which is set to clear set the values of the fields to nil if certain conditions are met, and this code is run on the OnCurrentRecord event, and this is the code that is highlighted, but surely it is only running this when it goes back to another record after deleting one?

I think i got rid of all of the default values for that reason. I will check through it all again. What other sort of things would cause it to be 'dirty' other than the setting of focus?

Yea. It's weird though because the errors produced aren't always the same one (I assume it is depending on what records exist) The error will either be that it cannot edit the record because it has been deleted by another user (not possible as i'm the only one currently on the system) so it's...

Yea that's all right. The C:\ is the location and filename of the backend database or whatever file it is that you want to get the modified details from. labalename is the name of the label on that form that you want to put the information into for the user to see. If you just want it to show...

Yea sure thing :) Public Sub RelinkTables(NewPathname As String) Dim Dbs As Database Dim Tdf As TableDef Dim Tdfs As TableDefs Set Dbs = CurrentDb Set Tdfs = Dbs.TableDefs 'Loop through the tables collection For Each Tdf In Tdfs If Tdf.SourceTableName <> ""...

Yea think that's exactly what it's doing. But i've just added Me.Form.Requery after each query, and then removed them and added it after all the queries ran and with that in there, it is still giving me the same error (different subform each time) but it's just not deleting them at all with...

Will this just resize it though? I don't want to resize the form as it fits on the monitor of the resolutions to be used, I just want it to be centred basically. If I can?

Updated in what way? Design, data or literally everything? I would've though you're going to need some sort of code that can check the properties of the database file itself, and monitor the data and time that it was last edited. When this changes, then use some code which will change the label...

On my main form for entering staff details, every time I create a new record, 3 of the 4 sub forms create 1 blank record with absolutely no link to anything, just completely blank. I looked on the forum and found a similar problem in that if you set the focus from the main form to the subform...

Is there away in VB or otherwise, to ensure that the form is always centred automatically no matter what system it is run on? I know there is the auto centre option but this only works horizontally and even then doesn't always work (or seem to) I ask as the system i'm producing is going to be...