Search results for query: *

Hi I create a file that contains numerous columns with a Product Description. These can contain spurious characters such as tabs and a plus above a minus etc. This file is rejected in the next process until I remove these records. In the SQL I can keep on adding characters to exclude using the...

Hi I've created a database in Access 2007 that enables members of staff using front end forms to fill in customer application forms. There's an Autoexec.bat macro that opens a certain form and only allows the user to add records. I've created another facility within this database for other...

Hi I've created a number of Access databases and put security on one of these. Everytime I access different databases I'm prompted for passwords. (I setup a system.mdw thinking security would only apply to one database). Some of the databases where set up before I set up the security and...

Hi I have a form that is data entry, where Customers details are to be entered. When a customers Account number is entered a search is made to find out if this information is already held, if we do then I'd like to be able to find the record and be able to amend the data if need be. This is...

Hi I'd like to log every occurance of when a letter is sent to a retailer. I've created a table to log the information, I've created code that will populate this table. The Users have to have the ability to change the printer/trays etc and so I allow them to preview the report before...

How do I display the conditions I used for a query in a form? I have a form that displays values and counts that are calculated from various financial weeks and I'd like to display the weeks [that where used in the query] in the form too.

Hi I have a table in my database that contains Orders, I recieve a list of Cancellations [of customers] that I have to then use to update the list of Orders to mark that certain customer products have been cancelled. In order to find just the Orders that have to be marked as cancelled on the...

Hi, I received a text file which had an income field in an incorrect format [left justified and missing some zeroes]. I imported the file to a table, made the relevant changes so it is now right justified and has leading zeroes. How do I export the table so it is in the correct format? At the...

Hi, How do I take a value in a field in a form and place it into a field in a table? I'm wanting to put the 'products sold' from my form into a table called 'Products' and the field being 'Products sold'. I can't seem to name the appropriate fields correctly. My coding is...

Hi, I need to sort a report on a calculated field. I have read that I should put the calculation in the underlying query. When I put the same code in the SQL I get a message saying that the field cannot be found yet it works within the report. I'd like to find the sum of items purchased in...

Hi, I have two tables that I would like to match by name within a query. There are two fields I use for the name in each table, Surname and Forename. When I join the tables together by Surname I qet thousands of records back. How do I get back the records where the forenames are similair e.g...

Hi, I have two tables [Sales 2001 & Sales 2002 which have identical fields] and would like to run a query where all the data is combined \ appended into the same fields within the query but I don't want to merge the two tables together. Is there a way around it?