Search results

Here is what bothers me today. In one form, I have three unbound boxes (named Outmod1 to Outmod3) whom control sources are based on random functions (to simulate small changes for the user). The user toy with those value, lock one or more, before going on further. That is what is intended at...

Sorry for something which should be very basic, but I'm stumped by the following problem : I want to loop through a form and extract one field at time per record found. So I wrote : Dim rst as recordset Dim Xnb, Cpt, Exitidx as long set rst = me.recordsetclone Xnb = rst.recordsetcount if...

Hello here is the code that bothers me : dim strSQL as string LReftst = tst_idx (InRef) ' this is a global public function which returns a long if LReftst <> 0 then strSQL = " SELECT tbl_ctc_evt.[Idx Ctc], tbl_ctc_evt.[Idx evt] FROM tbl_ctc_evt WHERE tbl_ctc_evt.[Idx Ctc] = '" & LReftst &...

Hello, Here is what trouble me : In a standard module, I need to test an long field. Public function test_Idx (Inref as Long) as Long Dim stDocname as string Dim T_idx as long stDocname = "Edit_Form" DoCmd.Openform stDocname,,,"[Ref_ctc]=" & Inref So the form opens only where I want it to be...

Sorry for the question's wording. Here is what bugs me: - I have one table tblRefctc with the followings fields : LCtcRef,../..,LRefServ0, LrefServ1,..LrefServ16. Where all those Lref are long; LCtcRef being the primary key. This table describe a contact from different branches (account...

This is my first try with public variables and there are some problems, I'd like your help with. Idea : I'd like to set a public boolean variable which can be read in various forms. My idea is to tie the visible aspect of various buttons to this value. After reading the forum here, I came to...

Hello, In one of my forms, I use a boolean value (check-box) which I'd like to set as false as the form open. To do this I made a query and use it as opening statement in the form : " Private Sub Form_open () Dim stDocName as string stDocName ="Reset_Action" DoCmd.Openquery...

It should be exceedingly simple, but I got mashed potatoes between the ears today. I make a query looking up for Name+Firstname+Ref number which I display in a tabular form . Now, I want to use check boxes to select the ones I wants to print. But the thing is, if I add a check box in the main...

I am baffled by the following behaviour. I use a table, with fields like Name, Firstname, Service (like accounting etc..) I have a form with various fields in amongst which these above. Here is my source of discontent : I make a query where the Service is hard written and look for...

To validate a main form, I run a subform based on a duplicate query. I use a macro to do this, and have an invisible independant field on the main form into which the duplicate count is put. This works fine. What does create a problem is : - When there is no duplicate, the subform is void...

Hello, I have a form where a user select a service (S_name) and type a required password in a textbox before carrying on. I must match the data in the textbox to a field (S_sec) which match (S_name) above. After which I send back a valid/unvalid msgbox. My problem is how to link the data...

Hi, I have to import an excel file which contains fields I know will have to be reformatted/modified, e.g phone field which contains national code which has to be deleted. I figured out how to modify the relevant fields, but for the life of me cannot find how to make it so imported data is...