Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: gransbpa
  • Content: Threads
  • Order by date
  1. gransbpa

    Combo box sorting problem

    Hi there, I have a combo box with it's rowsource based on a database table. This table has an ID (key-field), a number which is an identifier for the user and a description. I only want the combobox to show the identifier (not the ID) and the description, and I want to sort the combobox on the...
  2. gransbpa

    Error 86 Could not delete from specified tables

    Hi there, I am running code which deletes all records from a table using SQL. This worked before, but now all of a sudden the code does not work anymore: I get the error message 86: could not delete from specified tables. This is strange, especially because the code empties 8 tables, and only 4...
  3. gransbpa

    How to avoid 4000 character field lenght restriction ?

    Hi there, I have an SQL Server database, which I want to update from an Access database. One field in this Access database is a memo field, having an allmost unlimited capacity. When I try to update the field in the SQL Server database from this field, the maximum capacity in the SQL Server...
  4. gransbpa

    Unsafe expressions?

    Hi there, I am developing a database in access 2003. When I open the database, I get the following error message: 'Security warning: unsafe expressions are not blocked' Then I have the ability to open the database anyway, and after this I get this other message: This file may not be safe if...
  5. gransbpa

    Office97 and Win2003?

    Hi there, We have an old MSAccess 97 application, the backend of which we want to host on a Windows 2003 Server (Is now on a Windows NT Server). Furthermore, to be able to compact and repair this backend on a regular basis, we want to install the MSAccess97 executable on this server also. Does...
  6. gransbpa

    Office 97 and Windows 2003 server?

    Hi there, We have an old MSAccess 97 application, the backend of which we want to host on a Windows 2003 Server (Is now on a Windows NT Server). Furthermore, to be able to compact and repair this backend on a regular basis, we want to install the MSAccess97 executable on this server also. Does...
  7. gransbpa

    Copying a table from 1 database to another

    Hi there, I want to copy table from one database to another with lines of code. I used the TransferDatabase method as well as the CopyObject method, but both create a link to the original database table instead of an actual copy. This is not what I want, however: I want the actual table copied...
  8. gransbpa

    Automating copying a table

    Hi there, I want to copy table from one database to another with lines of code. I used the TransferDatabase method as well as the CopyObject method, but both create a link to the original database table instead of an actual copy. This is not what I want, however: I want the actual table copied...
  9. gransbpa

    Windows\secure.html problem

    Hi there, I'm seriously infected with a virus or something like that causing several problems: it is changing my startpage to c:\\windows\secure.html. After that, I get several messages that I am infected with spyware, and all kinds of xxx-sites open themselves up. Virtually every process on my...
  10. gransbpa

    Fill Word-document fields from Access database

    Hi there, I have an MSAccess2000 database with client-data. From one screen, I want to print a Word(2000) document. I implemented the code which opens the document, now I want some blanks in the document to get their data out of access, e.g. a name, a street, an adress, etc. I tried mailmerge...
  11. gransbpa

    change password in workgroup

    Hi there, I want to create a new user in a workgroup file, and then change his password from default/blank to something else. However, when I am logged on as myself (I belong to the Admin group), I can't change the new user's password: you can only reset it. But the user himself does not have...
  12. gransbpa

    INSANE PROBLEM: String HDA not accepted!!

    I encountered an insane problem in Access: when you enter the text 'HDA' in a table text-field it automatically gets converted to 'HAD' when you leave the field. Access does not accept the string 'HDA'. I checked, and this happens in Access as well as Excel. It happens in Access 97 as well as...
  13. gransbpa

    How to get an image in a Canvas

    Hi there, I just started programming in Java, and made a simple applet to show an image loaded from a directory, using the drawImage and getImage methods. Now I want to make the same functionality in an application, using a Canvas instead of an applet, but the above function only seem to...
  14. gransbpa

    Empty Pages driving me nuts!!

    Hello, I'm printing an Acc2000 report consisting of several subreports. Depending upon initial conditions, sometimes subreports are put to invisible. But the parent report containing the subreports keeps printing one empty page at the end. I already put all the pagebreaks in the parentreport to...
  15. gransbpa

    Force end of report

    Hi there, I have a report containing multiple fields, labels and pagebreaks. I want to print only a subsection of this report, depending on the value of certain boolean parameters which serve as input for the report. However, I can't seem to force the report to stop printing. I can put...
  16. gransbpa

    How to handle integrate subreports into one report

    Hi there, I have a report which should combine several subreports. I'm trying hard to find a way to achieve that every subreport can be coded from within the main report to start on a new page, but I can't seem to find the right syntax. Does anyone have an idea how to do this? Thanks.
  17. gransbpa

    Hijack this.log still containing dangerous entries?

    Hi there, I had several problems (dialers dialing in, cookies automatically generating themselves, etc.). I run hijack this, and removed some entries, but I'm still having some problems, not sure my system is 'clean' now. Does anybody have an idea what is the matter? Thanks! Logfile of...
  18. gransbpa

    Access 97 unter Windows XP

    Hi there, Right now I have a lot of clients running Access97 under Win 2000. The migration from Win 95/98 to Win 2000 has been performed without many problems, apart from some minor issues. Now, we want to migrate to Win XP, but we wonder if the migration of our Access97 apps from Win 2000 to...
  19. gransbpa

    report problem access97 under win2K

    Hello there, I have an application running under Access 97 to run under Windows 2000 (first it ran under win95). Some reports (defined in the page setup for a network printer) functioned well with the combination Access97/Win95, but when trying to print them with the combination...
  20. gransbpa

    Importing from Email

    Hi there, I'm looking for a way to get orderinfo automatically from email without user intervention. Anyone knows how to do this? Thanks.

Part and Inventory Search

Back
Top