Code:
browserName = navigator.appName; browserVer = parseInt(navigator.appVersion); if ((browserName == "Netscape")
isoquin
Last Activity: May 15 '08, 07:52 AM
Joined: Jul 16 '07
Location:
-
I've had many of the same ideas as both of you, and I keep coming up scratching my head. If I simply try to log in directly to their site (not through the remote form on my site), the url and source is exactly the same, regardless of browser. Javascript in the source checks browser, but it is limited to this:
... -
ASP Form Browser Incompat?
This is an odd one. I have a group of users who all need to sign onto site X each with a unique password. Site X has a simple form with a password field and submit button. The submit method is POST and the action takes it to an ASP page (apologies if this is the wrong forum).
In order to save my users a little time, I built a page on my domain (which is not site X) that mimics that form, automatically fills in the person's unique... -
First I'll say I'm by no means an Access expert, but I have encountered this and came up with my own solution.
You can have your form's "BeforeUpda te" event check for the field first.
Again, I'm no expert like some of the other pros here, but giv eit a sho...Code:if isNull(myVariable) Then MsgBox ("your own error here") Cancel = True Else: Cancel = False End IfLeave a comment:
-
Warnings/Saving Disabled? Other odd occurances...
I've done my homework on this a bit already.
Problem: the usual warnings of "Do you want to save?" or "Are you sure you want to delete that? It cannot be undeleted." etc have mysteriously stopped working.
Tools > Options > Edit/Find > Confirm: all boxes are checked
DoCmd.SetWarnin gs is not ANYWHERE in ANY code of mine. Nonetheless, I threw it in once and set it to TRUE just to be... -
grrr - can't delete this anymore
figured out a workaround - please disregardLeave a comment:
-
Multiple Subforms, AfterUpdate?
Hello-
I have one form frmProject1 (record source tblProject1), with two subforms within it:
1) frmPayroll (tblPayroll), and
2) frmTimes (tblTimes)
Basically, there are multiple different tblProject(n) where n is some number. While the details of each is stored via their respective forms, all of the forms need to link to tblPayroll and record higher-level information (employee, amount of time, etc). So... -
My appologies for the lack of clarity. I'm using a continuous form, with multiple records being displayed at any given time. Furthermore, the records displayed do not change with a query, but by the Me.Filter and vba. The user will be readily changing the filter, and displaying different items frequently. As such, i was hoping for a running tally of certain records. Specifically, a sum or count of a field, whose value is generated from a vba...Leave a comment:
-
Count Unbound Text Field?
I've looked, and not found much. I have a text field in a form named [myLocation], which acquires its data through a control source of =getLocation()
the getLocation() function returns a DLookup, which changes based on some other field of that record.
Now, I would like the form footer to count the two different locations that may occur. So, naturally I tried:
=Count(IIf([myLocation]="Home",0))... -
thank you much dear, that did the trick.
If you don't mind a quick followup (as I like to know the code, not just copy it), does this simply traverse every element in the div and individually assign the color?...Leave a comment:
-
"Problem: my bottom table won't display in red!".Code:<table hite="200" with="600" id="toptable"> ---table contents--- </table> <table style="text-color:FF0000" id="bottom-table"> ---table contents--- </table>
Yes, you can *address* one problem without fixing the others....Leave a comment:
-
with all due respect, I'm guessing the problem can be addressed despite those.
I don't have safari, so I don't exactly know what you're trying to get it to look like. If you simply don't want the bottom div to show up behind the top div, add a background-color:white to your css appropriately.
If you want the top portion to move as well, remove the absolute positioning.Leave a comment:
-
Javascript changing CSS color
I'm working with the following code, trying to change the color of the links inside the divs. While the background color and border change exactly as they're supposed to, the text/link color itself doesn't.
This is starting to drive me bonkers.
Ideas please?
...Code:<div class="style1">Gallery <div class="style2"> <table cellpadding="5"
-
ah i meant all manner of JOIN statements (left join, inner join, etc). thanks for the answer!Leave a comment:
-
Table-Exclusion Query
I've looked around and found things similar but not exactly this. I essentially have two lists.
tbl_allData has every ID
tbl_completedFo rm is a subset list of allData
I would like a query [remainingList] to give me all IDs from tbl_allData except for those IDs found in tbl_completedFo rm.
I know this should be simble, but I've tried all manner of SQL statements, joins, and <> to do this, with... -
I have a legitimate connection, tested and true. I can pull data, export it to a blank database, and play with it as usual. However, in the SQL connection Access project, the Queries "tab" only lists the following:
Create Function in Designer
Create View in Designer
Create Stored Procedure in Designer
But, if I try to open any of these, it says my version doesn't support them with an external SQL database....Leave a comment:
-
I should clarify:
I'm not having a problem with the SQL statement (although that did make things much more clear), but rather that I can't seem to create queries within an Access project that pulls data from an external SQL server (which I enter through IP address and login).
Ideas?Leave a comment:
-
SQL Server + Access = No Queries!?
So I'm connecting to an external SQL server. The data I need to access is stored across three tables, lets call them:
tblTinkerers
tblWidgets
tblParts
tblTinkerers is related to tblWidgets by the latter's PK.
tblWidgets is related to tblParts by the latter's PK
So, to see what Tinkerers need which parts, you need to traverse the tables. Now, I've not really worked with this SQL server... -
Jim-
I greatly appreciate the reply. The SQL server is completely remote (as in, not on this computer, and not anywhere on my domain/LAN). I was just given an IP address for it. I was also given a specific username and password setup by the admin of that SQL server.
I also don't quite understand what MDB file using ODBC is. I've used access when building DBs from scratch, but I've never done *this* before, and as...Leave a comment:
-
SQL Server <=> MS Access Project
Hello-
This field is new for me, and I've looked elsewhere for tutorials.
I was recently given an SQL Server (IP) Address, username, and password. I need to work with the data in Access, and don't quite know how to get the two to speak to one another.
I've made a new project from existing data, and got to the Data Link properties. It's clear where the username and password goes, and I took a guess... -
Passing Arguments in Firefox != IE? BAH!
Goal: Div which moves to mouse position, and has contents changed.
This seems to work ok in IE (with the exception of the div being slightly higher then the mouse for some reason?), but doesn't work at all in FF. In fact, even a basic argument pass doesn't seem to work. I've been looking around the net as to why this is happening. Here's my code - please direct me to the apropriate tutorial or offer pointers - thank you.
...
No activity results to display
Leave a comment: