Recent content by Okibi07
-
O
Formatting a Report from a Command Button
Anyone have any thoughts? Still stuck on this. -
O
Highlighting only Rows that meet Conditions
Hi just jumping in here to also solve my problem. I am trying to do the same essential thing - I have a "Priority" box on my report that either says Yes/No. What I want to do is the "Detail" background to change yellow if Priority says "Yes". What I have in my code is not working, so would... -
O
Formatting a Report from a Command Button
Hi all, So I have a report that lists different clients, their contact information, and their various representatives. What I want to be able to do is have a button next to every client entry which the user can click. Once the button is clicked, I want the "person name" box in the report to be... -
O
Not all records displaying in form
I just changed the "Record Source" of my form from SELECT Client.*, Memos.NoteDate, Memos.Notes AS Notes_Memos FROM Client INNER JOIN Memos ON Client.ID=Memos.[Client Name Foreign Key]; to SELECT Client.*, Memos.NoteDate, Memos.Notes AS Notes_Memos FROM Client LEFT JOIN Memos ON... -
O
Not all records displaying in form
Hi all, Tried looking for this answer, and couldn't find my exact case available. I have a form where users can look through different records as well as add a new record through a control button. When a new record is added, all the relevant data should end up in the corresponding back end... -
O
Opening a Form based off of a Double Click event on a Report
Woooo Paul you are my super hero!!! :D I guess it was just the "integer" addition that made it work? Access is weird. Thanks x1 million for this! -
O
Opening a Form based off of a Double Click event on a Report
Ok, deleted, closed the program, copy and pasted your code and suggestions, still getting same error message. Not sure what else I'm screwing up! Thanks so much for all your help with my database! -
O
Opening a Form based off of a Double Click event on a Report
Hi Paul, Should I redo the code in the Client Form's VBA, or continue putting it in the CRM Report's VBA? Thanks! -
O
Opening a Form based off of a Double Click event on a Report
I don't really know what you mean - I only see once in all my VBA where I have "Client_Name_DblClick" Sorry, still learning Access language here, really appreciate your help! -
O
Opening a Form based off of a Double Click event on a Report
Error message: The expression On Dbl Click you entered as the event property setting produced the following error: Procedure declaration does not match description of event or procedure having the same name. *The expression may not result in the name of a macro, the name of a user-defined... -
O
Opening a Form based off of a Double Click event on a Report
It's essentially the same as before, with slight changes to reflect that I'm basing it off text and the "FieldName" has been updated to reflect my Client Form's record source properly. Private Sub Client_Name_DblClick() DoCmd.OpenForm "Client", acNormal, , "Client = '" & Me.Client_Name & "'"... -
O
Opening a Form based off of a Double Click event on a Report
Thanks for that Paul, that does help me understand a bit more. Unfortunately I am still getting an error message. What I think is going wrong is that on the Report, I am clicking "Client Name". I want the DoCmd to open the form based on the report's "Client Name" which is also the same "Client... -
O
Opening a Form based off of a Double Click event on a Report
Hi all, I'm pretty new to Access, so excuse if this is a weird or backward question. I have searched the forums and havn't really found something specific to my problem, so help would be appreciated. I have a main Form "Client" that shows details such as Representatives, phone numbers, status...