Search results

Ahh. No. I did forget to mention something important. The itemID in tblPrice is a combo box with bound column = 2 and data from SELECT [tblItems].[Name], [tblItems].[itemID] FROM tblItems ORDER BY [tblItems].[Name];

I am getting an empty list with my solution or with yours.

SELECT [tblPrice].[ID], [tblPrice].[SupplierID], [tblPrice].[ItemID], [tblPrice].[price] FROM tblPrice WHERE ((([tblPrice].[ItemID])=[Forms]![frmItems]![itemID]));

SELECT [tblPrice].[ID], [tblPrice].[SupplierID], [tblPrice].[ItemID], [tblPrice].[price] FROM tblPrice WHERE ((([tblPrice].[ItemID])=[Forms]![frmItems]![itemID]));

Hi Thanks in advance for helping with this problem. I have a Continuous Form with data from table items (ItemID is the Key), on the form I have an Unbound list with Row Source being a SELECT from a table Prices, the SELECT has Criteria under ItemID field to match the form itemID control...

Hi Thank you for helping. I have a combo box which I use to jump to a certain record in a form in Continuous View. The combo box located in the form header which works fine when the code is attached to the OnChange event. But that works premature when I have not finished typing what I am...

Hi Please help with this request. Thank you. I have a form based on a table which has an image field. the form displays the images OK. How can I make an Excel sheet from this form so that I can email it and others fill in data in it return it back? I tried export to excel but the image did not...

Hi Thanks in advance for your help. I have a form to enter record in its underlying table. One of the table fields is a listbox. I would like "less mouse clicking" the form to remember the last item chosen in the list box so that when I move to a new records I do not have to select it from...

It works with .bmp but not with .jpg

Yes. where 'file' is the name of the image file. In design view, the name is Image which is the name of the field I choose in the underlying table.

As I am working with Access 2000. The control in the report view shows the text which is file.jpg and not the actual image.

Hi Please help with my request. Thank you in advance. I have a report which gets it's records from a table which has OLE Object data type being a "file.jpg". How can I get the image to show in the report print view and also print it with the report? Thanks alot

Hello Please suggest a way to do this. Thanks in advance. I have a table with data like this Field_1,Field_2,Field_3 A,B,5 A,B,3 A,C,7 A,C,6 X,Y,4 X,Y,3 I need a report where I can only see A,B,5 A,C,7 X,Y,4 That is Group by Field_1 and only show the records which has Field_2 with the max...

Thank you. How can I get the query to ask for start and end dates to limit the output records when run?

Thank you. I am sorry I forgot to say that I am using Access 2000.

Hi I have tableA and tableB. I need to get the records in tableA which does not have a match in tableB. The match is found in AutoNumber in tableA and a Text type field in tableB. How can I cast Text into Long Integer and then write the query? many thx

Thank you all.

Using the CD or Add/Remove Programs under Control panel?

do I need to uninstall office 2007 and reinstall 2000 on this XP box?

Yes. Will do. ********* Now I went and opened the database in my W2K under office 2000 and all is sweet. the 9.0 Object Library is listed under Tools > references. I did couple of Compact and Repair to insure all is well. Copied it to the XP Machine which has both offices 2K and 2007...