Search results

I've added in so many places at this stage but this doesn't work either. Sorry anything else.

Using this at least I am on the right record but I cannot move on to another one. I have tried rs.MoveNext ??

I have a Main Form with 2 tabs. One of the tabs has a datasheet form that lists all record. The other has the details of the record depending on what is selected in the list. My problem is that when I add a new record I cannot see it on the details tab until I close the app and reload. It is on...

You have no vehical id's in the customer table so there is no link. The Link Child/Master should be between teh Customer and Vehical forms sorry I didn't read the problem properly. You seem to have done this but dont forget Child link is CustomerId. Unless each co is only going to have 1...

Sounds like it will work - can you help me do it. I think my problem might be that I want to move thru all records in the table at this point so I mean the next id. I have code in the ONCurrent event that enables me to display the correct record depending on the rec selected in the first form...

Use [frmCustomers].form![CustomerId] as the master link field on your subform. You will need to set a default Customer ID for the Customers form so that when you open the forms you have a Customer Id to reference. Just add a hidden textbox on the Customers form bound to CustomerId and set...

Hi I have a form with 2 tabs in one tab there is a datasheet view of the table and the second tab has the details. The second tab displayes the details depending on which record you select in the first - this all works fine. My problem is that once I choose a record and look at it's details from...

Check out this thread http://www.access-programmers.co.uk/forums/showthread.php?t=67348 Message Box For Passwrord in the General Forum. Oldsoftboss gave me a very nice solution.

Hi I want to run a query that returns a calculated field (x*y) which I have done but at the same time I want to do (x*y) for the records that are marked with a flag producing two figures so that I can do two subtotals ? Any ideas. I am doing this on a form using Queries and the subtotals in the...

Thanks a million it works lovely

Hi All I am using amessage box to get users to enter a password to enable them to access certain feature in my app. How do I put an Input mask on the Msgbox so that when the user types in the password it appears to them as ####. Amy ideas?

I have got the notinlist to work but when I try to requery my combo box i get an error saying You must save the field first.? Any ideas? The data is being added to the table.

I'm trying it now just using Access and I cannot get it to get the autonum from the parent. It worked earlier when I didn't want it to.

I am using AddNew because the forms are based on a series of SQL queries not on a specific table.

Sorry no it's not.

Have done that for the subform.

I am adding reords to 2 tables via a form and subform. The id is an autonum on the main form and I want this to carry through to the subform but when I try this I get an error saying the Id field cannot be blank in the subform. How do I populate the id field in the subform with the autonum from...

Hi I have a main form and a sub form I want the data in the mainform to refresh depending on the record I pick in the subform. Can this be done? If so how?