Search results for query: *

hi everyone - I'm working on a technical report that will be using all 10 multi group levels. I'm on the 9th level and for some reason I cannot find the field I need from the drop down list box (see picture attached). I checked the underlying query and the field is definitely part of the SQL...

I can't seem to get my head wrapped around this one ... example: assuming table has 25 names with their ages I simply want a count for each age group between 1-10 as 10 between 11-20 as 20 between 21-30 as 30 So essentially the result with return Three columns with a count for each group. 10...

Can anyone direct me with this one. I have an excel file with a list of averages for every month. Whse Location Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec etc ... (sorry cant seem to get the number to line up with the months) warehouse 1 10 10 15 12 15 11 14 warehouse 2 9 7 5 6 4 8 9...

I have the following code that works fine if I have only one email address but want to sometimes include more than one address. The addresses are stored in a table and retrieved through a form when a customer is selected. Text91 and Text87 (are both on the form). .To = StrEmail Do While...

I am trying to take data from a subform to include it in an email. It works fine when only referring as such [subform]![field] but then it only shows the first line of the subform records. Does anyone know how to include all records from the subform? This is what I have to date: Dim...

I have searched several forums (and read and re-read all the books I have) for an example on how to select a printer during runtime. There are several examples in this forum alone but none do what I think would be the obvious thing. I have two reports that need to be printed on seperate...

What would cause a one page report to repeat? I have a one page report that now shows 1201 pages. My report is based information taken from a main form which then calls another form to obtain the rest of the information. This second forms is where I have the print button function. My guess is...

I have a report which has several subforms. One particular subform has the HASDATA code so that it only shows up when data exists. This part works great and as it should. My problem is that I have about 10 objects ranging from lines to labels to text boxes (all on that same report) that I want...

I'm having trouble running this query. Someone suggested that I break down the query into two parts but I have no idea how to do this. I'm hoping anyone can help shed some light. SELECT DISTINCTROW tblRatesHeader.Quote, tblRatesHeader.Origin, tblRatesHeader.Destination, tblRatesHeader.Mode...

I've been asked to look into the possibility of saving an attachment from an email and then copy it to it's appropriate record. This is the scenario. The email is sent from the same address and always has the same title content and contains one or more document images. Every email sent from...

Any one know of any threads that explains how to establish current year (assuming from computer settings ???) and then establish the year prior, then continue on with the rest on my query to finally arrive at comparing this year from last year? Much appreciated. (I already tried searching...

OK, now I'm worried. This message doesn't say much except to contact Microsoft and that it may be serious then again it may not be as serious as it looks. I tried to repair it but that didn't help. I've been working with Access for at least three years now and never had something like this...

I have this code that prevents the user to duplicate entries at runtime. The problem is that I had to disable the REQUIRED property in the table. Now users can bypass this field without keying any data. Any suggestions on how to programically trigger the REQUIRED property would be appreciated...

I created an application and now wonder how to manage the distribution of newer forms. The table and data do not change, only the forms and queries. Is this manageable through the Access Dev Tool Kit (Access 97)while creating the installation files or is it done some other way. I checked...

I'm working on a shipping program at work that generates and prints a generic bill of lading and shipping labels. Shipping dept is asking to have the option of overriding the quantity of labels required to be printed. That;s not a problem. My problem is once I know how many labels to print, how...

I have an application designed as stand alone. I would like to have the ability to upload the data entered in that app and store it on a designated server. The appplication also has several specially designed queries from which I would like to also have the ability to use (as opposed to...

HELP ! I tried installing an application onto a server and a message came up explaining that the version of the DAO350.DLL file trying to install is newer than that of the one on the server. Also note that the message did not allow me to override the older version with this newer one. Customer...

I've written some code which basically takes information from one table and then compares it against two other tables and then CREATES a new table from the result. I used the INNER JOIN .... ON .... Then to compare I used INSERT ...... The codes works fine until I add the WHERE ..... Now...

Hello everyone, my first time here and so far very impressed with the contents of this board. I've run into a problem and hope someone can tell me where I got sidetracked. Facts: on a form I have four comboxes and two text boxes from which the user will select/input and then run the report...