[vba] Forum Topics

Hi Everyone. It's been a while since I was on here last, but ran into an interesting problem with a nested for loop that I cannot solve. Hoping someone here will know the answer. I placed breakpoints in my code at the For x=1 to 10 line and after to …

Hi I hope someone can shed some light on the problem I am having at the momment with an Excel 2010 Sheet, the workbook has 13 sheets with formulas and I rotate the 2 values using vba there are other things going on like a link to SQL server that …

Am having this piece of COde, but whenever am trying to execute this , Dim tsf As TestSetFactory - > error user not defined appears. pls help Dim tdc As TDConnection Sub UpdateStats() 'create QC connection QCconnect_silent "URL", "DOMAIN", "PROJECT", "USERNAME", "PASSWORD" 'process tests getMetrics 'disconnect QCdisconnect End Sub Private …

Hi, I want to change the numeric value in a cell to a string with 1000 Separator(,), e.g. numeric 1000 will to string "1,000" and 123456789 will change to string "123,456,789". How to do that in VBA? Thanks

My process is to multiply the given points in B8, D8, F8, H8, J8, L8, and N8 to A3, B3, C3, D3, E3, F3, G3 respectively. this procedure is to be processed in C8, E8, G8, I8, K8, M8, and O8. after multiplying, the process should perform =sum(C8,E8,G8,I8,K8,M8,O8) to P8. …

Helloooo Firstly, ive done a bit of googling, and found a few articles relating to my problem. None seem to help though. I require a simple method of acquiring the "Page Number" of the selected cell. range1.Information(wdActiveEndPageNumber) Something like this, does not work. Even though i read that it does. …

hi , i have a textbox control in one sheet and a range of data in another sheet in the same file. how do i copy the range of data in paste it in the textbox control? appreciate a reply thanks

Working in Word 2010, I have a long document with many formatting changes to be made. To start with, throughout the document I'd like to replace "Click OK" with "Click [B]OK[/B]", so the OK will be bold but not "Click". I also need it to be case insensitive, as some …

I am trying to add a button to outlook's tool bar using a Macro.The problem is that the button appears but on clicking it nothing happens,I suspect I am supplying parameters wrongly to the OnAction method. The call[CODE]Call AddToolbarButton("My very own button", "Click here", "!<Sub/UserForm>")[/CODE] The method it's self: [CODE]Function …

Hi. I need to make a system where I can accept input from the audience, and it'll show live on a PowerPoint Slide. I can create the user input system, but I don't know how to make a PowerPoint macro that when run will either: [LIST=1] [*]Retrieve text from a …

I have been fighting with this all day and looked at so much documentation and other posts I think I am going blind. I can't find an answer that works. I am trying to read through a set of records until the reference number changes and then return to the …

Hello, as anyone reading this might have guessed I need help. And please forgive me for making it long. [COLOR="Green"]You may skip right to [B]Found Half of a Solution[/B] if you don't want/need the background of my problem.[/COLOR] [B][U]Why and What[/U][/B] I am developping for a client an Excel worksheet …

Hello, I'm still trying to work out the same problem: how to process data from an Excel sheet (above all sort through it but in groups; will explain further down) to use in a Cluster Chart without storing it as data in an Excel sheet. The problem at hand: I …

Hello, it now seems that I might be able to use SQL/MS Query to do what I tried to find a [URL="http://www.daniweb.com/software-development/visual-basic-4-5-6/threads/388319"]workaround[/URL]. (Even if this works that does not invalidate the problem posed in that thread, though its urgency would be reduced.) So: is there a way to perform in …

Hello, I have produced some VBA in Access that creates a spreadsheet. I have also created an SQL query that retrieves records from an Access table. I have 48 tables (each table for a specific institution centre). I have created another bit of VBA code that creates a spreadsheet and …

The below bit of code is running very very slowly. I cant see why this should be but there seems to be almost a second delay when I'm using f8 to run through the code bit by bit when I get to the end if...any clues? [code] Sub firstResponse() Dim …

Hi Everyone, I am writing a program in VBA (within Access 2010) that grabs a specific .txt file, split up the fields as per given specification and imports the values in to an Access table. So far, I can open the file and see what the program is seeing and …

[CODE]Dim Processors(4) As ProcessorType For j = 1 To 4 Step 1 Put #filenum, WritePos, Processors(j).byte0 WritePos = WritePos + 1[/CODE] I'm in the process of translating this VBA code to python, and essentially what it does is creates 4 Processor Objects but as you can see from the for …

Hello All, Could you please help me with the following VBA code that I have to understand (but I am not aware of VBA) [CODE]Public Function ErlangB(Servers As Single, Intensity As Single) As Single 'The Erlang B formula calculates the percentage likelyhood of the call ' being blocked, that is …

Hey all, I have split an Access database not on the server. I have decided to VBA code the links, however I have reached a stall when attempted to VBA code the update query; updating the remote table with data from the local temporary table. I have tried multiple things …

im using the dlookup() to prievew password at a unbound textbox within a criteria that the username and security question that are entered matches the database. Ex: user forget password. he enters his user name, and select the security question, and answer the question. if these data match the data …

[CODE]Private Sub Command4_Click() Dim vPass As String If IsNull([usernametxt]) = True Then MsgBox "Username is required", vbOKOnly, "Required Data" ElseIf IsNull([answertxt]) = True Then MsgBox "Password is required", vbOKOnly, "Required Data" End If ' Evaluate filter before it is passed to DLookup function. strFilter = "[USERNAME]= '" & Me.usernametxt & …

[CODE]Public Sub loginbtn_Click() If IsNull([usernamecbo]) = True Then MsgBox "Username is required", vbOKOnly, "Required Data" ElseIf IsNull([passwordtxt]) = True Then MsgBox "Password is required", vbOKOnly, "Required Data" Else If Me.passwordtxt.Value = DLookup("PASSWORD", "SYS_USER", "[SERIAL_NUMBER] = " & Me.usernamecbo.Value) Then strUser = Me.usernamecbo.Value strAccountType = DLookup("USER_TYPE", "SYS_USER", "[SERIAL_NUMBER] = " & …

hi, all im working in access 2007 vba, i write a code in the login screen, to check if the user name and password match with the corresponding username and password in the database. the problem im facing is if a user enters a usernam correct and a password which …

i`m working with access 2007, i have two tables SYS_USER, ACCOUNT TYPE. the first table contains (username, password, first name, last name). the second table is only one field (manager, admin, agent). there are two forms (administration, login), the administration form adds a new user, the login form makes user …

HI everyone... i`m working on access 2007. i have two table called USER, and USER_PRIVILEGES i created a form with bound text boxes and bound check boxes. the text boxes are for the user information(first name, last name , ...etc) the bound check boxes are for (print report, delete, modify …

hi, im working on a small project on access 2007, i have a form that contains multiple textboxes ,and a save button. these textboxes are related to tables, so what i need is a code for that button to save the records in the textboxes in the tables and then …

Hello! I'm working on VBA within MS Access XP, and can't seem to get the proper usage of the split function down. I've been trying to make this work, but I keep getting the "Run-time error '9': Subscript out of range" error. Since the code of my project is kind …

HI all, am fairly new here stil and hope to give back as much as i take , in time , experience and wisdom... (the wisdom bit is probably way off for now) I have a set of tables , but one table needs to show the information chosen in …

Hi all and thanks for reading this..... I have a question that I cannot seem to find an answer for, out there in the big ol ether they call the internet, it involves a three stage procedure on a button pressed within an Access form ... [B] stage 1 : …