Isladogs,
I had not thought about setting it up that way. I appreciate you responding.
privateguy
Last Activity: Feb 22 '21, 12:52 AM
Joined: Mar 3 '18
Location:
-
privateguy replied to Entering multiple preset values in a table that is different with each new record?in AccessNeoPa,
I have read many of your other posts in the past. They are always well thought out and you always give deeper insight that the original poster may or may not have considered. So thank you for sharing your thoughts.
I had grappled with joining the tables, but did not think it was a good idea when I had to enter a onetime reminder. Our thought process is similar. I have other fields to give me greater flexibility....Leave a comment:
-
privateguy started a topic Entering multiple preset values in a table that is different with each new record?in AccessEntering multiple preset values in a table that is different with each new record?
I have 2 tables, one called Reminders and the other one is named Preset Events. The tables are not joined. The Preset Events table mirrors the Reminder’s table except it does not contain the Date field or the Person’s ID associated with the event. The Preset Event table contains default values for a given event, i.e. for a wedding anniversary, I may want to be reminded yearly and given a notice 2 weeks before the event. The duration for this... -
privateguy replied to How to replace the name of a form within the syntax with the value in a textbox?in AccessTwinnyfo,
Yes. The structure of NeoPa's syntax as well as yours worked without error! Two different ways of accomplishing the same task. In analyzing them, I see the distinct value of both. For brevity, I like using the ! mark instead of having write out the word Controls.
I give kudos to both you and NeoPa. I say to both of you that I am very appreciative of your expertise in helping me solve this problem. I humbly...Leave a comment:
-
privateguy replied to How to replace the name of a form within the syntax with the value in a textbox?in AccessRabbit, if I only had one sub form, there would be no need to do it the way that I am; however, if I have let's say 20 sub forms that contain unique data, it makes sense to only re-query the sub form that was edited. I hope this gives you clarity. Thank you for responding.Leave a comment:
-
privateguy replied to How to replace the name of a form within the syntax with the value in a textbox?in Accesstwinnyfo, I tried that as well. The error it produced was that it could not find the field. I have tried using strings, setting the value of the textbox as a control without any success. Unless some other guru knows of a way to do this, I am going to be stuck with using the Select Case statement. I appreciate you giving thought to my problem.Leave a comment:
-
privateguy replied to How to replace the name of a form within the syntax with the value in a textbox?in AccessNeoPa, I did not see the solution to my problem in your post. I understand that sub forms are controls as well as the syntax to reference the appropriate control. Your post does not state, for my problem, how to take the value of the textbox, which can change, and insert it into the syntax without causing an error. I was hoping there was a way to accomplish this with only a few lines of code instead of me having to writing many lines of code if I...Leave a comment:
-
privateguy replied to How to replace the name of a form within the syntax with the value in a textbox?in AccessNeoPa, thank you for responding. Your article on how to refer to forms and sub forms is awesome; however, that is not my problem. The syntax that I am using works if I hard code the name of the sub form. My problem is trying to use a variable for the name of the sub form so that I can use the value in the textbox.Leave a comment:
-
privateguy replied to How to replace the name of a form within the syntax with the value in a textbox?in AccessIt causes an error as well. The "(" after the "!" causes the first error. I tried using a string. I tried assigning a textbox value to a variable, but both did not work as well.Leave a comment:
-
privateguy replied to How to replace the name of a form within the syntax with the value in a textbox?in Accesstwinnyfo,
I tried using brackets as well. Using "me" causes another error.
Removing the "me" causes the error that it cannot find the field.Leave a comment:
-
privateguy replied to How to replace the name of a form within the syntax with the value in a textbox?in Accesstwinnyfo,
Thanks for responding. I wish it was that simple. Unfortunately, that does not work. It causes the following error "Compile error: Expected identifier or bracketed expression."Leave a comment:
-
privateguy started a topic How to replace the name of a form within the syntax with the value in a textbox?in AccessHow to replace the name of a form within the syntax with the value in a textbox?
I have a form that contains 3 sub forms with the names sub1, sub2 and sub3. Each sub form has a button that pops up the same form. When the user clicks on the sub form button, the name of the sub form that called the popup form is stored in a hidden textbox so that the name of the sub form can be used to requery the sub form once the popup form is closed. The syntax to requery the sub form is:In this syntax,...Code:Forms!Mainform!Subform.Requery
-
privateguy replied to How to write query to extract date only for different customers on the same day.in AccessTwinnyfo,
This is my first time in seeking assistance on a forum. To be honest, I don't know what you mean by using Code Tags when pasting code. I will try the examples provided. Thank you again.Leave a comment:
-
privateguy replied to How to write query to extract date only for different customers on the same day.in AccessThank you both for your replies. I am using VB. I had the same logic in mind but did not know of an easy way to write the query. In both of your examples it seems that I would have to know the date to insert it into the code. My workaround was to loop through the distinctive show dates and then test each individual date to see if the customer count was greater than one. If so, then I placed the date in a a combo box. Below is the code that I used....Leave a comment:
-
privateguy started a topic How to write query to extract date only for different customers on the same day.in AccessHow to write query to extract date only for different customers on the same day.
I want to select the dates where two or more different customers were shown properties on the same day. I want to exclude the dates where only a singular customer was shown properties on that day. For example:
...Code:[B][U]ShowDate Customer Property[/U][/B] 7/21/2017 James 123 Main 7/18/2017 James 231 Park 7/18/2017 James 345 Forest 7/18/2017 James 678 Central 6/19/2017 Carmen 531 Charleston 6/19/2017 James 898 Broadway
No activity results to display
Leave a comment: