Search results

  1. D

    Totalling fotter amount in report footer

    Hello there.....I have a report that I am trying to alter. There is a detail section and two footer sections. I would like to insert into the report footer a "total" textbox where the sum of a value in one of the footer sections is shown. The name of the field in the footer is "Region_Total". I...
  2. D

    constant size

    I have built a db that acts as a reporting tool. I have many forms that criteria is entered and various forms are created. I have disabled my min/max/close buttons. My problem is that I do not want the forms to be allowed to be min/maxed. When I generate a report the user will certainly...
  3. D

    dumb moment

    I cannot remember how to denote the current directory. It is for the following example: Set MyXL = GetObject(".\SL_Template.xlt") It will be bundled up with the dB so i would like it to work regardless of where the user places the folder.
  4. D

    inserting a CR in a textbox

    One of the values returned in my report can sometime be quite lengty with numerous sentences. is it possible to format the box to insert a carriage return after every period and have the box size accordingly???? you'd be a lifesaver.
  5. D

    updating and appending recordsets

    The big picture: I have imported a range of cells from an excel doc into a acces table. I have added and extra field to this table titled "ERROR". I run various SQL queries on the data comparing it to the data in my database and will eventually create a report of the discrepencies. As a result...
  6. D

    null in queries

    I have a form where a user enters criteria that determines a query that is executed and sent to a report. My situation arises in one field of the table where in some cases a null value. My form allows the user to set a range for this field but i would also like the query to return the null...
  7. D

    accessing chart properties within the code

    i have a report with an embedded chart i created through the wizard. the report is passed a query to use as it's recordsource as they serve at least 4 queries per report. i need to pass this same query to the chart but cannot seem to get at the chart rowsource property. Assuming because it's...
  8. D

    A decent chart reference

    hi there...i have a access 97 dB that creates multiple reports. Each of these reports is created from a 0ne of four queries depending on the criteria. I would now like to embedd a chart into the report summarizing the data. However, the graph rowsource property does not seem to be accessable...
  9. D

    setting recordsource

    Hi...me again i have one report that is passed along a one of 4 almost identical queries. Therefore, as per wahtever conditions i need to set the recodsource to whichever query applies. I have written the below using 2 different tech's for setting it but it does not like. An error comes up...
  10. D

    keep getting $NAME?

    I have a form in which the user enters a bunch of criteria which is passed along to a query and that to a report. In the header of the report i have various textboxes stating the criteria values. I did this by setting the control sources. eg. =[Forms]![frmReport_Char]![cbox_status] but all i...
  11. D

    link child/master fields

    I posted a question earlier because I was only getting ALL of records with the first occurance of BV in the criteria. I am now thinking the SQL is not the problem at all. This is the snippet where I update a subform and my problem lies in the lines: Me.sfrmForm.LinkChildFields =...
  12. D

    baffled I am?????

    I have this query QRY = "SELECT * FROM tblMain_BV WHERE ([BV] BETWEEN cint(" & tbox_BV_min & ") AND cint(" & tbox_BV_max & ")) ORDER BY [BV];" the problem is that I assign it to the record source of a subform but it lists only all the occurances of the next occuring value from the low end...
  13. D

    Driving me cookoo!!!

    I have actaully asked this before but go no reply so i'll try my luck again. I need to retrieve a recordset from a table. The records i need to retrieve are related to another rs i've gathered which holds a list of keys. So me question is how do i write a query in SQL that takes 2 tables and...
  14. D

    Treating dataview like a table

    Hi all......I have a form with various combo boxes used for criteria. In the form is a subform which holds a table in datasheet view and updates as i choose from the combo box criteria's. There is a textbox on my form which i would like to fill with the average of on of the columns in the...
  15. D

    newbie question

    You'll all have to forgive my ignorance on this one, I am very new to this game. I have been developing a db but have written all my queries by hand as the query builder is making no sense to me. These queries are getting very long and difficult to debug so I am cracking and asking for help...
  16. D

    Breaking down SQL's

    I have to write this ludicrussly long SQL statement so was thinking about doing it in steps for easier debugging. IE. Get a record set as per some criteria then with new criteria search that recordset not the whole table. i have never seen this before so is it even apossibility and if so what...
  17. D

    comboboxes- more than bound column

    Good Morning all.....I have had an ongoing dilema which i have been ignoring thus far. In a como box with say 3 columns. After you pick from the list how do i get all 3 to remain in the box as opposed to just the bound column???? Thanks in advance
  18. D

    numbers in queries

    Hello all.....i have a form which is used to make an entry in a table with many fields. I do not want the fields to be mandatory. All the text fields are np as i set the allowzerolength property. Numbers however dont have this property and will crash the query when not entered. Anybody know...
  19. D

    cascading combo boxes

    This is a variation of code borrowed from www.candace_tripp.com and results in cascading combo boxes and an updating subform.it works great except the first time through the line : Me.sfrmForm.LinkMasterFields = "VEGETATION_CODE" results in an input box asking for a parameter value for...
  20. D

    Number fields?

    i asked this question earlier about doing a SQL Insert but not working when fields left empty. I was refered to change all the "Required" and "allowzerolength". Thanks, it worked great with a table holding all text. However i have another table with all numbers. These dont have the...
Back
Top Bottom