WannabePrgmr
Last Activity: Dec 11 '13, 08:00 PM
Joined: Jan 5 '10
Location: Cleveland, Ohio
-
Perfect! Thanks for your help! After messing around for an hour or two, I figured out the rest of what I needed for this as well! Thanks for getting me started and following up!... -
I apologize. I didn't know if I should've replied here or post new, so I did both.
Thank you for the great start! This worked exactly like you said it would, however after the chart was created, a run-time error came up stating "The specified dimension is not valid for the current chart type". When I click "Debug", it highlights:
...Code:ActiveChart.Location Where:=xlLocationAsObject, Name:="Sheet1&
Leave a comment:
-
Thank you for the great start! This worked exactly like you said it would, however after the chart was created, a run-time error came up stating "The specified dimension is not valid for the current chart type". When I click "Debug", it highlights:
Code:ActiveChart.Location Where:=xlLocationAsObject, Name:="Sheet1"
Leave a comment:
-
Basic Excel Macro to create graphs
I have a simple Excel Spreadsheet that continuously updates with data (both columns and rows). I am trying to build a macro that will start with the first row (which is actually row 2) and graph all the data in that row until an empty cell is found and stop. Then I need it to loop to the next row and graph that row until an empty cell found. I need it to continue row by row until and empty cell is found in Column A. I'd like each of the graphs... -
Criteria for Query in code instead of query itself
I am working in Access 2003. Everything was working great, until I started adding criteria to the query! I am now trying to remove the criteria from the query itself and use code instead (I've verified that removing the criteria from the query makes it work again).
I'm trying to code something like this:
[Text39]...Code:ListSteve.RowSource = "qryOlderT WHERE [StartDate]_ Between Date()-[Text39] And Date()-20000"
-
I figured it out! Classic idiot move on my part! It was actually only [Bendix Number] that was causing the issue and it was because it was not listed in qryOlder.
Thanks for your help and explanation again! I learn so much from you guys!!!!Leave a comment:
-
ADezii, I guess I wasn't looking close enough to the emails!!! You're right, when I take away the ! it repeats whatever data is in the first record. But if I put the ! there, the following error comes up "Run-time error '3265': Item not found in this collection".
It only happens on [Customer Number] and [Bendix Number].
I'm going to google the error and see what I find.....Leave a comment:
-
Interesting! Here is the code that works. As soon as I put the ! back in front of those that do not have it, "object not founs" comes back.
...Code:.....![Type] & vbCrLf & "Product: " &_ [Product Type] & vbCrLf & "Status: " & ![Status] &_ vbCrLf & "Bendix Number: " & [Bendix Number] &_ vbCrLf & "Customer Number: " & [Customer
Leave a comment:
-
NeoPa, Thanks for your response! I believe ADezii was simply pointing out what he changed. The "Set objMessage = ..." code was in the original, messy (sorry about that) code that I posted.
Question for either of you.....I kept the ! in front as you did but for a few of them it kept coming back with an "object not found" error. I had to simply delete the ! and it's working perfect! So most of them still have...Leave a comment:
-
ADezii, thank you for such a quick reply! Thanks for the corrections! I don't know how I missed .MoveNext (it was in there at one point).
Now it only sends the same record (the first one) 3 times. So I get three identical emails with the same information in them. 3 happens to be the amount of records returned in the query (and I tested it by deleting one so there were only two in the query. It then sent two of the first record).
...Leave a comment:
-
Looping through a query
I have a form that is brought up at startup (frmSteve) and I would like to run a query (qryOlder) in the "On Current" for that form. The query captures any record that is over 14 days old. What I need to do is send an automatic email to myself for each record that came up in the query.
The query works fine. The code I have to auto-email works fine. I am just completely clueless as to how to set up the code to loop through the... -
Thanks Jim Doherty! That did it perfectly! I appreciate the help very much.
NeoPa, thank you for your input. I am learning on the fly and very much jumped in head first so there is a lot I have to learn to correctly set these databases up.Leave a comment:
-
There is a table for each product type. So the case statements pull the correct table for "Model" whenever the product is selected in Product Type.
I tried to sort the tables themselves and they do sort in the table view, but not when they are listed in the combobox when they are called.
ThanksLeave a comment:
-
How to sort combobox data on the fly?
In Access 2003, I am trying to sort the combobox "Model". The "Model" rowsource is chosen based on the "Product Type" choice (i.e. Compressors, Actuators or Valves).
How can I code it so that each choice loaded as the rowsource will be sorted in ascending order.
I have the following code:
...Code:Private Sub Product_Type_AfterUpdate() Select Case Product_Type.Value -
Adezii,
It definitely took care of that issue, but something else has come up as a result that doesn't happen all the time.
What happens, when it happens is that if you type in a reference number, it will bring up a different reference number (seems to be random) and an error comes up:
Run-Time error '3077':
Syntax error (missing operator) in expression
If I click on "Debug",...Leave a comment:
-
Thanks NeoPa! I set it up different, but I'll check out what you have as it looks much less complicated (as usual).Leave a comment:
-
Wow, do I feel like a HUGE idiot! I guess I was over doing it, as usual! I had picked up one too many things at once and was trying them together!
Thanks Missinglinq! I appreciate the help very much!Leave a comment:
-
Directly in a query:
Where "Phone Number" is a phone number. The field is a text field and I have an input mask to force the number n the following format:Code:AreaCode: format([Phone Number], left([Phone Number], 3))
1234567890
The problem is that if the first three (area code) contain a "0", it will pull the numbers up to the "0" then copy the entire number after...Leave a comment:
-
Problem with left(text,#) function!
I keep seeing that if the "text" part ofis "" or zero, that it will return "text", which is what it is doing in my situation.Code:left(text, #)
These are phone numbers that I'm trying to pull the area codes from.
It's actually starting to return the first 3 characters on the left, until it see's a "0" and then it returns the entire number ("text").
... -
I keep seeing that if the "text" part ofis "" or zero, that it will return "text", which is what it is doing. It's actually starting to return the first 3 characters on the left, until it see's a "0" and then it returns the entire number ("text").Code:left(text, #)
I have this field set as a text field but apparently that isn't good enough.
Does anyone know how to code...Leave a comment:
No activity results to display
Leave a comment: