Search results

Thank you all, thank you missinglinq - I was able to apply your solution! :)

Thank you Minty. Each items, in each area (kitchen, living room, dining room, laundry room...), i.e. Kitchen - door, Kitchen - wall, Kitchen - sink, kitchen counter and the list goes on - must have a field that allows the user to type in whatever he wants as an explanation. Your a) suggestion...

I simply created a combo box with value list. Used the mouse to select, then copy, then paste. Would like to automate this or something better. That is all I tried. I don't know how to code it which is why I posted it. I would like a mechanism, button or other, that would do the copy and...

Hi all! I have a Unit Inspection form where I would like to facilitate the data entry (many many fields). I would like to have a list - dropdown or individual text boxes at the top of the subform, that would provide the followng choices: To be repaired; To be replaced; To be...

Thank you Ranman. Sort of understand - it is like it is in edit mode vs add mode... So how do I achieve what you are suggesting?

Hi all, I am getting this error : Cannot add record(s); join key of tblOccupancy not in record set. My join key is UnitNum from the tblOccupancy. It is in both the continuous subform as well as in the main form. Also, in both queries of the main form and the subform, I can add records...

Thank you Arnel. OK for the following... add another fields in your master inspection table, ie, Status="On going", "Closed", "On going repair" StatusDate = Date ------- move the other fields to inspection detail table - ALL the fields? Like the areas, and the items? Or are those in lookup...

Hi, Would like to create tables for Unit (apartments) Inspections data entry – need assistance in creating tables with proper links Each section below is One-to-Many to the section below it… TABLE – Inspection InspectID PK - Autonumber UnitNum Number (PK)...

Thank you Gizmo. Good links too.

Hi everyone, Would like your opinion(s)/advice as to when do you decide to save a query for a report vs having the codes saved within the report? It is just when you plan to use that query more than for the one report? Or are there other considerations? Thank you!

Please - UPDATE - thank you. If Me.cmdLabelFlagSelectAll.Caption = "Select All" Then CurrentDb.Execute "qry_R_LabelSelectAll", dbFailOnError Else CurrentDb.Execute "qry_R_LabelUnselectAll", dbFailOnError End If Me.Requery

Thank you for the response Glaxiom. Very clear to me especially with the explanation and the sample. I understand what you are suggesting. I will give it a lot of thought and try to implement it.

Hi Paul, 2am here and finally got a chance to apply the code you generously provided. Now it seems to work - not getting any error message. But there are two things: 1) When the records are flagged, some of the other fields are "reacting" - "shaking / moving"... it is just eerie. Like the...

I sure did - have not had a minute - son is sick and wants "mommy"~!. Thank you Baldy - Much Appreciated! Once I have it working, I will rate and mark the thread as successfull and complete.

No offense taken - I DID TRY and way before even posting this thread. Also, it is not as if I came here empty handed. I created the queries, I applied coding behind two buttons I created and did my best to manipulate the event to make it work - it did not. How can you judge me like that...

Thank you for trying to assist. As mentioned in my thread: I am running MS Access 2010. I would like to have a toggle button that selects and deselects a check box field. I have this SQL but it is returning a compile error. Can you please assist? (please provide FULL coding - I did not write...

I tried it before I answered you. Sorry should have sent this: Returns: Run-time error 3417 - An action query cannot be used as a row source + highlights line CurrentDbExecute strSQL, dbFailOnError, in yellow. Why and how does it work for you? Here is the code, updated, as I think you...

Thank you Baldy for responding. Hope you can help. It comes up with Compile error: Variable not defined. It highlights the first instance of the word "strSQL". I would not know how to "declare strSQL". Sorry.

Dear Arnel, I must be missing something! I did create a query - it is called qry_R_Labels. And the label report is now based on that query. I am sure I messed up somewhere! It does not return an error message but opens the module and stops at : Set qdf = CurrentDb.CreateQueryDef(""...

Hi All, I am running MS Access 2010. I would like to have a toggle button that selects and deselects a check box field. I have this SQL but it is returning a compile error. Can you please assist? (please provide FULL coding - I did not write this one - I am at a beginner-intermediate...