Recent content by pacg

RG Did you undestand? 1st. I have more than one field. 2nd. I probably have more than one parameter = 1 or 2 or 3 ... so stLinkCriteria = "[YourField] = " & C4a its IMPOSSIBLE! The picture: one form - has 5 textboxes (c1,c2,...c4...) one report with a query source - 5 fields, each one with the...

Hi I have a textbox (C4) has to be a criteria in the report "RELAT_GENERICO". The field in the report is numeric, so he receives 1 or 2 or 3 ... I need to "pass" my string ("19 or 20 or 21") to be the criteria but she passes like string or like a complex string. How to do it? CODE Dim QUOTE...

Hi deck To automate: 1. Create a recordset with data that you need - create the field to put on it (you have a lot ex for this) 2. Open RS and with a FOR or WHILE (not rs.eof) put your formula 3. Done

Hi threeo2 Probably to help you i'll need that function in vb.

Hi I have an app using MS Acess 2000 (with lots of VBA code) linked to a SQL db. Can i - without closing and openning forms and reports - established only one windows in my task bar? Like a real app. Thanks pacg

Try to see the Northwind.mdb of MS Access. It has something of a kind.

Try in the activate form: If [field name].value = "anything" then Yourfield = "what you want" else ... endif

Hi Ice Try this! Dim strParentDocName As String On Error Resume Next strParentDocName = Me.Parent.Name If Err <> 0 Then GoTo Form_Current_Exit Else On Error GoTo Form_Current_Err Me.Parent![FORM NAME].Requery

What is the error?

Thanks boss I not fun with this solution (i already knew this solution) but it works. Thanks

Ghudson It has to be a form contin. How can i control just one record? Currentrecord? Selectoreg.?

Hi I've read some threads about this but all finish in some textbox field with color. Some with conditional formating - but i want to use the record select (arrow). Can we use some event - like onclick - to do this? Thanks pacg

Chris: Thanks for the time spent! Wayne: Good thoughts !! Not my career but the experience tell me that (when happens) this is the best solution. You must think the three actions separadely: insert, editions and removes. Thank you both pacg

Hi Try in SSQL = to the value ID (= 2) I beleive it needs ' '

I'll explain. Not very with english so ... I need to "snapshot" the data from the table into the form. Why? Snapping only establish the connection in that second. Why? I'll beleive this app will be used by several (>=15) users. So, many will be doing updates, inserts, querying... I dont want...