Search results

Hi, I have a field Invoice Date and a field Invoice Month. On my form how do I get the Month part of the Invoice Date to populate into Invoice Month? Tried this Private Sub DateContractSigned_AfterUpdate() Me.MonthSigned = DateContractSigned(Month) End Sub But no joy. Anyone? Also anyone...

So are tblReport and tblProductGroup lookup tables that feed drop down menus on your forms? First off you need a ID field as a PK in tblA. Then relationship wise FK in tblA goes from FK to PK in tblReport and PK in tblProductGroup. When you then have fields on the forms, you will use drop...

Create a form using TableA as its Source. Then create subforms for Table B, Table C etc... Then these subforms should all link to the master form of TableA using Child/Master links in the forms properties. eg. Table A ID is primary key Name DOB Address TableB tableBID is PK TableA_ID is FK...

Try the Northwind template within Microsoft Access.

Look at the fore colour, background colour, border colour, font colour etc.. properties on that field. change Back Style to normal.

Cheers mate. Will try tonight. It is the Microsoft Northwind Example. Seems a good set up in theory but some tweaks to tailor it to peoples needs can throw up problems that I have never dealt with before. I'll give it all a go tonight and see how I get on. Cheers.

Cheers but not sure what to do here. If I get properties for Invoice Order button on the OrderDetail form. There is a Marco attached. Not sure which part of this needs to be edited? There is a SetOrderState line within that, any ideas if I just removed that would it be ok? I have created the...

Are you using continuous forms?

Cheers mate I will give it a go.

Issue an invoice in the db attached few posts back.

Cheers. Think its ok now. However I would like to know if there is a way I can remove the feature that doesnt allow me to edit invoices after they have been submitted? Reason I need to edit is sometimes if people cant pay, we may offer a discount, so the invoice will need editing to reflect...

Hi, yes i think it works , thank you very much. 1 problem I have found. For the OrderLineItems form, if I select Supplier products filter fine. But if I enter a new row below and select Supplier, it clears the Product from previous entry? Any ideas??

You want clientID in Client tbl and ProjectID in Project table and InsiderID in Insider tbl. You then want a clientID field in Project tbl and a ProjectID field in Insider tbl. Then your links are from clientID (client tbl) to clientID (project tbl), then ProjectID (Project tbl) to ProjectID...

Yes it would be your PK, then in relationships you PK in client tbl links to FK clientID in Revenue table. For the dynamic set up you are asking for might require you to use unbound controls or vba code. Use a search form instead search Access search form on here, theres loads.

I agree 100% but its Microsoft sample (northwind) so not sure why MS would do that either. But I dont want to change all the lookups incase the forms, fields etc.. fail. Annoying.

Dont think its possible.

No you want a Client table with all your client info (name, address etc..), then you want a table say Revenue. In Revenue you would have revID clientID Year RevenueAmount ExpensesAmount For Year, on your form you would have a drop down, to select a year which is then stored in the Year...

Last problem, I have my Supplier combo bringing back the SupplierID's, however I can't seem to get the Supplier name which the query brings back. Query is ProductList. Fiddled around but can't seem to get it?

Boss mate thanks. Sure it works now. Will test tonight/tomorrow and feed back results.

Use the forms in the Nav bar and open OrderLineItems.