Search results

ok so my problem is much bigger then I tought. So I have a form that is based on a query from 3 tables. But when I try to update the form I'm getting Recordset not updatable, and I can't figure out how to solve it.

I'm trying to open or unlock a recordset do do a simple calclation and then relock the record set. Does anyone know if / how this can be done with vba?

so then I need to use a seperate query for each form.

I have a query that runs to check if a form has any empty delay hrs. SELECT [Tble-wcDelays].ID1, [Tble-wcDelays].LinkingID, [Tble-wcDelays].HoursDelay, [Tble-wcDelays].ReasonDelay FROM [Tble-wcDelays] GROUP BY [Tble-wcDelays].ID1, [Tble-wcDelays].LinkingID, [Tble-wcDelays].HoursDelay...

thank you very much Mr. B worked like a charm jon

Me.step = Left(Me.step, InStrRev(Me.step, ",") - 1) This code works fine as long as it can find the "," but if there is no , entered it errors or. Is there a way I can look for the comma before this code runs? jon

Can someone please tell me how to stop this error from occuring. "Potential Security Concern" I get this everytime a query runs that is creating a file for exporting. The database is in a trusted location, the query is a make table query if that makes a difference. jon

very strange, I got the old code working using the old code. I'm guessing windows7 must account for the difference. jon

I used to have a code that we used to copy data from a folder that was on the desktop using the code below. DoCmd.CopyObject "C:\Documents and Settings\All Users\Desktop\Wetcleans\ This does not work with windows7. I have tried the C:\USERS\PUBLIC\DESSKTOP\Wetcleans but that does not seem to...

that is / was it

If ([Forms!Frm-RPC]![dat108] - [Forms!Frm-RPC]![dat101] > 0.1) Or ([Forms!Frm-RPC]![dat108] - [Forms!Frm-RPlC]![dat101] < -0.1) Then Yes the form Frm-RPC is open

same error occurs with the Forms! added

OMG I am an idiot thank you

If ([Frm-RPC]![dat107] isn't that what I have here? FRM-RPC is the mainform and dat107 would be the control ? what am I missing here

ok but its not a subform its a popup form. do you determine mainform vs sub

here is the code If ([Frm-RPC]![dat107] - [Frm-RPC]![dat100] > 0.1) Or ([Frm-RPC]![dat107] - [Frm-RPC]![dat100] < -0.1) Then The form is open but the form does not focus and when this runs I get an error that it cant find the control or its closed? any help

My problem is I want to catch is the case is "1-abc" or "1-aaa" to add if Step42 is "allok" or "1-aaa" or 1-abc" but not if is say "aaa" does that make sense?

Maybe I cant use select case for what I'm trying to do. Select Case (Me.Step42) Case "allok" Me.Step43.Locked = True Me.dat18.Locked = True Me.Step42.Enabled = False Me.dat18.Enabled = False...

Would that be a select case within a case? There are other values for that step I want to catch. jon

so I'm trying to use select case on the 1st to digits of a field. I f it equals 1- then the case is meet but its not working. Will this work or no? [CODE Case (Left(Me.Step42, 2) = "1-")][/CODE]