Search results

I get cannot assign a value to this object. Any ideas? Thanks! David Somers

On my real estate management software I need to get a LeaseID from Building Number and Apartment Number for my transactions form. However when I try to get it and store it in txtLeaseID so I can use it, it doesn't do it. I've attached my db to this message. If someone could look and see what I'm...

I have a table that has only one column and one entry which is supposed to be the name of the property that the program is used for. How can I get that name displayed in a label on my switchboard and have it set to whatever that one entry is set to? Thanks! David Somers

I have one more question that doesn't pertain to this, but I figured I'd put it here so people don't complain about many topics. :) I have a table that holds the a property name that I want to be displayed on the Switchboard. I'm not really sure of how to do that and I tried...

Yeah, I've done that. When I order it, it goes like 1, 11, 12, ..., 2, 20, ...., 3, 30..., etc. This I know is ordering, but not the ordering that I would like for it to do. Is there a way to make it order, 1,2,3, ...., A, B, C, etc., because I have numbers and letters for apartment numbers...

I've got one more question. I have a form that adds and deletes apartment numbers. When I entered the data to start with I entered it in the datasheet view of the table and put in numbers like 1, 2, 3, ..., etc. My form allows for the addition and deletion of apartment numbers. When I delete...

How was it done in the Northwinds sample db? Thanks! David Somers

I'm having a problem with my startup screen that basically gives information and then has a Don't display on startup check box and an OK button that is supposed to close the startup screen and load the Switchboard form. However, its not doing this when I click ok or check the check box. I've...

I have a form that opens whenever I open my database. It opens as if I went and hit open from the database list box. How do I prevent this form from opening whenever I open the database? Thanks! David Somers

I opened the form in design view and went to the form properties and then format. I don't see an option for autoformat. Where under the format tab is that option? Thanks! David Somers

I have a form that I set the style as Stone when I created it using the wizard. Is there a way to change it without redoing the form? I want to give it a solid gray background instead of the marble look that Stone has. Thanks! David Somers

That worked.. Thanks for the little push. :) Thanks! David Somers

I want to make sure its "dummy proof". :) How about this: Declare a public variable as boolean and then when they hit add, set it to true and then when they click the button to open the link use that variable for the determination? Thanks! David Somers

Yeah, File/Print on the menu bar. Later, David Somers

The lease form name is subfrmNewTenantNew. I need to determine if they've added the record by clicking the add button, not by if the textfield is blank. How would I make that determination? Thanks! David Somers

Hello all! I need on my new tenant form a button that opens my lease form. But I need to have that button make the determination of whether they've added the new tenant first. If they have, open the lease form, if not display a message box saying you must add the tenant before putting lease...

My advice is to ask someone with more advice than me. :) I'm just learning this stuff too! Later, David Somers

Those are not autonumbers because I don't need them to be. I can't put this all on one form because it has multiple tables involved with the query and it would make things more complicated. Unless I'm wrong. :) I've made some changes however and not I get an error saying: 'You can't assign a...

Is there a way to do that automatically by passing it to the lease information form when I click then button to insert lease information? Thanks! David Somers

I have a relationship set from TenantID (FK) in tblLease to TenantID (PK) in tblTenant. What could it be? Thanks! David Somers