Search results

Hi sxschech. Thanks for replay. I have query and result of it look like: Name| Q1 | Q2 | Q3 | Q4 -----+----+---+----+----- AAA 12 45 78 59 AAA 16 48 71 65 AAA 18 42 72 61 Is it possible create a chart based on this query and use value of column NAME like...

Hi All. I have form with ComboBox that has list of projects. And I created chart report that reference for those projects. I would like when user will select value from project list and click button to open report so report will display project name as a title. How it to do? I will appreciate...

Hi. Thanks for replay. I have embedded object in the form but absolutely forgot how I link that object to source and where I can find it in design mode. Thanks.

Hi All. In my old DB I wanted to modify OLEUnbound field but I forgot how I link it to the source. Where is source? In the property of that field in Data tab: Source Doc ..........| Source Item .........| Link Master Fields...| Link Child Field.......| Row Source...........| OLEType...

Thanks for help. I used plus sign like in SQL Server not &. Now is fixed. Thanks

Yes, you are right. I tried concatenate Facility_code of facility table and AutoNumbet ID field of main table but got error. What is a problem? Thanks

Hi CBrighton. Thanks for replay. I need generate identifier for each new record. Thanks.

Hi All. If is possible generate user identifier? I mean user generator ID with any charters letter and number not table ID AutoNumber. Thanks.

Hi PNGBill Thanks for help. It is works.

Hi All I ceated simple query that sorted in desc order SvcDate. And created report besed on that querty with count total record like ="Total " & Count([CountField]) & " Patient(s)" in report footer. Without count field the report in desc order when I incude count field I'm loosing order. What is...

In Detail form I create or edit record. That I validated to correct data. When if all data is correct record is saved and close Detail form that ListBox of Main form display it at the bottom of list. I would like at this moment highlight and point new record. Now when I return to Main form first...

Thanks A lot. Validation is done. Now all inporten fields are fill and Save event is executed new record come up on ListBox of MainForm. I would like at this moment highlight and point new record in ListBox. Or other words. New record will append at the bottom of LIstBox. How to hightlight new...

My border style is solid and under validation condition code about border Me.txtLName.BorderColor = RED Thanks for help.

Hi Paul. Thanks for replay. Validation almost done. Only when field is validating I cannot get red border for according field(s). And other problem. When everything is OK and Save event is executed new record come up on ListBox of MainForm. I would like at this moment highlight and point new...

Hi All. On Save_Click procedure I insert code: If IsNull(Me.txtLName) Then MsgBox "Please enter Last Name." Me.txtLName.BorderColor = 255 Cancel = True Else Cancel = False End If But after my error message I got system error message: "Object doesn't...

Hi All. In my detail form has field that I would like to validate during enter process. For 3 TextBox and 1 ComboBox I would like create validation if user forgot enter data and couple TextBox number of entering characters must =7. If is it possible how create those validation when user open...

Hi All. Is it passible to use diferent data sources to each tab control pages? If yes how use tableA for Page1 and tableB for Page2 of tab control. Thanks.

Yes. Existing records to keep original date and time. Next new records will store data depends on date and time when form will opened.

Thanks for replay. Yes that is right if need to display current date and time. I would like to do by this way, of cause if it posiable. For instance, I saved record1 with date 5/26/09 and time 11:00 AM in Date and Time of Table1. Next time when I open record1 of Form1 fields txtDate and txtTime...

Hi all. In my form I have 2 textbox that display current date and time Private Sub Form_Timer() txtDate1.Caption = Format(Now, "mmm d yyyy") txtTime1.Caption = Format(Now, "hh:mm AMPM") End Sub I would like when user close form by save evet values of current time and date save in Table1...