Search results

I am confused by a problem I am having. I have a module that is just deleting rows based on criteria and one block seems to only work when the module is ran by itself but when it is ran during the whole process, it doesnt do anything. Here is the full module: Public Sub Criteria() Dim wb...

That is an understatement. I don't typically ever ask a question there due to how super strict they are and if the question had ever been asked, regardless of how old the original question was, they will dock you for it. Posting there gives me anxiety lol.

Just for record sake, here is what ended up being used: import pandas as pd df = pd.read_html(url)[0] df = df[df['Progress Point'] != 'Cancelled'] columns_to_drop = ['Line Nbr', 'Total Qty', 'Catalog Description', 'Shipping Loc', 'Reserved Qty', 'Shipment Leg'] df =...

The good people over at Stack Overflow got me sorted. I actually did not even have to use a loop and was able to do it all within pandas before even dropping it into Excel. Took two whole lines of code to do it (yay python).

I figured that was likely the case, but you guys are always so helpful I figured I would stop here first

This one is a little off the wall and understand if this isn't the right place to ask. I am trying to loop through a table in Excel and if my control column does not equal a specific value, append it to another sheet that is a copy of a report template. While I could likely do this in VBA, the...

I have been learning Python and C# and have been using Visual Studio while learning and it is such a nicer environment to write code in. Being that it is also produced and owned by Microsoft, why in the world would they not allow it to be used in the development of Access or Excel files? If I...

Thanks Gas! I finally got to sit back down and can sift through this and will report back!

How did you manage that by using just a check box? Did you just clone the record in the event the value was set to true?

In my app for sending cuts of electrical wire to our wire room to be cut, I have a form that the sales people fill out before sending the request back. It consist of a header that has several required fields to be filled out and saved before the sub-forms with the actual data entry become active...

After reading more while I was on vacation last week I was able to get the form to open in the different states using Pats example but modified a wee bit. I added an unbound control that is not visible to the user that is set to true or false when the form is opened based on the login of the...

Sorry for not checking back, was on vacation all last week :giggle:. Doing what Doc suggested and checking if the object is nothing did the trick in getting the code to work correctly.

Reading now. Will post wat comes of it. Thank you!

I have a module that sends emails when a task is complete and it works fine as long as Outlook is already open and running. However when it is not, I get run time error 429. To handle this, I have tried starting Outlook but it never seems to actually start: Public Sub SendAcknowledgement() Dim...

JDraw, the purpose of the YN field to show if the action has been completed or not. So if the WHERE for the Completed is set to false, then you are looking at active task whereas when it is set to true, you are looking at history/completed task. The exact case for me is a user who is actively...

I see and I am searching through the forum and reading everything I can find. Out of curiosity though, using just a yes/no field as my criteria in a WHERE clause, would it be easier to create a function that I can flip back and forth via VBA depending on various conditions? Main reason I ask is...

I agree with Gemma that it is horrifying that companies encouraged to be the main tool used even in a multi-user environment. My company is one and I have been learning my way through Access the last few years and have made a few simple apps to remove the need for several Excel sheets and it has...

I have been reading how I can pass parameters to a query using VBA but am struggling to find an example I fully understand. So say I have a form that when opened by one user, the parameter for a yes/no field is false but for another I would want it to be true, how would I change that on the go...

Understood. I will tear it apart and reassemble until it breaks again.

Is having a IIF statement in the reports record source query causing this? Is that what you mean?