Search results

Hi, I tried a separate command button with : Private Sub Command703_Click() DoCmd.OpenReport "CORrptLease_AnnexA", acViewPreview, , "[UnitNum]=" & Me![UnitNum] End Sub Same thing - waits and waits and get Not Responding. Could my computer be the problem? Like not enough resources or...

Same - not responding... :( Calling it a night for now - it's 5 AM. Thank you so much for trying. Will stay posted.

What is the name of the Control on the Form? UnitNum What is the name of the Form? frmUnitUpd and what is the name of the Field from the Report? UnitNum "Maybe you have some code on Open or Load event on your report" Nothing in the REPORT. I do have the following in the FORM: OnLoad...

Arggg Now it is doing like before - attempting to run (little round circle thinking) and then Not Responding. It is just taking less time to do it than before. :(

Yes, Gina. I simply wanted you to know that both the field and the control have the same name. I know the difference between the two. THANK YOU

Thank Arnel. This is the coding I now have, following your suggestion. It is reporting an error: Run-time error 2103: The report name 'cboReports' you entered in either the property sheet or macro is misspelled or refers to a report that doesn't exist. The report being selected from the...

I think it should and could work... but it is taking for ever and then MS Access says "Not Responding". Now, I opened that report, manually, entered the UnitNum of the record I was into (so the link or what you have as Field in Report, and it is fine - opens real quick. The report is just a one...

No, I am sure that would work - looks great. The field is numeric. Exactly where would I insert it? Just so I don't mess up the existing codes which are working fine. Glad to have your input Gina! Always!

Hi everyone, In my data entry Client form, named frmUnitUpd, I have a combo box with the following codes to list all reports in the database that begin with the letters COR. Combo Box: cboReports Row Source Type: Table/Query Row Source: SELECT MSysObjects.Name FROM MsysObjects WHERE...

Hi all! I took this coding off the Internet and it works (along with a module). But I would rather have it into a macro than having to copy/paste into each report where I need it. Please provide detailed explanations as to what is to be selected in the macro drop downs. THANK YOU! Private...

Sneuberg, Marking this thread solved. TY for the PM allowance. Loved your quote! Have a lot of thinking to do!

No not sticky with the Tenancy table although hours were put in to redo all the queries, reports and adjust the data... I don't see the need for a History table because - WITHOUT the Tenancy table I can still pull the information using what I previously had, the MoveIn and MoveOut dates within...

Great! That single quote... returns no error. To activate it, I created a macro that runs the module. Then, named the macro AutoExec. :):):):):)

PBaldy, thank you but this is not a "yes/no" field. It is a TEXT field where the user is limited to a "Y" or an "N" (the default value). FYI (just a note): there are four fields - deactivate, deactivate date, deactivate reason(s) and deactivate by... I want this treated clearly, with...

Dear Sneuberg, need to answer... If you only liked it - I honestly thought it "looked" so professional and logical - had never built this way before and was VERY appreciative someone taking the time to explain and offer it this way- I had no idea what I was getting into - still don't but...

It worked! For the benefit of others, here it is. In a table, a field with it's property as calculated (using MS Access 2010): IIf([Status]="M" And [Gender]="M","M." & " " & [FirstName] & " " & [LastName] & ", " & "Membre",IIf([Status]="M" And [Gender]="F","Mme" & " " & [FirstName] & " " &...

You are a teacher! Learning much but this is a bit over my head still. I get how to do it (I just did try it). However, I did not add the "Dim" parts... and the fields... only what I know how to write : the IIF statement or expression... I am going to keep this preciously in my "learning...

It is so strange that you said this now. I have been redoing all the reports for the last 2 days - and, yes, have had to add the Tenancy table everywhere and find myself always confused as to why it has to be there... I just figured Mark is right and I am learning to do it the "right" way...

Yes, it is. As I said, the Mr. John Doe works fine. But the second one I want to do does not work. See my last post. Can you help? TYTTY It should come out : M. John Doe, Member or M. John Doe, Occupant (with an "e" at the end if a female)...

After much thought to both ways... I will add a field to the Tenant table that will indicate the tenant is no longer active, so he has an EndDate in the other table... But I have made a copy of your advice Sneuberg - may work very well for other things I had in mind... TY Thank you all !