Search results for query: *

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

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

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

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

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

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

I need to merge a couple of large mdbs. I was hoping to create one mdb to coordinate it all. I will need to create indexes, create new mdbs, and summarize data and build new tables. Is it possible to create indexes on tables that reside in a different mdb? Once this is resolved, I think I...

I am having intermittent problems with an Access database. It was developed in Access XP – running on Windows XP/Access 2003. Split, FE on desktops, BE on Win2000 server I have 3 forms that have combo boxes that pull data from the same (customer) table. All three have autofill property on. One...

I have a few questions regarding security that I hope someone will be able to answer. 1. I am running Access XP. My application is split - front end on all user stations and data on a server. I used the security wizard to create a new workgroup with a shortcut to my secured mdb. I notice...

I have 2 Access applications. The data resides on the server and the applications reside on the local user pcs. If I implement security – separate workgroup files for each mdb (actually mde), do I need to have a copy of the mdw on each pc? Can it reside on the server? Is there a better way...

I am getting the following the error “2465 Microsoft Access can’t find the field “|” referred to in your expression” from the following piece code. If Me!Loc = "REQ" Then Me![COND] = "-----" Me!PRICE = 0 Me!QUANTITY = 0 Me!MFG = "---" Me!Loc = "RFQ" Me!PARTNO = "---"...

I have a landscape report that displays one master record on the left side of the detail section - it is approximately 6 inches wide. Immediately to the right of the record, I have 2 subreports both related to the master record. The subreports are about 3 inches in width and appear one below...

I have a table, with a 5 field primary key, that is related to 5 other tables. Every so often, for no explainable reason, an update to the primary table (via a form) causes the record in the primary table to become corrupt and ultimately requires its demise by deletion. This in turn causes...

I have a database with a table "PART" that is related (referential integrity enforced and set to cascade updates) to 3 other detail tables. The primary key of PART consists of multiple fields. The client just noticed that some changes he made to the primary table did not update in...

I have an application that loops through a recordset (containing email addresses and filenames) and calls a function that sends email using the Outlook object. At the end of my function I quit Outlook and set my outlook variable = nothing. If I have my Outlook set up NOT to automatically...

I have a table with email addresses and filenames. Many addresses receive the same file.(20 to be exact). I am sending the emails using the Outlook object. I have created a string with all of the addresses separated by "; " but I get the error "outlook does not recognize one...

I have an Access 2002 application in a multi-user environment, and 2 large tables (one table has 1 million records) in a mysql database. I need to query the 2 mysql tables from Access. The query runs too slow! Are there any hints/tricks/suggestions that anyone might have for improving...

If the users accidently attempts to insert a duplicate record - the get a very unfriendly error message. Is there some way of trapping this error in order to make the message more user-friendly? Thanks, Nancy