Search results

thanks Jon K

Thanks Pat. Oops quick edit - For the first question it is not the current record, it is in a differant table.

3 Questions A) Is there a shorter way of doing this line? DoCmd.RunSQL ("UPDATE ContainerData SET ContainerData.Status = 'Hired' WHERE ((ContainerData.ContainerNumber) = [Container1]);") B)Can I combine the 2 following lines into one statement - DoCmd.RunSQL ("UPDATE ContainerData SET...

3 Questions A) Is there a shorter way of doing this line? DoCmd.RunSQL ("UPDATE ContainerData SET ContainerData.Status = 'Hired' WHERE ((ContainerData.ContainerNumber) = [Container1]);") B)Can I combine the 2 following lines into one statement - DoCmd.RunSQL ("UPDATE ContainerData SET...

Tried Me.Requery in several places but it didn't work. Whatever I try to do the properties of the Form are set at "[ID]=73" in the 'filter' field when the form has been opened from another form. EDIT - I fixed this problem by simply re-making the form, don't know why but it now works :(

Same problem Same problem here - If I open the form I can search through all the data in the table, but if I enter the Form from an 'open form' command in another form it (firstly) won't open the record with the ID number I have supplied from the other form and then (secondly) I cannot choose...

I have created this database for work and it is my first go. I have a few bugs that need to be sorted out before it is finished. A) When creating a quote in the 'FORM - Quote' the autonumber will not activate when something is entered into any field - it simply goes blank. the only acception...

As well as learning access I still need to learn how to ask questions. The field from the table 'quotes' is actually called 'ID' :o The field 'ID' is the autonumbering primary key in that table.

First stupid question - What does 'Me' actually stand for? (for example Me![ID]) Next question - I still cannot get the program to look for the record based on the ID from another table. I know that DoCmd.OpenForm "FORM - Find Quote or Agreement", , , "[ID]=" & Me![ID] will open a Form...

Pat Sorry for the newbie questions but I gota ask - how does this line Me.VendorID = Forms!YourOtherForm!VendorID look if you need the ID from a table which is called Quotes? I tried Me.ID = Tables!Quotes!ID and a few other variations but without success.

ID has been created in the table 'quotes', the question is how do I now open the next form with that ID number?

I have a form which is a query, it is a quote and when it is finished the client information goes to the 'client' table (for re-use) and the financial data goes into the 'quotes' table. No when the user completes the form the form closes and another form opens with the same information. My...

PierreR Thanks for that, works fantastic :D James

I have used Max's code (with great success) for visibilty, just need to ask if anyone knows how to turn the visibility off for a button after it has been pushed. I have tried the simple method of turning the visibility off in the button code but I get the error 'Can't turn off visibilty on an...

I have a quote system where a user simply opens the quote form and types in the necessary information (swithboard - add mode). My question is this - If the person is a pre-existing customer then how can i get their information into the quote form? I have the combo box set up to choose the...

Wayne Thanks for that, all fixed. James

Nothing to be sorry about, you did point me in the right direction :D Yet Another question - I have the INSERT line 15 fields long, now if at least one field is empty none of the information is inserted :( How can I get around this?

Got it, thanks for all the help :) EDIT - Can I get this line any shorter? DoCmd.RunSQL ("UPDATE ContainerData SET ContainerData.Status = 'Hired' WHERE ((ContainerData.ContainerNumber) = [Container1]);")

The "Available/Hired" status is only in the 'main' table; the form I use is from the 'quotes' table and when a quote is turned into a sale then I need the status changed in the main table (to a 'Hired'). Just need to know how to change the info in the 'main' table from my form.

I wish to create a button in a form that changes a data object in a differant table than the one that the form is sourced from. When someone hires a container I wish to change "Available" to "Hired" in the main table. I know that to change the data in the table that the form is based on is...