Grey Box Inside The Checkbox
Oct 13, 2006
I have a checkbox that has a grayed out box inside of it. What causes this/ what is it? I looked up the record and there should be a checkmark in the box. In the table it is set to have one.
I know that if the prefeances of Enables is set to No then all of the check box and the text label box is all grayed out, But in my case it is only the inner part of the box…. (And it is a Checkbox…)
The box name is ABC1 and it just reads the record, that’s it... It is used for reports later down the road. So there is not any code set to this check box.
Anyone have any ideas?
Thanks,
Darkhat01
View Replies
ADVERTISEMENT
Mar 30, 2006
I have a form that has several fields that a user will enter data. When finished, the data is inserted into a table. Works great. What I want to do now is look at one of the fields entered and if it is equal to a certain value, I want to disable one of the other text boxes (fields) on the form AND pop a screen that will allow the user to enter a list of names that will update a different table.
So, if user inputs a directory name GENERIC, the txtScriptName box needs to be disabled/greyed-out and I need a form to pop so the user can put in a list of script names. If any other directory name is entered, the txtScriptName box needs to remain editable. (For directories equal to GENERIC, there will be multiple script names instead of just one)
I've been successful at getting the form to pop if GENERIC is entered but can't figure out how to grey-out the txtScriptName field. I tried using Me.txtScriptName Locked in the Before Update of the preceding field but it didn't work - could still update the txtScriptName field.
Any other sugestions?
Thanks!
Mary
View 1 Replies
View Related
Dec 16, 2013
I'm having a problem with the syntax of a recordset of a Datasheet inside a subform which is also inside a Main Form.
Main Form - frm_1_0_LMS
Subform - frm_1_4_0_TeamApprovals
Subform(Datasheet) - frm_1_4_1_TeamApprovalsList
Here is my code:
Code:
Dim rs As DAO.Recordset
Set rs = Forms!frm_1_0_LMS.frm_1_4_0_TeamApprovals.frm_1_4_1_TeamApprovalsList.Form.Recordset
If Not (rs.EOF And rs.BOF) Then
Forms!frm_1_4_2_ApproveDeclineUserLeave.Controls("lblFiledDateLeave").Caption = rs!Leave_Date
End If
I am getting this error: Object doesn't support this property or method
View 1 Replies
View Related
Sep 16, 2005
quick question... i have a form with a "Save" button. i wanna disable/grey all the fields when user push the button, so they will not be able to make change... please help.
View 2 Replies
View Related
May 23, 2006
Hi,
I have a group of option buttons. A user can select more than one. However, currently all of the option buttons have a grey spot in them except for the first one which is blank. I want all of the option buttons to be blank.
Any thoughts?
Thanks
View 2 Replies
View Related
Aug 1, 2006
I have a form with two cascading combo boxes. The options available in the second box depend on what is selected from the first.
Some of the selections which can be made in the first box do not have any options to be selected in the second box and so it currently just pops down empty.
Is there a way that I can make the second box "greyed out" if there are no options for it?
Thanks,
Gary
View 13 Replies
View Related
Nov 3, 2013
This seems like a really simple question but I have searched everywhere and can't find a solution.
I have a main form with a subform. The subform is in datasheet view.
How do I remove the grey bar from the left of the subform. I.e the row selectors where you click to highlight the entire row
I have attached an image in case
View 5 Replies
View Related
Mar 10, 2008
I have a query that updates a field on a table with the value in another field. When I run the query from the Access control panel, the query does exactly what it should do, 100% perfect. When I call the query using DoCmd.OpenQuery in VBA in an OnClick function on a form, it does not work properly, only appending certain amounts of information, leaving some fields blank.Can anyone shed some light on this.the SQL for the query is:UPDATE tblHolding SET tblHolding.CostGRV = [tblHolding]![OrderCost]WHERE ((([tblHolding].[Item Code])=[tblHolding]![Item Code]));It populates another field in the same record in the same table as itself.tblHolding is populated by a Subform on the Form that has the button that calls this query when clicked.Hope I am making sense.
View 3 Replies
View Related
Oct 23, 2005
Hopefully just a simple one??? I am using a popup form to input data into a display form which is on one page of a tabbed control. The display form updates through an afterupdate requery command. This all seems to work OK but when I enter the new record via the popup form then close it, it leaves a greyed out space and I lose input ability. I need to close down and when opened up all records are OK. If I drag the popup box on the screen it leaves a grey trail behind it. Any ideas on what could be the problem?
Thanks
View 1 Replies
View Related
Oct 24, 2013
I am trying to use a check box to either grey out certain text field(s). For example If the box is checked true then certain fields would become available to input data. If the box is not checked it stays grayed out.
View 8 Replies
View Related
Mar 29, 2005
is it possible? if so, how?
thanks
View 2 Replies
View Related
Jan 7, 2005
I've been trying unsuccessfully, but i'd like to put a tab control on the page of another tab control. is this possible? i don't see why it wouldn't be.
Thanks
View 1 Replies
View Related
Oct 16, 2013
i add a tab control, but i want to insert a table inside my tab how can i do that?..cant find any tables in my design tab when i work on my tab control
View 1 Replies
View Related
Jul 27, 2007
My following sql statement is wrong. "Scenairovalues Step02" is the table name. How should I write this one with the empty space in the name?
vtSql = "Select * from Scenairovalues Step02"
Thanks a lot in advance!
View 2 Replies
View Related
Mar 19, 2006
I have a table with the following fields:
Record_No <--- This is an autonumber field
Est_COE --Date Field Type
DATE_DOCR
DATE_Followup
Progress
I then have used multiple querries that just count records based off of Status:
Example of one of the querry's:
SELECT Count(borrower.Record_Number) AS Close_Of_Escrow
FROM borrower
WHERE (((borrower.Est_COE) Between Date() And (Date()+7)) AND ((borrower.Progress)="active"));
Another Example of one other querry:
SELECT Count(Borrower_Journal_Notes.ID) AS Followups_Not_Done
FROM Borrower_Journal_Notes
WHERE (((Borrower_Journal_Notes.Follow_Up_date)>Date()) AND ((Borrower_Journal_Notes.Followed_Up_Complete) Not Like -1));
Then I put both these querry's into a another querry so i can get the data put into a single form using one record source. (The master querry)
View 3 Replies
View Related
Jan 4, 2008
here's my problem...
i have a crosstab query where in one field (value) has a range of 1 to 19.
I used the min and max for two separate row headings....
the min and max works only on values (1 to 9) or (11 to 19)
example... the 2 columns have values 8 and 4
the min returns 4 and the max returns 8
however, when the values became a mix of single and double digit (e.g. 11 and 8)
the min returns 11 and the max returns 8
does the min function on compares the values with only the same digits?
pls help.
View 3 Replies
View Related
Feb 1, 2005
I've been trying to figure out but can't come up with the proper expression or code to do what i want to.
basically when I focus on a field I want it to first check if there is any data/value in it and onyl do a DCount if there is and otherwise not (IE if the field is null skip the DCount)
I figured it would be similar to IF [Host] = 'NULL' THEN (Nothing here) ELSE (DCOUNT here)
But each time I try i get a syntax error, could anyone shed light on what is the proper code for such a thing?
View 1 Replies
View Related
Jan 21, 2005
Hello everyone, its been a while since i asked for advice.
This is probably a silly question, so if it can't be done, please let me know. you would save me time in trying to makeup code to perform the action.
Is it possible to have a Report embedded into a Form. [i was guessing that the sub report/form] is where to start.
If that can be done, i would then have to find a way to get the embeded report to link to a primary key. And also size the report view to around 50%
.......... now ive wrote this, i'm more sure it can't be done, so what the heck, i'll check with you geniuses anyway
Best Regards
Aaron
View 3 Replies
View Related
Jun 2, 2006
I am looking to subtract number inside the same field. and then return the difference to a new field (column). This data is used to generate a graph and the this is currently done by hand. I know there has to be an
easier way to do this.
Below is an example of what I am looking for.
I have a table called Numbers, and fields or columns called...
Value(s) Result(s)
-70 0
-70 1.02
-68.98 1.09
-67.89 3.11
-71 .71
-69.29 1.52
-67.77
So what I am doing is subtracting row two from row one. The difference is then put in another field(column) in row one. The process repeats, row three from two, four from three, five from four, etc, etc. This occurs for hundreds of rows.
Is there a SQL statement that can do this? Your help is much appreciated!!!
Thanks for your help.
View 3 Replies
View Related
Oct 6, 2005
I created a help file in access that lets you have text mesasge up to 1024 chars. Just press F1 key on any control that you have setup to bring up help message.
Does any one see any problems with the way I did this?
Form
Help File: = ""
Help Context ID: = 0
For each control on the form where you would like to have a help message do the following.
Form
Control
Help Context ID: = Set to one of the help index numbers in the help table.
Add KeyDown Event to the control
Private Sub Text0_KeyDown(KeyCode As Integer, Shift As Integer)
'Add this line
KeyCode = DisplayHelp(KeyCode, Me.ActiveControl.HelpContextId)
End Sub
module
Function DisplayHelp(KeyCode As Integer, HelpContextId As Integer) As Integer
Dim dbs As DAO.Database
Dim rstRecords As DAO.Recordset
If KeyCode = VBKeyF1 Then ' 112 = F1
Set dbs = CurrentDb
Set rstRecords = dbs.OpenRecordset("SELECT tlbHelp.Index, tlbHelp.HelpMessage " & _
"FROM tlbHelp WHERE (((tlbHelp.Index)=" & HelpContextId & "));")
With rstRecords
If .RecordCount > 0 Then
Call MsgBox(!HelpMessage, vbInformation, "Help")
End If
End With
DisplayHelp = 0 ' Clear KeyCode
rstRecords.Close
Set dbs = Nothing
Else
DisplayHelp = KeyCode
End If
End Function
Create Table and Fields
Table Name: tlbHelp
Field Name: Index as Number
Field Name: HelpMessage as Memo
Field Name: FieldName as Text
Field Name: FormName as Text
How type in custom number and message for each help message.
View 2 Replies
View Related
May 28, 2007
hi everyone..
can the text in the listbox be printed?? not the entire form.
View 3 Replies
View Related
Dec 22, 2007
I wonder if you can help me. In my query, for this calculated field, i get an error message about a syntax error missing operator in query expression.
what did i do wrong? thanks
FormulaID is a text field.
UnitRM Combined: nz(DLookUp("UnitRM Combined","QryFormulaSummed","[QryFormulaSummed].[FormulaID]='" & tblCostJunction.FormulaID & "'"))
View 5 Replies
View Related
Jun 14, 2005
I've been testing my scripts so my database has a whole bunch of bogus records in it. I'd like to simply delete everything out of my orders table (there aren't any legit ones in there yet) so that I can start over when I go live and not have all that crap in there.
Is there an easy way to do this without re-creating a blank database and copying/pasting table only over?
View 2 Replies
View Related
Jun 28, 2005
Not sure where to start here, I have a subform which spits out query results. Next to the SERIAL field in each record I have a button (ADDSN). On my main form I have a listbox (SNLIST). I want to be able to click the button and have the associated SERIAL field be added to the listbox. I know how to add data to a listbox but I do not know how to add the data from a certain field selected records. How do I access this information?
Thanks.
View 2 Replies
View Related
May 12, 2006
Hi
I have 5 PC clients and a server.each user upon shutting down his PC,is prompted to send all the information inside a table "Patron" to a table inside the server.That way each user backs up his information to a table inside the server and at the end of the day,the table on the server side contains all the data from the 5 PCs.I am new to access,can anyone guide me through the steps I need to accomplish this project?
thanks in advance
View 1 Replies
View Related
Aug 5, 2015
I have a table with all my contacts. Manufacturers, distributers and outlet shops. I want to be able to make relationsships that show which manufacturers sell to which distributers and outlet shops, but at the same time I also want to be able to see which manufacturers are being sold by a particular outlet shop or distributer.
I am reading everywhere that you need to make a table to link the 2 tables together for every one relationship you have and this I understand. Most of the time it is relations between 2 tables that you want to establish. But in this case all these companies are in the same table. Can I still make a many-to-many relations ship between different items that are all in the same table using one single extra table that holds these relationships?
View 6 Replies
View Related
