Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. bdmoran

    ImportExportText Macro Deletes File

    Thank you for the reply. I'm not too familiar with VBA. My goal would be to either auto execute this code when the Database opens (which I would like to schedule daily) or auto execute this code at a specific time everyday. Is there a way to do this through VBA? From my research, the...
  2. bdmoran

    ImportExportText Macro Deletes File

    Hello, I created a Macro with 2 steps: 1. OpensQuery 2. ImportExportText This worked perfectly during testing on my local machine. However, when I tried to implement on a server downstairs, the importexporttext portion deletes the file I created instead of exporting the data. I get the...
  3. bdmoran

    Comparing Weeks By year

    Yes, that is the formula I have been using. I shouldn't have used the "date" format in my last post, that was a bad example. But basically what I was saying was it gives me repetitve numbers since I have dates in 2012 and 2013 So a better example is this: September Week 1 Week 2 Week 3 Week...
  4. bdmoran

    Comparing Weeks By year

    Alright so nothing changed from my original post -- but I can add on. So with my first group being month, I added in the DATEPART function for my second group. I also have a third group which groups by team. (There are only 2 teams). Group 1 = Month Group2 = DATEPART(add_date) Group 3 =...
  5. bdmoran

    Comparing Weeks By year

    Pete - I tried using the DATEPART formula before I reached out for some help. However, it doesn't produce the results I am looking for.
  6. bdmoran

    Comparing Weeks By year

    Thank you for the response, Brian. My report is broken out by month, but not weeks. My second group is the WeekOfYear field but for some reason doesn't populate. I will try and plug away at it. I apprecaite all your help. Bests, Brendon
  7. bdmoran

    Comparing Weeks By year

    Alright so I created a table that has dates ranging from 1/1/2010-1/1/2050. I left joined my original table to my "Dates" table. Here are my groups: Group 1. Formula = monthname(month({v_ticket_and_returns.add_datetime})) Group 2. Date field from my "Dates" table ---Then I would sort this...
  8. bdmoran

    Comparing Weeks By year

    Yes, I believe I could create a temp table in one of my databases in SQL Server. How would the joins work though?
  9. bdmoran

    Comparing Weeks By year

    Hello, I I am looking to compare Sales from the 2012-2013 season to the 2013-2014 season. Is there a formula I can create that matches week numbers from this year to the previous year? I'm looking to set up a manual crosstab. Here is an example: 2012-2013...
  10. bdmoran

    Setting up Macro On Remote Desktop

    Thank you for your reponses. I had to log off the network to delete the .ldb file and then set up my macro. Cheers, Brendon
  11. bdmoran

    Setting up Macro On Remote Desktop

    Thank you for the quick response. Do you know what this means. "You cannot delete the file because it is open in System
  12. bdmoran

    Setting up Macro On Remote Desktop

    Hello, I have a simple Macro I created and tested on my computer. It's using an OpenQuery macro and an ImportExportText macro. I need to set these up on the production database that is located on a remote server. When I log into the remote server I switch my production DB to "Exclusive." I...
  13. bdmoran

    Windows Task Scheduler Running a Macros

    I appreciate your help but I figured it out... All I did was create a batch file using this path: "S:\DATA\AcsData.mdb" /x MasterAccessToImport Thanks again!
  14. bdmoran

    Windows Task Scheduler Running a Macros

    Alright I tried your first suggestion and still nothing. I also tried this: "C:\ProgramData\Microsoft\Windows\Start Menu\Programs\Microsoft Office\Msaccess.exe" "S:\DATA\AcsData.mdb" /x MasterAccessToImport I feel like I tried both of these yesterday too, since I have been messing around...
  15. bdmoran

    Windows Task Scheduler Running a Macros

    Hello, So I have an ImportExport Text macro set up in an Access Database. I am trying to find the best way to run this automatically, once a day. From the research I've done over the past few days, it seems like people have been using the Task Scheduler to automatically open up an Access DB...
  16. bdmoran

    Crystal Reports Where Clause

    It's because if that cust_first_name field is NULL then primary code is always going to be 'y'. So it's never true that cust_first_name will be NULL and primary_code will be "N". It's alright anyways -- I ended up working it out using different fields. I appreciate all the input though...
  17. bdmoran

    Crystal Reports Where Clause

    So in other words, if first name is NULL, I want the first and last name of the Secondary contact (primary_code = n)
  18. bdmoran

    Crystal Reports Where Clause

    That won't work because I only want to pull the secondary contact if the first name is null.
  19. bdmoran

    Crystal Reports Where Clause

    Hello, I am new to using Crystal Reports and quickly learned that the syntax is different from SQL Server. I was wondering if there is something similar to a where or having clause. I created a formula: IF isnull({v_cust_name.name_first})then {v_cust_name.name_last} else...
  20. bdmoran

    Multi-Part Identifier

    SELECT AT_trans_for_emailTrigger.email_addr,AT_trans_for_emailTrigger.inet_event_description,Convert(nvarchar(50), v_live_inventory.event_date,(101)) as event_date,right(CONVERT(varchar, v_live_inventory.event_time, 100),7) as event_time,AT_trans_for_emailTrigger.add_usr...

Part and Inventory Search

Back
Top