Search results

I’m looking to filter the data in a “Store Location” table using a select query, but I’m having a spot of bother getting the filters to work. The data is a simple store number/address setup with a traffic light system to show the condition of four pieces of equipment within each store. The...

Will do cheers for that one and all. Denis

Cheers for that boys and girls, I'll have a play and see how it goes. Cheers Denis

Up until now I’ve been using the applications I design for internal use at the company where I work, however, I am now developing an equipment selection application to issue to our customers. I’m currently running on Access 2003, but we’re upgrading to office 2007 so I’ll probably be using...

I have a simple database with one form which I'm developing and it's been running ok up until now, when I keep getting the following error whenever I call my code from an event, such as a click or after update (infact all events are producing the same error). All the events were calling my code...

Cheers for that, I thought there may be a short cut way but it seems not. Cheers D

Gents, I'm building an update query for my supplier prices and I've run into a problem. When I select fields such as part number, model, description and supplier name (all of which I won't be updating) in the design view, when I come to view the data before running the query all that is listed...

Regarding your tutorial, I bought myself a few books one of which is this: Title: Access 2003, Inside Out By: Mircosoft press ISBN-13: 978-0-7356-1513-7 ISBN-10: 0-7356-1513-6 It's a chucky book but covers a good amount of material, and is the one I refer to the most along with this website...

Cheers Guus I used those from your previous post to sort out the problem, and they came in well hand. D

Got it working. Mile-O I guess you joined my two threads together but you've dropped the reply that solved the problem for me. One of my replys had a link to a web site: http://support.microsoft.com/default.aspx?scid=kb;en-us;209203 The line causing all the problems is this one...

Sorry for the delay gents I've been away from my computer for a few hours with a customer. I managed to get passed the last error by adjusting this line: My_RecordSet.FindFirst "PartNumber=""" & Me.Text_PartNumber & """" To this: My_RecordSet.FindFirst "PartNumber=" & Me.Text_PartNumber But...

Openning a recordset I'm testing out trying to open a query recordset on a query called "Discount_Query" but keep getting the following error: 3061: Too few parameters. Expected 1. I've got a single query looking at a single table, there are three fields in the query and I'm filtering the...

Here you go. SELECT Table_SpecialDiscount.PartNumber, Table_SpecialDiscount.SpecialDiscount, Table_SpecialDiscount.AccountNumber FROM Table_SpecialDiscount WHERE (((Table_SpecialDiscount.AccountNumber)=[Forms]![PriceListCompiler_Form]![Combo_Customer])); D

Yes it is. D

The query pulls all three fields from a table and I can view the query when operating the form to which it is associated. Also the query is filtering the records correctly to give me four results, but I just can't get the code to run to edit the discount value from the query. D

The error is: 3265: Item not found in collection AccountNumber is a long integer Cheers D

Ladies & Gents, Once again I'm here knowing exactly how I need to structure my software to run, but I'm at a complete loss as to what the correct syntax should be. I've got a query called My_Query with three fields namely PartNumber, AccountNumber and Discount. I've got some code to look at...

I thought it looked like a Yamaha, I guess I've got a hard summer test riding ahead of me, what a shame. Cheers D

Guus2005, What's the make and model of the bike in your signature, I'm looking to buy a new one later this year and it looks similar to one that caught my eye the other day. If prefer to reply via e-mail then I'm on denis.mccrohan@gmx.com Cheers mucker D

Cheers for that I should be able to get things running now. D