Search results for query: *

Hi all, I need some help in wrting this bit of code please. On a continous form I have a check box which is used to mark off payments. (PD) The are times when payments have to be reversed. i have put an unbound checkbox in the footer (Cancel) with this code; If Cancel Then If Cancel Then...

Hi In our Db there is a continous form that has a start date to show schedules for clients. The schedules can vary from one month to several months. What I require is to use condtional formatting so that just the current month can have a different background colour. I know how to set up the...

Hi Below is the sql code for a crosstab query; TRANSFORM Sum(Accounts08.InvoiceTotal) AS SumOfInvoiceTotal SELECT Accounts08.Companyname, Sum(Accounts08.InvoiceTotal) AS [Total Of InvoiceTotal] FROM Accounts08 GROUP BY Accounts08.Companyname PIVOT Format([DateRaised],"mmm-yyyy"); I need to be...

Hi I have created a crosstab query to pull debtors from a list of companies.This is then exported to Excel. The problem i have is that it only shows 12 months. So I get Sep09 to Aug 1o. What I requires is for it to got from July 09 to Aug 10. Here is the sql code for the query; TRANSFORM...

Hi, I am using this code on a continous form to show specific data when a certain date criteria is reached. Expression is DateDiff("d",[DateRaised],Date())>30 This will hightlight all dates that are over 30 days. What I need to do is to be able to show 30 days, 60 days in different colours...

Hi all, I have a requirement to be able to export a table to csv format. I know I can use the Export command in the menu for this, but I would like to just be able to use a command button to do it automatically. Many thanks, kp

Hi On an invoice form I have used this code to generate invoice numbers Me.InvoiceNumber = Nz(DMax("InvoiceNumber", "Accounts08"), 0) + 1 What I have noticed is that the invoice number does not appear in the table until the invoice is saved. I need to have 2 people invoicing at the same time...

Hi, I have a requirement to export an access query to the desktop where MYOB can link via software. I have created a command button on a form with this code Private Sub PostInvoices_Click() On Error GoTo Err_PostInvoices_Click Dim stDocName As String stDocName = "QSendInvoices"...

Hi , In an Invoice Ledger there is a date to show the date the invoice was raised. What I want to show is that when the date exceeds 30 days that the date of invoice will change background colour so that the bookeeper can then query the company. I think that the condtional format would work...

Hi, I have a continous form that has 4 number fields that are summed in a field in the form Footer. In the tblAccounts the number fields are D1, D2,D3,D4 Also in the tblAccounts there are 4 fields that Total each one, D1Total,D2Total, D3Total,D4Total. In the form Footer I have placed D1Total...

Hi, Heres one I am not able to solve. On a continous form how can the data be duplicated onto the next record. ie: I have a form that has 6 text fields. I just want to use the On Dbl Click event to duplicate the data onto the next record. Many thanks, kp

hi all, I have a continous form on which there is a date field, and 4 number fields. The number fields are used to input hours worked. This is an invoice form. The number fields are d1,n1,sat,sun. The date field is, SDate What I would like to happen is that when the date field shows a...

Hi Just need some help please on how to get a text box (TDiff) which the data type is set to number and field size is set to double. There are two time fields (Start) and (Finish). I need the TDiff field to show the difference between both time fields as a decimal. ie: If the start field has a...

Hi all, I have been trying to find out how to update the mainform Totals field when you add or change data in a text field in a subform. The subform (continous) has a subtotals column and there are 3 textfields, the datatype being Number and the fieldsize being double. The subtotals is summed...

Hi all, Please excuse my ingorance on how to explain this issue. The issue is how to get a text box on the subform to update when the mainform is updated. On the mainform there is a textbox ACS The same textbox is on the subform. The structure of the tbls has this textbox in both...

Hi, On a continous form there is a check box in the Detail Section. It is used to select a record to input data.The checkbox is a Yes/No. What is required is that when you go to a new record, that the checkbox on the previous record, becomes unchecked. The reason is that when the checkbox is...

Hi all, I am having trouble trying to create an aged debtors report. The construction of the report is no problem. Its creating the date queries. All invoices created have the datenow function. The report needs to show, 90 days, 60 days, 30 days and current. On the dateraised field in the...

Hi, In a continous form there are 3 text boxes, ID, firstanme, lastname. The form is used to select clients, by ID. The selection works ok, but the question is this. In the condtional formatting I have used 'when the field has focus' and used this to change background colour and text, when the...

Hi all, On a form with the default view set to single. The purpose of this form is to show client details. Also on this form I have a created a list form, which shows all the clients in the database. The list uses the same query as for the mainform (client) What I want to do is to be able to...

Hi all, I am setting up a user for our db on remote desktop. What I need to do is for the db to close if it has been idle for say 20min. Is this possible? If it is how can I do it. many thanks KP