Date Format 7 129 (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 Server 3 245 (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! 1 120 (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 Question 3 120 (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 forms 3 570 (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 confusion 1 132 (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 value 1 507 (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-form 1 647 (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 set 1 304 (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 Search 8 118 (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