• WSDrew

    WSDrew

    @wsdrew

    Viewing 15 replies - 1 through 15 (of 790 total)
    Author
    Replies
    • in reply to: Using IP Address as Query Filter (2002) #1098298

      Ok, I’m a little busy at the moment, trying to get a project for work done, so I don’t have the time to modify the code for you. But here’s what you should do. Where it is opening the recordset, change that line to open a SQL statement that queries for that email address…then check for EOF/BOF. (Stay away from filters in a recordset….). If there is a record, close the recordset, and create the HTML you want to display, otherwise, close the recordset, reopen it (like the original line) add the record and display whatever you want for that.

      To display different data to the user, use conditional formatting:

      This text is displayed to the user if x=something, it’s HTML, so
      would display to the end user as a line break

      This is displayed if x doesn’t equal something

      Within conditional formatting, you can ‘place’ variables into the html with like this:

      Hello

      hope this helps.

    • in reply to: Triggers for Active Directory (VB) #1093668

      This shows some promise. Unfortunately, I’m swamped today, I’ve added that site to my favorites. If I figure out a way to ‘hook’ into AD, I’ll post my solution here.

    • in reply to: Triggers for Active Directory (VB) #1093584

      That’s possible. Honestly, I have code that can get the data I am looking for. Wouldn’t be hard to modify the code so that I can set it as a service to ‘check’ for changes by doing comparisons. I just don’t want to have a service constantly checking AD. I actually have a service I wrote that does check AD for locked user accounts. Runs once a minute….very quick code. There are hooks for all sorts of things, was just hoping there was one for AD.

    • in reply to: Including Folder Name when Printing tasks (Outlook 2003) #1091912

      Thanks Joe, that did the trick. (Actually, I added the ‘In Folder’ field)

    • in reply to: Using IP Address as Query Filter (2002) #1091131

      Cool, well if you have any specific questions, give me a holler.

      Have you ever made an asp page?

    • in reply to: ? permission problem (Access 97) #1091130

      What about the folder that the database is in?

    • in reply to: ? permission problem (Access 97) #1091044

      Ok, so the account has nothing to do with Access itself, both the admin and the limited user are NT based accounts, and both are logging into the database with Admin (the default account). If that’s the case, then it’s not an Access issue, it’s a file permission issue. Create a .txt file in the same folder as the .mdb, then log in with the limited account, and see if they can change the contents of that .txt file.

    • in reply to: Using IP Address as Query Filter (2002) #1091041

      google for request.cookie and response.cookie. The first ‘reads’ cookies from the web user, the other writes.

      I started with Access 97, taught myself how to write VBA code, and about 2 years later decided to give asp a whack…haven’t turned back since. I love web interfaces, they have some distinct advantages over anything else (with only a few drawbacks).

      If you have the MSDN installed, take a look at the ASP Built in Objects reference card. Pretty handy.

    • in reply to: Using IP Address as Query Filter (2002) #1091019

      Sorry for the delay in replying, but you really shouldn’t use the IP address to identify something with a web user.

      Instead, create a user id and set it as a cookie. Have each page check to see if a session object ‘exists’. If it does, that object is the user’s ‘id’. If not, check for a cookie (you can set and read web users local cookies for your sight) value.

      Now, this is a stripped down version of actually having user accounts, where a user has a username and password. (using the cookies will work, but if someone wipes out their cookies, they’d get a ‘new’ account the next time.

    • in reply to: ? permission problem (Access 97) #1091002

      What is the limited account? Are we talking an Access User Level Security account, or an NT account?

    • in reply to: Triggers for Active Directory (VB) #1091000

      Thanks Hans. I hope I get a reply too. I haven’t found what I am looking for through google yet. I just need to know if it’s possible.

    • in reply to: Quick Question- How do you list all tables in … (Access) #1089545

      Thanks! I’ll try to be more active, just got too busy with work.

    • in reply to: Is it bad to use Memo Data Type? (Access 2000 – 2007) #1089516

      A lot of information has been posted already. Text fields are limited to 255 characters, because the first byte of storage represents how many characters will follow, so if there are 10 characters stored for the text in a field, in the actual .mdb file, where that field ‘starts’ will be one byte with the binary value of 10, followed by the 10 bytes representing the characters of the field. So Access never takes up more space then necessary for text fields, due to this prefix byte.

      Memo fields, as already explained, are stored outside of the table structure (from the standpoint of the actual file structure of an .mdb). Size wise, however, Memo fields are in theory allowed to take up the entire space of the database. The 65k character limit is only applicable when the data is entered through the Access interface, such as a form, or table view. If you put data into a memo field programatically, you’re limited to the physical disk space limit of the .mdb (1 gig in 97, 2 gig in 2000 and later).

      However, the main reason I am posting to this, is that there are other differences which should be taken into consideration when designing a database structure. First, Text fields can be indexed, Memo fields cannot (at least Access won’t index them…). So when data is entered into an indexed text field, doing a search in that field will have jet hit the index. Doing a search in a memo field will have Jet running through the entirety of every applicable memo field. If you have hundreds of megs of text, that’s a lot to run through.

      Also Memo fields have some issues with queries. Off the top of my head, I know you can’t group by a memo field, you can with a text field.

      Don’t misunderstand me, I use memo fields all the time. I use them when I have no idea how much text is going to be entered. If I know there’s a limit, I use a text field. and if the limit is over 255, but can be dealt with by multiple text fields, sometimes I’ll design the table to have multiple text fields, to include the indexing/querying capabilities of a text field.

    • in reply to: Quick Question- How do you list all tables in … (Access) #1089513

      A lot of methods posted. Personally, I prefer the ADO method (which will work for tables and queries):

      Function GetDBTables()
      On Error GoTo ErrorHandler
      Dim cnn As ADODB.Connection
      Dim rs As ADODB.Recordset
      If DBConnect(cnn) Then
      Set rs = cnn.OpenSchema(adSchemaTables)
      Me.lstTables.Clear
      rs.MoveFirst
      Do Until rs.EOF = True
      If Me.optTables Then
      If rs.Fields(“TABLE_TYPE”) = “TABLE” Then Me.lstTables.AddItem rs.Fields(“TABLE_NAME”)
      Else
      If rs.Fields(“TABLE_TYPE”) = “VIEW” Then Me.lstTables.AddItem rs.Fields(“TABLE_NAME”)
      End If
      rs.MoveNext
      Loop
      rs.Close
      Set rs = Nothing
      cnn.Close
      Set cnn = Nothing
      End If
      Exit Function

      ErrorHandler:
      Err.Clear
      End Function

      This is right out of an application I wrote that builds classes in ASP from tables/queries. It’s displaying them in a listbox. And there are option buttons to display tables, or to display queries. The function DBConnect is essentially:

      Function DBConnect(ByRef cnn as ADODB.Connection)
      set cnn=new ADODB.connection
      cnn.Provider=”Microsoft.Jet.OLEDB.4.0″
      cnn.Open “C:SomePathSomeDatabase.mdb”
      Exit function

      However, you can connect that ‘cnn’, the connection object, to any database you want (Access, SQL Server, Oracle, etc), and it will list the tables for you.

    • in reply to: Hiding the Access Window (2003) #992900

      I know, my website has been down for a few months, long story.

      As for docs on regions, look up Region Function in the MSDN library.

    Viewing 15 replies - 1 through 15 (of 790 total)