Search results

I have a query that counts the number of items per category. Some of the people who input the data don't classify some items thus the category name is blank for those items. I need to write some VBA that looks at the query results when the report is opened and if the category name is blank, it...

I searched and couldn't find anything on this specific issue. I'm on the verge of designing a pretty big database and I've run into what may become a bit of a problem. There will probably be several backends in different locations. Should another backend ever be created or if the location for...

I sucessfully implemented the Adobe ActiveX control (AcroPDF.dll I believe) onto a form so PDF documents could be previewed. The only problem is that the ActiveX control stays small, no matter how much I enlarge it in design view. The ONLY thing that will make it expand is if, with the form...

I have a MySQL database on my site that I use to keep track of my car's gas mileage. I imported the data from the Excel spreadsheet I was using, so the majority of the entries have the MPG already calculated. My problem is that I cannot figure out how to do calculations on data that I'm...

Well I'm having the all too common issue of the mouse wheel scrolling through all records in a form. However, I've decided to make light of the situation and adapt the form to the mouse wheel. I have a list box on the form and whenever the user clicks on a record in the list, details about...

Hello, I've searched and searched but I cannot find a solution to my problem. I have a combobox with a list of manufacturers. When you select one, the URL of their website shows up in a text box below. I have a 'remove' button on the form and when you click it, it removes the manufacturer...

This is a weird problem I've been having lately and I don't really know where it would fit on here. At work I listen to music through Windows Media Player, so I have its taskbar toolbar enabled so I can still control it while minimized. Whenever I minimize or maximize WMP, for some odd reason...

I built a database that allows users to pull PDF versions of contracts through it, but one thing that I see becoming a problem is that the links to the PDF files refer to a mapped network drive and some users may have a different drive letter assigned to the network share that the files are on...

I got the snapshot viewer control working on one of my forms, but I'm having some difficulties. I have 4 reports and 3 of them are generated using the 'WhereCondition' in the 'DoCmd.OpenReport' command. Here is one of the shorter pieces of code: Dim path As String path =...

I'm using the Snapshot Viewer control in one of my forms to display reports within the form. This works fine, except that with multiple page reports, there is no button to change pages, users have to right click and select 'next page.' In design mode the buttons to change pages and print...

A few days ago I set up a button on some forms to create a new e-mail in Outlook and it worked fine. This morning while testing everything out I was getting this error: Run-Time Error 430 "Class does not support Automation or does not support expected interface" I was confused because it was...

Is there some way to have my DB to compact and repair itself with no user intervention? I've seen the automation scripts and DB's, but they all require that a database that runs the script be open. It will be used by numerous users so having it compact and repair upon closing is not an option.

Whats the best way to filter search results? I'll do my best to explain my problem: I made a form that lets users search for records in a database and displays them in another form. In that form I've made 3 buttons to let users narrow down the results to show only certain items within the...