Search results for query: *

I have a query that is going to return no more than 4 results... for Example Select Items from tblItems This query returns: table chair desk seat I want to be able to take this result and use it as columns in a new query.. How would I go about using this.. Something like Select ??? as...

The other day I downloaded a windows service pack and it is causing files I create with Microsoft Word 2000 to be generated without the Archive file attribute. This is causing problems for a program I have that uses Word files... Before downloading the patch, all files created by Word 2000 had...

Hello, I have a question or two about singleton design pattern in php.. First of all, does having a single static instance of a class mean that you can get a reference to that class in two separate webpages and in the second page, it still contain all the data from the first page. If so, this...

Is it possible to have a field that autoupdates itself based on another field in the table... For example tdate accountname number 10/10/2000 as 1 12/02/2001 as 2 12/02/2001 shailesh 1 12/03/2001 as 3 12/03/2001...

Sorry its been a couple days for a reply... Question about the line "CurrentProject.Connection" It doesnt recognize CurrentProject as a valid object for me.. Do i need to include something for it? Also one other question... Is ADO still a good solution if in my example earlier...

Dont know if i made this clear or not.... tblNames is an Access table, tblCompletedNames is a sql attached table Netooi

Could something like this be done with ADO? Also, i'm using Access 97 and someone told me you cant do ADO with '97.. Is that true or not? Dim db As Database Dim rsNames As Recordset Dim rsCompleted As Recordset Set db = CurrentDb Set rsNames = db.OpenRecordset("tblNames&quot...

First, make your query putting in the fields you need to return. Then, in query design, right-click and select parameters Add a date/time field called "MyDate" or whatever you want to name it.. then set the Criteria field to be [MyDate] if you should need the query to return less...

1. The coding is being done in event procedures on the Access forms using Visual Basic.. 2. I'm not sure on the number of records.. I'm working with someone on this project and they asked me to research this problem.. I'm guessing a couple thousand records max.. And i need to check with them...

No, i'm using Access '97 if you have any suggestions for it... I havent had time yet to play with the first reply but I'll try it too and see if its any improvement and i'll let you know what happens.... THanks, Netooi

Hello, I have a question dealing with performance problems when using the VB FindFirst command. When I use this command on tables in Access I have around 3x faster performance than when i use the FindFirst command on SQL attached tables. I have noticed significant improvement in times when...

Hello, I have a question dealing with performance problems when using the VB FindFirst command. When I use this command on tables in Access I have around 3x faster performance than when i use the FindFirst command on SQL attached tables. I have noticed significant improvement in times when...

Hi, I'm working with firing a macro when a form field Check box is checked in Microsoft word.... It has the On Enter and On Exit options to fire the macro... My problem is it fires the first time you click on the check box (On Enter) it fires when you leave the checkbox to click on another...

Ok, I have a MS Word Document that uses form fields.. Of course when the fields are active, the document is protected so you can only access the form fields... Is it possible to be able to access different sections of the document that arent part of the form fields... Here is my situation: I...

I have a string called "MyStr" that has a name in it. I want to be able to insert that name into a table in my Access database called tblData that has a field called Name. Could someone hook me up with the VB to do this? Thanks, Netooi

I have a string called "MyStr" that has a name in it. I want to be able to insert that name into a table in my Access database called tblData that has a field called Name. Could someone hook me up with the VB to do this? Thanks, Netooi

I need some help moving data from MS Word to MS Access... I have a MS Word document that you can enter data into certain fields in the document and i need to know if there is a way to extract the data from the Word document into an Access database. I'm not sure where to start. Thanks for any...

I need some help moving data from MS Word to MS Access... I have a MS Word document that you can enter data into certain fields in the document and i need to know if there is a way to extract the data from the Word document into an Access database. I'm not sure where to start. Thanks for any...

Ok, I have two tables... Table One and Table Two for lack of a better name. Table One has a field called IDNumber. It contains text fields of numbers such as "123456789" Table Two has two fields in which these text numbers can be stored. We will call them NumberOne and NumberTwo I...

Ok.. Here's my situation.. I recently brought this up and you guys were able to give me a solution but things just got a little more complicated.. Here's a brief summary of the old problem so you will know what i'm after now: I have a Access Database that was upsized to SQL Server 7.0. In...