Search results

sorry mate, i cant help any further as i dont know what else to suggest. i have a search form that has as many possible criterias as your form appears to have and i build the sqlstring similiar to you. My sql feeds a subform as yours does and all i do is open a report and use the on open event...

just an after thought have you set the reports record source by using the on open event or did you set its record source in the propertys the only way i can generate the error that it doesnt exist is if i set the record source in the propertys,if i leave the record source blank in the...

well i am stumped as that is how i have my reports set up,perhaps someone else here can help you

i have to assume a bit here as you dont give me a lot of information to work from. i assume your form is bound to a table to answer your questions 1.use the after update event for the textbox Mydate on your form,and insert this code me.[Date14]=dateadd("d",14,Mydate) that way you can edit...

after the docmd.openform action set the focus to the control you want forms![formname]![controlname].setfocus

you should not use Date as a field name as its a reserved word in access assuming you are using a form for data entry and the txtbox control names are Mydate and Date14 in the date14 txtbox set its control source to =dateadd("d",14,Mydate)

use the on print event for the report section dim MyQty as long Dim IdNo as long MyQty=me.[the name of the qty control] IdNo=[the name of the id control] docmd.runsql("UPDATE Stock SET Stock.Qty = [qty]-MyQty WHERE (((Stock.Id)=" & IdNo)); however every time the report is run the stock will...

use the spin buttons spinup and spindown event assuming you want to add 1 day Private Sub MySpinButton_SpinUp() if isnull(me.yourdatefield) then me.yourdatefield=date else me.yourdatefield=dateadd("d",1,me.yourdatefield) end if End Sub Private Sub MySpinButton_SpinDown() if...

what about using a picture control on your form instead of using a hyperlink use the on click event for the button Me.NameOfyourPictureControl.Picture = full path name of the picture eg me.Mypicturecontrol.picture=C:\My Documents\bitmap doors\Stock Door0022.bmp or if you have a lot of pictures...

access has many ways to accomplish the same thing,glad you got it to work

if you already have created the recordset in your search form then if you declare strsql as a public string variable placed in a code module(not a form module) and use me.report.recordsource=strsql on the open event of the report should do the trick,you would not create the recordset in any of...

set the tab index for the first text box to 0

I misunderstood your question i thought you were opening the report from a form that was using strsql as its record source. so where does strsql get executed.

Me.Report.RecordSource = sqlstring assuming sqlstring is a public string Variable

without knowing what values your tables hold and relationships etc its a bit hard to help here is a simple sql that would return the top 3 values of a table i am assuming you have some sort of employee id and station id etc.The sql would negate the need to store calculated values, it may help...

is txtcln_plate_id a form control name if so try Set rst = db.OpenRecordset("SELECT Max(Clnid)AS MaxOfClnid FROM Clones WHERE Clnplateid = " & txtCln_plate_id & ";")

have you tried decompiling your 97 version to see if you can "fix" the corruption

why not add a archive field (yes/no) to your table,then instead of sending the data to a new table,just update the yes/no field

make sure the data types are the same maybe some numbers are stored as text or vice versa

if you are trying to hide the button while it still has the focus you will get an error set the focus to another control before you attempt to hide the button