Recent content by zevw

This was all for a temp table and not a structural permanent table! I also did not have a chance to read the article! Thanks guys!

I searched while waiting and did this and it works! rst.Fields("Field" & Cnt) = splt

I am going through a description field in a table separated by spaces I am using Split to capture each word in a separate field and the place it in the same table in field1, field2, field3 each time I loop around How can I code the rst!field1 = splt since the number 1 is placed in through a...

Thanks!

I am looping through a Database and want to delete all its Forms, in the middle of looping it gives me a error the object or Name does not exist or invalid. Is there a more proper way how to do this? Dim frmName As String, i As Integer For i = 0 To CurrentProject.AllForms.Count - 1...

Works great!

How do I now combine the variable with this string WrdNum = "Forms!ReviewForm!" & FrmName & ".Form.WordId" doesn't work its a string WrdNum = Forms!ReviewForm![FrmName].Form.WordId It doesn't recognize FrmName as a variable?

Thanks! Since it was in tab control it was giving me the name of the Tab. So I used FrmName = Screen.PreviousControl.Form.Name

I have a record selected in a subform and I click on delete in the parent form I know I can do Form![Parentform]![Subform].subform How can I get the name of the subform with Me.Name Me.Name gives me the parent form name not the subform name

Thanks! It works great!

This form that I"m loading takes 15 to 30 seconds to load, I am looking for a way to display a message to the user while its loading like every 5 second like this! "Have Patience ... this will take a moment to load!" The msgbox is not appropriate because it waits for user input what can I do...

I put it all the way at the end the Load Event Procedure and it works fine. Thanks!

I Thank You for the valuable information. I have a minor problem I created a function and call it in the open event procedure Private Sub Form_Open(Cancel As Integer) CurrentDb.Properties("AppTitle").Value = Nz(DLookup("HName", "Company"), "") Me.Company.Caption =...

Is there a way to figure out if the object on the screen is a form or a report. Can I write a function when a form opens I can capture if its a form and if its a report capture the report and manipulate the menu bar. Thanks in advance!

Thanks I will try it tomorrow!