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...

The query calculates total counts and sums based on various criteria, it's not grouped by weeks or anything else. I was hoping to display the values I used in the 'Where' statement in the form too. The query looks for number of items sold, value of items sold where the orders sold where in...

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.

I've got around the problem by using a subquery. Thanks for your interest Tracy

Hi I have a table of 'orders', which contains customer number, dates, prices, product numbers etc. I am supplied a list of customers who have cancelled with various other information from another party, unfortunately the only field indentical on this list with the 'orders' table is the...

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...

Many thanks randysmid, that solved the problem.

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, Its Access 2000. The debugger still seems to stop at the same line. Is there another way around it?

The Code stops with an 'invalid argument' at Set rstprod = CurrentDb.openrecordset("product", dbOpenDynaset) if I remove Dim DBS As Database Set DBS = CurrentDb if I don't it highlites the 'DBS As Databse'. The 'Date' is defined as a string in the table so that shouldn't be the...

Hi, This is my code, I hope you can help. Private Sub addrecs_Click() Dim DBS As Database, rstprod As Recordset Set DBS = CurrentDb Set rstprod = CurrentDb.openrecordset("product", dbOpenDynaset) rstprod.AddNew rstprod![Date] = "200209" rstprod![Department] =...

Hi, Sorry for more hassle, I've typed in the following Dim rstprod As Recordset Set rstprod = CurrentDb.OpenRecordset("Product", dbopendynaset) rstprod.AddNew then the fields I'd like to populate but end up with an error message saying Run time error 3001, Invalid argument, Could...

Hi Paul, The form is not bound to anything, it just takes calculations from queries and I'd like to put those into a table to store. I've added a button to my form which opens a table 'Products' and then goes to a new record. I was then hoping to take the information from the form and place...

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...

Thanks very much, it did the trick.

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...