rovral
Last Activity: Jun 9 '12, 07:54 PM
Joined: Mar 2 '12
Location:
-
Thanks immensely Mihail, everything works now. -
Thanks for this, I didn't want to recode my search form after many hours of getting it to work the way it is, but I am working on a similar scenario for a future project and I will definitely use this approach. It is pretty slick.
Thanks again.Leave a comment:
-
I think in each case I need to account for the third option but I don't know what condition I need to make the if statement. If that is correct.Leave a comment:
-
No doubt, but for the time being it makes sense and of course I don't foresee the need to change this in the future (I'm probably wrong) lol. I just don't want to spend a lot of time recoding this. Anyway, do you know how to incorporate my existing code to account for three options?
Thanks for your help.Leave a comment:
-
Thanks, but I like the user being able to see the choices instead of selecting from a combo box. Besides I almost have it working except for the issue mentioned above and there isn't very much code involved. Also, I am terrible with arrays and your way would require more effort to get the arrays working. The arrays I have now work fine.Leave a comment:
-
It works great based on two buttons but when I add a third it doesn't work properly. Do I need to add a third variable such as StoredLease and then use some kind of if statement in the select case? Note that list box selections for lease and building will always be the same.
Here is mu code so far:
...Code:Dim StoredMulti, StoredBuilding, StoredLease Dim strSQL, strSQL_Multi As String Private Sub Form_Load()
Leave a comment:
-
I was thinking, what if I added a third option for building sales and make this the default? This may solve my problem.Leave a comment:
-
Remembering multi-select list box selection
Thanks for your reply. That works pretty good. However, I didn't use an option group because I would like to be able to unselect both options. The form is actually a search form and when I click on the search button, different SQL is created depending on which check box is selected but different items appear in the listbox depending on which check box is selected like we already established....Leave a comment:
-
Remembering multi-select list box selections
I have an unbound multi-select list box that is populated from a query that displays types of buildings. I have two check boxes on the form that change the items in the list box when one or the other is set to true, only one check box can be selected at a time. One check box, when selected, displays all types of buildings except for multi-family, while the other check box displays only multi-family buildings.
My problem is if the... -
No worries, I will look to someplace else for answers since you obviously don't understand what I am asking.
Thank you.Leave a comment:
-
Open form to specific record
stLinkCriteria2 was a mistake, I have taken that out.
My relationships are :
[imgnothumb]http://bytes.com/attachments/attachment/6264d1333379522/image1.jpg[/imgnothumb]...Leave a comment:
-
Open a form to a specific record including correct record in subform
I have a search form that displays a bunch of sales records in a subform based on sql. I also have a more button that will take you to the data entry form based on the id # in the search subform and the ID # in the data entry form. The data entry form also has a subform that displays the sales details. There can be more than one sales record for a particular building. The problem I have is there a way to not only open the data entry form to the specific... -
It is a realty sales database so it is possible for the same building to be sold twice or more, but I don't want duplicate sales, so ideally, the form should check first if the address is a duplicate and then probably check the sales date as well to be sure it is a duplicate. Maybe I need another table that holds the sales information and create a one to many here. That is probably what I will do then run my existing check on the address and add...Leave a comment:
-
Here is Microsoft's explanation http://support.microsoft.com/kb/289659Leave a comment:
-
I fixed the problem, it turns out that I had a calculated field that I set the default value to 0 on. Apparently you can't do this. Now the form works.
Thanks for your reply'sLeave a comment:
-
Table design:
Building_ID (Autonumber, primary key)
Location_Addres s (Memo)
Location (Text)
Province (Text)
Location_Distri ct_ID (Number, foreign key)
Trans_Date (Date/Time)
Selling_Price (Currency)
Selling_Terms (Text)
Land_Use (Text)
Legal_Desc (Memo)
Linc_No (Number)
Site_Size_SF (Number)
Site_Size_Acres (Number)
Site_Size_Condo (Text)
Land_Value_Est...Leave a comment:
-
It just stopped working and started giving me the error, didn't change anything. Here is the details.
Table design:
Building_ID (Autonumber, primary key)
Location_Addres s (Memo)
Location (Text)
Province (Text)
Location_Distri ct_ID (Number, foreign key)
Trans_Date (Date/Time)
Selling_Price (Currency)
Selling_Terms (Text)
Land_Use (Text)
Legal_Desc (Memo)...Leave a comment:
-
My table is normalized not sure what you have in mind basing a query on the primary key. Example?Leave a comment:
-
field cannot be updated
All of a sudden, I get "the field cannot be updated" error when trying to add a new record in my data entry form. The form worked fine before. I doesn't matter what field I enter data into, I get the error. I click OK and then it lets me continue entering information. Puzzled as to why this is happening. Any ideas? -
Check for duplicate addresses from a data entry form
I have a data entry form that lists the details of building sales. I know a building can sell more than once so I need to allow duplicate addresses. However, occasionally the same sale will get entered more than once. I have code that checks if the address is a duplicate and takes the user to the existing record to verify the information and this works fine. But as I add more sales into the database, the possibility of more than one sale for a particular...
No activity results to display
Leave a comment: