Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: jjonesal
  • Content: Threads
  • Order by date
  1. jjonesal

    multi-user security and make table queries

    I have a database that I have enabled for multi-user security. Created users and groups, and set permissions on objects. However, when I'm setting permissions, Access won't allow me to set permissions for the object name <New Tables/Queries>. It gives me this error message: You can't change...
  2. jjonesal

    Prevent 97 users from converting DB to 2003

    I currently have users that have both 97 and Access 2003 installed on their machines. We have many databases on the network that users access - some in 97 format & some in 2003 format. When a 2003 user opens a 97 format database, they used to get the Open/Convert dialog - and using the KB...
  3. jjonesal

    Lotus 123 formula question

    I’ve got a Lotus worksheet that has this formulas in one of the cells: 1/@FV(1,C14,C15) I’m trying to understand how Lotus interprets this…. I would have expected to see the @ symbol as the first character in the cell to denote that a formula was being used. If anyone can point me to a...
  4. jjonesal

    Problem seeing records through a form

    I have a form frmAnalysisDetails. My switchboard has two entries. One that opens the form in Add mode and another that opens the form in Edit mode. The option to open the form in Add mode seems to work fine, but the option to open the form in Edit mode, comes up in Add mode. I only see one...
  5. jjonesal

    Wizards not functioning properly

    I am using Office XP, and everything was going great.... Then, I installed Visio 2000 on my machine, and now my MS Access wizards (i.e. the Form Wizard, Query Wizard, and Report Wizard) are not working properly. When I invoke the wizard, a dialog box displays like it's trying to install MS...
  6. jjonesal

    Response.Cache.SetCacheability()

    Okay, I'm new to this web dev stuff and using ASP.NET. I've read through all of MSDN and I'm still not sure that I get it... I know that the Cache property of the Response object determines how the server caches responses before sending them to the client. But, could someone give me a simple...
  7. jjonesal

    Response.Cache.SetCacheability

    Okay, I'm new to this web dev stuff and using ASP.NET. I've read through all of MSDN and I'm still not sure that I get it... I know that the Cache property of the Response object determines how the server caches responses before sending them to the client. But, could someone give me a simple...
  8. jjonesal

    state management question w/ ASP.NET

    Okay, I'm new to web development and I'm just now getting started with asp.net. I have read all the help files and articles I can find on this, but still have a question. If I want to store a small amount of session information on the client, I know I can use cookies, the ViewState property...
  9. jjonesal

    ModifiedCurrent vs. CurrentRows

    I was under the impression that a RowStateFilter of ModifiedCurrent made visible a modified version of original data. But then we also have CurrentRows. Can someone point me to an explanation of the exact differences in these two RowStates? J. Jones jjonesal@cableone.net
  10. jjonesal

    The search key was not found in any record Error

    I am getting this error message when attempting to delete a row in a stand-alone table (no relationships to other tables): The search key was not found in any record. I was updating through a form when Access 2002 terminated and the record I'm trying to delete is a record that looks like it...
  11. jjonesal

    Difference between OPEN_FORM and CALL_FORM

    Perhaps someone can help. What's the difference between using the Form Builder built-in CALL_FORM instead of OPEN_FORM? Do you know if OPEN_FORM can be used to open a query-only form? If you opened a query-only form and then used the OPEN_FORM built-in to invoke another form, what happens? Does...
  12. jjonesal

    An object as a stored procedure parameter?

    Could anyone tell me if Forms supports the use of objects being passed as stored procedure parameters? J. Jones jjones@cybrtyme.com
  13. jjonesal

    FIND_TIMER and ID_NULL functionality

    I'm having difficulty fully understanding these two functions. I know that FIND_TIMER accepts a timer name and returns a TIMER type. I also know that ID_NULL is overloaded and can accept different types of input parameters (one being timer) and returns a Boolean (T/F) indicating whether the...
  14. jjonesal

    db_accessadmin vs. db_securityadmin

    Could anyone give me a brief overview of how these are similar and different or point me to a good resource? In books online, I haven't found much info. Thanks in advance, J. Jones jjones@cybrtyme.com
  15. jjonesal

    You could do this in vba code using

    You could do this in vba code using the TableDef collection like below (probably wouldn't want to do it with a message box though, but...for simplicity's sake...) Or you could just directly query the MSysObjects table (name & type). Each different object type will have a different type value. Be...

Part and Inventory Search

Back
Top