- Strength to Increase Rep
- +0
- Strength to Decrease Rep
- -0
- Upvotes Received
- 2
- Posts with Upvotes
- 2
- Upvoting Members
- 1
- Downvotes Received
- 0
- Posts with Downvotes
- 0
- Downvoting Members
- 0
DBA (Oracle, DB2 & SQL Server) and VB Programmer
61 Posted Topics
 | santhakumar, You'll need two things in order to print barcode. 1) the font for the specific barcode to print, i.e. Code 39 (or 3 of 9), Code 128, Interleaved 2 of 5, etc. 2) the algorithm used to convert your data into the characters that need to be printed, this … |
 | Hi Steelchords, In order to see hidden objects in a database, even for importing, do the following: Menu "Tools/Options" Tab "View" Check "Hidden Objects" and, possibly, "System Objects" In order to find all references to a specific object, even in stored queries and cotrol properties of forms and reports you … |
| | Hi all, Here's to hoping that a SQL Server guru is hiding among the ranks of DaniWeb members. I have two servers, DB01 - the production database server and BKP01 - the backup server, that are in two different geographical locations. Since some queries on DB01 are accessing BKP01 there …  |
| | Hi Bang2711, First of all you are missing two .dlls in your .zip file: XVoice.dll ExButton.dll Next, I see you have references to both DAO and ADODB in your project, unless you actually use both (and from what I see you are only using DAO) remove the one you are … |
| | Hi , Try this out, it worked well when I threw it together. But [b]REMEMBER[/b] to read the note in the header... You have been warned... ;) [code] Public Sub CreateQuery() 'NOTE: this code NEEDS to have a reference to DAO ' If you already have a reference to ADO … |
| | Hi community, I have the weirdest error happening in my VB6 program when I try to execute an "INSERT INTO" query. Here are the premises: [code=VB]Public conn as ADODB.Connection Public rs1 as ADODB.Recordset[/code] - the database is Access 2003 this will be migrated to SQL server later. - conn has … |
| | Hi kdee, You could try something like this:[CODE]Private Sub PopulateFromData() 'Assuming your dataset is called Data1 'and your ComboBox is called Combo1 Combo1.Clear 'If you want to start with a blank ComboBox While Not Data1.Recordset.EOF Combo1.AddItem Data1.Recordset.Fields("<your field name>") Data1.Recordset.MoveNext Wend End Sub[/CODE] Hope this helps Happy coding Yomet |
| | Have you tried ".AddItem" with column values separated by "vbTab"? Yomet |
| | Hello, I have the same problem as this poster [URL="http://www.daniweb.com/forums/thread89221.html"]http://www.daniweb.com/forums/thread89221.html[/URL] but to summarize: I have a VB6 project that worked fine until Sep. 2008. I have not worked on it since then so when I started working on it in the last month and got error messages I was very … |
| | Re: Automation error Could you please post your project? It will help us to help you solve your problem. Yomet |
| | aparnesh, Have you tried adding a reference to "Microsoft PowerPoint XXX Object Library" to your project? Through the "Project / References" menu. If so, sorry but it was obvious and I'll see what can be done in other ways. Otherwise, give me an update to see how it's going with … |
| | What Comatose means, I think, is that if you are not using VB as the programming language this post does not belong here but in another forum dedicated to the programming language you are using. Yomet P.S. Corerct me if I'm wrong Comatose. |
| | Hi, I have a weird problem with my workstation at home. All of a sudden the network connection status says "Acquiring network address", however, my computer is running on a static IP address and has been doing so for years now. I have a wireless access point (WAP) that is … |
| | Hi, I have a form of variable height. When the form grows in height I have code that verifies if the bottom of the form will come below the bottom of the screen and, if so, moves the form up - no problem until here. However, some of my users … |
| | [QUOTE=royaloba in PM]sir Yomet help me sir i'm stuck with my project...my problem is how to open a multiple text file and load it to a single master file...i already have the code how to read multiple text file but the problem is when i write the text file it … |
| | Hi grandfilth, I tried to format a control for degrees minutes and seconds and, just like you, could not do it. So I made these two little routines that will do the job for you, one converting from decmal degrees to degrees, minutes and seconds and the other converting back … |
| | Hi Michelle and JackAssNo1, First of all I want to thank you for not going the way of letting your users do everything in one form, it'a an approach that often leads to catastrophe. Now for the problem. I don't know what the 'cure' is for your problem with Form.AllowAdditions … |
| | royaloba, In order to parse out the data you do not want I suggest validating the input line before splitting it into the data() array. Assuming that you only want the "Access" events in your database I would change your code to the following: [code] While Not EOF(inFile) Line Input … |
| | setup, See w00dy's reply to the initial posting, it is the best way to go. In the Package & Deployment Wizard you can add files that you [b]know[/b] are needed, i.e. database files, .ini files, etc. Yomet  |
| | jto, As far as I know you will have to install the VB runtime, and probably also the Crystal runtime, files on each PC that will run your program. Once you have installed those support files you can run the program over the network as long as any specific DLLs, … |
| | Re: Arabic printing kmbhat1971, If I understand your problem correctly you are transferring data from VB to a Word document but when you do this the text does not display in the correct font. Is this correct? If so what you need is simply to tell Word to use the correct font before … |
 | adalita_m, Do you mean that if the customer should get $35.70 back your program needs to calculate the smallest number of coins and bills that make up $35.70? Please confirm if this is your problem or if I misunderstood you totally. Yomet |
