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.

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

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

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()

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

I am trying to requery a subform in the oncurrent event of another form. I am using the syntax provided by Mile-O-Phile on this site as follows Me.Parent![fsubDrawRev].Requery Forms!frmDrawings!fsubDrawRev.Form!fsubDrawRevsubform.Requery The first requery works fine but the second one says I...

Does anyone know how to stop a requery causing the app to flicker.??

I am using the following command to delete records. DoCmd.RunCommand acCmdDeleteRecord which is fine if the user presses OK but if the user presses No it just crashes. How do I code this with my own error messages. Below is what I have so far but that deletes whether you press or no as the...

Unlike everyone else I want to enable right click but ticking the allow Default Shortcuts Menu won't work for me as I am using Access .adp which runs on machines that don't have Access installed (therefore they cannot have shortcut menus). How do I get around this or do I have to find another...

I have a form (1) that is just a list so it does not need to be updateable so I set recorset type to snapshot. On another tab I have another form (2) and a subform (2a) that shows more details about the record shown on form 1. The master child relationship between Form 1 and 2 is as follows (on...

I have a view based on 4 tables. From this view I need to show only the highest revision of an item. The revision number and details are held in one table while the main data is held in another. This is the code I was using but which doesn't work as I wanted it. I need to only return 1 line per...

Below is code I am using to insert data into a table an dthen update the est_id. It works fine for the last record in the loop but the others in the loop are not being updated by the bottom piece of code. Anybody know what I am missing Do While Not rstmat.EOF Debug.Print rstmat!est_id...

When I tab past the last field on my form when in edit mode a new record is created ?? Why ? How do I stop this?

FoxPro code equivalent in SQL This is a FoxPro command I need to know anything that will do the same thing in SQL. select * from ctmat where ctmat.est_id == ctest.est_id into table c:\temp\ecopy_a.dbf

I am using a .find to locate a record in a recordset if I dont find any record I want to move on to the next piece of code - how do I do that.

I have a text box with a default 0 when the user clicks in the box and types the text us entered before the 0 I need it to be typed over the 0 thus replacing it. I know there is a way to do this using fill from left or right but for the life of me I cannot remember how or where I found it before.

I have a pivot chart with weeks on the Category Axis. If I select weeks 24,25,26 and 27 but there is only data for 24 and 26 (these are then shown on the graph) how do I show that the others have no data in them I need them to be shown on the chart as it is problems that I am reporting and weeks...

I need to create a report with 7 coulmns something like this Cust Invoice A B C D E F Total Sales Cust1 8897 €1 €3 €1 €5 €2 €3 €4 €9 Total €2...

I am having a number of speed issues in my app where I am using recordsets , finding the record that matches a field in a form I have open and then updating the record. I believe I could do this using a query instead of a recordset if I could get the correct syntax for using forms.fields in the...