Search results

Not sure I understand. But in the example I made up, it would be several units that would have ONE lease each. So (for example) the report could have : Unit 1 - Jane Doe - Member + John Doe - Member + Kate Doe - Occupant > 1 lease Unit 7 - Mike Fry - Member + Jack Fry - Occupant > 1 lease etc..

Opening a query was an extra precaution - as really, no records should be deleted UNLESS they made an extra entry by mistake. Your coding works great ( :) ) but it deletes the record (quickly!) and does not open the query... Would the fact that these users, including the one who will be...

OMG!!! What beautiful work! Just opened the form! I will see if I can adapt it... I will need to make it so they select their labels like below. Originally, I thought I could have a given report, let's say one that produces a lease for all new tenants. The user would print the report and...

Hi all! I am a newbie... really trying to learn. I have a command button on a subform (main form = frmUnitUpd / subform = frmUnitUpd_Tenants ) to allow the deletion of a record. I wish to: 1) ad a warning message - "Was this record entered by mistake?" If user clicks on "yes" - have the...

WOW!!!! get back to you later today - have people coming over right now. TYTYTYTYTYTY!! I am blessed!

I believe this is where the link I supplied led to... I suppose it is possible - it's sound right but I would have no idea how to apply this to my sample, let alone a label report. If anyone wants to try it, I sure could use it! Thank you!

Thank you. Really need to think about all this and re-examine everything closely. It is getting confusing (for me). Will definitely get back to you - thank you so much!

Hi Sneuberg, I found this on the Web. It is way too advance for me but perhaps you can make sense of it. It seems to be what is needed here... Correct me if I am wrong... http://accessdatabasetutorial.com/2014/06/12/concatenating-multiple-rows-into-single-line-in-ms-access/ Thanks! Can't...

Hi, I understand the creation of labels based on a table that has the lines in separate fields vs separate records. But how will that table created, each time the users want to output labels for a certain report? I remember a database - a long time ago (like 25 years!) where the programmer...

Mmm... strange - I get no error message... Here is the query for the main report: SELECT tblUnits.UnitID, tblUnits.UnitNum, (IIf([Gender]="M","M. " & [FirstName] & " " & [LastName],"Mme " & [FirstName] & " " & [LastName])) AS Salutation, tblTenants.TenantID, tblTenants.Unit_Num...

The report did include a query - just not an outside saved query... It can just be saved if you need it as a separate file. Why create a new report? The option of having one name on the label is absolutely not possible. I thought of a mail merge to Word but I really would like to avoid that...

Got it! Thanks! Answers my question perfectly. Gina - you rock!

Thank you Sneuberg. Will rephrase - that was so incorrect. And providing a sample is a great idea. The label report was created using the Label Wizard. But the UnitNumber as well as the tenant names are all on separate labels despite having grouped them like in my report (letters) which is...

I totally understand. But once I let go of this database, there will be 1 administrator that will handle it and, yes, he will be wanting to do queries and so on. It will be HIS database. He may create new forms, new reports down the road. As well, the number of bedrooms in the units is...

Hi everyone! Just want your opinion on this "dilemma", lol. I have a UnitType field. It is represented as: 1B (stands for 1 bedroom) 2BI (stands for 2 bedrooms, inferior level) 2BL (stands for 2 bedrooms, superior level) 2BA (stands for 2 bedrooms with special amenities) ... for a total of 7...

Bingo! It works! TYTYTYTY

Hi all! I am stumped by this one. I did a report where individual letters are sent to multiple recipients. Works fine. Tried to do the same for a label report - it destroys the label format. In the letter reports, the recipients are grouped by UnitNum. Also, the query pulls recipients...

Hi CJ - again thank you. I copy/pasted the codes. But it still returns record #1. Here is what is in the table. RecordID = 1 ApprDate = 03-Aug-14 1Bed = $700 RecordID = 2 ApprDate = 05-Nov-16 1Bed = $900 etc. I need the record with the last date entered - the closest one to today's date...

Hi Gina! Thank you! CJ, call me dumb but I have tried and tried to modify the query... the only time it worked, it returned record number 1 which is not the latest date (closest to today). Here is the query - how do I modify this? The date field in this one is ApprDate. SELECT...

Great! Can you provide us with the function and the query? Like in a sample database? I need to convert English dates into French for reports. Don't know how to write a function or use the suggested commands in a query... THANKS