Recent content by rockyjr

I guess it works the same... but, for navigation controls... is it the same? I went here but they dont talk about the navigation control... http://msdn.microsoft.com/en-us/library/office/aa224135(v=office.11).aspx

Oh man!!.. I got it to work on the small scale one... hummm... I guess I'll have to check what I'm doing wrong in the other one.... Thanks pr2-eugin, Learned a lot! Luc

Ya I think so... I will recreate the database on a small scale and show you what I'm doing wrong.... yep... I'm sure I'm doing something wrong... lol...

Does it matter if the subform is a datasheet??? The header names dont change. :confused: :banghead:

Ok, that's what I had for the form... I even went a little step further... Since I want to reuse the same code over and over i was thinking of passing the form name to a function, this is how I did it... On the main form I have this: Private Sub Form_Load() 'Check User Language Preferrence...

Pretty good... but for some reason.. I just cant find a way to loop through.... I know this changes the caption but I dont want to it to be static. Forms![Form1].[Subform1]!ID_Label.Caption = "whatever" Luc

I'm sorry in advance if someone ask this question before. I couldnt find anything on this... I have a form (Form1) and a in it, I have 2 subforms datasheet (Subform1 and Subform2). I have ID, First Name, Last Name in each as headers. I need to: 1) Find the subforms 2) Loop through the...

Hi everyone, Is there a way to transfer variables on a form (any data on a form) to a textbox on a HTML website? How would I go about this? Thanks in advance for any help! Luc

Ah ok ok, I see. I will give this a try. Thank you!

Hi everyone, I dont know if anyone could help me on this one. I would like to write some VB to update a field in a table. My table is like this. table name : DepDates Field names: ID, sDate, and sDateF I have a report and the dates comes out as follows: Saturday, April 10th, 2012. I was...

Here's a quick example.

Using the same funtion... is there a way to find duplicates??

That's awesome... This is what I finished with : Dim ctl As Control For Each ctl In Me.Controls If ctl.ControlType = acTextBox Then If ctl.OldValue = Me.txtsearch Then ctl.ForeColor = vbRed Else ctl.ForeColor = vblack End If End If Next ctl It didnt like the If...

The code looks good... just not at the right place. So, if I understand, you have a form with the checkboxes... a subform in that form right? The code should be entered into your query....go to design view of the query and go to the SQL view and enter the code there. Now, your subform...

Ok.... that was dumb!!!... outch!! Ok... have a little something again...... Here's the code: Dim ctl As Control For Each ctl In Me.Controls If ctl.Name = Me.txtsearch Then ctl.ForeColor = vbRed Else ctl.ForeColor = vblack End If Next ctl ....I'm getting an error at...