Search results

working on it thanks!

Sorry Arnel - totally confused. Way above my level here! The query qry_F_TenantList drives the main form of the entire database. It lists all the tenants that are active. The query behind this module is to create a label report. It must be restricted as per the field I mentioned above...

Arnel, I don't know why the programmer chose a query that was already in-use by a form - I cannot change it otherwise the form content will be wrong. Can I create a new one? And just change the name where ever I see qry_F_TenantList?

Hi all! This is a module that creates a query (correct me if I am saying this wrong :(). I would like to modify it to include more fields with some criteria. I have no idea where that would go - obviously I did not write this wonderful module. These are the fields I would like to add and...

Awww! THANK YOU! Any luck with that diagram yet, with the "live" parking spaces? Tough one, right?

Thank you Arnel!! Sorry for my ignorance but where does it say: IF field content was an "F", change to an "M". As I do have a Status "O" and that one will not change upon that txtMoveOutDate being filled...

Hi all, I need to add coding to an existing event procedure. It should do two things : The event is set in the AfterUpdate of the following: Name: txtMoveOutDate Control Source: tblOccupancy.MoveOutDate If that field is updated, so not null anymore, event should say/do: 1) Set the...

Hi all, I have some coding that needs updating. I did not write the code and cannot perform the two updates required. 1) At the time the code was written the control text box name was status, same as the field name. I would like to change the control text box name to cboStatus for...

You can also default the reports to open in print preview. I can no longer see them in report view - just plain makes me nuts, lol !

Hi Arnel, Just wondering if you are still working on this mega challenge, lol ! Do you need any files? Please let me know. Anyone else out there that would like to help? THANK YOU All!

Yes, it can apply to the page footer JOC.

Thank you Arnel for the response. The tblParkingAlloc is, both, in the sample you sent back to me and the one I originally sent to you. So I am confused as to what you would like me to post. You wish for me to resend the original sample database, or the one you provided back to me or create...

The data is ficticious to test. And, yes, Salinger or any other tenant may be there twice as they can own more than one vehicle, so have more than one parking space. i have 5 records showing in the report. SALINGER, Jerome David has two entry on the table but the first instance his parking...

That table was in the sample database. You don't have it? The report and the query I provided would not work without it. It is called tblParkingAlloc (for allocated)

tblParkingAdmin contains all the spaces and type of parking. tblParkingAlloc indicates the tenants that have been assigned to the available parking spaces. Both tables are needed. In my text boxes, I am saying: if there is no tenant here (tblAlloc), use the content of the field in...

are you using it live? Yes, this is why my boxes had all the IIF statements... you have to close the report and open it again, to see changes. I did the report is just a snapshot of what is in the table at the time the report is generated. it does not refresh. Does not refresh AT ALL or...

I must be doing something wrong. I allocated a parking space, in the table, to a tenant. But her name does not appear in any of the labels? "Ok - here it is. This is the diagram of the COOP parking lots and spaces. I would like the full name of the tenant and Unit Number to appear in the...

These are labels, right? Not text boxes. How does this work since there is no record source? Is it all done through VBA? Amazing. So I can delete my query, right? How will the names change automatically when a new tenant is assigned the parking space? I am really interested in knowing how...

Of course! My pleasure! So this is doable then? WOW! "one more thing i will do the parking, left to right, and top-down, based on your image." That was my intent all along! Terrific!

Ok - here it is. This is the diagram of the COOP parking lots and spaces. I would like the full name of the tenant and Unit Number to appear in the control box - if no tenant has the parking lot - the tblParkingAdmin, PkgType field content should appear there instead as some spaces are, for...