Initially I was wondering whether in their log of HTTP activity they were storing something, but I guess that was stupid of me.
Yes, they are just tracking which programs are running, anyway to change how the name appears?
Well, I apologize if I hit a sore spot for you, but I bet the time to figure this out equates to about the same amount of time as un-bubble wrapping a cube, or having to pick up about 300 3/4s filled cups of water all over someones desk.
So the MIS department likes to uninstall FF from people's computers and monitor who is visiting the web using it, I'd like to write a small app that will make IE appear as FireFox when visiting websites - not too the websites, but to our MIS department.
Anyone have any ideas?
If you need...
I apologize for not being clear... the problem is now solved
1. This procedure will be run on demand and I wanted it to be able to figure out the current year...
declare @Cur_FY as int
select @Cur_FY = dd.FY
from date_dimension as dd
dd.date =...
I am trying to write this procedure so it does not need to be editing or ask for input going forward... I have a date dimension table which allows me to create joins to find the fiscal period/quarter/year... to get the current fiscal year I am doing this:
select
@Cur_FY = dd.fiscal_year...
This will be the first procedure I have ever written but pretty much this is what I need to do:
Query against a date dimension table to return the current fiscal year
Then create 8 additional variables which will use the current fiscal year variable to determine the start and end dates of...
Mind is completely mush at this point today...
I have a worksheet that people constantly update, every time an update is made, I'd like the date and time to appear in field A1.
Easiest way to do this would be?
I just got it via chat, $199 free shipping, no tax.
Actual conversation:
Vogel now a friend recently purchased a Dell 2209WA
Vogel how much are those going for?
Agent Let me take a look for you.
Agent Those monitors are going for $299
Vogel for some reason i...
Use IE conditionals and set up a separate IE specific CSS style sheet with just the modified styles for IE. Make sure it's after the link to your first style sheet.
Anyone know much about the 1900x1200 resolution issue this monitor has? I've seen it in a bunch of reviews and not sure how much of a pain in the ass it'd be.
Right now I've got 2 19" Dell ultrasharps and im thinking of going to this... think its worth it?
What the...
I post this message and now its fixed. No rhyme or reason, can someone please explain to me what the issue was? Some sort of key combination that locked the table?
I didn't have any of the tables open....
In Excel, I created a table of rows I needed to update, I imported this table into access as Sheet1.
Then I created this select query to produce an easily updated view of the data:
SELECT RawFinancials.*
FROM RawFinancials INNER JOIN Sheet1 ON RawFinancials.Prj = Sheet1.Prj;
The...
Ok I said screw it, I copied the entire document into excel, identified the rows to remove, removed them, then cleared the table in access, and appended the new table.
Solved.
I appreciate all the help!
Hello Kyzen,
I'm not sure I follow. Table A has relationships to other tables... TableB was just an upload from excel where I identified rows that do not need to be in TableA
- J
I tried to just write a SQL statement to delete the rows using the join, however Access gives me an error: "Could not delete from specified tables"
That's why I was attempting to using the design view.
mmm
So when I delete the rows in the select query, it clears Table B and not Table A of those rows...
What am I doing wrong? There are actually three primary keys in each table...
Here is my query:
SELECT *
FROM
TableA
INNER JOIN TableB
ON (TableA .Prd =TableB.Prd)
AND...
Here is an example of what I'm trying to do:
I have two tables:
Table A
Col 1: ID
Col 2: Desc
Col 3: Financials
Table B
Col 1: ID
Table B contains a subset from Table A. I want to delete all rows in Table A that have ID's in Table B.
Thanks in advance.
Thanks in advance for any help...
I am trying to use VBA to cut and paste an entire worksheets information into a new workbook. The problem is, when this happens, all of my equations break, even if they're 'ok'.
For instance:
Workbook1 has two worksheets; 'budget' and 'rates'...
Hi Borg, you're going to have to give us more information to get the help you need.
What do your tables look like? How are they structured?
What are you using the expression builder for? Otherwise you might want to invest in an Access book, expression builder can be a useful tool.
I have been learning php on the job for the last 3 months, it is an absolute breeze if you have any programming experience.
Like mentioned above, there are tons of online resources. Download and install XAMPP or APACHE and go to town.
Klin - no but just as stupidly I set the User DSN settings, but not the System DSN settings.
Damnit, that was a completely unnecessary headache.
Thanks for the response
I am looking to set up a connection between a website set up on my localhost and the SQL db here at work.
I have set up the ODBC connection and figured I'd be able to just use the odbc_connection() function with my UN/PW, however it does not seem to be working.
Does this have anything to...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.