Date Format7129 (4/27/2007 5:18:08 PM) I have a Textbox with a number in it. 042707 I need to convert this number to a date 04/27/07 and then compare it to the current date to see if it matches If Me.TxtNumber = Date() Then MsgBox "Matches" ... DS
mde upsizing to SQL Server3245 (4/27/2007 10:50:59 PM) I have a mde database that I need to upgrade to SQL Server using the unsizing wizard within Access. But the wizard wont allow upsizing an mde. I thought of opening a new empty mdb and copying all the tables a... Dave
Combo Box Code needed!1120 (4/28/2007 1:55:30 AM) If [tbStatus] is "Finished"set this Combo box to "No" Thanks for any help.....Bob ... Bob
A2K format - BeforeUpdate Question3120 (4/23/2007 12:11:36 PM) G'day ppl Have a form which after the user has completed all data input can invoice job out. I have a command button: Private Sub InvoiceBtn_Click() Dim InvoiceResp As Integer InvoiceResp = MsgBox("... NoodNutt
Textbox fields on continuous forms3570 (4/27/2007 8:16:02 PM) How can you have different coloured text in a text box of a continuous form. For example I would like the text to be red if the value is 25% or greater all other value should have black text. The data type is... Utf
form focus confusion1132 (4/27/2007 7:19:33 PM) on a form I have a tab control behind the form is this code (referring to the tab control): Private Sub Form_Activate() Me.pgDATA.SetFocus End Sub on one of the pages (not pgDATA) I have a command button ... mark
Referencing a field in a recordset with a string value1507 (4/27/2007 7:20:04 PM) I attempted to reference a field in a recordset by using a string, but the field is not being recognized. The field name is a string b/c the code is within a do...loop statement where it goes through a serie... Utf
Passing value from form to sub-form1647 (4/27/2007 6:01:19 PM) How do I do this? Specifically, when the form(s) open I want to set the value of an option group on the sub-form. ... JimP
Stepping through a Record set1304 (4/27/2007 5:26:04 PM) I need to step through a record set too compare values. Normally I would create a form to do this. Is there a way to do this in code only? ... Utf
Form Search8118 (4/24/2007 2:07:23 PM) Hi all, I have something in mind that I would want to create any help would be appreciated. I have two tables "TransactionDB" and "NewCards". Both tables have one same field "Card_No". Table "NewCards" have to... khashid