| | Hi jto, I suggest you make a sub that finds the fields depending on the space character since it seems to delimit your data, for this you can use the SPLIT function to return the data elements in an array. From there you can easily cut out what you don't … |
| | Hi Iafia, If all you want to do is shift the letters three steps you can easily do that by taking the ASCII value of each letter add three to it and then convert it back to a character, i.e. [CODE]Dim Password As String Dim i As Integer Dim Return … |
| | Hi helloworld, I really don't understand what you mean when you say "Dim Z As Integer String As String As Integer" since this is an illegal syntax in any flavor of VB. A variable can only be declared as one type so this makes no sense. Could you please tell … |
| | Re: VB and Excel. vishalsomani, Since this is an assignment I will not give you a full answer to your question, that is against the rules of this forum. However, I will give you the SQL queries to get the data you want since you could easily get those through Access anyway. Here goes: … |
| | If you only want to see the Excel workbook opened by your program try: x.visible = True If you need to change data in your Excel workbook while your program is running you will need to modify your program to close the workbook after each update and then open it … |
| | HI2Japan, I had this sitting from another posting here, just modified it slightly. Try this out[CODE]Public Sub Test() Dim SR As Integer Dim ER As Integer Dim SC As Integer Dim EC As Integer Dim RowVar As Integer Dim ColVar As Integer Dim found As Boolean 'Change the indexes for … |
| | Hi all, My client is running a Win 2003 SP1 Server with many users accessing it through Terminal Services. Every night I have some scripts to run that only run correctly if all users are logged off from Terminal Services. I am wondering if it is possible to script the …  |
| | And then there are those who actually [u]want[/u] to do something with their lives. Find some other forum where this kind of activity [i]might[/i] be welcome As for difficult - that's where you grow... (*hint, hint, hint*) |
| | Hi Comatose, I just saw your code and would like to know if you can really use a FOR EACH ... NEXT loop over an array. I have never tried it nor seen it but it could be really handy instead of using UBound all the time. Thx Yomet |
| | Hey nicentral, Nice Psuedo code, it's been years since I last saw that (University)! However I think you meant to put an "AND" in here: if not rs.eof or not rs.bof then or maybe If not (rs.eof or rs.bof) then I hate it when I get caught in these little … |
| | Hi Jhun, It should be quite easy since you have already figured out how to get data into the grid. The way to go about it is to set the RecordSource property to a query statement instead of a table name. The RecordSources "Table1" and "SELECT * FROM Table1" will … |
| | VBNewGuy or NewVBGuy (whichever you prefer), First of all you need to have a ComboBox control somewhere, you cannot create an object variable that is not pointing to a specific instance of that object type. Once this is done you can set your vcombo1 variable to point to that specific … |
| | Hi Yoshidex, I am not totally familiar with the workings of ADO but I do know that you need to put a loop into your code that will loop through all the found records and add them one by one to the listbox. I also included a check after the … |
| | Marco, Since there are millions of things that could possibly cause VB to crash nobody can help you by just looking at your message. The best way to get help would be to post your project, or at least enough of it to cause the crash, then someone could actually … |
| | Re: Server checker Hi Slavrix, If you want to know how they did it you could ask then for the source code of their status.php program. That is what determines the color of the square in the web page. In the code of ServerCheck.php you can see them calling it SRC="status.php?link=xaoswow.servegame.com" Creds to … |
| | Hi jto, If I understand correctly you are loading a file and want the progress bar to indicate how far you have actually come in the load process - correct? If so you could use the FileLen(<path>) function to get the length of the file initially. You store this in … |
 | Hi complete, Firt of all - Kegtapper, "String * 4096" is the correct way to declare a fixed length string. Now for the problem, looking at the declaration of atxml_ValidateRequirements the type mismatch is in the second argument - it should be an integer, the percent sign is the type … |
