I've scrubbed the database of real info added some fillers, i tried to remove all logos and identifying stuff, if you see any please let me know.
The database is still under construction so there are some buttons and stuff that don't work yet.
A copy of my table and form structre is attached.
Thanks,
X...
Xenver
Last Activity: Aug 21 '14, 12:00 PM
Joined: Jul 21 '14
Location:
-
There is a table which stores the notes for each credit called "tbl_Credit s Notes" Each credit has its own column for notes, and there is a project number column to track what project the note is about. The notes are stored as a text string in this table.
The "Notes" button is located on a form which is used to view the credits for each project called "frm_Projec ts Credits. Each credit has a button on this...Leave a comment:
-
Ok, to help you understand why i wanted to do this i'll start by giving you a little context about what the database is actually for.
I work for a large engineering company, many of the buildings we design pursue certification under a system called LEED. LEED is a green building rating system which helps to encourage environmentally friendly building design. Basically to achieve LEED certification you have to implement certain design...Leave a comment:
-
I'm not updating the value of the field, I'm updating the fields control source. The textbox is being used to enter notes/comments on various project credits, i want to update its control source so i don't have to make about 50 forms ( that'show many credits i have) that perform essentially the same function.Leave a comment:
-
twinnyfo,
Thanks so much for your help on this and my past questions, i managed to figure out the code i need by messing around a bit, i got this:
working after i realized that there was no item on the form named SS 2, that item is in the query.Code:[Forms]![frm_Credits Notes]![Notes].ControlSource = "[SS 2]"
Thanks again, im sure I'll have more questions in the future!...Leave a comment:
-
I probably should have mentioned that the notes form, "frm_Credit s Notes" is a continuous form. When i use the above code all the textboxes update to mirror each other and the text i enter doesn't show up in the table.
Thanks,
XLeave a comment:
-
I probably won't be able to tell you haw to do this, but if you want help you're probably going to need to give us more information, what function are you trying to deactivate? what function are you trying to implement? What version of excel are you using?Leave a comment:
-
Thanks for the response!
When I exclude the quotes and double equals like you have above I get a error:
Run-time error '13': Type mismatch
Thanks.Leave a comment:
-
Changing the control source of a textbox
Hi All,
I have many buttons on a form, i want each of these buttons to open the same form but change the control source of the textbox on the form so i can use it to update multiple fields and not have to create a bunch of forms to do the same thing. All of the fields being updated are on the same table, the control source of the update form is a select query which is based on that table.
my current code is this:
... -
Hey,
I checked, and all the check boxes had their triple state property set to No, but for some reason when the form was first opened, until they were clicked they started with a blue fill, I'm guessing that indicated a null value because i went through and set all of their default values to 0 and the blue fill went away and everything works fine now. Thanks a lot!Leave a comment:
-
Ok,so I'm using the code in an OnLoad event, and translated to use my forms names it looks like this:
...Code:Private Sub Report_Load() Dim strValues As String strValues = "" If [Forms]![frm_Reports Credit]![SS 1] Then If strValues = "" Then strValues = [Forms]![frm_Reports Credit]![SS 1] Else strValues = strValuesLeave a comment:
-
Hello,
Thanks yes this is very helpful. I think i can use this to do what i want to do but... this is a little embarrassing but i don't know where to enter the code... whenever I've used code before it's been in the code builder for an event (on click etc.) Thanks for the quick response too, everyone on this forum is so helpful!Leave a comment:
-
Displaying text based on multiple checkboxes
Hello All,
So I've got a form with multiple check boxes on it, the user makes selections on this form then clicks next, this opens a second form, on this form i would like to display text in an unbound text box based on the boxes the user has selected.
so if the user selects check box 1,5,and 7 i would like the text box to display:
1,5,7
Is this possible?
Thanks. -
Thanks Guys, you were all very helpful.Leave a comment:
-
IIF statement in query criteria based on checkbox
ok, so i have a form with unbound check boxes on it, i want to alter a query criteria based on the check boxes values,so i have this as an example of my query criteria:
SS 1 is the check box I'm trying to evaluate.>0 is what i want the query criteria to be if the box is checked, Null is the value i want the criteria to be if the box is unchecked.Code:IIf([Forms]![frm_Reports Credit]![SS 1]=True,>0,Null)
... -
Hello, i realize I'm probably not making much sense, so i made a stripped down version of the db for you to look at, there are still some buttons that don't work and stuff, but it should get the point across. Hope this helps. yes i know the tbl_Projects_Cr edits is a nightmare in terms of normalization, but it's all i could figure out within the time i can devote to this....Leave a comment:
-
I'm sorry, I must have mislead you, the report will not be open when the button is pressed. With the code you gave me in the report's module the button creates a shortcut to a pdf that doesn't exist in my recent items. The shortcut says it's target is a PDF in my documents folder but windows cannot find the document and it doesn't seem to exist.
also when i press the export button now it prompts me to input a value for whatever the...Leave a comment:
-
The Button is on the form. I think i see what you're saying, I need to change the record source of the report, not the form. How do i go about doing that while keeping the button on the form?
I thought by using these lines:
I would be changing...Code:strNewRecordSource = "SELECT * FROM [qry_Projects Credits] WHERE [Project Number] = " & Me![Project Number] Me.RecordSource = strNewRecordSource
Leave a comment:
-
There are other blocks of code, but i don't think they'll interfere with this one, for the most part they just open/ close forms with the DoCmd.Open[object type] or DoCmd.Close commands. The only one more complicated than that runs an append query that updates the query that this form uses and sets warnings off/turns them on, it looks like this:
...Code:DoCmd.SetWarnings (WarningsOff) DoCmd.OpenQuery "Project to project credits Project
Leave a comment:
-
use DoCmd.OutputTo to export a PDF of the current record on a report?
Hello,
I want to create a button on a form that exports the current record on the form to a PDF of a report. I've taken the code i found here:
http://bytes.com/topic/access/answers/909411-can-i-use-docmd-outputto-export-current-record-only
and modified it to be this:
...Code:Private Sub Command481_Click() Dim strOriginalRecordSource As String Dim strNewRecordSource As String
No activity results to display
Leave a comment: