Search results for query: *

Hi dhookom I think you're on to something. I made this field a LONG TEXT. Thanks for pointing that out. Cheers!

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...

Nice ! This kind of quick response is no doubt a classic "been there done that" kind of thing. Thnks very much for the help Skip Ray

Thanks for the tip Skip (sorry couldn't hesitate). I'll look into that right away. As for the question about "when Aug is empty", yes I did mean the DATA corresponding to Aug. Thanks again Ray

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...

John, Each form must make reference to the help file in question. For example in the OTHER tab of the form properties type the help file project name in the HELP FILE property field (yourHelpFileName.chm) Then in the field that you want the user to hit the F1 button to trigger the help file...

sorry website is www.helpmatic.net

I've been using HELPAMATIC.com and works just fine. Very user friendly. You can download a demo from their site. Cost to buy is very reasonable. I;ve even been able to incorporate several tutorial video clips within my help file. Much easier to use than the traditional help files from MS. HTH Ray

Thanks Andreas, But when I do as suggested, I get an error telling me "Item not found in this collection" I think this is because it's trying to refer from the current form but the actual records should be from a subform location within the main form. Subform is called...

I have similar reports. I simply create a subreport within the main report and render the visible property to NO. Then make reference to that subreport when doing your calcs.

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...

no but that's one I never thought of. Will give that a shot and let you know. Thanks.

I don't think that's possible. The design app is compiled and installed as an MDE with a back end. The runtime is also included. I don;t have the thermal printer setup on my machine. (please note that this app is not installed on my company network as most cases are in this forum). I designed an...

Thanks cajuncenturion, Had a look at your code and I don;t think it's what I'm looking for. I don't want to change the default printer as the first report DOES require it to print on default. The second report must print to the alternative printer. The code I indicated does allow me to do...

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'm back ! I managed to get this working by changing the recordset code to this: Set rs = Me.qryShipmentDimssubform.Form.RecordsetClone (for Access 97) But now I have the same problem with Access2k !!!!!!! It worked fine before I made a converted copy. What I found though is this ... If I...

"Unexpected Error Occured. 2465 Application defined or Object-defined error."