Hey Stewart,
This worked perfectly. It ran the first time through without a single problem! I can't thank you and PianoMan64 enough for all of your efforts!!!
Thanks again,
Jason
jkwok
Last Activity: Nov 6 '08, 09:06 PM
Joined: Feb 25 '08
Location:
-
Hi,
Yes you're right. I have no database access permissions at this time which makes this little project all the more difficult. Is there any way I can do this without database access?
Thanks again,
JasonLeave a comment:
-
Import data from webpage
Hi,
I have a webpage, which I have no control over, that is basically just a table full of data. I've looked at the source code and the imformation I would like to important isn't named in any way, shape or form. It's not valid xhtml either, as the code is riddled with style tags.
Example:
...Code:<td><b>Last Name: </b>DOE<BR><b>First Name: </b>JOHN<br><b>Start Date and
-
If it's of any help, I'm using Access and Excel 2003. I've been searching the msdn site but haven't found much of anything relevant, but it must be possible to export to a template right? :D
Thanks again,
JasonLeave a comment:
-
Hey PianoMan64,
Your code worked perfectly. I was able to create all 1800 spreadsheets and they were are properly named! Thank you very much!
I have one more issue though. When the spreadsheets are created, is there anyway to have them use a template I have? The person who will be using this has a preset format she has to use, along with a few macros, and has made a template for it.
It's currently named...Leave a comment:
-
Hi Joe P,
This looks amazing! I really appreciate all the time and effort you put into helping me out! I'll try this and let you know how it turns out.
Thanks again!
JasonLeave a comment:
-
Exporting to multiple spreadsheets
Hi,
I have a spreadsheet which I've imported into one table, 'Assets', in Access. In the table, I have to separate the data based on one attribute: 'empID'. empID is the employee ID and can occur in multiple rows, so it's not the primary key.
What I need to do is this:
1. go through the entire Assets table and produce a spreadsheet for each empID. So for each unique empID, a spreadsheet will be made containing... -
Hi,
Setting the anchors worked perfectly! Thank you so much for your help!
Thanks,
JasonLeave a comment:
-
Auto Resize form elements
Hi,
I have a form with two rich text boxes and two buttons. Some of the users want to be able to maximize and/or resize the form and have the rich text boxes resize to fit and the buttons always stay close to the right side border.
Any tips on how I could do this? Maximizing and resizing have already been enabled. The effect now is that when you resize smaller, the text boxes and buttons go out of sight (depending on... -
Hi ADezii,
I'll try that. I remember learning access in university, and the prof showed us a way to make macros open in design view instead of simply running. This was several years ago though, in Access 97, so perhaps that feature was laid to rest a long time ago?!
Thanks anyway!
JasonLeave a comment:
-
Opening a Macro in Design View
Hi,
I have several macros, and usually in haste I will double click on the macro and run it whereas I just wanted to open it in design view. I remember being able to change a setting somewhere so that a double-click on a macro will open in design view instead of actually running the macro.
I've looked all over access and can't find out how to do this. I know it's possible, or at least it was in the Office 97 version... -
Hi Cori25,
If doing it in a module is a better idea, then I'm up to trying it. Is there somewhere you can direct me to learn how to get this working?
Thanks,
JasonLeave a comment:
-
Export to excel sheets
Hi,
I have 5 tables in my database. I would like to be able to export the data from 4 tables into one excel file, where each table would be on it's own sheet.
Is this possible with just a macro group? Or would I have to do some VB coding here?
Thanks,
Jason -
These both sound like good solutions, I'll give them a try. Thanks!Leave a comment:
-
Number precision
Hi,
I have a make-table query with one attribute that is derrived from multiplying a number against currency value.
For example:
Hours Worked * Rate = Expense
95.516 * $55.54 = 5305.0446044
How can I control the decimal places so that I end up with this?
95.516 * $55.54 = $5305.04
I've tried editing the field properties in the query design window... -
Hi Stewart,
Thank you so much for all your help. I think you're right about the whole situation. I'll make adjustments and I'm sure my colleague will find a way to work through it.
Thanks again, I really appreciate it!
JasonLeave a comment:
-
Hi Stewart,
Thanks for your quick reply! This looks good and I can see how it works. I ran this on my test database and this worked perfectly. The only problem is that a colleague of mine exports this table to excel every day for his reports and removed the ID attribute from the live database as he said it interfered somehow. (which makes no sense to me)
Long story short, I have no ID attribute to use. I hate to trouble...Leave a comment:
-
Hi Stewart,
Sorry if my description was unclear. It's as you said: "set the Ticket Count on the first occurrence of each different case number to 1" and leave the others blank or "0" would even suffice.
So here is a sample of the current table, with ticket_count currently all empty.
...Code:Case_Num Ticket_Count A3747422 A3747422 A3747422 A3747422 A3747422
Leave a comment:
-
I've tried the following:
UPDATE Combined SET Combined.Ticket _Count = "1"
WHERE (SELECT DISTINCT Combined.Case_N um FROM Combined;);
I know this doesn't work, but I'm grasping at straws trying to get something to work. Should I make the SELECT query first, and then make the UPDATE query using that SELECT query somehow?
Thanks again,
JasonLeave a comment:
-
Updating distinct rows
Hi,
Assuming I have a table called 'Combined' with three attributes.
Combined
id - Case_Num - Ticket_Count
I need to make an update query so that for every distinct Case_Num, write a "1" in the Ticket_Count. I've tried a few different things using DISTINCT and DISTINCTROWS but I'm getting nowhere!
This seems very simple, but I can't seem to get it to work. Any help would...
No activity results to display
Leave a comment: