Search results

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...

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

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)...

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...

is there any way of having a form like in the outlook thing where the menu with buttons is down the left

Instead of using the code in each form:- Private Sub cmdClose_Click() On Error GoTo Err_cmdClose_Click DoCmd.Close Exit_cmdClose_Click: Exit Sub Err_cmdClose_Click: MsgBox Err.Description Resume Exit_cmdClose_Click End Sub Private Sub cmdFirst_Click() On Error GoTo...

I have read over the few months of time I have spent looking through this great site a lot of good things but I need or want to open a discussion on the use of access as a double entry bookkeeping system as the packets on the market are no way near as flexable in report or design and as access...

I have this code on a button:- Private Sub cmdCreateRefNo_Click() Dim OurRef1 As String Dim OurRef2 As String Dim OurRef3 As String OurRef1 = Year(Date) OurRef2 = Month(Date) OurRef3 = 1 If OurRef2 < 10 Then OurRef2 = "0" + OurRef2 Else OurRef2 = Month(Date) End If Me.txtOurRef = right(OurRef1...

I need to Update The trelNametoAddress with new Name but Keep the Address I notice at the Bottom of the Code for Proc Sub cmdAddAddress there is some code that Creates a new Address related to the Company but I wish to Create a new Name related to the Address an update trelNametoAddress...

I'm just getting into unbound forms and using querys to update table and am finding the forms a lot quicker in loading and the data a lot safer but the work in the design is far more extensive than I though as every action and reaction has to be coded. But the experianced gained may be fruitful...

This is my first real attempt at Unbound forms and am finding this really dificult. On the form Main next to the Information tag is an Update button this is meant to update any changes made to the tblNames at the appropriate Record the Only thing is I disigned an Update qery and then copied the...

I have tried for three days now and reorganized my table added some and delted fiels and re done a form in four lanquages. frmCompany has Subforms:- frmCompanyAddresses frmCompanyNotes frmCompanyContactDetails Now this was done so that a Company can have more than one Address but the...

I have two unbound txt boxes that are meant to show the totals of a subform how do I get these unboundboxes to the value creasted in these querys query1 should = txt1(Unbound) SELECT DISTINCTROW tblInvoices.Nickname1, Sum(tblInvoices.Value€) AS [Sum Of Value€] FROM tblInvoices GROUP BY...

This is the Code I have for the Not on List event on my form Dim Strsql As String, X As Integer X = MsgBox("Do you want to add this value to the list?", vbYesNo) If X = vbYes Then Strsql = "Insert Into tlkupCounty ([County]) values ('" & NewData & "')" 'MsgBox strsql...

HELP! HELP! HELP I Have a form with Bound combo boxes these are Related to other Tables so the dropdownlist gives the names in table "Companies" now the problem is when an name is typed in that is not in the list it does not add it to the bound list. the error message does not come up as this...