9,979 Topics
| |
Hye again , I have problem to get Backup file .my code is bellow [CODE]Dim strB As String 'On Error Resume Next strB = "D:\backup\db" & Date$ & ".mdb" FileCopy "C:\Database\MyDb.mdb", strB MsgBox "Backup Complete!!"[/CODE] I always receive Run-time error '70' "Permission denied" please help me | |
Hi everyone, goodday. Right now im planing to setup 5databases for each store(5 loan branch). Each branch encode customer and loan account. Also hold each db for the branch inventory. For single branch the database works perfectly (encode transaction and produce reports). Now my problem is.. I want to centralize … | |
Hello . I have a toolbar in my application . IT display image and text in english. Now i want to change the font family of the font. For example the font is ARIAL and i want to convert it to a new font(ex HINDU) that i have installed in … | |
please i am new to this vb programming but i have a challenge before me.. I need to make a program that will compare the date in the database with the system date and if they are equal, it pops up a notification on the icon tray. Your help will … | |
I have this little problem (at least I hope it is little). My vb6 program behaves differently when I execute it with the execute button in vb6 and when I execute it by using the compiled .exe file. I have a huge 2 picture boxes which loads 2 x 5 … | |
When i was entered into login page the code is here [code] Private Sub txt_Password_KeyPress(KeyAscii As Integer) If KeyAscii = 13 Then If UCase(txt_Password) = UCase(txt_dbPassword) Then Unload Me Modification_Main.Enabled = True 'unlock database here Else MsgBox "Invalid password.", vbExclamation txt_Password.SetFocus SendKeys "{home}" & "+{end}" counter = counter + 1 … | |
I need to create a program which calculates the bonus points for the books read. This program need to obtain reader name and bonus point earned. Number of books read Points is as bellow; First three books 10 points each Next three books 15 points each All books over six … | |
hi good day, im a beginner of VB using DAO. Right now im doing my first sales system. My problem is I want to delete something from my database. my code is this. With DTPicker1 Dbase.Execute(Delete * from SalesTable where eDate = ' " & DTPicker1.Value & " ' ") … | |
im making a program and my problem is i want to make the textbox behave like a search engine whenever the user input certain word in the textbox all similar keywords will display like search engine does.sorry i dont know what is the name of that control and im not … | |
Hello, Hi, can you help me please I have problem in my program,I used MsAccess as my database... how can i make my textbox just like in google that when you type a certain word it will have drop down list... ex...the user will type this word "how to make" … | |
Hi, I hope some one have time to help a new hobby programme. I have a Word doc with is a report over an inspection, with is linked to VBA. First history When you are open the doc you will have a pop up window (with is create in VBA) … | |
Hi, I have created a program to play videos in VB6. But it cant play FLV files. Can anyone please suggest how to play FLV files in VB6. | |
I have followed every step in the My Sql forum posted - [URL="http://dev.mysql.com/tech-resources/articles/vb-blob-handling.html."]http://dev.mysql.com/tech-resources/articles/vb-blob-handling.html.[/URL] I have no problem in saving the picture file to MySql. The problem arises in retrieving the picture. I am using code as follow: - [CODE]Private Sub DataLoadPicture() On Error GoTo ErrFailed Dim cnPhoto As New ADODB.Connection … | |
Hello, I am almost done with writing the program below. My problem is when I go to get the next line in the file, the first line works great. I am writing it in autoit and I heard it is similar to Basic so hopefully someone could help. I am … | |
Hey guys, I want to write code that does something like this: If option = 1 Then Create one Button and display it Else If option = 2 Then Create two Buttons and display them End If To do this, can I simply do: [CODE]If option = 1 Then Dim … | |
I'm relatively new to VBA, and I'm trying to automate some macros for a datasheet. I need it to look at the value known as rackRack.Text (I know, not the best var name) and split it. The original value would look like: "B-04". I want it to split and select … | |
Hi, Please find my requirement - The Datetimepicker should display the current month - It should disable the 1st day of the month (i.e mindate should be 2nd day of the month) - It should disable all dates > current date (i.e maxdate should be current system date) So that … | |
How to get the difference of the month from the date specified. Example: [code=vb] date1.value="5/1/2010" date2.vale ="5/31/2011" [/code] it should give a result of 12. thank you for helping.! | |
So I've been trying to convert CSV files to XLS. However, this line of code keeps giving me problems: [CODE] oExcel.SaveAs FileName:=FilePath_XLS(TableName), FileFormat:=xlNormal[/CODE] The FilePath_XLS returns correctly... I just can't figure out what's going wrong but it will not execute.. | |
Hi everyone! i have a question if someone know how can i check with a VB application if another programs window is minimized or maximized? example i would make a simple VB app that could while running check with a timer if "MS Paint" for example was maximized and check … | |
hi! we are having trouble in our program. every time we click login button it will proceed to the next form even if it doesn't have anything on it. can you please help us regarding this problem [code] Private Sub Command1_Click() Adodc1.RecordSource = " select * from login where username … | |
Hye All Please help me to create Data Reports Accourding to given Dates. I Created a VB6 Form put 2 Time/Date Picker Controls and one Command Button.what will be code for Button to display Report Between given dates. | |
The project I'm working on has a bit of code in the workbook open event that makes excel go full screen, hide any toolbars that a user has configured to run in fullscreen (and make a note so they can be restored on exit) and loads a custom toolbar. [code] … | |
I am writing information to a list box and I want to be able to have a small case letter following a period with no space between them ie: Harry.c I am using VB6. I will appreciate any/all help. Thanks. | |
I wish to call a form with the form name contained in a variable using a declaration such as [CODE]public myform as form[/CODE] will work if the formname is used. but myform will not accept a variable containing the form name | |
I'm working on a vb parser for excel but when it comes across anything that is not int the spread sheet it gives me an excel error message and I want to stop that before it prompts. [CODE] Try xlWorkSheet.Cells.Replace(What:="Boulevard", Replacement:="BLVD") Catch ex As Exception ex = Nothing End Try[/CODE] | |
hi!!! my group is doing a thesis work... and the name of our thesis is Faculty Attendance Monitoring System Using TouchScreen Biometric System... Can You give me some code in making that system... please!!!! tnx.. from:Hotaru | |
Hi, Does anyone give me some suggestion? When I close the form, but some process is still running.I don't know how to handle this kind of situation. What I want to do is that stop all processes first and then close form automatically. [CODE]Private Sub Command1_Click() 'Do process 1 Call … | |
Hell all I have problem to login as administrator and as Operator with less permissions. following code .i create and open recoedset "Type_rs" [CODE] dim Str_T as String SELECT Case Type_rs.Field("User Type")=Str_t Case str_t="Administrator" mainfrm.toobar1.enable=true case Str_T="Operator" mainfrm.toolbar1.enable=False End SELECT [/CODE] I thing Type_rs.Field("User Type")=Str_t is not working properlly please … |
The End.