Search results

Hello All, I have been having this annoying problem when my code run at night on my VDI machine. I believe when the machine goes to sleep the path to the drive is disconnected. So when it wakes up to run the code, I get this error. I can log into the computer and run it just fine...

Hey Everyone. I am shocked I have never came across this before. I have a column like order number in a table and I just want to see the unique data based off that column. I know to do district...but because of the data it still duplicates some columns. How do I force it to only show unique...

Hello All, I have some data in a table I would like to display horizontally instead of vertically. How is this done....did alot of searching and have not found a solution yet. Here an example of what I mean: Any Ideas?

Hello All, I am linked to a database that has some tables with fields that are in excess of 255 fields. When I look at them in Crystal, it displays all the fields. Is there a workaround that would allow me to see all the fields? I tried to play around with passthrough but didn't work. Any...

Hello All, I am trying to attach a excel file to email. I have the file being exported to a location then I would like for the email to attach but I keep getting runtime saying that it has been moved or deleted....and the file is there... Do I need to put a pause in or something to give time...

Hello All, I have a table that have multiple entries and I am trying to get it all on one line base off of account number. The way the table was set up (not me) repeats the data when I run a query against it. I know I possibly can run a cross tab query that might clear this up but have a...

Hello All, I have a linked table in access to a SQL db. However, I run in the field limitation of 255 and the field I need is below the 255 more. If I was able to sort the link table I could possible still get the field I need.....Crystal has this option to do this..(put the field in abcd...

Hello Everyone, Does anyone know a way around this "Reserve Error (-7713)?" I am trying to link through Amazon Redshift ODBC driver. I am connected and have access to the data however, when I try to link to one of the tables I get this error I have tried the REGIT WorkArounds=8192 fix and...

Hey Guys, Ran into a problem I have not encountered before. I am linked to a SQL db that have many tables. One in particular has 403 fields....I am limited to see and use the first 255 any way around this?? Anyway to choose the fields I want....most of those fields I do not even use... The...

Hey guys, Can you use a Hex function in a query or is there a equivalent? Thanks, cg

Hey Guys, Weird question, Is there a way to search on the description of a queries? Say if I want to make some notes about the query I built because I might need to use it later....or remember how I did it... Any way? or Naa?

Hello All, I have a query which list a customer number and a POL Code. When I run the query it list some duplicates...for example Cust # | POL Number | Address --------- -------------- ------------ 12345 - ONL - 56 Chicken St 12345 - PA2 - 85...

Hey Guys, I have a query the takes the current month and filters the criteria to give me the last day of that month and the last day of that same month one year ago. So it looks like (for instance) give me everything Between 20170731 and 20180731 So it looks like this in the query criteria...

Hello All, Trying to use some criteria in a query that is giving me a error. When I put this in the query >DateAdd("yyyy",-1,Date()) I get an error.....what I am trying to get is: "One year ago today" for the criteria..... So whenever the query runs, the criteria will be that day a year...

Hello All, I am trying to put the date in the file name. I am outputting a table to an excel file and trying to put the date before the file name. What i was working with so far......sorry relatively new to this Function testthisone() Dim FilTim As String Dim FilNam As String Dim OutNam As...

Hello All, Trying to figure out why this code is not working. Function SendMail() Dim outl As outlook.Application Set outl = New outlook.Application Dim mi As outlook.MailItem Set mi = outl.CreateItem(olMailItem) mi.body = "Hello, blah blah blah" mi.Subject = "CV_blah" mi.To = "blah@blah.com"...

Hello All, I have multiple table linked via ODBC connection. This includes a connected oracle db. I have a code that is running some queries and then send it to excel. However during the code it is asking for user name and password. I input the details and it continues. I am trying to have...

Hey guys, I and trying to convert some mainframe query to Access. I am working with: HEX(SUBSTR(EXTRA_IN,1,3)) AS FKT_AMG1 Obviously, Access does not have a substr function...so I tried to use Left or Right....I got some results with Mid but some time I got nothing.... I tried...

Hey guys, I am trying to figure out how to write this query.:banghead: The data has a list of numbers and an address. One for business and one for Home. What I need is the business address....which would be easy but there are some that just have a home address. So what I am trying to write...

Hello guys, I have not been on here in a while. I have a issue I am trying to solve. I have data in a database that is formatted like this: yyyy/mm/dd ...in text format So I did this...