Search results for query: *

I am sure there's a simple way to do this but I can't get my head round it. I have a master table with accounts (account no, name, etc) and a linked table with transactions, many per account, (date, amount, etc). Is there an SQL statement to retrive the name from the master table with the date...

I have a datagrid displaying about 10,000 records. When I drag the scroll bar down, if I go past about half way, it jumps back to near the top. What's going on? Page down key seems to work OK but it's laborious with so many records.

I have an application written in VB 6.0 and have been asked about porting it to an AS/400 environment. I guess one option would be run my application on an attached PC and connect to the data via ODBC. Is practical to translate the code to a different language? (There is a small amount of user...

I need to convert a binary number, read from a text file, to it's decimal equivalent. It's in two's complement format, i.e can be negative. Does anybody have a suitable routine or can anyone point me in the right direction? Many thanks

How can I hide the database window button in the toolbar by code in an mde file? I have the standard toolbar available in an mde application but need to disable the database window button for some users. Thanx.

My application is working fine except on some PC's the shell function is not working (returns 0). Application is 2002 format, Access 2003 loaded on PC. Applies to mdb and mde version. I have tried stepping through and shelling to various programs such as notepad but no luck. The code is OK...

I have an Access application that opens a second access database using opencurrentdatabase and opens a form and does some other stuff. This has been working fine locally (access 2002) and on the network (access 2003, upgraded from 2002). The application is in 2002. There is a new termianl on...

Hi I am setting some report parameters as follows: With drReport.Sections!PageHeader .Controls!lblParameter.Caption = NullStr(rsTable!Value) End With This appears fine if I print: drReport.PrintReport But not if I show: drReport.Show vbModal The show just shows the caption as...

I have a form with a button to print a report. This calls a second form to enter criteria and display the report in preview mode. The second form then closes. I am left with my report preview behind the first form. I have to click on the report to bring it into focus for viewing/printing. How...

I am sure this is easy but I can't get my head round it. I have 2 tables in a 1 to many relationship. Table 1 (one) contains itemid qtyordered Table 2 (many) contains itemid qtyreceived What I want is itemid qtyordered sum(qtyreceived) but only where qtyordered > qtyreceived The problem seems...

Is it OK to use fields calculated in a report. If I have a field with name txtDebit and a field with name txtCredit can I have a field where the control source is [txtDebit] + [txtCredit] and name txtTotal? Will Access know to calculate txtCredit and txtDebit before txtTotal? Can txtTotal be in...

Why does AscB(Chr(&H1B)) = 26 Correct and AscB(Chr(&H82)) = 26 ??????? whereas Asc(Chr(&H1B)) = 26 Correct and Asc(Chr(&H82)) = 130 Correct

Can anyone advise on how to convert string to double? I am reading an incoming hex string such as 40 B2 FC 6B 85 1E B8 52 This supposedly represents a numeric double data type. How can I convert it? What is the value of the above no?

I have a cheque writing routine. It works in 2 phases. Phase 1: enter the first cheque no and allocate the number sequence to the transactions. Phase 2: print the transactions with the cheque no. What is the best way to carry out phase 1? I can loop round an ADO recordset and allocate the...

My Access 2002 application is working fine on XP terminals. I have created a runtime version (using the developer edition) and loaded it onto termianls running Windows 98. I am getting various issues but the main one is speed (the others may be caused by some timimg out issue). Has anyone had...

In a form I allow selection of a record in a table. I then openreport with a where clause e.g. DoCmd.OpenReport "rptTenantEnquiry", acViewPreview, , "lngTenID = " & CStr(Me.lngTenID) This works fine with a few records but with a large number of records the report is blank (just headings). Has...

All reports in my application are OK in my development environment (Access XP, Windows XP). However when running on the end user's PC (Access runtime, Windows 98) some reports are OK when previewed but some fields print #name when printed. I have no control over this within VBA so what's going on?

I have a form F1 which adds a record to a table T1 using ADO. On completion form F1 opens a second form F2 which is bound to the table T1. The problem is that the new record isn't visible in F2. The record is created correctly and the recordset and connection are closed. If I step through with...

My application automates Word and worked fine with Word 2000. If have loaded Word 2002 and it still works but when I now load onto my client's PC with Word 2000 it crashes. The document is loaded and populated but crashes on 'wordobject.activedocument.print'. It comes up with a message "... has...

Have moved development from 98 to XP. Now when use PDW to install from XP to 98 get error registering msjro.dll and scrrun.dll. If register with regsvr32 get loadlibrary failed message. If ignore error get run time error 429. Looks like an issue with different version. Is it possible to develop...