Search results for query: *

Hi, I have a company that delivers skips to customers. I input the data on a subform for the delivery of the skips which includes the date (Taken from the main form), address, skip type, type of job(deliver/collect/Swap) etc..... Is it possible to duplicate that entry (if it is a delivery or...

Hi, I have a query that did work in Access 2003 but i cannot get to work in 2007. The form where the query is used has several checkboxes that filter a subreport when they are clicked. Like IIf([Forms]![frmAllData]![chkBlocked]=True,-1,"*") This is the code i have in the query for each...

Hi, I am using code to extract data from Access into a spreadsheet. I am having problems inserting formula at the end of certain data columns that totals the column above. The first row will always be row 8 but the last row will always change. Am i missing something in my formula code below as...

Hi, I have two text boxes on a report that i show and hide depending on a value of a tickbox. The code below works for every record apart from the first record if the value is true. Both boxes properties are set to invisible, but if i enable them they show all the time on the first page. Do i...

Hi, I have got the code to create a pivot and a chart from the source data. The problem i have is there is far too much data to be displayed in a chart. Is there a was of deselecting all the entries, in this case date, and only display the first date that is in cell A5 in the pivot table? At...

Hi, I have a report that is run by selecting dates between a range on a form. A different page for each customer is produced in the report. I also have a textbox on the form where the user inputs the date they want printed on the report. I can get the date to print on the first record of the...

Hi, I have a subform that has customer payment details. ie: Amount Owed, Amount Paid, Amount Outstanding. The subform updates the amount outstanding automatically when a payment is made. I have a checkbox that marks the record paid in full but this is manual, is it possible to have the checkbox...

Hi, I have a stock database in access. In the database is flat table with locations, codes Qty's etc.... Each location is split into Back and Front with a maximum capacity to hold 2 codes. I cant seem to figure out how to create a query that will display locations that have different codes in...

Hi, I have 2 forms, Main and Sub. I am filtering the subform using a combination of 7 comboboxes on the main form. The subform has a list of product codes and their location where they are stored. I am looking to put a textbox on the main form that counts the amount of distinct codes when i...

Hi, I have a form with a subform on it that is filtered by selecting entries in the dropdown boxes. I would also like to be able to put a checkbox on the form that allows me only to show the records that have differences between two values. This is the code i have built, but it does not work...

Hi, I have a problem with filtering a subform based on many comboboxes. I can filter using one Combobox using this code: Private Sub cmbAisle_AfterUpdate() Me.qryAllData_subform.Form.Filter = "[Aisle]='" & Me.[cmbAisle] & "'" Me.qryAllData_subform.Form.FilterOn = True End Sub But when i add...

Hi, Is it possible to have Access send an eMail with the user id of the person accessing the database to a defined mailbox? Dazz

Hi, I have code that exports data to a spreadsheet. What i would like to do is then apply conditional formatting to each row based on a value in a column in that row. I am having problems getting the code to work. This is what i have so far: ----------------------------------------- Dim xlApp...

Hi, I can run the code below once in the database, but when i try to run it again i get an error: 1004 - Method 'Cells' of object'_Global' Failed Error occured during FormatExcelBasic function. If i shutdown the database and restart the code works again. Any help would be much appreciated...

Hi, I have a tabbed database that on one of the tabs has a link to a picture. Each time i change the record i am looking at the picture for that record updates automatically. This is causing errors if certain users scroll through the records to fast. Is there a way of having the picture update...

Hi, I have a form with address fields [Name] & [Address] etc....... I can display these in a text field in a line, but would like to have each field on a separate line. IE: [Name] [Address] I have tried [Name] & chr$(13)& [Address] in the record source, but it ignores the return code. Is...

Hi, I have the following code that works and sends the required E-mail with attachment, but when i try and close Excel, Excel crashes everytime. We are using Excel 2003 SP1. If this version is causing the problem, is there anther way of doing the same thing as we cannot upgrade to SP2 at the...

Hi, I am trying to build a report from a query. In it i have Customer, Product Code and a Quantity. I would only like to show products that have a Quantity value Greater than 100 and Lower than -100 by customer. This i can do in the query OK. My problem is that i need to have a grand total of...

I have a map of Europe on a report as a linked picture. Is it possible to run a query for certain locations held in the database and list each location in a text box and place the text box on the correct location on the map? I have a link in the table for each location that goes to Multimap...

Hi, I have a tickbox, when the tickbox is true i have a textbox appear. If i scroll through the records the textbox stays visible whether or not the tickbox is true or false on the other records. Is there a way i can have the form refresh so the textbox stays hidden when scrolling through. The...