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!

Register Log in
  • Congratulations Rhinorhino 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: abbyanu
  • Content: Threads
  • Order by date
  1. abbyanu

    Open Subform with Matching Data from Separate Form

    I'm trying to pass data from two combo boxes in a form to a subform in a second form , but I'm getting this error: Enter Parameter Value. I've tried all possible ways, including using a textbox instead of a combo box, but I'm getting the same error. When I enter input values into the "Enter...
  2. abbyanu

    Adding and displaying records with Multi Select List Box

    Hi I have three related tables: GL: gl_id; gl_name GL_Acct: gl_id; acct_id Account: account_id; account_name There exists a 1:many relationship between GL and GL_Account, and between Account and GL_Acct. I wish to populate GL_Acct using a multi-select list box in the GL form. For example one...
  3. abbyanu

    Searching tables

    Hi... I need some help writing some code: I have two tables: Process (primary key: Process ID e.g. PR01) and Accounts (primary key: Account ID e.g. PR). When entering a new process, I wish to make sure that it is valid, in other words, the first two characters of Process ID must match an Account...
  4. abbyanu

    Corrupt DLL - Visio 2002 Pro - ProcessEngineering.dll

    Hi Could someone please send me a copy of the Visio 2002 Professional ProcessEngineering.dll file? Mine seems to be corrupt: It's found in Program Files\Microsoft Office\Visio10\DLL\ProcessEngineering.dll Please send to: abravision@netscape.net Many thanks. Sincerely, Abbyanu.
  5. abbyanu

    Updating table with values from another table

    Hi I have two tables: [Products] and [TempData]. [Products] has some extra fields which [TempData] does not have. While [TempData] contains some new records and updated fields, which I imported from MS Excel 2000. How can I update all the [Products] records with the [TempData] records, while...
  6. abbyanu

    Updating table with values from another table

    Hi I have two tables: [Products] and [TempData]. [Products] has some extra fields which [TempData] does not have. While [TempData] contains some new records and updated fields, which I imported from MS Excel 2000. How can I update all the [Products] records with the [TempData] records, while...
  7. abbyanu

    Updating Access table with Excel 2000

    Hi I would like to update an Access table from Excel 2000, and ensure that there are no duplicate records. The access table has some extra fields that the excel worksheet does not have. I wish to update the access table and leave these extra fields intact when I import the excel data...
  8. abbyanu

    FindFirst vs Seek

    Hi I have a line .FindFirst ("ProductNumber ='" & Prodno) that is generating an error: Run-time erroe '3077' Syntax error (missing operator) in expression. I've tried all variations, but in vain. Any idea what's causing the problem? It's also slow. I've also read somewhere in...
  9. abbyanu

    Importing Text Files

    Hi I'm still learning VB, and I have some code that's giving me a headache. table name: yeeken Fields: 1. ProductNumber (primary field) 2. Notes (Memo field) Each ProductNumber has a corresponding ProductNumber.txt file, which I wish to import into the [Notes] field, thus for example if the...
  10. abbyanu

    Importing multiple textfiles

    Hello I have an Access 2000 table called "Products". The primary field is "ProductNumber". This table also a memo field "Description", which should contain the product description. I wish to import the product descriptions from DacEasy accounting text files...
  11. abbyanu

    Importing multiple textfiles into table

    Hi I have an Access 2000 table called "Products". The primary field is "ProductNumber". This table also a memo field "Description", which should contain the product description. I wish to import the product descriptions from DacEasy accounting text files...
  12. abbyanu

    Browsing for Images

    Hi! I'm using Access 2000. I would like to create a command button that enables the user to browse the hard drive for JPEG and GIF images. Once an image has been selected, I want to store only it's full pathname in a table (field name is ImagePath). Could someone please help me out with the...
  13. abbyanu

    Storing Images in Database as Filename

    Hi I'm developing a small Access App, which we hope to use both in-house and on the Internet (incorporating ASP). I wish to store images in an access table as filename (e.g. image.jpg) without the pathname. I also wish to use the image filename to display the actual image on a Form, and also...
  14. abbyanu

    Erratic Mouse in X

    Hi I just installed Linux Mandrake 7.1. It works fine, but I can't use the mouse in X windows, because it keeps jumping from one place to the next erratically when I try to point and click. I have a standard 2-button mouse. Any special settings I should use? How? Please help. I'm a newbie...
  15. abbyanu

    MCSE Win2K Core books

    Hi I'm planning to pursue the MCSE Win2K Track. I would like to purchase the best books for a novice, to help me prapare for the exams. At the moment, I have three options in mind: 1. MCSE Windows 2000 Core Four Boxed Set (Exams 70-210, 70-215, 70-216, & 70-217). Published by Syngress, Aug...
  16. abbyanu

    Displaying Subform Totals

    Hi folks I have two linked tables (1 to many relationship or parent and child), and using a form and a subform to input data into both tables. The tables are: purchase invoices (main form) and purchases (subform), with several purchase records linked to one invoice number. I wish to display...
  17. abbyanu

    Calculations on data entry

    Hi I'm making a small Access app. On the data entry screen, the user enters two fields, say quantity and unit price. On the same data entry screen, how can make the program automatically calculate the total price (which is = unit price*quantity, and save the result in the total price field of...
  18. abbyanu

    Acrobat 4.05 Installation in Windows 2000 Pro

    Hi I'm trying to install Adobe Acrobat 4.05 in a Windows 2000 professional machine, but I'm getting the following message: The instruction at "0x10004827" referenced memory at "0x1030ae9c". The memory could not be "read". The installation then terminates when I...
  19. abbyanu

    Hi I'm trying to install Adobe A

    Hi I'm trying to install Adobe Acrobat 4.05 in a Windows 2000 professional machine, but I'm getting the following message: The instruction at "0x10004827" referenced memory at "0x1030ae9c". The memory could not be "read". The installation then terminates when I...
  20. abbyanu

    Automatically generating IDs

    Hi. I'd like to automatically generate IDs for the primary keys in the data entry screen when the user adds a new record. Any hint on how I can go about this? I would like to use a sequence like 0001, 0002, etc. Many thanks. Abby.

Part and Inventory Search

Back
Top