Search results

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

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

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.

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.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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