shena

Hi all, i created a table (columns:part_no, part_desc, pi_loc) whereby part_no field has unique values. But, now need to add one more column "customer" and the part_no will have duplicates. And, we need to verify new entries by checking the part_no and customer fields (which tied together is unique). How …

Hi there experts, I would like to know that is there any way to filter data in vb6 (data grid, flex grid or etc) as we do in excel spreadsheet? If no, can anyone suggest how to filter records in data grid pls? I'm nw to this. Please help anyone. …

Hi, i have 3 tables in oracle sql developer (packing, detail, header). I need to update the packing table's part no with header table's part no. But header doesn't contain the serial id hence i need to refer to detail table for cross reference. I did like below, but it …

Hi, I wrote a vb script in text file to send an automated email as a reminder to 36 recipients. I'm loading recipients from access database. I can send out email when i tried with test db, whereby there's only one recipient for each category (TO, CC, BCC). However, i …

Hi experts out there, I'm populating records from access db. The condition is that if the first column has been filled with 5 pairs of records (10 rows and a row of gap between each record), then move to next column and so on. How do i accomplish this? Kindly …

Hi all, I would like to format a column in datagrid with 2 conditions. The column must be entered with only "N/A" or date (DD-MMM-YYYY) format value. [CODE] If Me.grdDataGrid.DataFormats(10).Format <> "N/A" Then MsgBox "Invalid Data Entry!", vbInformation Exit Sub End If[/CODE] The code above still produce "Invalid Data Entry" …

Hi experts out there, I'm using a zebra printer, model TLP 2844Z. I need to print my company logo on a label. I've been trying this for the past two weeks and no idea what I'm doing wrong with the code below :( Other lines are printed except for the …

Hi all, I want to send an email to people in the database field list. How to accomplsh that? My code is straight forward and also found an error saying: "the transport failed to connect to the server". Please help. [CODE]Private Sub From_Load() Call SendEmail End Sub[/CODE] [CODE]Public Function SendEmail() …

Hi experts out there, I'm using ms access to store a date value in (dd/mm/yyyy) format. This field too stores text value something like e.g: N/A. When user selects a date (dd/MM/yyyy) via dtpicker, i want the datagrid to be filtered by that date if it found in that date …

Hi all, I have a column with duplicate serial numbers. I would like to find those duplicates and then highlight the whole row. How do i perform this in macro? Pls help anyone.

Hi there, I wrote a VBA program as below, but I'm not able to exit the sub nor exit do looping if the condition is fulfilled, why so???? It runs through the lines until end subsequently creating empty text file. I want like if the if condition is fulfilled then …

Hi all, I have two textboxes only in a form. At textbox1, upon pressing enter/carriage return it suppose to setfocus to textbox2 instead it's performing textbox2's keypress event by calling a command button. How to handle this? Where am i doing wrong? Please help. [CODE]Private Sub txtSNO_KeyPress(KeyAscii As Integer) If …

Hi guys, I have a very simple form with 2 textboxes only and a listview to display added record. Upon form load i wanted to sest focus to textbox1, but it shows this error: Run-time error 5:Invalid Procedure call or argument My form load code [CODE]Private Sub Form_Load() bModelMaster = …

Hi all, I have a vb program that opens a file(.btw) if the input matches the .btw file name. How do i prevent from opening another .btw file via input if there's already one file opened? Please help me experts out there. Thanks.

Hi friends, How do i calculate the week number of a year? The week number should be calculated from the first day of a year. For example, this year 1st January 2010 falled on Friday, so week 1 should be calculcated from Friday(01/01/2010) till Thursday (07/01/2010). therefore, given any date, …

Hi, I created tables in ms access whereby all the tables have index. In a table, if I delete a record (lets say index number 10) and then write a new record through program, the new record doesn't follow the last running number (where last index is now 9, new …

Hi experts out there, I have a program where the backend is access database. I was able to run the program in user's pc after i placed it at C drive. After that, i placed it in the server and created shortcut to the.exe, the program ran. But, when i …

Hi all, I have form to populate list view items which allows the user to view, add, update, and delete model records. But when i start the project, the [B]Run-time error '380': Invalid Property Value[/B] comes. i click to debug, it highlighted a line as i have indicated below in …

Hi all, I have string like this: JK-501-[COLOR="Red"]3556-25[/COLOR]-A-03#C I would to extract the middle part without dash which suppose to look like this:355625 I wrote the code this way, but the string extracted looks like this: 3556-25355625 [CODE] For i = 1 To Len(cbPN.Text) If Mid(cbPN.Text, i, 1) = "-" …

Respedted Seniors, I have a form to input a product model detail. When i run the project and choose to click the menu 'Model Master', an error as below occurred. [B]Run-time error '3709': The connection cannot be used to perform this operation. it is either closed or invalid in this …

Hi friends, I have a form with 8 textfields. Textfield1 is combo box. Thus, when user chooses an item, Textfield2 and Textfield3 automatically retrieve value from DB and fill in the textfields (in lostfocus event). Then, user will add running number behind Textfield3. After that, fill in the rest of …

Hi all, How to create refresh Button in the form? I have combo box with the data linked to Access database. I create another form for data input for those that appear on the combo box. When I close the input form, I realise that the data is not yet …

Hi, I created a macro in excel by importing XML file and then make amendments and then run to export as textfile. I have a column with specific characters like "A" or "C" as last characters of a string. I want to export that column strings after removing the last …

Hi, I need help for this problem that i'm trying to solve for a while (i'm new in PHP). How do i submit the value into database? Here's the code: [code]<form name="Form1" method="POST" action="checkbox.php"> <p><input type="checkbox" name="floor tile"> Floor Tiles</p> <p><input type="checkbox" name="polished tile"> Polished Tiles</p> <p><input type="checkbox" name="homogeneous tile"> …