Search results

Hi I have a combo box that goes to the 1st record in the recordset, - but is there a funky way of filtering on that first record that it finds? Field is CustomerNo. Any help - more than gratefully received. Cheers Paul

Hi I have a table that contains several thousand records detailing PartNo, Price and Customer. I want to do a query that ranks the price for each part number so say Part Price Rank a 1 1 a 10 2 a 100 3 b 1 1 b 10 2 b 100 3...

Hi Have a Crystal report V10 that is driven by a parameter called ShowCustomer - is there any way of viewing the detail of ShowCustomer - i.e so that it shows the customers selected by the user - say Argos,Homebase,Wickes etc in a text box? Any help gratefully accepted Cheers Paul

Hi I have a table that contains 1 year of sales. Fields include Item,NetSale,Customer,Month. I need to count how many times an item has been bought by a customer. I can see from a report wizard how the count is achieved - but I need to action this at query level. Any thoughts/help greatly...

Hi I want to remove the last 2 characters in a code - so in the stock code BS1222222ZZ I want to get rid of the ZZ. There are 6000 records that need to be amended. I was thinking about some form of query that would a) Count the number of charcters (Expr1) b) Based on the number of...

Ola This is a weird one. I have a report that prints embedded Access graphics - from a table. When I originally designed it, each time I went to print - no graphics appeared - then almost overnight - they started to print and I've had no trouble since - until today... when I started adding...

Hi I've got a form based on a table. 2 field on the form - bedtype (PK) and selecta - a check box. The form is continous. The idea is that the user selects 1 selection - by ticking the check box. The issue - if they select 1 - I need to ensure that they cannot select any others on the form...

Hi I have a report based on user input through a series of forms. At the end of the process they hit a cmd button which closes all the form's and (alledgedly saves all the data) then they hit a second cmd button which opens the report. Problem is - when you open the report - there's a series...

Hi I'm looking to build a product generator - so user will select from a series of combo box's (Bed, (could be 5000, 5100 etc) Plug,(could be A,B,C,D) Castor could be ZZ, AA, EE,etc) and a code will be generated. (i.e 5100CEE) I can achieve this - but I've been thrown one of those balls that...

Hi I have a report based on a crosstab query. The query lists allowances that a teacher may get - say Threshold,Form Teacher etc. From I have constructed a std letter that incorporates all the variables from the query. So Dear [FirstName]. This is a breakdown of your allowances for the...

Hi I have a Returns module that allows Companies to trace what has been received, when and why. The Why is based on a number of reasons in a combo box linked to a table. However, I would like to say that if a product returned was new - then the choice in the combo box was limited from say 16...

Hi This is not a menu question. I've seen a myriad of reporting solutions using a dashboard (like a clockometer) as their output device. Has anyone ever used one (through access) (binded to a query) and could you share how to achieve this. Cheers as always Paul

Hi Have a file that drops all the values like this Ref Mr1 102.0 Mr2 104 there are 2000 rows of this (+ other bits which require same treatment) I need the value to be moved from underneath the Ref - to the next column - - can't drop the data out csv or any other way - so data can only be...

Hi I have a table that when imported from an external program (sage) has a number based property. To achieve linkage with other tables, I have to manually change the field fom a number to text. Is this possible to achieve programmatically. Much appreciated on any advise. Regards Paul

Hi I'm trying to show a report that reflect's slow moving stock - tried initially to show a bunch of transactions from invoice file and then show a non match from stock file - which works ok - but doesn't reflect transactions that occured - say 1 in jan and the next in dec. So - thought I'd...

Hi I've compiled a make table query and would really be happy if I could automatically assign a primary key to one of the fields i.e account ref. Any ideas, suggestions gratefully appreciated Cheers paul

Chaps Have a db that deals with customer comms, works fine in one db - so I transferred all the relevant tables/queries/forms etc into a new db - thing is main form opens, but it brings up a Microsoft Access cannot find the macro you are referring to - so I copied every single macro (as you do)...

Chaps I import data from excel into a table and have to manually change one fields data type from number to text to ensure all my queries run ok. Question Can this be done programmatically? Any help gratefully appreciated. Cheers Paul

Chaps Le grande concept - instead of using some crm stuff - set up a db to handle all of our customer mgt info -(however need to centralise everything inc email messages) -therefore need a way to link all of the outlook messages back to the relevant customers - I can see that you can export...

Chaps Have a form that user enters invoicing details onto - have two fields one called taxcode the other taxamount - have disabled the taxamount field and the thought goes - if a user types a t1 code the field becomes enabled - tried this using an if statement on the afterupdate of taxcode...