121 Topics

Member Avatar for
Member Avatar for Ace_806

Hi! I found this code in one of the threads [here](https://www.daniweb.com/programming/software-development/threads/125119/auto-generate-id-number#post611289) I converted it into an access kind of code(?) and unfortunately, it won't increment, nor find the top/max in my database. Someone please help? ` Private Function GenID() As String Dim dr As OleDbDataReader Dim com As OleDbCommand Dim …

Member Avatar for tinstaafl
0
74
Member Avatar for Start4me

I've been looking tutorials and examples of setting the value field of a input tag. I'm trying to enter two IP addresses into the text fields on [this](https://www.ipaddressguide.com/cidr) website, under IP Range To CIDR. But my code won't enter anything. There's no ID tag, so I can't use the getElementById …

Member Avatar for Start4me
0
2K
Member Avatar for Start4me

I'm working in Excel to extract content of a table from a web page and populate Excel sheet cells with it. I'm trying to extract data from a table that gets loaded to a web page after show results method gets called. I have an error that says "Run-time error …

Member Avatar for Ben_32
0
12K
Member Avatar for Divinedar

I have a worksheet of about 388 items that each item is exported into a template worksheet that is created to itemize each item. It creates the worksheets but I can't get it to stop looping at the line of code in bold comments icons. The line that it stops …

Member Avatar for xrjf
0
541
Member Avatar for infoitmanoj

I have 2 sheets in same Excel. First excel sheet contains the following fields No Material 10th july 11th july 1 DATUM DCP ESD Black 2 DATUM DCP ESD Blue My second worksheet contains the following fields No Date Material Stock size+Wastage 1 10th july DATUM DCP ESD Black 283.47 …

Member Avatar for rproffitt
0
310
Member Avatar for baabjitvk

Hi thaks in advance if I am steered rightly I have created a form in which a combobox and a submit button are present. when i select an integer value from combobox (Ex: 5) and click submit button, those many number of textboxes (Ex: 5) are to be created dynamically …

Member Avatar for rproffitt
0
191
Member Avatar for tom_17

Hi, I need to write a macro that has one row of dates. Row D. I need the macro to go down row and depending on the date I need to input a number to the cell to the right of that date. Example. If date < 12/22/16 insert value …

Member Avatar for tom_17
0
288
Member Avatar for samsambm
Member Avatar for DGULLIVER

Good morning, I have 2 client applications which do the same thing. The first app which is written in VBA(MS ACCESS) and the other is ASP.Net. We can have multiple items for a client so we use a transaction id. When the access application starts a new transaction the app …

Member Avatar for rubberman
0
302
Member Avatar for sharon.chapman7

Hi, When I use the code below, the data is written to the detail section, but only shows in the design mode. How do I get the data to display on the report? Dim stDocName As String Dim db As Database Dim rs As Recordset Dim rs2 As Recordset Dim …

0
205
Member Avatar for GeneClaude

Hello! I've been debugging this VBA program that computes the root of an equation using Newton Raphson method and with the use of the UserForm. The user will type the equation, the initial guess and the number of iterations. I was able to search on automatically differentiating the equation unlike …

0
467
Member Avatar for Papa_Don

Hi group, I'm trying to insert both a copied range (from and Excel file) AND a message (text) into the body of an Outlook email. I've perfected the code to insert the range, but I've not figured out how to get the message to go along with it. I hope …

Member Avatar for Papa_Don
0
5K
Member Avatar for zelrick

Hello DaniWeb Users/Programmers, I don't know if I post this on the right thread but I already post in Linux and Unix Thread but the cause I try ask in here is because it is programming related. I am a window user but trying to use linux for some purpose. …

Member Avatar for Stuugie
0
404
Member Avatar for TylerTCF

I was wondering if anyone could help me out with a problem I've had for a few days. This is a code snippet of a program I'm writing to move and delete email attachments from one or more selected emails. Everything works great except the program won't edit the body …

Member Avatar for Stuugie
0
542
Member Avatar for Jambaly

I am desgining a userform in ArcMap, but I don't know how to sum up numeric values in a textbox (txtBox1) in another textox (txtBox2). Can anybody provide me with a vba code for that!

Member Avatar for Vicky_4
0
3K
Member Avatar for Papa_Don

Group, In VB.net, I use the following to return the actual name of a folder where data is kept. Is there an equivalent in VBA? I sure hope so. It would solve some problems for me. foldernameGD = CStr(getFolderNameGD("O:\Revenue Management\Centralized Revenue Management Service\CRMS Hotels", propertyNo2 & "*")) In advance, thanks …

Member Avatar for Papa_Don
0
306
Member Avatar for Papa_Don

Group, In VB.net, I use the following to return the actual name of a folder where data is kept. Is there an equivalent in VBA? I sure hope so. It would solve some problems for me. foldernameGD = CStr(getFolderNameGD("O:\Revenue Management\Centralized Revenue Management Service\CRMS Hotels", propertyNo2 & "*")) In advance, thanks …

Member Avatar for Minimalist
0
304
Member Avatar for Papa_Don

Hi Group, I've recreated a spreadsheet that has multiple macro's behind it. One of these macro's opens and existing file, copies the data in it and then pastes it into the original workbook (where the macro's originate) and then closes the existing file. After the copy and paste is done, …

Member Avatar for hefaz
0
405
Member Avatar for djjeavons

This snippet demonstrates how you can add VBA code to an Excel file at run time. **Prerequisites** In this snippet I am using Microsoft Excel 2013 with the Microsoft Excel 15.0 object library. Before you can use this code, you will have to change a setting within Microsoft Excel to …

0
1K
Member Avatar for Papa_Don

Hi Group, I've written a macro to save a copy of the spreadsheet at the end of each day. I tried to test it as a shared file and learned the macro wouldn't work. Is this normal for a shared document? If so, is there a way around this? How …

Member Avatar for Reverend Jim
0
317
Member Avatar for Papa_Don

I need to identify how the code identifies that a file is at the "eof" (end of file). Here's why: On Monday's, I'm having to combine text files created over the weekend that will eventually be read and pulled into an Excel spreadsheet (generally there are three files). Using VB.net, …

Member Avatar for |-|x
0
442
Member Avatar for Papa_Don

Hi group, I've written some VBA code behind an Excel spreadsheet to check to see if another workbook is open. If it isn't open, I'm having the code open it for me. This works fine the first time the macro runs. However this same spreadsheet has a cell where a …

Member Avatar for Papa_Don
0
284
Member Avatar for Papa_Don

Hello Group, I'm trying to convert some VBA code into VB.net. Here is that VBA code: Open filePath For Input As #1 ' filePath = the text file I need to read Do Until textRowNo = 8 'discard these first 7 rows... Line Input #1, LineFromFile 'this is the row …

Member Avatar for Reverend Jim
0
9K
Member Avatar for Tensigh

I'm trying to write code in VBA in Excel that opens a desginated directory, finds all xls and xlsx files and then converts them to csv. I found two sets of code that do one or the other perfectly, but I can't make it work. I'm sure I'm just missing …

Member Avatar for Stuugie
0
5K
Member Avatar for Papa_Don

Hello everyone! Is there a way in VBA to find a file name that has an unknown portion to it? Let me explain: Our computer system is UNIX based. It is creating a text file for us that uses the date, the hour, minutes and seconds that the file was …

Member Avatar for Minimalist
0
323
Member Avatar for happygeek

Think that macro viruses written in VBA (Visual Basic for Applications) are just something that people using the Internet a couple of decades ago had to worry about? Think again. Word macro attacks never went away, they just went into decline. New evidence suggests they could be making something of …

Member Avatar for happygeek
1
1K
Member Avatar for Papa_Don

Group, I'm trying to improve a macro in an EXCEL spreadsheet. The spreadsheet has multiple tabs (sheets), some of which have grouped rows in them. My "cleanup" routine needs to check to see if these grouped rows exist. Is there some code that does this (hopefully boolean)? If it helps, …

Member Avatar for ddanbe
0
700
Member Avatar for Papa_Don

Group, I've created a large spreadsheet with a fair amount of code behide it. Historically it has run well and with no issues. However it has started giving me a "Run-time error '9': Subscript out of range" error. I have no idea what is causing it. It is stoping at …

Member Avatar for Papa_Don
0
2K
Member Avatar for Papa_Don

Hello Group, I'm writing a macro to match dates from one spreadsheet to another. Specificially, SpreadsheetA has the date listed as text. I want to match that date to a range of dates in a column to find the row the matching date is on. I have some things that …

Member Avatar for Papa_Don
0
4K
Member Avatar for Papa_Don

I need to dynamically group rows together in an EXCEL worksheet. The obvious choice to do this will be VBA. I hope you can help. My spreadsheet has 18 columns and (up to) 5,000 rows of data. I've written the following code which works "OK" however it fails to group …

Member Avatar for Papa_Don
0
5K

The End.