Search results

Hello, I am looking for some guidance/suggestions on best way to manage a design with Access 2007-2010. I have two db's both in sharepoint if that matters. 1. Customers with orders, linked by customer number A-For customers there are contacts which also are linked by customer number 2. Leads...

I am attempting to create a report based on [Sales Analysis] query which would pull suppliers, customers with values for Sales & Commission. This report would then show additional columns for Sales & Commission, however they would be for last years sales or same month last year. I seem to be...

I need help please, I have fooled with this scenario for months now and seem to have hit a wall. I my db uses forms like northwinds 07 (I believe) in which you select the "grouping" fields such as customer, location, employee etc. I am attempting to be able to pass these parameters through...

I am attemtping to add additional column headings to create a crosstab query. I have worked out the scenario to do this through query design and then based a report on same query. I am now trying to assign variables through a form. I feel as though I have tried every option and still get errors...

I have a search form that has a text box that needs to be bound to [SIC1] but show a lookup value. Anyone know how to do this with out making it a combo box? I tried setting the control source to DLookup, but it appears as though the text box doesnt know what value to bind to the box and gives...

Struggling here. Have a table (Customers) which has lookup fields for codes. This is expanded to a query (customers extended). The query displays the lookup value just fine. I have a form which is split and is used to search for customers based on a number of things including the codes. Unless...

Struggling with omitting entire rows when no orders exist for customers. I have a crosstab that pulls & groups suppliers orders per customer based on months. I then pull that info to a report which provides a comparision of sales in specified year verses prior year and next year when...

Can someone please help review this code. I have been working on this for months now and at a loss. Have a multi list box/combo box form that should open a form on preview command. I have run into multiple issues which I had in other topics. After reviewing help files and chnaging code, form and...

I am struggling with marrying forms to reports based on my selections. It would be very nice if I could be pointed to a reference or helpfull info. I am limited in Access, but feel as though I can grasp conpects once I see them. I have the following Tables Employees Customers Principals...

I am about to loose it...... For weeks on end I have worked on adapting parts of northwind to an old existing database. After spending months trying to import an excel spreadsheet, removing invoice, inventory and other worthless parts; I am now struggling to just enter a freaking order. This...

Thank you for any help in advance. I have adapted parts of Northwinds along with an old DB. I believe I have included Class Objects, Modules, and class modules in order to do so. My issue is: I have designed a Sales Report Dialog form much like Northwinds and adapted code for varrious...