Search results for query: *

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

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

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

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

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

Hello I have a database in which two of my columns are ID (Populated) and Invoice (Empty) I have a query to populate the Invoice table based on an export which fills the query with the ID and Invoice number. The query works but I get an &quot;Circular reference caused by 'Query' error message...

Hello I have an access db that I can't alter the structure. In one of the tables the fields contain commas. I use a query to pull the info out into a csv. With the commas in the db I get my information spread out because of the commas. I have heard about the replace function in VB but don't...

Hello Is it possible to use the control key to select multiple records in a msflexgrid? I have searched but I have not come across a solution. Any help would be greatly appreciated. Bob

Hello I have a Flex Grid populated by my db. I am wondering is there a way to select mutilple rows in the grid and delete them. It will allow me to use the shift key but not the control key so the user has to delete one at a time. Any help will be greatly appreciated Thanks Bob

I have a database (access 2000). In the db has a query Address Corrections. Currently I am pulling the info into a data grid. In the db there is a column called Bill Date. The query and some of the fields have spaces between the names. What I would like to do is pull the info into the grid based...

Is it possible to run an access macro if access isn't installed on a machine thru VB? If so how can I do this? I have several macros in a database. They are mostly reports Thanks Bob

I am trying to access a query in access 2000. Tables are ok I just need to access the query and send to flex grid to view results. If someone would show me the code I would be greatful Thanks Bob

Hello I have a main report with a sub report inside. When I am in Crystal Reports I can view the main and the sub reports. When I either compile or try to us VB to view the reports all I can see is the main report. The link is there but I am unable to access the sub I have fields in the main...

I need to translate numbers to text from my company db. I am using the statement below to pull out the info into a csv file. In the Shipvia column we us numbers 1 = Post office, 2 = Fedex, 3 = UPS, 4 = Courier. When I pull it out I get the numbers. Is there a way to translate them to the text...

Hello I have a main report with a sub report inside. When I am in Crystal Reports I can view the main and the sub reports. When I either compile or try to us VB to view the reports all I can see is the main report. The link is there but I am unable to access the sub I have fields in the main...

Hello I have a crystal report that has an on demand sub report. I have it on a form with a command button to run the report. The main report shows fine but the sub report won't run. Any suggestions would be appreciated Thanks Bob

Hello I have a main and a sub report. The main report consists of CompanyName, Packages(Shipped), Cost, Date. I use a date parament to retrieve the data. In my sub report I have State, Packages, Cost, Date. Also I ma using another date paramenter in the sub report. My probelm is although both...

I am pulling information from an Access 2000 db to a csv file. In one of the tables (Shipment) the cost and weight fields I need to change the formatting of the numbers. I cannot alter the db so I pull it out in a csv. My problem is the numbers in the cost and weight fields are not set up the...