Sorry about that. I made a mistake. Do what NeoPa said.
comteck
comteck
Last Activity: Oct 26 '06, 05:34 PM
Joined: Jun 29 '06
Location: Edmonton, AB
-
Try this. First, set the "Enabled" property to "No" for all textboxes, comboboxes, etc that you want greyed out. Then for the OnExit property for the textbox that you want the others to be dependant on, create an Event Procedure with the following code:
If Me.textbox1 <>"" Then
Me.textbox2.ena bled="Yes"
Me.textbox3.ena bled="Yes"
Me.combobox2.en abled="Yes"...Leave a comment:
-
Sorry Killer.... it did work for me. Might be a different case here. However, not everybody is correct in their solutions that they offer on here. Normally however, people are not rude about it....Leave a comment:
-
Not sure what you're looking for.Leave a comment:
-
What??????????? ??Leave a comment:
-
Not 100% sure, but you may have to change the language of the keyboard.
comteckLeave a comment:
-
No it does not.
comteckLeave a comment:
-
I don't know if you can rename a field on the fly. If you can, it's not done with the ALTER TABLE statement. ADD COLUMN or ALTER COLUMN can only be used with ALTER TABLE. RENAME COLUMN cannot be used.
You may have to rename the field from the design view of the table. Just a word of caution.... if you rename fields in your table, it may affect all queries, forms, etc. that are associated with that table.
comteckLeave a comment:
-
Create a query based on the table that you are checking for duplicates from. Call the query "qryDuplicates" . Open the query in design view, and enter the following statement in the field that you are checking for duplicates (i.e if you are checking for duplicate serial numbers, and that field is called "serialnumber") , enter this statement in criteria under the field "serialnumb er":
In (SELECT [serialnumber]...Leave a comment:
-
Use "UCase" as NeoPa suggested, but also add an ELSEIF statement. It should look like this:
...Code:Private Sub Form_Open(Cancel As Integer) mUser = InputBox("Please sign in: ", "User Sign In", , 5000, 5000) UCase(mUser) Debug.Print mUser Debug.Print Len(mUser) If mUser <> "JG" Then MsgBox "Incorrect Entry!", vbCritical 'DoCmd.CloseLeave a comment:
-
How about a little more information.
comteckLeave a comment:
-
Well, I'll need a little more information on your tables (including field names and PKs). As well, I need to know what the Record Source is for the report, and what is the combo box based on?
comteckLeave a comment:
-
Are you trying to do a JOIN, where you have a form based on more than one table, or on a table and a query?
comteckLeave a comment:
-
I'm kinda confused. Did the Min, Max functions work, or was it not what you were looking for?
comteckLeave a comment:
-
I think this is what you are looking for. Try this:
Open your form in design view, and open the properties. Assign the query to the Record Source of the form. Now when you add controls, such as textboxes, combo boxes, etc to the form, you open the properties for those controls, and click on the Control Source. You will have a list of all the fields for the query. Select one.
Close and save the form.
...Leave a comment:
-
As far as I know, a report is just that.. a means of displaying data. I don't believe it is possible to make a selection in a report. You can however, make a selection from a combo box on a form, and then have this selection displayed on the report.
comteckLeave a comment:
-
Is your first date your lowest date, and your last date your most recent date. If they are you can use Min, Max. Create a textbox for the first date, and in the Control Source, type:
=Min([Date])
Create another textbox for the last date, and in the Control Source, type:
=Max([Date])
This is assuming that the field containing the dates is named "Date". If not, use whatever name...Leave a comment:
-
Do you want the new value to be stored in a table, or just appear in an unbound textbox?
comteckLeave a comment:
-
I think there must be a way to do it because if you look at the Northwind database that comes with Access, there is a tab control used on it. Its background color is different from the default color.
Thank you for the replies by the way.
comteckLeave a comment:
-
There's something I'm not understanding here. Why do you have your table set up to display 4 decimal places, when you only want 2 for your currency?
comteckLeave a comment:
No activity results to display
Leave a comment: