Search results

Hey folks, have a question that I'm getting stumped on. I'm trying to log in to a retailer's website to download some data so I can report off the data. Thing is, I want to download this automatically without having to log in and download the file so I can then automatically load the data and...

Hey all...I've spent several hours trying to get this to work. I've searched Google, tried multiple ways to get it done, but I just can't do it. I have a set of code that opens another workbook. I know it's open and I can see that it's open. I even have a loop that checks to make sure the file...

Why will this not work? I've done a search for the error and I don't get much help. I also tried Google, which yielded no help. I don't get it. Here's my SQL...the subquery returns 22 records. SELECT Count(SELECT DISTINCT [Client] FROM [Project Administrator Work Requests] WHERE [Request...

I did a search on "if exists" and didn't come up with a solution for this problem. I have a crosstab query that takes the teams from a table and adds up all the instances of that particular team name. Red, Green, and Blue. However, there are not always instances of all teams. So, sometimes...

I'm in somewhat of a pickle, I guess. I was hoping to be able to do this all in a query instead of doing a query and then using VB to do my day calculation and then somehow spitting that back out. This is for a web app, so I'm using ASP.Net with VB code behind. I'm trying to establish a data...

This won't work for some reason. I know the date going into it is 9/1 ElseIf thedate.Month = 9 And thedate.DayOfWeek = DayOfWeek.Monday Then Select Case thedate.Day Case 1 To 7 thedate.AddDays(1) End Select

Just when you think you have something figured out, BAM. You get slammed with something else you wouldn't expect. I have a list box that is populated with the days of the week. I have a msg box popping up telling me the value of the item I click on right after I click it. I'm storing that...

Why is this so hard to find? Not being able to figure this out is daunting enough without not being able to find the answer here or on Google. </venting> Okay, all I want to know is how I can store the value of a selected item in a list box in a variable. I have tried the .ItemsSelected...

I was hoping you guys could assist me in figuring this little thing out. I have a form for work request submissions. Here's a highlight of the opportunity. User opens form User selects a date range via a calendar (used the API calendar) User selects a recap schedule (Daily, Weekly...

Every time I try to go in and edit code in Access...I get this generic error. In was happening in 2007 so I installed 2003. Still happening. The only thing I have recently installed is SQL Server 2005 Express.

Office Enterprise 2007 Had an Access app that sent tasks automatically via Outlook. Worked just fine. Installed Visual Web Developer Express and started getting error 429 every time I tried to use the Access app. 429 is "ActiveX Control Can't Create Object". Uninstalled Visual Web Developer...

First, I want to say that I have used the search feature A LOT all day today looking for answers. I also know of the security features in Outlook 2003 that don't allow you to utilize the Outlook Object Model in Access to truly automate tasks and emails. Basically, I'm designing a system to...

How would I do this on a report? I want to group by a set of numbers, including negative, but ignore the negative number... Like this... 123 123 123 -123 46 -46 46 2 2 2 14 -14 etc...

I have an objective that I need to do and I thought, at first, that it was just to import in a text file using VBA...but now I'm not sure. Here's the objective: Write a program (do not use DoCmd.TransferText) to convert "test.txt" to a tab delimited file. All fields must be trimmed of extra...

How in the world can I accomplish this? I have a set of dates on a form that change from week to week. I'd like to reference these text boxes in a query as column names. How can I do this?

I am currently building a process in Access that creates a report in Excel consisting of multiple tabs of data. The building of this Excel file is not a problem for me. Here's the issue I'm having... There is a sheet in another Excel file that is created by someone else that I need to use in...

I tried the search and while I found some things related to my issue, I couldn't really come to a conclusion on my issue. I have all the databases on the network set to compact on close. This is resulting in a new copy of the compacted database with the generic "db1.mdb" file name every time...

I'm working on some data in Excel. I have a couple of data sets that I want to chart but I want to be able to control which data set is charted on the chart with a combo box. Anyone have any ideas?

Let me go through the steps... 1. Insert Chart 2. Define Data 3. Define Series Name When defining the series name, it defines the chart title dynamically. If the series name changes (defined by a cell on another sheet), the chart title changes. When I go to add a trendline, the chart...

I have sucessfully put some code into the On Error event on a form...it does what it is supposed to. But I don't want the generic Access error to pop up right after my message box tells the user what is wrong. I've search the forum to no avail. I was hoping for some help. My Code for On...