Recent content by alifyag

Hello, I use the following code to open a new instance of excel and do the needful Set EXLApp = New Excel.Application Set EXLApp = GetObject("", "excel.application") EXLApp.Application.Workbooks.Open "C:\Perl\bin\test.xls" EXLApp.Application.Visible = False Set...

hello, i open an excel worksheet though vb and make some changes in the excel file. the excel worksheet is in hidden mode. i want to create a save as button on my vb form. when the user clicks on the save as button i want to enable the user to save that excel file in the location he desires. i...

Hello, The following code gets executed when i click on cmd_Execute Private Sub cmdExecute_Click() Shell ("perl gps_field_VB.pl " & sFile & " " & "ams.xls " & final_lat & " " & final_long) End Sub where sFile, final_lat, final_long all are defined. The Dos window pops up in minimised mode and...

hello, i have a problem with date formatting. i am using PHP and mysql. i want to accept the date from the user in mm/dd/yyyy format and if the user enters anything else, i wont except it. how do i set the criteria on my textbox where the date is inputted. thanks

hello, i have a combo box with a list of drop down values in it. also i have a add button. if the user chooses something from the combo box and clicks on add then it gets added to another list box. however my problem is that when the form opens the first time and the user directly clicks on the...

hello, i have a combo box with a list of drop down values in it. also i have a add button. if the user chooses something from the combo box and clicks on add then it gets added to another list box. however my problem is that when the form opens the first time and the user directly clicks on the...

hello, i have a list box to which i keep addign records. i also ahve a delete button. when i click on the delete button i want the record in the listbox to get deleted and it shoudl eb physically removed. its an unbound form. i have used the following code in my delete button but the record is...

hello, i have a simple question. i have a text box on my form and using classes i am filling the text box with price. however the decimal point does not show. for example i have price 45.75 but it only shows 45.00 please let me know...i tried currency, long, integer but i didnt work. thanks al

hi, i have a combo box which is going to contain certian fieldnames. i want to have only certain fildnames in it and not all. i used the following code Set rs = CurrentDb.OpenRecordset("Select top 1 * from Publishers;") For i = 0 To rs.Fields.Count - 1 If rs.Fields(i).Name...

hello, please help. i am in a fix. i have two columns in a report address and company name. if the user decides to sort by company name i want company name to be displayed as the first column and address as the second column and vice versa if he selects address. i wrote the following code in my...

hello, i have a form switchboard where when the user types his user name and passowrd, i store the NAME of that user in a variable called pname which i have declared as a public variable in the bas utilities. now when this user prints a report i want the NAME of this user to get displayed in the...

hi, i have a combobox on which i have to carry out a sort. if the combo box is left blank by the user ( that is he does not select anything from the drop down list) then i want my report to be sorted by the CompanyName field in my database when the user clicks on the print butten. pleeease help...

hi, i have a combobox on which i have to carry out a sort. if the combo box is left blank by the user ( that is he does not select anything from the drop down list) then i want the form to be sorted by the CompanyName field in my database. pleeease help. i tried writing code in the after update...

hi, i have a combo box and a print command button. i want the print command button to be disabled when nothing is chosen from the combo box however as as soon as somethign is chosen from the combo box, i want the command button to be enabled. in which event should i do this. i am working in vba...

hi, i have a combo box and a print command button. i want the print command button to be disabled when nothing is chosen from the combo box however as as soon as somethign is chosen from the combo box, i want the command button to be enabled. in which event should i do this. thanks