Search results

Hello I’m working on a section of code that when a user clicks a button it looks at a table called TBLVersion and increments the version number. The version number format is 1.0.1 what I need the code to do is increment the last digit by one for example to “1.0.2”. I got the flowing code to...

that works perfect. Appreciate your help thank you so much!!

Do I have to declare shellExecute in a function or something? I keep receiving a compile error: Sub or Function not defined. Below is the code I have for the on click function. Dim db As DAO.Database Set db = CurrentDb Dim doc As Document Dim mypath As String Dim mycontrol As String mypath =...

Hello I’m using MS Access 2010. I have a code that I’m using that loops through a folder gather all the names of the files in the folder and inserts them into a table (shown below). The table is named “tblFiles” there are two columns in the table titled file name and file path. What I want to...

Hey Alex I just found out the solution to my problem. The commas in the currency value creates another column when inserted into a list box, In order to prevent that from happening I had to add single quotes to change the currency value into a string. Updated code below. sql = "insert into...

Hello everyone So I have this database that when you click a button it generates a report using the information entered by a user. On that report I have a multi-column list box that holds a currency value. The problem that I am having is that the list box is cutting off some of the currency...