Search results

But the prices are quite an expence if you want multi currency and I am of the opiniion that the way these applications impliment multi-currency is accounting wise incorrect. All these applications like Quickbooks the way they implent this is in my way of thinking wrong. as when a cross currency...

I Have I have tables like Clients, Accounts, Suppliers, Transactions etc but I did before try doing the ledger as a double entry but got told my form was to complicated and that instead of having one form for all transaction I should have one for each well I think why not one form for all...

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

The address one is OK but If the all I want to add to the recordset the Company I have to have code that adds a new record to the trelNametoAddress and Create a intNAmeID which is Pulled from the table Names When it adds a record to the table then inserts this into trelNamestoaddress and then...

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

So Lets say we do it like this. We have an Unbound Form called Main. In this form is a text box(Unbound) after the update event it runs a query that searches the table for Name "Unbound Text Box". it finds it and then what loads the other Unbound text boxes with the data from the Query so how...

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

Press the Edit Button and in the Header at the top is a combo under the heading Company. Select the Company there is only One but with two Address. Now this will Populate the Form I have sused out the Update Button in the Information Area and I am sure I can do the same in the Address (Now I...

Access 2002 XP

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

try the Button wizard to Open form with related info from you present form and record.

I had this problem and am still looking for an answer but can I make a gues that these combos are on a subform?

All I want is to be able to toake the contents of forms!frmCompany!Country and add it to the tlkupCounty.Country as the statment adds the County when not in list to tlkupCounty.County the rowsource of the cboCounty is tlkupCounty.County,tlkupCounty.Country

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

I Have A form with Several List/combo boxes on. The dropdowmns on each show what is in that paticular related table ie the companies one show the list from the table Companies. now if I type in a Name of a Company that is not in the list I want to Automaticaly add it to the table Companies so it...

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