Search results

Oh wow that was easy!! Thanks!

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

Ended up doing it the hard way :( Its kinda slow, so if anyone knows a quicker way to do this, then let me know please! Set dbs = CurrentDb Set newdbs = OpenDatabase(tbFile, False, False, "MS Access;pwd=password") For Each tdf In dbs.TableDefs If...

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

Hmm, interesting, I'll look into that. Thanks for the suggestion! You would think that after a few years and several versions of Access have gone by that Microsoft would address this inconvenience :rolleyes:

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

Nevermind, I simply copied over the 'FindFirst' stuff I had in the combo box's AfterUpdate event and made it work using that

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

Ok, I got it completely... I set up a counter for the characters in the path, subtracted 1, did a Left$ using the length and it cut out the little block then I added the rest of the info and thats it!

Alright, I got it to work... kinda When I get the path, it leaves a bunch of trailing spaces. I got rid of them using 'Trim' and tried to add the path and file name onto that. I end up with this in debug mode: "\\bkcfil01\common
\DatabaseTest\official presentation - final.ppt" When I try to...

Thanks! It works, but I'm having trouble getting it to work the way I want it to. I'm passing it the location of a file a user selects using a browse dialog box and it converts the share drive letter to UNC just fine, I just can't figure out how to pass the UNC name back to another function...

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

Discovered that adding 'acHidden' to the end of OpenReport does what I need. Doh

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

Figured it out... I just added a '.ShowNavigationButtons = True' where the control is called.

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