Search results

Hi I have a Child Report with underlaying records from a SELECT DISTINCT. I prints records of prices, I need to show "some_text" if the price is "0". Which event should I use? I tried ChildReport On_Activate but could not pull it off. Many thx

Hi Please help with the syntax of a vba line to get the Text to show the content of the combo box . Private Sub Style2_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single) Me.ControlTipText = Me.Value End Sub many thx

Hi Using Access 2000 under windows XP pro. computers in a LAN, I have a split database on machine1 with the back_end file located in the Shared Documents folder "C:\Documents and Settings\All Users\Documents" and a front_end located in another folder. Machine2 has a copy of the front_end but...

Hi Working with Access 2000 I have a Continuous subform based on a query based on few linked tables.One of those tables has a Yes/No field which shows in the subform. I want to be able to change the status of this field for each record independently, so I placed an unbound check box in the...

Hi I have a command button as a field in a continuous subform which is based on a table. I click it and it opens a report. I need the report to be filtered by the ID of said record and not to show all the records. thanks a lot.

Hi using Access 2000 I have a table with fields (image, info1, info2, info3). I want to produce a report where 15 records are displayed in a table like manner. each table cell contain the whole record and the table is 5 rows by 3 columns. Many thx

Hi I have a Continuous Form with an Unbound TextBox, its Data property has The form Data is based on tblItems I am getting one price for all the records. I expect to get the correct price for each item.. Please help. Thank you.

Hi I have a database I have built and been using for 10 years "Access 2000". It is to manage my customers, service and invoicing. I would like to add booking where I can book x number of services at any time/day segment and be able to have a nice colorful visual for quick view. I have a feeling...

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

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

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

Hi I have both Office 2000 and 2007 on XP. This Access 2000 database is producing an error, when it first starts it opens a Form which has an event as below. Is there a fix please? Thank you Private Sub Form_Activate() 'Maximize the form and Sets size of forms DoCmd.Maximize End Sub

Hi I just opened my Access 2000 file with 2007 office and it gave some Security warning about some VBA macros that has been disabled. I would like to see those macros and decide if I want to enable them. how can I do that? thx

Hi I have a customer database with their phone numbers, I need to run a query to filter by the phone number received from a caller ID to retrieve the customer's records once the phone rings and before I answer. please give me some steps on what needs to be done. I have XP pro and office 2007...

Hi I have a database with many objects of each kind which I built for my business during the last 10 years using Access 2000 under W2K. now I want to add another functionality to it, and that is to retreive customer data once the phone rings using the caller id data. some packages are needed...

Hello I have a command button on a form which fires a report, the report gets its data from a query. I need to filter that report by limiting the data to show only those records between two dates which are on the form. I was able to a bit of that in VBA, so now when I fire the report it just...