Recent content by a.sinatra

Private Sub Form_Load() Dim strTime1 As Date Dim strTime2 As Date Dim strTime3 As Date strTime1 = Time() strTime2 = "10:00:00 PM" strTime3 = strTime2 - strTime1 Me.txtTime2 = Format(CDate(strTime3), "hh:nn:ss") End Sub You can go from here, set it up on a timer so it updates, you could also...

bump bump bump ________ Find headshop

I need code that will set all my control to the description i supplied in the table... Me.sDOB.Name = Me.sDOB.StatusBarText That's what i have now, i just need to make it so that all the controls use it. ________ Ford Pinto Picture

NZ Function ________ Honda Ruckus

NZ Function ________ WHOLESALE VAPORIZER

To make the hidden access window work, you must set all forms used to modal & pop-up. ________ STAR CRAFT REPLAYS

I kinda don't undertsand what you are saying, "activate". Your autonumber should only be for internal use, it should not be seen/used by the end-user. ________ Ultram rehab forums

Hrm. Alright, AXP & A2k3 have it. (Sorry about that) ________ Chrysler tevan specifications

Try this: SELECT [fiftykLabel] AS [section] FROM [SELECT a.section_label as fiftykLabel, b.section_label as twofivekLabel from [dsw 50k ends] as a left join [dsw 2500 ends] as b on a.section_label= b.section_label]. AS [%$##@_Alias] WHERE [twofivekLabel] is null; ________ Chevrolet Beretta...

Go to the reports properties and set the report to a pop-up & modal. The only problem you will have is there will be no "print" function if you need one because the access window will be hidden. ________ Vaporizer Affiliates

This will most likey be done in a query, but post you will need to post your table information. ________ Elysion

This is posted in the "Tables" Forum, are you using/wating a lookup value in a table or a form? Table (i don't recomend this): Default Value: Format(Date(), "mmmm") Form (used for entering data, i like :D ): Private Sub Form_Load() Dim dtNewMonth As Date Me.cboMonth.RowSourceType = "Value...

Your subform isnt set up correctly or you have a wrong link establishing them. ________ Girlfriend Pictures

Cascading Combo Boxes ________ BABI MAC

Ya.. ok? It works the same way for the subform. :rolleyes: ________ oxygen vaporizer