Search results

all the code works as is, but the pictures don't display though the paths are there. more than welcome to have a look.

bumpy bump :(

I'm having a problem with my sub forms and the sample linking image code. Top subform is in data view and the bottom in form. Sync'd with a textbox. notes show individual data per record as you click on them, and the picture updates the location the same. Problem I am having is that the...

nvm wrong forum

Private Sub cmdBrowse_Click() On Error GoTo err_cmdBrowse Me![txtPicture] = GetOpenFile_CLT("C:\", "Select the File") Me![txtPicture] = LCase(Me![txtPicture]) Me!Picture.Picture = Me!txtPicture exit_cmdBrowse: Exit Sub err_cmdBrowse: MsgBox Error$ Resume...

Go to design view on the form. Click on the box left and above the ruler (top left corner) right click properties. under event tab, remove the 'On Open' code. It'll have some docmd.maximize code in there.

I've tried this code and it will exit all your database. make a button and in properties, under the event tab. On Click - select event procedure. DoCmd.OpenForm ("form name")

that is brilliant thank you. Nice to see someone tells you how it's done and where you gone wrong rather than a fix. I can learn from it ;) How do i stop it now from filtering, so it takes me to all the records, but the correct record in the main form? Atm it's taking me to the record filtered...

well when i click on the name in the list i chose i goto the main form filtered which don't help :(

yeah i tried that but i screwed it up somehow.

customerlist is the box the list from from a query appear in and then filter out with the search txt box

there is docmd.close but that will close the database.

I'm working on the search sample in the sample database section on forum. I have got it looking as i want and working as i want bar 1 thing. Private Sub CustomerList_DblClick(Cancel As Integer) Dim stDocName As String Dim stLinkCriteria As String stDocName = "Customers" If...

DoCmd.OpenForm what is the opposite? there isn't a DoCmd.CloseForm

now get on msn and help me with something more complex :D

omg i did it without needing the help :D DoCmd.OpenForm ("Customer Search")

DoCmd.OpenForm sommat for opening forms?

lmao i was messing with tonnes of of combinations and yet it's so simple :D edit: tyvm

at top of event?

genius me :P I fixed it. DoCmd.RunCommand acCmdRecordsGoToNew come up with a new bug though. If i'm already on a new record and run this then i get a error. I know i need.. if record = new - do nothing.. else DoCmd.RunCommand acCmdRecordsGoToNew