kledki
Last Activity: Sep 6 '19, 04:40 PM
Joined: Jul 10 '19
Location:
-
Thank you both for your help, I solved my own problem. I checked the function 100 times, but there was one typo I just wasn't seeing! I feel silly for stressing out about it now -
You're right, I misspoke when I said CartonDateCode, it should have been CartonDateForma t.
I deleted the space, but I am still getting an error in the text box when I switch over to form view.
Code:=DLookUp("[OutputDateCode]","DateCodes","[CatonDateFormat] =" & [Forms]![ProductionReportLandscape]![CartonDateFormat])Leave a comment:
-
Runcode recieving error 2425
In MS Access 2010,I am trying to write some code to a module that I can then use RunCode to run from an AutoExec macro. I have written the code that I think should go in the module and get no errors when I debug/compile it. But when I try to use Runcode and run the macro I get error message 2425 which states "the expression you entered has a function name the Microsoft Access can't find." I checked to make sure that the name of the function... -
DLookup expression as control source results in error
I have a text box control on a form. I would like this text box to display a value from a table that is not the form's record source. To do this, I am attempting a DLookUp expression. The table that contains this target is called DateCodes. The field that I would like returned is called OutputDateCode. I would like the OutputDateCode that matches the CartonDateForma t for each record to be returned in the text box.For example, if CartonDateCode= 13,... -
Transferring specific data between access and excel
Hello. I have kind of a ridiculous question, I will explain it the best that I can.
In Access 2010, I have a form with several text controls. There are also two controls that are unbound combo boxes. Upon a new selection being made from these boxes, is it possible to transfer the contents from just these two controls to specific columns in excel so that they may be used in an existing formula?
I'm tempted to think that... -
Thank you so much for your helpLeave a comment:
-
Yes it is in a separate moduleLeave a comment:
-
Open subform via command button
I was wondering if it is possible to open a subform via clicking a command button on the main form? Just looking for a yes or no here so that I have a better idea of what possibility to pursue. Thanks! -
Call function from macro using RunCode
I have a function tha I have written which I am trying to run from a macro using Runcode. The macro that I am trying to call the function from is the OnClick event of a command button. Basically, I want to print a different page of my reort dependent upon the value in the text control "Text28." But when I press the button, the code is function is not running and I can't figure out why. Any suggestions would be very much appreciated! Here... -
Thanks! I figured it out nowLeave a comment:
-
PrintObject Macro
I am working in Microsoft Access 2010. I can't seem to find what I am looking for. Would someone be able to tell me what the PrintObject macro action does, and how to use it? I have searched all over the internet and am not finding the information I need. I would love it if someone could help me out. Thanks so much! -
Print all open database objects
I need two reports to print at the same time. Repor1 is always the same. There is a button on Report1 that when pressed will open one of several other reports based on the value entered in one of the controls on Reprt1. This report becomes Report2, the second report that I need to print. Basically Report1 is a given and Report2 is a variable that changes from record to record. Once they are both open, I would like to be able to print both of the... -
Firstly, the ccode example that you provided was invaluable, so thank you. Secondly, I still have a problem. So the "QualityFor mat" control is updated after a selection is made from a combo box on the same form called "Resource ID." The code that I have will work properly if "QualityFor mat" is typed in manually, but not when it is automatically updated after a selection is made from the combo box. Why is that? Does the...Leave a comment:
-
By that I mean that when "QualityFor mat" is updated, nothing is happening. The other forms are not opening....Code:Private Sub txtQualityFormat_AfterUpdate() Select Case Me.txtQualityFormat Case "QualityFormat= SG Industrial" Call DoCmd.OpenForm(FormName:="SG_Industrial") Case "QualityFormat= LG Industrial" Call DoCmd.OpenForm(FormName:="LG_Industrial") Case "QualityFormat=
Leave a comment:
-
Please excuse my ignorance on this, I'm pretty new to coding within Microsoft Access. Here is my cade now but I still cannot get it to work:
...Code:Private Sub Quality_Format_AfterUpdate() Select Case Me.txtQuality_Format Case "A" Call DoCmd.OpenForm(FormName:="SG_Industrial") Case "B'" Call DoCmd.OpenForm(FormName:="LG_Industrial") Case "C" Call DoCmd.OpenForm(FormName:="SG_Retail_Carton")
Leave a comment:
-
Okay, thank you guys. I see now how my terminology may have been confusing and will try to be better about that in the future. By Group2, I simply mean the group that contains forms A, B, C, and D. I have changed the name of the "format" control to "Quality Check" in order to avoid confusion. I attempted to use the code that you provided, but I'm sure I did something wrong because nothing is happening after the control is updated....Leave a comment:
-
opening corresponding forms or reports
I am working in Microsoft Access 2010.
I have a form called "Production Report." There are several input fields on this form, one of which is called "Format."
I also have several other forms, Group2, that correspond to the different values that can be entered in "Format." For example, the "Format" field can be populated with either A, B, C, or D. Based upon which one of these... -
Thanks for your help. I've decided to take both of your advice and rethink my approach!Leave a comment:
-
They are independent forms, open simultaneously. FormA is called "Production Report" and FormB is called "Quality Record." There is also a table called "Product Master Data." This table is the record source for FormA. The top field on FormA is a combo box called "Protean Resource" and once a resource is selected from the combo box, all of the fields beneath it on FormA are populated with the information for...Leave a comment:
-
Passing data from one form to another Microsoft Access
I have one form, FormA, with multiple fields that populate automatically based on the selection from a combo box. I have another form, FormB, that needs the same information as some of the fields on FormA. Once a selection is made from FormA's combo box and the rest of the fields are populated, I would like the information from some of those fields to automatically be transferred/shared to the corresponding fields on FormB. I am just learning Microsoft...
No activity results to display
Leave a comment: