Search results

Hi Everyone!, I have a table with the follwing; ShopID, CustomerID, Month, Item_ref, Product Category There are about one thousand shops. The CustomerID field is only unique per shop. I.e. all transactions for customer ID '002' in shop 1 will be for the same customer, but customer ID '002'...

Hi Everyone, I want to perform queries that count the number of customers using combinations of different products. The data is organised like so: CustomerID ProductType No of Items 1 A 5 1 B...

I am hoping someone can give me guidance on a fairly major project I am working on. I am responsible for producing lots of figures, charts etc. each month and the current process takes a very long time! I have been charged with improving this process, which currently includes the following:-...

Hi Everyone, I want to be able to transpose and transfer data from a CSV file into Access. The format of the data is as follows:- Jan-04, Feb-04, Mar-04, Apr-04 etc. Shop1 xxx xxx xxx xxx Shop2 x xx xxx xx Shop3 xx x...

Hi, I want to calculate the number of days between 2 dates using the datediff function, however the dates are in a strange format: YYYYMMDD Would I first have to format the dates? If so, how would I do that? Many thanks, Sasha!

Hi everyone, I have a table which has the following 3 fields:- Customer_ID Shop_ID Month I need a count by month for each shop for the number of unique customers. There is a complication in that the customer ID field is not unique from shop to shop. E.g. there could be a customer ID number...

Hi Everyone, I have a database where the file size seems to be getting bigger and bigger. It doesn't contain any pictures or images, just a few forms and quite a few tables and queries. The database was 160mb, I've compacted it which has reduced it a bit, but it's still 130mb. I'm not sure...

Hi there everyone, I'm in need of some urgent help!!...... I have a form that has a graph on it. The form's record source is a query with fields M1, M2, M3, M4, M5, M6. On the graph I have renamed these to represent months M1 being July '03, M6 being Dec '03 and so on. I now want to change the...

Hi Everyone, I am hoping someone can help me with this..... I have a table with the following fields:- Shop_ID, Order_Form_ID, Item_Ref_ID, Month For a certain selection of shops I want to be able to count how many items there are per order form. (One Order form will have many Item Refs) If I...

Hi everyone, I keep getting a mesage when I try to close down a form in my database-"the object is locked, so any changes you make will be discarded when the form is closed"-As far as I know I have not made any changes. It lets me close the form, however if someone else then try's to get into...

Hi everyone, I have developed a small database that seems to work OK. One of the senior bosses has seen the database and asked if he could have it on his machine. "Not a problem" I said. I moved the database to a directory he could view then created a shortcut for him on the desktop. He can...

Hi Everyone, I have added user level security to my database-this all seems fine, however I need to stop particular users' from viewing a certain form. To view the form a user clicks a command button-this searches for records based on the current record displayed. If there are no matches...

Hi Everyone, I am hoping someone can help!... I have 6 tables that I join together using a SQL Union query (there is no id that links the 6 tables to each other, but they link to other tables) Each table is from a supplier and contains the fields 'Supplier Name' 'product ID' 'Net Price'...

Hi Everyone, I am having trouble importing a large CSV file into Access. It just doesn't seem to be able to read the file-the preview panel on the import wizard just shows question marks. If I then go on to import the file, access just seems to lock up and freeze. It works fine on a...

Hi Everyone, I know this is an access forum, however I was wondering if anybody knows how to create cascading or linked combo boxes in excel? I.e. Where you make a selection from one combo box, then you choices on a second combo box are restricted based on the first combo box. Many thanks, Sasha

Hi Everyone, I have a question about database design. I have been a 'user' of access for a couple of years-designing queries, reports, forms etc. However, this has usually been on existing databases, never had to design a large or complicated database from scratch-until now! The basis for the...

Hi everyone, I'm having trouble running a report from a form... I have a command button which the user can press to view the report. In the on click event I have the following.... DoCmd.OpenReport "rptPipsCascade", acViewPreview, , "FFS Code =" & Me.FFS_COde When I press the button is says...

Hi there, I am hoping for some help on how to update records through forms.... I have a data base with a search form which works fine in displaying the records, however I now need the user to be able to update some fields but I am having lots of difficulty in doing this (recordset not...

Hi Everyone in this lovely forum!...... I've been given a task to design a pricing/products database and I am looking for some assistance... The purpose of the database is basically to let the user view the best prices of thousands of products from different suppliers. The basic structure at...

Hi Everyone, I've been searching the forums but can't find exactly what I'm looking for..... Basically I have a report, based on a query, formatted with a page for each area manager. There are now 45-50 area managers and it's becoming a hassle for them to search through the report and just...