Search results for query: *

Hi I think this is a simple question but it is several years since I used Access. I have Access 2010. I have created a table into which I download my bank statements, named tblStatements. One field is “spent_at” another is “Group” I want to update the field” Group” depending on the contents...

Hi I have an Access 2003 Application, I have now changed to Win 7 and Access 2010 64 bit. When I try to run it I get this message " Compile Error: THe code in this project must be updated for use on 64-bit systems. Please review and update Declare statements and then mark them with PtrSafe...

Hi I would like to analyse my spending from the last few years and have downloaded the statements. I have added an extra field, Category which I want to update with code. There is a field, Detail of Operation that identifies each type of transaction giving detail of payment type, card...

Hi I would like to add a text field to a table. I am sure this can be done with a query or code but after searching can not find an answer. Can anyone suggest a solution? I am using Access 2003 Thanks Stephen

Hi I have searched this forum without luck. I would like to create a continuous form that displays a linked picture. I am sure I have seen this done but I am unable to find a way to achieve it. Can anyone help please. I am using Access 2003 but could install Access 2007 if this helps Thanks...

Hi I would like to create a simple online calendar that will allow viewers to see if a property is available for rent or if it is already booked. The calendar would need to display 12 months at a time, ideally with the ability to scroll forward. The calendar would have one colour block for...

Hello I have not used Access for a few years and have never used much code in the past. I am creating a db to calculate the cost of building materials for a house restoration project. I have three tables, BOM, Specification and Room Size. As an example, I want to update the BOM table with...

Hi I have a date field in Month/year format. I want append data to the table and increase the date fiel by one month each time data is added. Can someone help with this thanks

Hi I have a stock control Acess db. I have created a report for orders that I want to put page numbers on. The reports pulls in orders from all customers so if I use the normal page number function it will read say, page 1 of 150 etc, but each customer will only have say 3 pages. Is there a...

I am using Access 2003, I am automatically emailing a repor, but every time outlook tries ti send, I get a dialog box asking if I want to sent the message. Do you know how I can send the email without this box appearing Many thanks

Hi I have a table where data is entered in the first field, and then the remaining fields are updated useing queries. The problem is that e.g if the first number is say 4, and this is divided by 2, the result is show as 1.999999. The problem is that I am takeing the number before the decimal...

Hi I have a fiels in a table that has the result of a calculation. The nuber could be eg. 7.85. Is there a way to extract just the decimal part of this fiels ie .85 ? Many thanks Brandon

Hi I have a table with a text field in which I want to search and replace some of the text, so I have another table in which I have two fields, one is the word to find, the other the replacement. The problem I have is e.g. if I have say the words “tea” and “teapot”as words to be replaced, tea...

Hi I have created a DAP which sits on the server, the idea is that ervery one in the office can see updates on reports easily, the problem is only a few people can open it correctly. All can see the heading, but not the data below. I assume I need to change a setting in thier browser, but I...

Hi I want to use a barcode scanner to read barcodes directly into a form field, then move to the next field. The scanner reads the barcode, but will not move to the next field, despite trying code in all the events to move to a new record or named field. Hitting the return key solves the...

Hi I have created a Data Access Page, which sits on a local server. Some of the PC's in the office can open this, and others can't. All the PC's run the same software, but someting is preventing them veiwing. Is there something that I should be checking on these PC's Thanks for your help...

Hi all I am using a meesage box that appears if an If statement is True, I want the user to be able to continue running the code when they click the OK button. Can someone please supply the code for this Many Thanks Brandon

Hi I have a table with 3 columns, Account, Amount_Due, Date. The amount due list the outstaning balance by date. The are multiple amouts for each account no various dates. I need to extract the balance on the last date for each account. I have tried a simple query, but this groups all amounts...

Hi I would like the Windows user log on name to be recorded when the user add records to a table, is this possible? Thanks Brandon

Hi I have a table “Customers”, and 6 of the fields are for the products (Say A,B,C,D,E,and F) that they stock, these fields are Yes/No. I want to create a query that will select customers depending on the products they stock. I want the criteria for this query to be entered in a form so that...