Recent content by TurboDieselOne

I have uploaded 2 screen shots. also the database. I can do the vba and all that stuff but this Multiple addresses and tabs like in Filemaker would look good and can I can put this across all the Other DB's I am creating like Invoicing and Clients and other stuff. I can use Filemaker but going...

It does not work When I add a Billing address on the billing tab I see the same address on all the Tabs

Does a seperate Query need to be used for each Tab-Page.

Yes Each type on each tab. There are only 4 Types, Billing Business Delivery Registered

Hi I need help on this one One form Fields - Name etc Tab-Control Pages Business_address Billing Address Delivery Address Other in - Not on Tab-Control I have a table for Suppliers name etc I have a table for Addresses I have a Table for Address type I need to put each address for the...

Great Thanks for quick reply. I'm sure all these things will creap back into memory once I start using Access again.

Right old user been away from access for ages and into Excel but new company new toys. Well old toy really new version. Form 1 opens and I have first Name, Last Name, Company now next to Company is button that opens a popup form that has a combo which uses a query to list the only the companies...

Now I have a table Called Actions This has A field: Clients That Looks Up as below in Table Design view Lookup SELECT Names.IDNames, Names.Company, Catagory.Type FROM Catagory INNER JOIN [Names] ON Catagory.IDCatagory=Names.Catagory WHERE (((Catagory.Type)="Client")) ORDER BY Names.Company...

I have been working on this for a week now and I have got through oh 65% of it but all the controls codes on each form are individual and not moduler VBA also the forms are not written to use record sets but are linked to querys, created from tables. I will when finished split this to FE and BE...

I have my own navigation buttons but if you go befors the first record with Previous or Last Record with Next I get this error message. At the moment the forms ar base on queries not tables so I have to trap this. Any clues please Thanks in Advance

The form Opens The user inputs there username and password this is checked against hte recordset of tblFeeEarners Then if correct the frmMenu Opens if not then a message is displayed and the user gets another 2 attempts if this is still not correct the recordset is set to nothing and the...

I have table of Users and Passwords I put in. What I want to do is load the record set of the table. which I have done:- Private Sub Form_Open(Cancel As Integer) Dim db As DAO.Database Dim rst As DAO.Recordset Set db = CurrentDb Set rst = db.OpenRecordset("tblFeeEarner") Do While Not (rst.EOF)...

Well what I want is one form with menu buttons down the left but no fields when the form loads. Press the button "Clients" and the code runs on the cmdClients_Click() that draws the unbound fields creates the rowsources for any combos and then loads the recordset intialises the navigation and...

I cannot get the Previous Button Working. the Next Button code worjks Find for now no error trapping yet and also the recordset is opened when a cmdbutton is clicke not when the form opens. Option Compare Database Option Explicit Private Sub cmdClear_Click() Dim db As Database Dim rst As...

Does any one know what code I would use to creat a control? Example:- Click Client Button Create controls:- intClientID txtClientName txtAddress cboFeeEarner etc and then I can set the properties of these controls to where to put them on the form and then create the recordset and set the...