Search results

Gee Thanks MajP. I'd never have thought of that. Some inbuild Access function ? Even though there's no next record. I've spend days trying to figure this out., Cheers.

I have managed a trim back demo of just the problem. Open frmShowRecord and type 41_062 into text309 This will show data in another text box and populate some other controls. Now delete 41_062 and press Enter. This should do nothing, but instead removes data from all the bound controls That's...

It may be a null error but I can't nail it down positively, Much of the code I can step through and see no errors. But this particular issue won't show up with Step. I have a workaround but really curious what is wrong and why. I understand its difficult to debug without all the code and...

> What are you actually trying to do? If txt309 is found in tblMain it becomes 'LocalPrefix" and MyActivate passes it to a a proc called ' PrepLocal'. This sets up a new recordsource for the form. But this is (should be?) irrelevant as the problem only happens when an empty text309. I tried a...

Public Sub MyActivate() On Error GoTo err_99 Dim temp DoCmd.Close acForm, "frmRecordselect" Me.txtImport = "" Me.txtBImport = "" If Form_frmDetailByArtist.Visible = True Then Form_frmDetailByArtist.Visible = False ReOpen = 1 End If temp =...

I've been trying that - single-step - but it steps to nowhere. After "End Sub" stepping stops and the controls lose their values. One differnce though - if not stepping - as well as losing values another (unbound) text box turns the text black (selected).

Thanks Doc Man, I can follow the logic of that but not why hitting Enter in a text box would change / alter the Forms record source.

I renamed Activate to MyActivate but that didn't alter the behaviour. But then found if Form_frmShowRecord.MyActivate was called evreytime (regardless of DLookup result) it behaved as intended. But that doesn't help understand what was wrong. > Undo the control when there is duplicate found...

Not sure if anyone can help with this. It's hard to explain and doesn't really make sense. I have an Open form with various controls bound to a query. On the Form there's a text box that lets me change the record source, and this all works as expected. However, if I enter rubbish into the text...

Hi Arne. No, no autonumber. The problem is 'Key' may be duplicated... and I only want the first-last MyCount that is squential and includes the number passed in.

I want the first and last entries for Location from a recordset depending on field "Key" (which is passed in). My plan was to move backwards until Key Changes then likewise forward to get the last. Key = rz!Location Do rz.MovePrevious 'Debug.Print rz!MyCount Loop Until...

I found a program called Unlocker which let me delete the .ldb file but the database still would not open. Until a reboot. Just wanted to thank all for their input.

Thanks for the detailed help. I may be stuck and the machine with the offending file is running XP. However I shared the folder and could see it in Win10. I tried the steps you outlined, but could no mention of the file or folder in PerfMon. Only one mention (under Network) of the XP machines...

I looked at the ldb file in a hex editor, it was 60 bytes long and contained the computer name and "Admin". I could change them and save ok. So I zeroed everything out so it can't work anymore, but still won't delete.

> In Resource Manager (accessible through Windows Task Manager), it is possible to determine which processes are using a file, I think by looking at either locks or file handles. You can then terminate them. I went into task manager and see a Folder Icon with a magnifying glass and the Access...

I'm using XP. That make a difference?. I'm told there is another person or process using it. But nothing I can see is. Is there some way check both apps and Background processes? Or failing that, some way to disconnect any persons or process? If I reboot (that's the only way to get to Safe...

Does that work for you? It doesn't here. The task appears to end, but the ldb file is not (and still cannot be) deleted. Using Office 2010.

Hi, I've asked this before and Googled in depth, but not come up with anything that works. How do you get of an .ldb file (apart from turning off the computer) ? There must be some kind of reg hack or method to release it ? Thanks.

Many thanks Colin that has really improved things :)

Having changed to a higher resolution monitor, my datasheet fonts don't look so good. Very thin and more grey than black. If I change the font weight to semi bold it's a lot better. But the change isn't reflected in the Form (only in design mode). Can I do anything about this ?