Search results for query: *

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...

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...

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...

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...

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...

Hello, I keep receiving this error: Msg 207, Level 16, State 1, Line 7 Invalid column name 'acct_id'. Msg 4104, Level 16, State 1, Line 7 The multi-part identifier "v_returned_inventory.repid" could not be bound. Msg 4104, Level 16, State 1, Line 7 The multi-part identifier...

I am new to writing case statements in SQL server. What I'm trying to do is if an account has more than 1 customer name ID, I want the phone number to be null otherwise, I want to pull the phone_number. The case statement is highlighted in RED: DECLARE @order_ID nvarchar(10),@other_info_2...

Hi all, I am creating a stored procedure to send an email and when I execute the SP i get this error: Msg 14624, Level 16, State 1, Procedure sp_send_dbmail, Line 237 At least one of the following parameters must be specified. "@body, @query, @file_attachments, @subject". Here is part of my...

Hello, I have the following DATEADD function I used in a stored procedure: (downloadedOrders.EditDt > DATEADD(hh, - 1, GETDATE())) This works great for me but when I try to use it in a linked server I keep getting errors. Here is an example of what I have on my linked server: select...

Hello, I created a macro about a year that was working perfectly. I haven't used it in about 3-4 months and I am now receiving this error: "The Microsoft Database engine cannot open or write to the file """""""". It is already opened exclusivley by another user, or you need permission to...

Hello - I am using a TransferSpreadsheet macro where I append an excel spreadsheet to a table in access called "Timesheet". I keep getting the "Type Conversion Failure" import error. It is because some of the fields in my excel file are null. Is there a way to not recieve this error? I tried...

Hi all - I have a table includes the following fields: In time Out Time Actual IN Actual Out The problem is that sometimes employees forget to clock in or out which results in null values in the above fields. I need a query that will pull data if one of these fields is null. I know I can use...

Hi - I set up a transferspreadsheet Macro that imports an excel spreadsheet to a table I created in access called "Timesheet." I keep getting import errors and it is because some of the fields in the excel spreadsheet are null. Is there any way to allow these null values to get imported? I...

Hello - There is a column in one of my tables in access that has an employee name and employee ID formatted like this: Smith, Mike [567891012] Pike, Tim [9898] I am looking to get the employee number in a seperate column. I was thinking to create a query with the[Right] function, but every...

Hi I created a Stored Procedure that sends e-mails. Here is part of it: EXEC msdb.dbo.sp_send_dbmail @profile_name = 'Orders_at_TDGarden_profile', @recipients = '@email_address' @body = @strBody , @subject = @strSubject It's supposed to send an e-mail to a speficic email...

Hello, I have a report in access that has a list of times employees clocked out of their shift. I need to round the time they clocked out to the nearest quarter hour but expressed as a decimal. for example, I need anything less than <=3:59=4.00 anything >=4:15=4.25 etc. Any help would be...