Search results for query: *

I reinstall Office XP pro and SP3 recently. The problem is when I close a table, the database window is blank. I should click Query or Form etc. then click Table, the contents of Table display. Same thing happens when I close a query. Please help and thanks a lot in advance! George

I just reinstall Microsoft Office XP professional. The strange thing is when I want to create new table or query by click the New button under Table or Query, the New table or New Query window do not display. It open a new table datasheet view or new query design view. Please help to let these...

Hi! We select a customer in a combobox to find related data in a form. the data are connected to a table in SQL server. The problem we got is the customer is not we selected sometimes. This is happened just for several customers but most is OK. BTW if data are connected to Access table...

I would like to install Windows 2000 Server and Windows XP in the same hard disk. My questions are: 1) Should I create a FAT Primary partition just for dual booting? 2) Can I use Extended Partition / Logical drive for Windows 2000 Sever and Windows XP? Any suggestion will be appriciated and...

Hi! I am new to Visual FoxPro. Please recommend some books about FoxPro. Thanks a lot! GC

We have an application database in SQL server 2000. when I try to backup transaction log file in Enterprise Manager. The Transaction Log is gray. What should I do to make it possible? Thanks a lot in advance! George

We will move our SQL server 7.0 to another NT server and upgrade to SQL server to 2000. What is the best way to do it? Upgrade first then move or move first then upgrade and we don't want interrupt users? Please help and thanks a lot in advance! george

After import a text file with 475 fields into SQL server 7.0, I got error message &quot; Too many columns defined in the rowset&quot;, when I try to open the table. There is a Help button on this message. It said that ODBC Error: <Os>. An ODBC error has been generated. You might have deleted a...

No objects were selected when I try to use mouse to select several objects in the form design view. I can select one object only by one click. Is anyone know how to solve this problem? Many thanks in advance! George

Is there a way to use keyboard to select the check box on form? If possible it will save a lot time for the data entry. Thanks a lot in advance! George

When I type my code, the cursor always moves to the end of line without space to the most right character. Whatever I use space bar or tab key the cursor back to left. What cause this happen? How to solve this problem and how to avoid it? Please help and thanks a lot in advance! George

An Access database is frozen when run a code. So database is interrupted in the session. when I try to reopen this database I got message that database need to repair. After click OK I got another message: Error 3356 -- You attempted to open a database that is already opened exclusively by user...

Hi! I'm not sure where to post my question, so I select this topic. I have a Main Menu form to print a lot of reports. I use the combination of several unbound fields to select a report, such as report type and Company,Team,Staff,etc. Then use a Print button to print selected report. The...

Hi! I have a report which use two unbound fields to show period start date and end date. Those two dates on the main menu form. I use FieldRecordSource &quot;= Forms!frmMainMenu!StartDate&quot;. The strange thing is that when I preview the report those two dates are on the report. But when I...

Hi! I got syntex error message when try to run the code: SELECT CASE WHEN NOT ISNUMERIC(LEFT(MRN,1)) THEN MRN WHEN NOT ISNUMERIC(LEFT(RIGHT(MRN,2),1)) THEN RIGHT(MRN,2) ELSE RIGHT(MRN,1) END AS Code FROM abo.tblPatients The error message is: Incorrect syntax near the keyword...

Hi! May be this is a stupid question. I have several reports in different Access databases. Now I want to put these reports together and print it on one report. Any idea will be greately appreciated and thanks in advance! george

Access does not allow to create a continuous form contains a continuous subform. I want to create this kind of the form which can add / edit data. Is there any way to make it? Thank you very much for your help? George

I got &quot;6: Overflow&quot; message when I run a code: SQL = &quot;SELECT * FROM [tblPatients_All] ORDER BY PtID, SOC, DCDate;&quot; Set rstPt_Init = db.OpenRecordset(SQL, dbOpenSnapshot) The tblPatients_All has 34400 records. I checked the data for each field and didn't find any data is...

I use DAO to create a temp table. But I don't know how to create an Autonumber field in that table directly. Microsoft has a code using function to create the autonumber field. This means after create the temp table I should call the function to add the autonumber field in the temp table. Is...

I have an access 97 database as the front-end and data are stored in SQL server. There is a form which is based on a temp table. This temp table is based on two linked tables from SQL server. I use DAO to create the temp table, then display on form. After user cahnges data on the form, I use...