Search results

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

tblctjor is the table name SQLACCESS is the owner of the table.

I am trying to run the following code but I keep getting the error 'Invalid column name' SQL1 = " Update SQLACCESS.tblctjor " & _ " Set systemtime = Now " & _ " WHERE systemloggoff = 1 AND start is not null " DoCmd.RunSQL (SQL1) I have also tried Now()

that's it I changed it to go to end of field for some reason earlier in the development (can't remember why now). I'll change it back to start of field and I'm sure I'll find out why I changed it in the first place. Can this be overridden per control ?

It's the same for all my combos?

When you enter a combo box for typing by either clicking or tab the cursor is placed one spacein and when you start typing the autoexpand does not work as the cursor is not on the first letter. I have tried setting the selstart to 0 on enter and on click butthis doesn't make any difference. How...