Search results

just asking where is DOLLARS, in the form or economic recordset. if in form then make it Me!Dollars. if in recordset try Economic!Dollars

check your report in design view. if the width of your report is greater than the width of the paper your expected to print it on then you get this error.

you can copy the SQL of your recordset, then create a new query, goto SQL view and paste the copied SQL. then goto Datasheet view of the query. it will display the output.

you can use tables from access as recordsource of your crystal report via ODBC. check Control Panel >> ODBC >> USER DSN. choose your driver (MS Access), follow the procedure, therafter.

try this statement: "SELECT [line_data_id],[section_id], [chk_status] " & _ "FROM section_detail WHERE section_id ='" & [Forms]![frmJob_section]![section_id] & "';"

you can use query as recordsource like the same with tables. put the query name in the RECORDSOURCE property of the form and assign each control (textbox,...) the ControlSource (fields,...) of your query. if you're doing it in code, say on Form_Open(), you can assign it like this...

really wierd, all this years i have'nt meet that kind of problem since i thought you cannot make total query with memo field or ole object in it so i have'nt tried. [This message has been edited by joeyreyma (edited 07-05-2001).]

see if my correction works: Strsql = "Select * from [Company Benefits] Where " & "[Company] ='" & Me![Company] & "';"

try to set the CanGrow and CanShrink properties of the textbox to YES

there may be other shortcuts but here's a simple one: Public Function ReturnDays() as Date Dim intDays As Integer Dim dtDateLoop As Date intDays = 0 For dtDateLoop = Me ("[Date_work_assigned]") To Me("[Date_Work_Completed]") If WeekDay(dtDateLoop) <> 1 Then...

I use to make graphs in reports and forms that dynamically updates everytime a user inputs a data so i guess this is what you're looking for. here's an example of the property: 'for maximum Me!Graph.Axes(xlvalue).MaximumScale = (yourNumber) 'for minimum Me!Graph.Axes(xlvalue).MinimumScale =...

here's what i usually do: Set rstqry = dbs.OpenRecordset("qryLO ID Count", dbOpenDynaset) If rstqry.RecordCount <> 0 Then rstqry.MoveFirst ... else ... end if ... testing is always important! hope i helped u!

if your expense totals field is physically saved in your table and it is a calculated field then i think your on the wrong track. calculated fields are not suppose to be saved with your details. better have it displayed on the forms only, don't bother saving it.

add ur [Input] to the parameter list of the query in QUERY >> PARAMETER and put the data type as well.

y don't u put your graphics on a report and hav ur records on another report and make it as sub-report of ur graphix report

u can make ur combo box show other columns by setting the COLUMN COUNT to the no. of desired columns. u can also adjust the widths using the COLUMN WIDTHS and the over-all width by LIST WIDTH. using this you can display the name and hide the id from the list of the combo box but then again...

ur references is okay but make sure you put them in the form header/footer and not on the page header/footer of your form.

check ur combo box's LOCKED property, set to false