Search results

Do I put Private Sub Form_Open(Cancel As Integer) Me.frm_Clients.InvoicesTb = Me.OpenArgs End Sub On the clients form? or?

I am doing some coursework for my cousin. His specs say 1-1 relationship between Accessories tbl and Supplier tbl. I get the concept of why it is 1-1 as 1 accessory only has 1 supplier linked to it. But in practice its not 1-1 as many people can have the same supplier. I have asked why and no...

Nothing. I just stuck it at the end then got confused with the next bit. So in the Search Form Open Event? Is it the search form I put this in? I use Me.frm_Clients.InvoicesTab=Me.OpenArgs

Hi, I just need to clarify something and need someone to explain it as detailed and as easy as possible. I have a 4 tables: Customer Order Accessories Suppliers Now I have PK ID in Customer table PK ID in Order table PK ID in Accessories table PK ID in Suppliers table But I also have...

Sorry mate. I am totally lost. I have applied ,,,OpenArgs to the end of my DoCmd.OpenForm. I have a form called Clients, with subform Invoices. The control in InvoicesCtl I am opening the form based on the ClientID. I can get the client form open at correct client but just cant get it to...

Thanks. Do i need to apply a Form_Load event detailing similar to : Private Sub Form_Load() ' If Not IsNull(Me.OpenArgs) Then ' If form's OpenArgs property has a value, assign the contents ' of OpenArgs to the strPlayerName field. OpenArgs will contain ' a Player name if this form is opened...

Do I need to specify the tab or can it work by me searching, finding the record, then double click and it open that record on the tab that the form wants? Eg. my invoices form opens clients form. but I want it to open clients form on the invoice tab? Do I scrap my previous code or?

Hi, I currently have a search form that runs a query to filter results when typing into a search field. When I find the record I want, I can double click and it opens a form based on the ID of the result to the ID form record. I use this code: 'Private Sub SearchResults_DblClick(Cancel As...

Hi, I have a field, DateContractSigned. Then I have 2 other fields MonthSigned and QuarterSigned. Does anyone have the VBA for an AfterUpdate Event (or better) to populate Month and Quarter fields? eg. If I enter 01/06/2012 in DateContractSigned, the MonthSigned field will read 06 or...

Name of the form is OrderDetails. There is no VBA on the forms or subforms. Its all Macros. There is a SetFormState used in Marcos that looks like it locks the form once IsInvoiced is checked. But I aint got a clue with macros and/or this lock/unlock set up. Any ideas on closer inspection...

Tried that already mate. Still wont work. It has been stumped good and proper.

Macro, Locks all that side of being able to edit an invoice once its submitted as an Invoice. Look at design view of form and you see checkbox for ISInvoiced, that ticks but can't untick. Tried your VBA as well. Does it work if you do it in one you attached few posts back? Cheers mate.

Sounds like you have selected a specific layout for form design. Try starting again but create a blank form?

My one is: ID: [ClientName] & ", " & [Address1] & ", " & [Address2] Tried your example and it gives me same 1 field answer. Are you using a select query?

Anyone? Thanks.

Why not create a Report then use a command button to load the report ready to print?

Hi, Does anyone out there know how to unlock the forms within the Northwind database sample to allow people to edit Invoices once they have been invoiced? I need ability to edit them after invoiced because the customer may receive discount at later date or new price negotiated, so I need the...

No joy. Completely stumped mate. Any ideas?

Would I need to add a new field to do the concatenate?

Cheers. Were would I put this "HH" &? Control source of Ref field or ? I want to store this. Same with Month() were do I put this?