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...

So to go into the Access VBA Editor, just ctrl + G it then navigate to whatever form/ module you're working in. You can then save that function and go to the Macro Editor, Run Code, and enter the name of the function. Is that what you're asking?

How is the pdf currently being opened? Is it done through VBA, or some other means? if it's the former, you can just use the close method on whatever variable you've set it to. If it's just open in general, you can run code to see if it's open, or just close it through something like this...

Service Pack upgrade fixed the issue.

Thanks. The ListView control is used as a drag and drop, where a user can upload a csv to the database by dragging it into the listbox. Do you know of another control that offers that drag/drop functionality?

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...

Can be a bar graph, pie chart...pretty much anything. The problem with MSChart is that it looks pretty ugly, but interfaces better in Access than Excel. I'm not sure if anyone has tried using a different program to accomplish this. I'd be curious to see what you've done with form controls. Any...

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...

Thanks. I was able to fix the issue by decompiling and setting the references back to 14. Letting each user have their own front end should work well. I worry about any updates being pushed out. Any good techniques to ensure they're using the latest version or are always up to date? I have some...

It's on a shared network where a user could potentially have a different version of Access.

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...

The only thing I can think of without seeing the database is the syntax for your where clause. Would adding this help? strLinkCriteria = "[tblCD_SupplyID]=" & chr(32) & Me![tblS_ID] & chr(32)

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...

For this particular purpose, it actually makes sense to concatenate. This is basically flat filing an EDI file, and everything applicable needs to fit within one record.

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...

Yes I did check, there are no multiple instances of Access running.

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...

DOH! I had to put my strsql declaration inside the loop so it would change. Works fine now.

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)...

You can always do a Dlookup on a table with specifed parameters. If it comes back null then your import failed. If it comes back true, then your import would be successful.