Search results

No one, huh?

bump......

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

I started commenting some code out and found out that my problem is in the if statement that checks to see if the macro exists. I thought it was fine since when I put a break in the code, it was testing as true. Anyway, you have to add a reference to the VBA extensibility package. However, I...

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

None of the gurus have a solution? :(

No one, eh?

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

THAT'S RIGHT!!!! I forgot all about that! Thanks!

I'm sorry, I don't follow your example...is this a SQL solution?

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 bumping this because it's an excellent reply to a problem I've been having all day.

I don't remember but I've abandoned that approach. I tried the function call for a function stored in Access from my VB.net code behind when I passed the SQL through in a string variable and it didn't work. That's all I remember.

I had already tried and it didn't work.

Thanks, Bob. Question for you, though. Can I call a function that is stored in Access from VB.Net in my query string??

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

I got it. One small difference. ElseIf thedate.Month = 9 And thedate.DayOfWeek = DayOfWeek.Monday Then Select Case thedate.Day Case 1 To 7 thedate = thedate.AddDays(1) End Select

thedate is simply a variable that has the date from a textbox in it. The textbox value is being cast as a date type and put into thedate. I know that the value of thedate is 9/1 when going into that section of code because I stepped through it. DayOfWeek.Monday is just the intellisense stuff...

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

Here's some code... The click event of the List Box: Private Sub recapdaysListBox_Click() If Me.recapschedulingComboBox.Value = "Weekly" Or Me.recapschedulingComboBox.Value = "Bi-Weekly" Then Dim selectedday As Long selectedday =...