Search results for query: *

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

...[CUSTOMERdelete] on [dbo].[CUSTOMER] for delete as BEGIN declare @errorNumber int, @errorMsg varchar(255) if exists( select * from deleted, ORDERS where ORDERS.CUSTOMER_ID = deleted.CUSTOMER_ID) begin select @errorNumber = 30004, @errorMsg =...

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...

...Trigger [CUSTOMERdelete] on [dbo].[CUSTOMER] for delete as BEGIN declare @errorNumber int, @errorMsg varchar(255) if exists( select * from deleted, ORDERS where ORDERS.CUSTOMER_ID = deleted.CUSTOMER_ID) begin select @errorNumber = 30004, @errorMsg =...

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!

...how to do this part) by traversing the array for the correct number of days for each month. So for december - I would end up with all of weeks 1 - 4 (28 days) = 1910 then week 5 divided by 7 is 314 (I rounded) * 3 = 942. I would have a total for month1 of 2852. Any ideas how this can be done?

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...

We are experiencing multiple crashes daily of the data file and the mdw. This seems to be a recent development. Previously - we would have occassional data crashes. Now is it daily We are using Access 2003 for most front end computes with Windows Server 2003 storing the data. There are a...

I had the same problem. It has something to do with having multiple versions of access installed - check out this link for the solution from Microsoft: http://support.microsoft.com/default.aspx?scid=kb;en-us;835519

Thanks for the fast reply. I will not be able to test this until I return to the office. However, I do have a couple of questions. 1. I am actually working with 3 mdbs. For the sake of simplicity, I will call them db1, db2 db3. I use db1 to control the processing of very large tables...

I have an odd problem. I have the following code: DoCmd.CopyObject pDatabase, , acTable, ptblName in an application. It copies a Link from the current database to the destination (pDatabase). This code works just fine on my home computer and my laptop. However, when I run it at my office -...

I have a client who is using an application developed in Access 2002. He is the only one still using Access 2002 - everyone else has upgraded to 2003. Today, he attempted to install Access 2003. He is getting the "unsafe expressions are not blocked " security message. The system info...