Search results

I know this is a simple procedure but I cannot figure it out. I need to insert a new column into an existing table. The column needs to be an auto number, starting at 1 and counting up by 1. In addition, this field needs to be a primary key for the table. Currently, the table has 150 million...

You are correct, jal. I removed the second reference and cleaned up the code a somewhat and it works wonderfully. Thanks

Yes, I do have Dim Myword as object--sorry forgot to include it. I don't know which line its. I just get an error message indicating that it needs an object and that is it.

This is the code I am using. It keeps telling me that an Object is required. Any thoughts? Set MyWord = CreateObject("Word.Application") MyWord.Visible = True Set HHForm = objWord.Documents.Add("\\c2\hub\Documents\TempFiles\SubjectTW.doc") MyWord.Activate MyWord.ActiveDocument.UnProtect...

Using bookmarks, I am exporting some data from by database to a Word document, which is then attached to an email. The receipt of the email is suppose to respond the information contained in the document using text fields and five comboboxes and email back so we can automatically import the...

I hadn't considered the 8k chuncks. How would I do it as a link to a file? More importantly, how would I upload the file, provide access to it for the user, and delete it if needs be while maintaining some level of security? I am using Access 2003 as the front-end. I’ve do this sort of thing...

I am using Access 2003 as a front-end with SQL Server 2005 for a back-end. I need to store documents (pdf, jpg, doc, etc). How do I do it with SQL from access? I would like to store the documents SQL and not as a reference. Thanks.

Here is an example of one of the scripts I am working with: Private Sub Form_Open(Cancel As Integer) Dim strConnection, conn, rs, strSQL strConnection = "Provider=SQLOLEDB; Data Source=myserver; Initial Catalog=myTable; User ID=UserNAme; Password=UserPW" Set conn =...

I am using mdb. The database is already running using just access for its backend. I took a copy of the db and uploaded the tables to a SQL 2005 server. That worked fine. Now the issue is setting the record set on the forms (most of the forms require some "where" statement). I was trying to...

Please help me. I have spent two days searching this forum and others looking for the answers to the following questions. This is driving me nuts. Environment: Access 2003 frontend with MS SQL 2005 backend Questions: 1. Using VBA, how do I use a server-side query to control a form? 2...

Thanks for the replys.... Here is what I have. tblIntakeMain (Primary Key: IntakeMainID) is contains data related to cases. A sub-table (stblPersonnel, Primary Key: PersonnelID, Foreign Key: IntakeMainID) contains people associated with each case. The number of people per case various...

I have a one to many question. I am in the middle of converting an Access database over to MS SQL 2005. I am converting all of the queries into pass though queries. One of my queries takes a sub-table that has many fields related to the primary table and concentrates them into one field using...

I have looked at a lot of treeview examples and none of them do what I need. Basically, I want a user to able drill down to a specific office using a treeview. That office would then be stored in the tblMain under the "location" field. The treeview should be based on the table...

Thanks...Got it.

I have a main form (fmnMain) with a one to many sub form(sbfmnContactInfor). The main form is office buildings and the sub form displays contact inform for each location On the subform, I have an unbound list box that lists the current entries for that location. I would like to be able to...

No good. By running the code in the after update event, causes an error. Any other suggestions? This seems so easy and it is so not. Why?

It is....It triggers from on exit event on the [TextDetails] field.

I have a subform (sfmIncidentDetailsUpdates) with a field (TextDetails) with the following code in the on exit event: Private Sub TextDetails_Exit(Cancel As Integer) Dim strSpell strSpell = Forms![IncidentForm]![sfmIncidentDetailsUpdates].Form![TextDetails] If IsNull(Len(strSpell)) Or...

Just a thought: what about creating a public function that ran the spell check? Something like this: in the on exit event : =spellcheck("") On subforms, you simply put in the name of the subform in quotes, otherwise it is ignored (I think I saw a calendar pop up that works like this)...

Okay...tired Me.sfrmName.Form!ctlName and no luck. If I set to strSpell = Me.cltName it works. However, it also check all of the other fields on the sub-form. This one has got me stumped.