Search results

  1. T

    If IsEmpty not returning desired results

    Changed the method I was using to copy and it is working now. Switched it to: For X = LastRow To 1 Step -1 If IsEmpty(Range("G" & X).Value) Then Range("B" & X).Copy Range("D" & X) Cells(X, 2).Delete End If Next X
  2. T

    If IsEmpty not returning desired results

    Ah I see. Now it is entering the if statement, but is throwing an object required answer. Hm.
  3. T

    If IsEmpty not returning desired results

    I am doing a simple for loop to loop through a range and check if a cell is empty and if it is, copy data in a cell on the row, paste it in another column one on the same row then delete the content in the cell it was copied from. The loop runs, but never seems to trigger true on the if...
  4. T

    Selecting rows based on range of values in cell

    It has been a minute since I have posted (had to take a break from all the dev stuff before my poor brain fried), but I have once again been handed a project to make everyone's life a little easier. I am trying to write a macro that will look through a column and copy rows that meet the...
  5. T

    Exporting to existing Excel workbook

    Disregard. Found https://www.access-programmers.co.uk/forums/threads/export-an-access-query-to-an-existing-excel-spreadsheet-in-vba.299856/ which put me in the right direction.
  6. T

    Exporting to existing Excel workbook

    I have been trying to research this, and while I have found various methods to move data from Access into Excel using TransferSpreadSheet, how can I control the range in which the data gets inserted? I have a template that has a header and named columns further down and such, so I would need to...
  7. T

    Query to show record with duplicates once

    I have a query that shows all jobs being worked on today and into the future ( > Date() -1). The problem I am having is when a job gets duplicated (for different versions or maybe a revision), the job shows up twice in this query, which I do not want. Here is a snip of the design view...
  8. T

    Calculated Controls

    All but 2 of 8 controls on this form are bound. 6 are bound to the base query which does several calculations (mostly summing and such, nothing complicated). The other 2 are based off the other controls. One does a simple sum of all the other controls and has not had any issues. The second one...
  9. T

    Calculated Controls

    How "deep" can you go with calculated controls? I have a sub-form with a calculated control, whose control source is a query which is also doing a calculation. I have another control which I was trying to do ANOTHER calculation based off the previous control, but it won't return the desired...
  10. T

    What IDE do you use?

    I downloaded Code and was playing with it last night. It is a much more straight forward version and feels less "busy". I will probably stick with it over Community, but keep both just in case. A lot of the guides/tutorials seem to be for Code anyways. It was much harder to track down things...
  11. T

    What IDE do you use?

    I believe it is because it is what he uses, so he is familiar with it and could provide help. He is a full stack dev and spends most of his day using it. I personally don't know anything about it as this is my first foray into code outside of VBA.
  12. T

    What IDE do you use?

    Currently I am trying to learn Python. Once I get the hang of that, I and want learn C#.
  13. T

    What IDE do you use?

    On the suggestion of a friend I grabbed Community. I can't quite find the difference between Community and Code other than Community seems to be a much more "complete" and robust applicaton.
  14. T

    Fry's electronics out of business

    I went in to our local Micro Center with a buddy a few weeks ago. We came out with a TV, a monitor, a 3D printer, Raspberry Pi's and 12pk of Mountain Dew :ROFLMAO:
  15. T

    What IDE do you use?

    I am curious what people use for their coding (obviously some just use the built in editor in Access/Excel and what not). I am trying to branch out and learn more coding (been focusing on Python lately), and I seen a bunch of people recommend VS community/Code. It seems there are tons out there...
  16. T

    Checkboxes on form cause run-time error

    It would appear somewhere along the line, a join in my forms control query somehow became invalid. It just so happened the code I was messing with affected just checkboxes which became messed up as a result of the messed up join. Don't know how it happened, but it has been fixed and everything...
  17. T

    Checkboxes on form cause run-time error

    After rearranging my form it appears something happened to my check boxes. In my code, I am just doing true/false checks but am getting run time error 2424, The expression you entered has a field, control, or property name that Access can't find. I have deleted the controls and re-added them. I...
  18. T

    Learn Python

    Creating websites and/or analysis applications is the direction I would probably go. As much fun as I have had making an Access db, I have learned that I am not very good at it :ROFLMAO:
  19. T

    Learn Python

    It was mostly a suggestion from my friend as he said its supposedly bar none the most popular programming language currently and is highly looked for and would be a solid language to learn if I wanted to possibly look to switching careers. He also highly recommended C# as it (in his words) is...
  20. T

    Learn Python

    Being all the code guru's several of you are, would anyone happen to have a nice resource that could facilitate me learning Python? I am wanting to get more into coding and learning and a friend of mine who is a full stack dev highly suggested I learn Python (while also heavily pushing C# since...
Top Bottom