Search results for query: *

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...

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...

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...

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.

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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.