Search results

Hello, I have a For Next statement that I use to cycle through a list of variables. These variables populate a textbox on my form. Once this textbox is populated, i have other listboxes autopopulate based on a query result. My issue is that not every variable will have results in the query...

Hello. I posted this in a VBA forum, but received no response, i know this is not directly applicable to Access, but the users in this forum are AWESOME and very knowledgeable so i fugured I would see if someone could help me. I am trying to publish an Excel Pivot Chart, but keep getting Run...

Hello, I created a Public Function called fNetWorkDays in my access database, however, when I try to use it in an expression I get "Undefined function 'fNetWorkDays' in expression". The Public Function is in a standard Module in my vba project. Does anyone know why I cannot call it in my queries?

Hello, I have an AfterUpdate event where I want a list box to be populated based on three different criteria based on a table in my database 1. Complete = False AND 2. Supplier on form = supplier in table AND 3. Status in table = "SUPPLIER_RFQ FOLLOW-UP" OR "SUPPLIER_RE-RFQ TO OTHER...

Hello, I am trying to populate a list box with an event after update in a combo box. I can get the formula to work using 2 criteria, the problem is i nee to add a third criteria. When I try to add it I get the run-time 13 error. Here is the code I am trying to use: Private Sub...

Hello, Help Please! I am close to getting code to send an email from access with the body of the email populated with a Rich Text textbox from my access form. The problem I am having is that the body of the email is converted to plain text in Outlook which is creating problems for me. Can...

Hello, I am a new access user and joind this site as it seemed like a helpful place where new users like myself are welcomed. My first question was responded to in less than 5 mins and was a great help. Thanks to everyone on here for sharing their knowledge and experience with a new user...

Please Help!!!! I am new to access and have been staring at the same Run-time error for 3 days (pathetic I know). I cannot for the life of me figure out why it does not like my Dlookup. Esentially, I want and After Update event in my combo box to populate a Rich text textbox in my form. After...