Recent content by mdctsg

Sorry I posted some incorrect information. It is a table not a query I am exporting. Thanks Bob

I need to export my query to a txt file and have it named referenced by the data in my field 1. The field 1 is just a julian date with UP in the front and an A on the rear. Each day the date will change but the UP and A will be constant. So today it will be example UP2005166A and tomorrow it...

Thanks BPNMike for your reply PHV That was what I was looking for. I keep forgetting about IIF when I am dealing with Access. I am so used to just using it for data storage as a part of a VB program. I am trying to get more into what the db can do itself. Thanks again Bob

Hello I have a field in my query1 that converts my date in table1 to Julian date. If the field in my table1.date is empty my query will have #Error in the field. Is there a way to clear that without making a delete query? Thanks Bob

Ok I think I have it figured out. I will need to find out where they are getting the letter they want at the end but as far as the UP goes I can add it to the front of the date using PHV's code. I added a table called Mark to give me the letter at the end until I get their data SELECT...

Remou I tried that sample from MS but it didn't seem to work the way I wanted. Thanks very much for your input. PHV that worked great. Just what I needed. If I can impose on either of you again. I have been informed that I need to add UP to the front of the date. So it should read UP02088 for...

Hello I am trying to convert my normal date 03/29/2005 into a Julian date format 05088. My db is populated through a text import. My table is table1, my field is Date and my Query is Query1. For the test purpose. I am having a horrible time with this. Can anyone help me please. Thanks Bob

Hello I have a DirList, a DriveList and a FileList on my form. I am populating the Listbox from the A:\ drive. I would like to copy a file of choice to a specific directory C:\Import and change the name to import.txt. The files on the floppy will be either a .txt or a .prn file. I just need to...

Never mind I found a solution. I wrote a FAQ in hopes of helping someone else who maybe having the same problem faq 768-4575 in this section. Anyway I went with Private Sub Command1_Click() With CR1 .ReportFileName = App.Path & "\Your Report.rpt .ParameterFields(0) = "Your Crystal...

Hello I have a report that runs off my Equipment table. I am trying to run the report based of the serial number. I have a parameter in the report that runs it by serial fine but I need tio do it by Visual. When I use this Private Sub LaVolpeButton1_Click() Dim txtSerial As String <---My text...

Thanks for responding to my post The cost field will change as each order is shipped. What I need to do is if the shipping method = and the package field = then subtact the percent by the cost field. Example Service Package Express Letter Then subtract 3.2 from Cost(Whatever it is)...

Hello I have an Access database. In my table I have 3 columns I need to work with. The first one is the shipping service type, the second is the packaging type, the third is the cost of shipping. There are several different shipping services and package types. What I need to do is input the...

Hello I am using Crystal 8.5 and a Access Db. I am using dates and option buttons to let the user to get the data and populate my crystal report. What I am trying to do is allow the user to select the distinct account number then date to fill the report. I have the account number populated in...

Far as I know if it's a case of multiples the ID will recieve a -1, -2 and a new line in the db so forth. Most of the time it will be only one. Unfortunatly I am sort of 3rd party in this. The software is what it is and so is the DB. I am just rying to find a way to marry the two so it doesn't...