Search results

Hey all, Has anyone had luck opening and manipulating Windows Media Player from Access? I'm not talking about embedding via Active X, but actually opening the player, playing it, then closing it. Dim Player As WindowsMediaPlayer Set Player = New WindowsMediaPlayer Player.url = url...

Hey everyone, Quick (or maybe not so quick) question: One of my applications uses the Microsoft Visual Basic 6.0 Common Controls (specifically the Slider Control and the ListView). I'm finding that not all my users have this installed, which is obviously going to cause problems as they don't...

Has anyone had success embedding dynamic charts within an Access form without using the MSChart feature? I could port the database to Tableau or Excel, but it would be nice for users to nice visuals within a workflow tool. Things I've thought of: Embedding an OLE object linked to Excel. The...

Hey everyone, I have a database that was developed in 2010. I know there's a compatibility issues from developing in 2016 and having it be backwards compatible (object library 16 vs 14), but I thought things should be ok if it was developed in 2010 and viewed on 2016. What I found is that the...

I'm not sure if this is the best place to ask this question, but... Using Access as the front end, Is there a best method of importing a csv document into a MySql DB? Would the best way be doing a vba insert loop on the raw document? That seems like it would take a long time. I'm just trying to...

All: I'm building a parser that will evaluate a text document and return data to a database. I'm running into some roadblocks, however, and was wondering if I could get some input or if someone has any ideas on how to make this work. There are two fields I'm really looking at, as an example...

I've created a "dashboard" application that can open other applications from buttons. It has been working for the past year. Now, today, when I go to open any application from this button, I am getting an error: The application loads, then gives the "Microsoft Office has stopped working" error...

Hello. I am trying to insert the file names of a specific directory into a table. Here is my code: Private Sub Command0_Click() 'DoCmd.SetWarnings False Dim folderpath As String Dim strsql As String folderpath = Dir("C:\blah\blahblah\test\*.*") strsql = "INSERT INTO imported (FilePathName)...

Hey everyone, I'm having a pretty hard time creating what should be a pretty simple query. I have a field called "Random" which I want to populate the fields with either a 0 or 1. The problem is I use this query: UPDATE words SET words.Random = Int((1-0+1)*Rnd()+0); Which obviously changes...

Greetings: I am working on an application that converts various formats into text files after they've been OCR'd for parsing. One thing I need to do is find something in the text file and then go to the next line and combine that line with the line i searched for. Is this possible to do...

Im testing some code to automate OCR in Access. I'm using this: Dim MiDoc as MODI.Document Set MiDoc = New MODI.Document miDoc.Create TextBox.Value miDoc.OCR Set miDoc = Nothing It keeps crashing MS Access. I'm not sure what I'm doing wrong. Any ideas?

I was wondering, and I'm not sure if this can be done, but it's worth asking... Is it possible to use VBA to "Map" pieces of an image based off the user's mouse dragging selections. So the user would open the tif, drag/selection pieces of the certificate he/ she wants (each selection can be a...

Greetings: I am trying to create an application that pulls text from a pdf and displays it into its applicable form fields. I will be extracting over 40 pieces of data from these certificates that get sent. I want each certificate to act as one record set, yet when I put in a request for the...

For some reason, this code doesn't seem to be working for me. I've never really had a problem with MoveNext until now. What I'm trying to do is display all the applicable values form a query recordset into an email, but it's only displaying the last value. Here is the function I made: Public...

I know I'm doing something wrong, but I'm trying to insert the results of a query, where the value of the query comes from a listbox into an email. To first test my query I am using this line: thepercent = db.OpenRecordset("SELECT converttopercent.[Dept Root Source] FROM converttopercent WHERE...

I'm trying to code something that scans for different files and automatically opens them. For example: 99 times out of 100, the file is going to be a pdf, so I made this code: OID = IeApp.Document.body.innerHTML OIDLEFT = Mid(OID, InStr(1, OID, "oid") + 4, 9) 'this scans the source code for a...

Hello: I am trying to figure out the best way to automate the click of a link. Basically what I want is to open the browser to a specific page and search for a pdf file (which is named arbitrarily) and click on it. What I have here: Dim IeApp As InternetExplorer Dim sURL As String Dim IeDoc...

Greetings: I am trying to import text line by line (it's html source code), but access imports it out of order if I use the import tool, so I am running code that will paste it line by line. I have most of the code finished, but the text file i wish to import has apostrophes in it, which won't...

Hey everyone! I am trying to set up an access button to go to a website, download its source code and import that txt file into a table so it can be parsed. Nothing too fancy, right? Well, when I go to import this text file, it imports that data in a weird inconsistent order. The problem is I...

Greetings: I'm trying to create a small program that makes one particular job my company does significantly easier. The software our client uses is obnoxious which involves a lot of clicking through their web interface to view documents to audit. It can be up to 1000 documents to audit, and each...