Recent content by swbrodie

That sounds great! I'm sure that I'm going to sound stupid, now, but I don't know how to set or read a Bookmark. I've tried reading the Help file, but it didn't tell me much about how to set one. I couldn't find an example there. I guess I need to go to a New Record, make a Bookmark, then...

Hello. Does anyone know of a way to post the contents of an Access form to a URL? Not create a data access page... just post the contents to the browser window. I would like to be able to click a button on the form and have it launch the user's browser. I could create a variable on the form...

Hello. I have a form, in datasheet view, that contains many records. I first placed the following action on the load of the form Go To Record = New This put the cursor in a new record, which I wanted, but the new record is at the very bottom of the screen, which is not very pretty. So I...

I thought I might have to do it that way. I was hoping to be able to set the property on the table itself. That way, all forms and reports would automatically display the chosen format. But, this works fine, too. Thanks, again.

Hello. I have a Settings table that contains certain "settings". One of the settings is DateMask, which holds a value such as "mm/dd/yyyy". Users can use this setting to choose the format in which they display dates. Is there a way to set a table's Format property from a macro, like you can...

Thank you very much. There was a reference to fpdtc.dll, which is available in Access XP, not 2000. I removed the reference to this library and everything is working now. Now I can go to lunch. :)

Okay, I'm about at my wit's end. I cannot, for the life of me, understand why this is not working properly. Here's the problem... I have a report that displays a header at the top of the page. This header takes the values (StartDate and EndDate) passed from a form, formats them as mmmm dd...

Hello. I have a form that gathers information and sends it via email using the SendObject action within a macro. If the user's email client (Outlook Express) is configured properly, everything works great. But, if the user has not yet created an account in the mail client, the macro fails and...

Well, I'd like to see a list of open Forms or Reports that behaves just like the list in the built-in window menu does. That way, if a user opens multiple Forms in the application, for example, they can click on the custom menu to view and get to them easily. Otherwise, they have to reopen...

Oh, thank you, thank you, thank you. You are the greatest! This is a very happy me about now. --> :D I hadn't been able to find that information anywhere. I don't suppose you know how to display a list of open windows in a custom menu bar, without using the built-in window menu. If you...

Hello. I have created a macro that exports data to a text file. The first line displays a message warning the user that performing the action will overwrite the existing file. The action is set to StopMacro and the condition is set to: Not MsgBox("Backup Confirmation@Are you sure you wish...

Thanks, Andrew. Unfortunately, doing this modifies the built-in window menu itself, so my default window menu is changed. Then, if I reset my default window menu, the window menu on my custom menu bar is also reset. Plus, opening the database on another user's machine causes it to view the...

Hello. I have a custom menu bar, in which I have created a window menu for Tile Horizontally/Vertically, etc. I would also like to include the list of active windows that you get with the default window menu. I do not want to use the built-in window menu because I do not want users to have...

Hello. Does anyone know if there is a way to display records backwards in a form in datasheet view? I don't mean to sort them in descending order. I mean to actually display them backwards, with the new record on the top? If not, is there a way to automatically jump to the very bottom of the...

Hello. I have a form that is bound to a table in my database. The form has several text fields and OK and Cancel buttons. What is the best method for allowing the user to click OK and have changes saved, but not saving changes if they close the window or click Cancel? I'm sure this is an...