Search results

Hi all, I am a very basic VBA user who has filled out some code for a continuous form multiple filter. The code is working quite happily. However, and this is more for my education, I'm sure the coding could be smaller and more efficient, but I don't know how! So I was wondering if anyone...

Hi all, I have attached a simplified version of the issue I am having at the moment. I have tbl_orders which records orders. I have a linked table called tbl_order_lines which details the items against each order. In a nutshell, an item can only appear once in an order. However, I do not know...

Dear all, I have searched in depth through the forums for an answer to this but all running sum posts do not quite answer my problem. I have a table ("tbl_idq_all") with a text field for product codes ("scode"), a date field (dd/mm/yyyy) and a quantity field ("po_qty"). This table therefore...

Hi all, I have absolutely no idea how to solve this issue. I've attached a stripped down version of a small order database I'm working on. A user would enter an order, the amount and the date the order is required by. As you can see from tbl_seasons, the business has financial periods that...

Dear all, I have a table of data (tbl_marginsummary) with a record for every combination of Customer, Season, Brand, Month and StockCode. What I am trying to achieve with my frm_summary is some kind of DSum (or a query of possible) based on any, all or some of the comboboxes I have at the top...

Dear all, I have attached a simplified database highlighting my issue - AnnualSpread.mdb. I have users who create a project and enter one amount for the cost of that project for the whole year. For financial purposes I have to automatically spread that one amount equally across 52 weeks. In...

Hi all, I've posted this here as I think the Form design will be the trickiest part of what I am trying to achieve. I have tried amending some examples that are close to what I want but I haven't been able to quite get there as my VBA is not advanced. The closest I have found to what I want is...

Hi all, I've attached the database I'm currently working on. What I need to create is a user friendly form to input f_quantity values. The main form needs to have a parameter where a customer ID would be selected. I then need what I think would be a datasheet subform which would display all...

Hi all, I have attached the database that I have been working on. My ultimate goal is to have a record in tbl_customer_product_month for each combination of customer, product and month. I will want to add values in each instance of cpm_value. I have tried to show the relationships in the...

Hi all, I'm currently working out how best to structure a database I want to build and I'd like some advice from the experts! My database will be built on 2 core objects: Table - tblCustomers Query - qryItems tblCustomers will be manually updated and changed within the database qryItems is a...

Dear All, I have a very basic database design, which I have attached. There are 2 specific objects I want to create within the database, and was wondering what sort of structure you might suggest, and any links you may have about creating the form and report that I need. 1. I want my form...

Hi All, I've been trying every way I can think of to construct a database that holds forecast sales data for my company. However, I have reached a bit of a brick wall. I decided to go back to the 2 fundamental tables that will be used. tblCustomers holds my customer specific data, including a...

Dear All, I am trying to update 1 table ("tblForecastFeed" from 2 'feeder' tables ("tblCustomerList" and "CLP Forecast Feed") but I think I'm doing something very wrong. This is the code I currently have: UPDATE (tblCustomerList INNER JOIN tblForecastData ON tblCustomerList.Customer =...

Hi, I'm working myself into a right lather trying to work this one out. I have a table with Item Data - tblCLPForecastFeed. I also have Customers who forecast against various Items on the tblCLPForecastFeed. The customer table is called tblCustomerList This is probably far more simple...

Hi all, I have an "Order Book" query which I run off a Linux database every week. I need to track the orders (and changes) week by week. Customers can be added every week and order quantities can either grow or reduce. My question is - does anyone know how I can run a query that automatically...

Hi all, I have a very simple database which I have attached. I've created a form based on one table. I want one of the fields to automatically look up the value from the other table and update the original table with an AfterUpdate event. This is the code: Option Compare Database Option...

Hi all, I have a very simple product database that I am designing, and am at the planning stage. This is probably a very basic question but I have never built a database from scratch before. In one Table ("Main Table"), I have the fields: "Item Number", "Description", "Shipment Terms" and...

Hi all, I have an import procedure which pulls all spreadsheets with a certain tab name from multiple files within a specified folder into one 'master' table in Access. Whenever one of the 'source' files is open, the VBA code cannot run. My questions is, does anyone know of any code I might be...

Hi all, Just a quick one - does anyone know how to maintain the existing order of rows when running a Make Table query? It's a very simple one - here's the code SELECT [CLP Forecast Feed].[Item Code], [CLP Forecast Feed].[Description ], [CLP Forecast Feed].Brand, [CLP Forecast...

Hi all, I've scoured the internet for answers to this as I thought it would be quite simple to sort out. I have the following VBA code: Private Sub RunSalesandOrdersbutton_Click() DoCmd.SetWarnings False DoCmd.OpenQuery "Step 1", acViewNormal, acEdit DoCmd.Close acQuery, "Step...