Search results

I used your codes to find vbCrLf in the comment column and the query returned PosnOfChar for all records as "Not Found"... So I think the vbCrLf is not the ALT+ENTER key in the comment field. If you type two sentences in a cell of a spreadsheet, then press ALT+ENTER key at the end of first...

Hi all, I have an Access table with >100K records and it has a comment column which I joined from another small table. The small table has reviewers' comments by each part number they reveiewed which I copied and pasted from an Excel file. Somtimes, some reveiwers use the ALT+ ENTER key to...

I changed the data from Single to Double and the query was still not working. When I changed to Currency, the query worked to have accurate data at 4th decimals. Thanks Pat!

I remember I set the data type is Single not Double for "Discount Rate" field so it might be the reason I couldn't get correct data at 3rd and 4th decimal places. I will try it later. Thanks for your responses!

Hi, I have a query to calculate the "initial" amount time "Discount Rate" to come up with the "Final" amount. However, the example below the Access query gives me 297132.6609 when I calculate it manualy I have 297132.6649. Since I want the numbers are correct at 4th decimal places, I wonder...

Hi I have a macro to export a query to CSV format by "ImportExportText". My original number field in the query have 4 decimal places. After the export, I see the numbers are in 2 decimal places in CSV file. Is it a way to change the query or some settings to show 4 decimal places in the...

Hi, I have an excel file of 17000 lines with part numbers and routing operation times. I wanted to have some formula to show the subtotal of a part number's operation hours after the filter instead of to show the total of all parts' operation hours. Is it a way to do that?

Excellent! This is exactly what I tried to accomplish.:)

I have a huge text file which I opened it in a spreadsheet. The data is not in database format. I want to manupulate the data and put them in right columns. Currently, all data is in column A 1 thru A70000. I want to get the part numbers from column A in column D and the part numbers are...

I have an Access Database that I wanted to be the similiar search like yours. If you could share the codes that you come up with the solution in the Forum, that would be great.

I think I'm fine now after I repaired the Office 2007 in Window's control panel.

tried the "compact & repair" but no luck yet

I have several Access Databases. Some of them have a switchboard. Currently, I received an error when I wanted to open the switchboard. The error says "Run time error '-2147418113 (80000ffff)': Method 'Conncection' of object '_CurrentProject' failed. When I cliicked the "Debuy" button and...

awesome. I used the color of "system button face" and it worked. Thanks!

It worked. Thanks very much!

I created 4 command boxes, 1 list box, 2 textboxs and 1 combo box in a form. I wanted all boxes have the same look like the command box. However, I tried different grey colors but still could match the command box's back color. Would someone know the exact back color code for a command box?

I have a simple Access module to download a query's output by BU field. There are 15 BUs so the module will create 15 excel files. It works well. But now people wanted to combine two or three BUs together in an excel file due to their relatively smaller records. Any suggestion to change the...

Thanks! I changed my codes and it worked. There is one thing I don't like this transferspreadsheet command in whichthere is no preserved data format in excel file. I created an Excel macro to reformat the data columns.....

I have a simple VBA code to opoen a query based on an input of one "Plant number". My code is as follow: ***************************** Private Sub cmdOpenQuery_Click() 'Debug.Print Me.cboPlant <- Original code to enter a plant number cboPlant = "1100" DoCmd.OpenQuery...

Both worked well. Thanks very much!