Search results for query: *

Hi, I need to put the date in the filename of an access report. I have tried this code as below. The report opens as a PDF OK, but no date. Got some error here. Any bright suggestions would be appreciated. Private Sub Master_Report_Click() Dim FilePath As String Dim FileName As String FilePath...

Hi All, I am using some code by Daniel van den Berg re having a star rating on a form. On the subform it works ok.But when the subform is on the navigation Form (access 2007) it gives this error. The code below is on the subform Private Sub Form_Current() SetRating Form_RecipesNew, Me.cRating...

Hi Guys, I'm in the process of designing a Chefs Order system. While its working as required I have been asked to provide the following. The order form works as per a continuous form using the Order No to link both main and sub forms. However as they order some 120 items each week, they don't...

Hello, I have a query re combo boxes in Excel 2007. I have a worksheet (worksheet1) with text data on it. I want to be able to put a combobox on another worksheet (worksheet2) and use it to fill in cells from the data on worksheet1. Just not sure how to implement this. Could I have some help...

Hi all, Just a question on running totals in a query I have used this code below to give a running balance RunningBalance: DSum("[Total]","Accounts","[Invoices]<=" & [Invoices]) However I want to add an expense field to this so we have an income and expense running balance. I have an "expense"...

Hello, I have a question about locking an Excel workbook on closing it down. Is this Possible? Particularly the cells that contain a users input. Many Thanks, KP

Hello, I have an excel workbook with a cover page that selects worksheets by using check boxes. When the Work Book opens I want the check boxes on the spreed sheet named 'Cover" to be opened as 'False' Just not sure how to do this. I have set "This Workbook" attribute from "General' to...

Hello, I am looking for some advice on how to prevent the cover of an excel 2010 spreadsheet from printing. There are 10 spreadsheets in the workbook, but I need to prevent sheet 1 or the name "Coversheet" from printing out. I print the work book to PDF with the following code; Private Sub...

Hi, I have created an excel workbook with just a few command buttons On my computer which is win 8 and using Office 2010 I have no issues with the command buttons working. However when I take a copy of the workbook to the office which is using the same version of office, but on Windows 7 the...

Hello, I am looking for a solution to removing this error (#Error) on a report when there are no calculations available. It appears on a sales report when no data is present. Thank you, Integrity

Hello, Just wanted to know how I can modify this query so that the running sum will show the sum total per date selected., instead of showing the total for the all the table data. SELECT T1.BankR, T1.DateRcvd, T1.BrokerStaffID, T1.TDeposit, T1.TDebit, T1.ItemName, T1.ChqNo, T1.CHK...

Hello, I have a question on using option groups. I understand the building of them, etc but here is my question. The scenario is on an invoice form. The invoice form is as normal using a query to gets is information. However I wanted to use the same invoice form to view archived invoice data...

Hi, Our Db uses an invoice system that has a main form and a subform. The Main form holds general data, such as invoice number, client id, etc. The subform holds service data, such as service type, date of service , employee times and charges with the subtotals etc. The two tables are linked in...

Hello, I have a been requested to implement a way in which an invoice can be duplicated so that dates can be changed on the subform without having to reenter all the data The mainform has a subform which holds the invoice items. I put a duplicate control on the mainform which will duplicate the...

Hello, I have a requirement to implement a popup form in a document management system that will open to show policies that are due for review. All policies logged have a review date. How would I write the code to achieve this? Many thanks, Integrity

Hi , Have a question on filtering a continuous form by using the on event (click). There is a textbox on the form (company) in which the user wants to be able to filter the form so that only that company will appear on the form. At present there is a combo box that is used to select the...

Hello, Just need some ideas on how to find the number of individual days between two dates. for eg; Start date 1st April 2013, End date Dec 1st 2013 How many Mondays, Tuesdays etc. Many thanks, Integrity

Hi all, I have a date field that when it is null that I can use conditional formatting to show that the field is empty.. This is what I have used condtion Field value; less than = Date() However it wont work... Many thanks Integrity

Hello, I would like to know how to write some code so that when an invoice is 'saved' by a command button that a clients last name is put into ascending order. I know that it can be done by using the 'Sort ascending', but just to make it full-proof for the users. Many thanks, Integrity

Hi again, Have a requirement to have a running balance which incorporates both deposits and debits. I have used this code for the deposits, but not sure how to incorporate the debits Balance: (SELECT Sum(tblBankRegister.TDeposit) AS Balance Many thanks Integrity