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

    Export query and name by data in field 1

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

    Export query and name by data in field 1

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

    Delete where #Error

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

    Delete where #Error

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

    Julian Date Help

    ...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 Table1.date AS Expr1, Format(1000*Format([table1].[Date],"+yy")+Format([table1].[Date],"y"),"""UP""00000")+Mark AS Date1 FROM Table1; That seems to be giving me what I need for...
  6. mdctsg

    Julian Date Help

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

    Julian Date Help

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

    Copy selected file in FIleListbox to specific location & ext

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

    Hello I have a report that runs of

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

    How do I pass a string parameter to Crystal from a VB text box?

    If you are familar with Crystal Reports then skip to Part 2 Part 1 Create your report in Crystal. Insert your parameter. If you are not familar with it go to Insert, select Field Object. Then select Parameter Fields. Next select the new button (Which looks like a page with a yellow star)...
  11. mdctsg

    Hello I have a report that runs of

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

    Help with query or module????

    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)...
  13. mdctsg

    Help with query or module????

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

    VB / Crystal selection

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

    Select Query

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

    Select Query

    The program that creates the invoice is a standalone application. It throws out an export of what data you want. So I can send it back to access. Sales are being generated one at a time. And yes I want to update each time it comes out. So the software creates the invoice, exports the data to...
  17. mdctsg

    Select Query

    Thanks so much for taking the time to help me. What I am going for is: In the database there is table1 which has customer information with the ID to define them. At the end is a blank column for Invoice number. In another program an Invoice will be generated after a sale. The program can...
  18. mdctsg

    Select Query

    Yes it was Table1. I added a table2 and it runs error free. The reason I was using a query to table1 is I need to run and update each record automatically each time a record is written without having to manually run the query. Can this be done? Thanks Bob
  19. mdctsg

    Select Query

    Same thing. I renamed the query to Return and changed the name in the statement.
  20. mdctsg

    Select Query

    It's working but I am getting the same error message Bob

Part and Inventory Search

Back
Top