Search results

Not quite what I'm after. I don't want to change the record fields but to change the focus of the record so that the conditional highlighting will work. It also keeps the name in the list form synced with its fields in the MainView form. The problem lies with getting an event to trigger the...

Hi guys, I have a main form that has two subforms, PlantList & MainView - the list shows the Latin Plant names and MainView shows data associated with the Latin name. Clicking on the list name will show the info in the other. I use an unbound field [ID] on the main form as link for the 2...

Ah yes. The Snap to Grid was on. I've not tried it since changing it but I'm hopeful. Thanks guys Dave

Has anybody else experienced a problem with aligning/moving/nudging controls using the arrow keys? I've noticed that the control may not move until an arrow is held down for several seconds, after which time the control suddenly moves off beyond the desired alignment required. It also may...

Hi all, I have a form with an embedded google webpage which is opened when a user selects a button on the mainview page to obtain more info on the selected item. It all works well except for the assembly of the searchstr, which I can do manually but not in VBA...yet. So, I have a string...

I may be old but I'm still a quick learner. :D

Thanks to all of you - isladogs, arenlgp, theDBguy and MajP. I tried all the options suggested and eventually succeeded with the method shown by MajP's demo Db. Thanks again. Davee

Thanks, theDBGuy. I will post some screenshots on Wednesday when I'm back on the PC. Cheers

IslaDogs- Thanks. I already tried those methods without success. Not sure why but gave up. arnelgp - Thanks, your solution appears simple but failed for me. I have 3 fields in the continuous form: LatinName, CommonName and an invisible Primary ID. I followed your method and found that the...

Hi All, I have a form with 2 subforms. The Form is the 'shell' which holds all the general operations like, opening other pop-up forms for info, search buttons and search fields, Quit button etc. The first subform (PlantList) holds the PrimaryID, LatinName and CommonName from the main table on...

Hi All, I retired from work many years ago when I used to create databases (in MS Access) for a local uni. I vowed never to do any more Access. Until now. I thought I might create a small database to hold the plant details in my garden and include searches and prompts for garden tasks based...