Recent content by PurpleUnicorn

Thanks for the reply. The F/E is an MDB. The delete is done by clicking a button - Docmd.RunCommand acCmdDeleteRecord.

I have an Access database(F/E and B/E) that I am in the process of migrating to SQL Server. I currently have sample data in SQL Server and I am testing my Access F/E. I have a delete trigger that is firing correctly - however, I am not getting the error message from my Access F/E. Here is...

Thanks for the reply Denny - I changed my errorhandler - I am still only getting the Access generated error (2501) - not the error message defined in the trigger. If I attempt to delete the record from the linked table - I get the correct message (from the trigger). When I attempt to delete...

I have an Access database(B/E) that I am in the process of migrating to SQL Server. I currently have sample data in SQL Server and I am testing my Access F/E. I have a delete trigger that is firing correctly - however, I am not getting the error message from my Access F/E. Here is my...

Yes, the detail form opens. The search form is actually a list of item numbers - the user clicks a search button next to the item of interest to check inventory. The item number is the criteria used in the detail form. If the item does not exist in inventory (thus no records) - the user needs...

I have a search form from which I open a detail form using the search criteria. If there are records in the detail form, all is well and the form opens - placing my criteria in an unbound textbox. I have code in the got focus event of the unbound textbox to place the cursor at the end of the...

Thank you so much adalger and PHV. I have spent so much time on this. My boss does hundreds of searches a day and can not have hundreds of browsers open! I used the code above - so short and sweet and I also located some code (here at tek-tips) to maximize the ie object and bring it into...

Sorry about that - I did get it to work. I didn't realize that IE must be opened first. Thanks. Now I just need to figure out how to test for an open browser.

adalger, I could not get your code to work - nothing happened when I ran it.

Thanks for the quick response. I have already tried the following: Dim wbBrowser As New SHDocVw.InternetExplorer wbBrowser.Visible = True wbBrowser.navigate sUrl, Nothing, Nothing, Nothing, Nothing Every time I click the button to search the internet - a new browser opens. Am I doing...

I have a form containing a list of items that I want to search for at a particular site. I construct my url using the selected item. I have tried: application.followlink myUrl,, false shellexecute ...sUrl... Web Browser control InternetExplorer object All allow me to follow the link and open...

Thanks so much for your help (and the affirmation). So far, I have the array loading - hopefully the rest will go smoothly! Thanks again!

Thanks for the replys - I don’t think I explained my problem with enough detail. Here is what I have: Week1: 500 Week2: 1200 Week3: 200 Week4: 10 Week5: 2200 and so on... I need to know the totals by month. So I need to end up with: Month1(in this instance – December): total for...

I have a table containing fields wk1 through wk52. I need to convert this data to mon1 - mon12. wk1 will always be the first week of the current month. I was thinking that I would need to convert weeks to days first, then somehow populate my months fields, but I'm not exactly sure how to go...

Hi, The application is split with FE/BE. Most of the F/E computers are using Windows XP and Access 2003. There are a couple of Terminal servers that connect - they have Windows 2000. The B/E is on a Server 2003 computer. As far as I know, security is set up correctly. Everything was...