Search results

I want to insert a picture that is visible only when a certain textbox is not empty. I tried using vb, but somehow, i can't use the property visible of the image, or the property text of the textbox. I don't know what's wrong... anyone can figure this out?:(

I have one table containing locations, and one table containing activities. Each activity has a location (as part of a composed primary key) and might have a subscription location. The activity table contains only the ids of locations, and i'm using a query to get both names. I don't know how...

It looks like shuting down access and reopen my database fixed the problem. Thx anyway!

I tried this... but it doesn't work. I get an error instead!

I have a report with 2 fields (coming from a query). One field is a name, and the other is an id number. I want something like this : name (idnumber) Is there a simple way (meaning, no coding or no invisible fields) to do this? I looked at the string functions, but i don't know which one i...

Yay! it works! Thx a lot :rolleyes:

I need a way to create new records in a table using code. Anyone can tell me how? Is using ms jet with recordsets the only way? (i don't have it:( )

The module name is : ClasseCreation The error message is : "Undefined Sub or Function" Error occurs while running the button code. Edit: i found out what was wrong...I apparently use the wrong module type (have no idea how that happened). :o It working now. Thanx for the help anyway

Me too:eek: Public Sub ActAPrec(ByVal noBloc As String, ByVal noAct As String, ByVal defAct As String, ByVal lstAct As String, ByVal existante As Boolean) Let BLOC = noBloc If existante = True Then Let ACT.No = lstAct Let ACT.Description = "empty" Else Let...

This is my public function prototype : Public Sub ActAPrec(ByVal noBloc As String, ByVal noAct As String, ByVal defAct As String, ByVal lstAct As String, ByVal existante As Boolean) :( Also, when i call the public sub from the button sub, the caps are changed properly... When i tried to run...

There is my function: Private Sub SuivantActAPrec_Click() Call ActAPrec("hey1", "haha2", "hehe3", "hoho4", False) DoCmd.OpenForm "FrmPrecAct" If CadreActivite.Value = 2 Then Form_FrmPrecAct.ModPrecAct.Visible = False Form_FrmPrecAct.Option3.Visible = False...

Hmm, i tried that before posting... My sub is not recognized... (and i checked for spelling also)

Hello I have a public sub in a module. I want to access this sub from a button on a form. When i click on the button, it calls a sub (from the event). This sub should be able to call the public sub from the other module, but i can't manage to do it. Thx to anyone who can help:)

Thx for the help!!!! It's working now!!! I used the text property tho:rolleyes:

Still not working :( The "me" is not accepted. I think it works only within vb code. I can do functions that works fine as long as i have less than two parameters. If i have 2, access is unhappy (so i am). Any ideas? oh... and... uh?

I tried your function... it works. So i guess the problem is in my function parameters. =CoutTotal([Txt_Cout1].Texte, [TxtCout2].Texte, [TxtCout3].Texte, [TxtCout4].Texte, [TxtCout5].Texte, [TxtCout6].Texte) This is in my ControlSource property (of a textbox) Is it correct?? (btw, i use a...

This could be an easy question... I created a vb funtion to output a string. I want to use this function on a report. How do i use the function in a report?

I have the same problem i think... 2 combo boxes : the second one list is depending on the first one selection Until now, i used a request to get the right values, but when i change the selection of the first combo box, the second combo box is not updated. Also, i tried different macros and...

Thx!!! I can beleive i past so much time on this...:eek:

Hi I have a combo box with 2 columns, one for an index (code), one for a name. When a value is selected, only the index is displayed. I'm trying to find a way to display the name in a text box (or anything else) so that the name is visible. I've tried for days already! Please help if you can!!!