Search results for query: *

Thanks a lot to everybody, offset function worked perfect

The "Part" section doesn't have equal number of rows, sometimes it might be more then 10 rows in one section. The last 'Part" in column A can be used to terminate the process even if I have to do a couple of rows manualy it is better then doing 17000 rows. Thanks a lot for your help!

The excell sheet contains 17000 rows with data and there are multiple part numbers that are displayed in the order I displayed, the last set of part will look like this Part 03999-01 empty cell empty cell empty cell empty cell empty cell

Column A "Part" should stop the copy process. Right now it looks like this: Part 3222-01 Empty Empty Empty Part 3444-02 Empty Empty Empty Part 3555-03 Empty Empty Empty and so on and I need it like this Part 3222-01...

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

Yes and for Alt-P is the same change, but the problem is that the button needs to hava a focus in order that this shortcuts works.

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!

Sorry I didn't explain the problem completely the first time so now I will try to do it better. I started the sales database, I have a customer_parts table, local_part table and bill_to table every month end I am going to get a prodact sales report in Excel with the customers part#, local part#...

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

The problem is I don't know what format is in database, because format is custom from the input screens, so I have to find out first what the format is and then format the field in the report.

I want the same format as in database, but there are more formats (like every country different format), how can I(if I can) write the formula that read database field and make the same format for the phone field on the report. Thanks!