Search results

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

The reason for the unbound form its to not use a table/query and to not ocupy the table. RowSource? hum... Probably i can use that. I'll give it a try. Thanks Chris

1st Q: I only have two fields now. When this works i'll put more fields. Recordcount = 14. 2nd question: Form is set to continuous. Thanks anyway.

My recordset have 14 records. The criteria WHERE is just to filter few records. I want to populate my unbound form with the 14 records.

Chris I want the 10 records in the form. I only have 1, and its the last one. Nevertheless good observation because DAO needs the position.

Hi - one unbound continuous form (form1) - one recordset (via DAO) - 2 fields: NAP and DateNAP () Onload i only get one record (the last one) from the recordset (=10). How can i pull all the records into the form. code-- Private Sub Form_Load() Dim rst As DAO.Recordset Dim strSQL As String Dim...