Recent content by nikmav

I thought that might be the case. So you mean install the full version access on one machine split the database and save out the BE to the network drive then copy that front end to the rest of the workstations?

Hello. I'm very new to Access and having trouble sourcing information that makes sense. I have a database that is split into a front and back end. The back end is to reside on a shared network location (yet to be determined but we'll call it \\SERVER\DBSHARE for now). The front end will be...

Hi vbaInet, Same problem, doesnt change record and still comes up with the runtime errror when I close the form. They are both linked to the Jobs record source. I thought that because they are in a tab it may not have been referenced but I tried: Private Sub QuoteNumber_Click()...

Hi Thales750, Im not sure how invisibe text boxes are going to help me. I can get the value that is clicked on to come through on a msg box after it has been clicked. The problem is setting the current record on the form that is opened.

Still no joy. The customer form pops up but still on the very first record. Would it help if I send through my file?

Hi vbaInet, Thanks for the reply. QuoteNumber is type Text as they can be alphanumeric. I modified the code to trim the leading space: strSearchName = Str(Me.QuoteNumber) strSearchName = LTrim(strSearchName) The subform still isnt going to the right record.

Hi guys, What I have is a Job List form where a user clicks on a QuoteNumber fieldwhich then opens the Customers form based on the CustomerID. This is done by: Private Sub QuoteNumber_Click() DoCmd.OpenForm "Customers", acNormal, , "CustomerID=" & Me.CustomerID, acFormEdit, acDialog End Sub...

Hi, this is driving me mental if anyone can help I'd greatly appreciate it. So basically I have the following forms: Main Form called Customers Sub Form to Main Form called Service1 Sub Form to Main Form called ServiceDataSheet (Same as Service but in datasheet view) If you haven't guessed...