| | Hi williamrojas78, I think the best way to get help on this is to post your project, including your .exe, and then we might have a look at it. Happy coding Yomet |
| | MDDS, Not sure but I don't think it's possible to do this directly in the file, however, I have a tactic to do it in a clean and fairly simple way. Create a UDT (User Defined Type) that contains the same elements as your text file Create an array of … |
| | Hi Avatar, I know I shouldn't give this to you "pre-digested" but I got into thinking about it and came up with a partial solution that is really "well-cooked" so have fun. However, just to make it a little bit more fun I will give you no comments or documentation … |
| | Hi Halsoft, I am not sure what you want to do but here goes. If what you want to do is look through your current selection to see if it contains a bookmark you could try something like this: [code]Public Sub test() Dim i As Integer For i = 1 … |
| | If I understand correctly you have a common dialog that lets you chose a file and when you have selected that file you want to put the name of that file in a database table - correct? If so just use the return value of the common dialog, it will … |
| | Hi, I noticed another thing that might make your code so bonkers, when you call the function you call it with NBR&, however the "&" is the type declaration character for the Long data type so what you're actually doing is declaring it as an Integer and then trying to … |
| | Or you get Postie, a free SMTP, POP IMAP client that can send e-mail without Outlook. I have used it myself in various projects and it works flawlessly. Here is where to get it [url]http://www.infradig.com/[/url] And here is my send-mail sub [code]Public Function SendMail(recipient As String, msgbody As String, subject … |
| | Hi barryhuizenga, From what I understand this is what happens: - You click a button to insert the time called into a patient's record - This button specifies which patient you wish to modify - What you want to do is simply update the time called (PAT_TimeSeen) field of that … |
| | Maged, I don't know about the problems you are having with the Chart componenets but the "The file is in use by another application." Error message has been bugging me also. I have not encountrered this from within VB, becuase I have not used it, but from other programs. What … |
| | Re: sql statement Hi cindynicole, At first glance I cannot see anything flagrantly wrong, however, I don't know the structure of the table. If you are not using all the fields of the table you have to specify which fields will hold the inserted data, i.e. "INSERT INTO order (ID, Desc, oNum) " … |
| | Duckman, Here is a little Sub I typed up that will export all formulas in the current worksheet to a text file. Just paste this Sub into a new module of the current workbook, change the Row and Column ranges to fit your worksheet, select the worksheet you want to … |
The End.