Search results for query: *

Recently my work updated to IE10. Previous to the update, I have a VBA project that was working flawlessly. The routine, opened a browser, navigated to a page, logged in to the site, entered some data into the online form, ".click"ed the submit button, worked it's way through the "Save As"...

I was having a HECK of a time figuring this out so I thought I'd post it just in case someone else needs it. I have a standard line chart with that tracks 2 series of data. Budget (Control Figure) And How much spent (Order Value) over time. I wanted the Order Value line to track daily, but...

With the data set below, I have created a Line Graph with the row source of: Me!Graph3.RowSource = "SELECT (Format([TDate],'DD MMM YYYY')),AVG([TrendOrdVal]) AS [AverageVal],AVG([TrendCF]) AS [ContFigure] FROM [StatsCurOrdValChart] GROUP BY (Year([TDate])*12 +...

I'm almost ashamed to ask this, but I searched and Can't find it here. Its a simple thing... I want to calculate the number of "Payments" due or overdue. (I'm removing the form information to make it easier to read.) If ContractInitialPayment > Date Then PaymentsDue = 0 Else...

This one was a tough one to title... What I am looking for is a Control (ActiveX or otherwise) to simulate expanding and contracting individual records on a form. I don't think TreeView will fit the bill due to field lables and interface objects I use for asthetics (Filled Rectangle Backrounds...

I generate a dynamic spreadsheet from Access. It works perfect except I do my MATH in access and just pass the result to Excel. Like this: wks.Cells(iRow, X) = LColMinor LColMinor contains a sum of specific data. What I want to do is pass the formula to make the spreadsheet updateable...

I've have searched for several days to find an answer to this and I have tried many dubious "fixes" with no joy. Background: My database was designed in Access 2003. It is a Front End/Back End setup. The back end resides on a shared network resourse. I have not updated to 2007 File Format...

This has been asked before with no resolution... I pasted the question below because the user did a good job of explaining it. ----- I just created a new form that used a query to populate a drop down list box. The bizzare thing is that if you click on the box, nothing shows up in the list...

I am trying to set the criteria in a query to only show the items selected in a list box. Here is my problem. When the query tries to read, the value of the function returning the criteria is: "'0101AA' or '0101AB' or '0101AC' or '0102AA' or '0102AB'" ie. the criteria I want, however it is...

Is there a way to disable a continuous forms scroll bar control tip text? Let me expand. If you click and hold the slide box, you get a control tip reading "Record: 4 of 100" as an example. On the form in question, as I slide the bar downward quickly, it leaves "ghosts" of the Tool Tip all...

I have a couple forms in my front end that cause Access to crash if I try adding any unbound controls to them. Once the form crashes, it becomes inaccessable via the DB Window (Design AND Open). The code for the form stays in tact (thankfully). The form that annoys me most is just a Main...

I appologize if this has been asked and answered, I searched the threads and FAQ but couldn't find the answer. I have a spreadsheet with a 2 row header field that I want to sort by a "Date Complete" column from VBA. That's easy enough... But I want all the BLANK cells (Incomplete Items) at...

I'm at my wits end. I'm trying to get query results to match user selected in a multi select list box. Here is what I have: The list box is a list of statuses... (Below is an example) A B C D E The function Function fun_ARStatus() Dim frm As Form, ctl As Control Dim varItm As...

First off, I cannot use any 3rd party software to fix this issue and I cannot revert to previous versions of adobe. I am literally STUCK with what I have. (Adobe Reader 8.1.2) I use this code to print a PDF Document. Option Compare Database '************ Code Start ********** ' This code was...

I have a word document with a checkbox on it. How do I "read" the state of that checkbox in Access 2K3? I already have the form open and I can read BOOKMARKS just fine. But when I try to read the Checkbox, All I get is something like this "[]". Here is snippet of my code. Set objword =...

I have an Access 2003 project that I would like to use a Common Access Card PIN requirement to use the database. All of the infrastructure is already in place and used for logging on to the workstation. I just want to be able query the installed CAC card for the Name of the user on the...

Is there a way for Access to invisibly automate a set of weblinks? Here is what I have in mind. A passworded site contains data on several different pages. I would like to create a sub in my data base that would go out, log into the site, go to the correct page and download the data...

First, I appologise if this has been asked before. I have spent the last few days looking, but I haven't found my answer. I have to find a way to pull table data for ONLY people that meet a specific criteria a set number of times. Here is an example: Data: Name YearOfTest Result Joe...

How would I modify the code at the bottom (BOLDED) to accomplish the following excel import statements? I need to import specific cells from the datasheet. DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel97, "CurrentUIC", filenameimp, True, "PRTEdit!a1:a2" DoCmd.TransferSpreadsheet...

I have created a database that imports a large number of xls data and puts that data into 3 related tables. The first table holds the users data, linked to a set of accomplishments semi annually, linked to the particulars of that accomplishment in the last table. Record count is @ 600...