Search results

vbaInet, I did not test your code. The code provided seems to be for a textbox within a form and not VBA code. The form I am using is not in a view (design view, layout view, etc.)... it is simply open. Maybe I am missing something.......? My apologies, I simply dabble in VBA and am not...

Beetle, I implimented your code and it works great. It might not be the simplest, but for me it works! VbaInet, the lines (on average) is unknown, so the loop provided by Beetle works for me. Thanks for all the help!

I have a pretty simple question I can't see to find the answer to. The user has the ablity to write notes on many lines (memo) that are stored in a table. When I output to a text file I need a "**" to be placed before each line of the notes. I have succeeded with the first line easily by...

I have a query issue. I have a data-set that is somewhat tree-like. My data looks something like this: # | ID | NEXT 01 | Leaf1 | Twig1 02 | Leaf2 | Twig2 03 | Leaf3 | Twig2 04 | Twig1 | Branch1 05 | Twig2 | Branch1 06 | Branch1 | Trunk1 I would like to...

I don't know how it could be the table. I have figured out that it is happening on only a select few computers. At my home computer, it works fine. Can't seem to figure this one out. Thanks for the suggestion Sketchin. Phil

I am utlizing the Command Button Wizard to create a Duplicate Record button. The macro is created automatically by the wizard. It looks like this: I am getting the error "The command or action 'Paste' isn't available now' Can someone tell me why I am getting this? The form control...

I figured it out. The first code was working, I just wasn't refreshing the form. Phil

I have a very simple form where I would like the user to have the option of accepting all the default values on the form. This is causing me a problem because if the user wants to accept the default values, he will hit "OK" however the record is not saved because the form was not dirty...

Thanks a million! The altered code works great! I truly appreciate the help! Phil

I appreciate all the help, thanks. I implemented the code you provided and somewhat understand it. I am getting an error: Error 13: Type mismatch on line "Set frm = Forms![MainForm]![SubForm]" Any reason why that would happen.

At a point within my code I need to requery a subform. When I do-so, the subform jumps to the top record. I have tried the below code to remedy the problem, but can't seem to figure out why it doesn't work. ID = Forms![MainForm]![Subform]![ID] 'Get the ID the subform is currently on...

Nevermind. I guess the "For Each frm in forms" only refreshes the open forms. This code is working for me: Public Function FormRefresh() As Boolean For Each frm In Forms frm.Refresh Next frm End Funcion THANKS AGAIN FOR THE HELP!

Thanks again for the help. I did this but had to add an if statement so that it can check if the form IsLoaded. Now I am getting the error 2465: Application-defined or object-defined error I am greatful for any help. Public Function FormRefresh() As Boolean For Each frm In Forms If...

I had previousely done this. It always stops on the first form that isloaded (i.e. the first time it comes accross the problem code). Thanks for the suggestion.

When I close a form I would like to refresh all open forms. I am using the code below, however I am getting the error message "Object Doesn't support this property or method" Error: 438 on the line dbs.AllForms(i).Refresh. The isloaded and count work fine. Public Function FormRefresh() As...