Search results

Thank you very much.

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

apr pillai The first "best" option. Aren't the machines clients of the LAN in my case? if so, Isn't Shared Documents folder "C:\Documents and Settings\All Users\Documents" a common folder in LAN? (btw, it is accessible to both machines). What do you mean by install the back-end database? Do you...

bingo. thx a lot.

Do I understand you right? Me.ComboName.Value = Me.ComboName.Value ?? This does not make sense? May be you can write the line full syntax to show what you mean please? The control I need to populate is the the "ComboName" but the ControlTip of the "ComboName".

ControlTipText is the problem syntax.

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

Thank you for helping. I changed the relationships and removed on table from the underlying query, got it to work and the missing field from the deleted table I got it in using a Dlookup clause.

It is read only because it has JOIN but that is inherent in the relationship. Are you suggesting that I rethink/change the relationship between tables? Is there another solution? thx

When I click on the Yes/No field "which is also a check box" the computer gives a short beep and nothing changes. tblSold.Paid is what I am trying to update.

Well. I tried to bound it to the records of Yes/No but it will not let me change the status.

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

thx working.

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.

AutoNumber, Text, OLE Object. So they aren't the same.

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

I changed it to Single Form for no avail. How can I overcome this problem? 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...