Search results for query: *

Does anyone know code that will work to print out a series of non-access files, regardless of what type they are? I have a table structure where people can "attach" various documents to their record. Really the table just stores the directory of the file they've attached. I would like to run...

Very strange problem... I noticed that one of my listboxes is missing some records, and so I checked its underlying query (which is assigned through the listbox.rowsource VB property) to find the problem. The strange thing is that the missing records ARE present in the underlying query results...

I am having some report formatting trouble. My fields are as such: HouseID Option Name Option Type 34 Sunroom Structural 34 Loft Structural 34 Side Entry Garage 34 Service Door Garage 34 Dining Bay Bay...

I have a line graph that charts Gross Profit $ earned each month. In some months, there was no GP reported, so technically the value would be "$0". But since nothing was entered for the $0 months, the value is just skipped over in the chart. My data is like the following example: DATE...

I am trying to dynamically refer to a variable name. I have multiple search variables: condCity condState condZIP condCustNum, etc.... Each one is an sql WHERE statement used in a rowsource assignment for a listbox. Example: rowsource = condCity & CondState & condZIP ... All variables...

I'm trying to append the data from multiple Excel spreadsheets into an access table. The Excel files are version 5, and new ones are constantly being downloaded from a remote site - so there is nothing I can do to change each one's format on the creation end. The code I'm using is as follows...

Hi everyone, I'd be grateful for any assistance... I have 9 listboxes ("list1", "list2", "list3", etc..) that are lined up on a form. When a user clicks on one of them, I need all the other listboxes to have the same index value be selected as well. This works well with a for...next loop, and...

I have a table with about 1500 records. Table is made up of repeating chunks of 112 records. Each group of 112 records is a pattern that establishes a class scheduling system. It is made of 14 weeks * 8 class types = 112 records. tblClassSchedule ID WeekNum ClassID LocationID...

I am trying to analyze ZIP codes. I need to set the following criteria: If the first # = 1 or 4 or Null Then set the value to the first three numbers of the ZIP code. If the first number is any other value than these 3 listed, then set the value to 999. Here is what I'm trying and it is...

I am seeking conceptual here on how to get started with a "3D Matrix" in Access. We run a training center which holds multiple classes in multiple cities at multiple times. So I need to create a matrix with 3 "axis". The 3 axes are: City Location Week of Class (in 14 week increments that...

I am trying to merge 3 tables - each has different types of info on the same companies. Unfortunately, there is no universal customer # that I can merge these on, so I need to do it based on company name. The problem is that the company names have slight differences. One table might say...

Not sure if I'm missing some big concept here... I have a pretty big query that is used as a rowsource for a listbox. I want to filter this listbox/query in lots of different ways based on different buttons I press from around the screen. I know that I can copy the sql from this query into a...

Hi everyone, I need help. I have two unbound list boxes "Houses" and "Lots" on form "Main" The value in Houses is supposed to filter the records shown in Lots The way I have always done this with no problem is by setting criteria in SQL in the rowsource for...

I have two unbound list boxes "Houses" and "Lots" on form "Main" The value in Houses is supposed to filter the records shown in Lots The way I have always done this with no problem is by setting criteria in SQL in the rowsource for Lots. This criteria would be...

I need to filter records based on whether they have "yes" values for various fields - but NOT on whether they have "no" values for other fields. Table: "Lots" [A] [B] [C] [D] [E] yes no yes no no no yes no no yes no no...

Please help... Big picture: I have an inventory - I want a 3-part prefiexed identifier string to illustrate what category heierarchy each product is. For example a fairy tale book would be "BKS-CHD-FRY" and a child's board game would be "GAM-BRD-CHD" I want these codes...

Field 1=Beginning Date Field 2=Beginning Balance The dates are progresssive entries which have 3-4 month intervals. Each date has a balance associated with it. I need a query where I can have the following fields: Field 1=Beginning Date Field 2=Beginning Balance Field 3=Ending Date Field...

I have a listbox control in my form that displays product names [ProdSelect]. The names of the products which display at any time are filtered based on a category selection from another list box [CatSelect]. Example, when you click on soap, only soaps show. When you click on shampoo, only...

I have 2 tables: "Jobs" table contains all the job numbers. "Options" table contains all possible options that are available with various jobs. I need to do two things. 1. Match up every option with every job. I had luck with this step by creating a select Query with...

I have a form with a subform. When I change data on the form, I need the subform to update. The problem is that the subform is based on a query, which based on another query, which is based on another query, which is then based on the data I have just changed in the main form. I have tried...