Recent content by livvie

I am trying to run an application written in MS Access 2003 with Access 2007 but it keeps throwing up errors such as invalid ref to form/object and the DataEntry property causes a lot of problems when set to true in code. Any ideas.

To make this worse this doesn't seem to be confined to one set of tables - it is also occuring on another query. The queries run fine in the Query Grid but it's when I try to open the form that uses the query I get the error.

It used to be called lineno and that forced me to use [] it didn't work that way so I changed it to line - I have used lineno elsewhere in my db and it is fine.

Yes sure - it's fine if I remove a table or remove the order by

IS that not what I did?

If I use order by on a query that has two linked tables I keep getting an error: This is the query SELECT d.PDetailsID, d.po_id, d.po_uniqid, d.job_id, d.p_qnty, d.p_desc, d.p_unitp, d.p_units, d.p_extend, d.p_qos, d.p_grec, d.p_done...

but this code is on the subform ? so therefore I get a method or data member not found error.

it stops the entire form being refreshed but it doesn't update the subtotal (recalc did)

I am refreshing the form but I would like to just refresh the field (I cannot get the syntax for this) I am using Access 2003 .adp The form is called fsubestdets and the control is txtsubtotal Private Sub txtmatcost_AfterUpdate() Dim mymatid As Variant Dim MyExtCost As Variant If...

I am using recalc to recalculate a total field in a form footer it is fine when I am editing a record but when I am adding a new one it refreshes the entire form - why ?

I am using Access .adp and you cannot reference a form from the query grid in .adp (or so I have been told and I can't get it to work)

Wayne In the form load of the form I have the code from post 1: What I am trying to do is as follows I have an input form where the users enters a start date (txtstart) and and end date (txtend) and the new form is loaded with the records whose [datefiled] falls between these dates. This is the...

Wayne With this piece of code what field am I checking against. I need to check that the datefiled date is between the start and end dates entered. When I justuse this line without my datefiled field I get an error near Between. If I inlcude [datefiled] then i get the sql error.

start date and end date aren't fields they are text boxes that the user puts a date into the date I am checking is datefiled?

I am trying to open up a form using the following linkcriteria Dim stDocName As String Dim stLinkCriteria As String stDocName = "frmNewDrawings" stLinkCriteria = "[datefiled] " & "Between " & Me.txtstart & " And " & Me.txtend DoCmd.OpenForm stDocName, acNormal, ...