Search results for query: *

I am new to VBA and I need help for a simple macro that will look at the value in A column "Part" and copy the value of B column down till it gets to the "Part " again and loop to the end. It should looks like something like this: Part 3222-01 3222-01 3222-01...

I have a table in MS Access that looks like this: Parent PName Child CName Clevel SupID Supplier ChildQty 11111 base 111-05 pppp A1 00555 uuuuuu 1 11111 base 111-04 llll B1 00553 mmmmmm 1 11111 base 111-07 hhhh c1 00333 dddddd 2 and so on. I have abot 150...

Hello! I have two tables joined by PartSupID, the first table(Part) contains all info about the product Part#,supplierID,Name, currency etc and PartSupID (combination of Part# and supplier ID) as a primary key. The second table(Price) contains the price information like POPrice, contract#...

I have a combo box as a month selection. Combination of the combo box selection and a fixed word like "Alum" would be my field in a table to update. For example my current selection is "JUl" and I would update the field "AlumJul" in a table.Something like this. Update Cost set...

I use Crystal reports version 10 and Betriave database. I am exporting invoices with multiple line items and my problem is with the description field. The data look like this: Invoice# item# Description Qty 3888 Order#4555 0 3888 BOL#000055 0 3888 PacKL:3888...

Hi, My questions might look stupid but I am stack on this event. I just want this event to be fired when the user click save button and dispyay the message box to check the data before saving it. My module look like this: Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As...

I have three buttons on the form "Save", "Exit" and "Print", when the user save the record it might go to the entry box again (combobox on the form) or might just close the form or print entered record. My problem is how to recognize user's input. I have shortcuts like Alt + S-Save, Alt +...

Hi, I am new in VBA and I need help to write this small macro. I have an excel file that look like this: Parent# child # 110 320 110 450 110 220 150 440 150 320 150 125 150 130 and so on. I need to write a macro that will copy child#...

I set up six exports macros with the specs to export six queries into six text files. Now I would like to create a macro that will copy each six files into one file. Can somebody help me with a sample. Thanks very much!

I have a select query with the new record that should be added across multiple joined tables like: Tables "local_part", "bill_to" and "customer_part" are joined with one to many relations and now I have a query from sales table with new customer part number and bil_to # . How can I update the...

I tryed to set up ODBC connection for Pervasive database step by step but I am not getting the connection. I am using CR.9 and pervasive SQL 2000 I can pull out the data using Btrieve data file from CR, but I want to set up ODBC in order to use data in Excel and Access I know the location of...

I got a custom report made by another company, and my job was to change the database connection to btrieve database that my company is using.I am using Crystal Reports 9.0. Every time when I am trying to connect to .ddf file I am getting an error that .dll is missing . I reserched a little bit...

I have a field in database that contains different phone formats depending on different state. So I have to write a formula that is taking a field from database and make the same format on the report. For example I have a field in database for Japan and format is ###-##-##-#### and field for...

Hi, For example I have 4 combo boxes filled with numbers(1 to 4) and user can select one number from combo box, but based on sorting user can just select one combo box and leave the rest blank or can select all combo boxes. I tried if statments, but that didn't work like this: if combo1.text=1...

I developed app. using VB 6.0 and Crystal Reports 4.6 . Everything works fine until I instal app on another machine,but when I want to open the report I got runtime error 20997. I even tried with instaling Crystal Report on that machine , but that didn't work either. Anyone can help?

Using VB6 and CR 4.6 , when I instal app. packed with PDW and when I want to open a report I get the runtime error 20997.Please if someone can help me. Thanks.

I am using VB 6.0 and Crystal Reports 4.6. When I instal app. I am geting error 20997. Can anyone help please about this error. Thanks.

My data acces from VB is hardcoded to mdb.file, so after instaling app. to another mashine, it look for mdb. file John B suggested ini. file to point app. to database. I don't know how to do that , if anyone can help me please , so I can keep my existing code. Thanks.

I packed my app that was instaled on D:/My folder with PDW and when I was trying to instal it on another mashine, it looks for database from my folder like D:/My folder/My database. How can I change connection to database , so that it looks for database from my app. not from developer folder...

I packaged my app. with PDW everything went OK, but when I ran setup at the end I got the error "Problem with shortcut icon" . If I ignore error I can still run app. from program files , but Start-Programs-myapp-empyty doesn't work. Any help would be appreciated.