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!

Register Log in
  • 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: *

  1. cjowsey

    Promotion interview tips

    I like this response very much. It looks like a great way to see if the employers (or at least interviewers) are smart enough to make the job enjoyable. Have a star.
  2. cjowsey

    MDB vs ADP

    An adp will allow you to add queries (they're actually SQL views) and reports just like an MDB. The views will be stored on the database server. It's not really a good idea to let most users go wild in a raw SQL database though unless they knwo what they are doing. End users adding columns to...
  3. cjowsey

    ADP corruption question...

    If you don't have the problem in your development environment, there is probably something different in the runtime. Have you thought about installing a copy of Access 2002 on the Terminal Server and seeing if the problem goes away? This suggests to me that the users are probably all sharing...
  4. cjowsey

    ADP corruption question...

    Have you run a Windows Office Update on the Terminal Server to make sure that you have the latest version of the runtime and the latest MDAC? Old versions have caused problems for me in the past. Otherwise, find out what sequence of events is causing the crash. It will probably be one form or...
  5. cjowsey

    Ques. on a report's Input Parameter in its property box

    I do something similar, but I use functions to set and get the parameter rather than a global variable.
  6. cjowsey

    ADP Security

    If you make your ADP into an ADE before distributing it there will be no code visible to break into. There is a lot you can do on the SQL Server end. Use views and stored procedures and never allow direct access to tables. Put all your users in a group or heirarchy of groups and set access...
  7. cjowsey

    Can not enter new record to ADP

    Happy to help.
  8. cjowsey

    Let Me Pick Your Brains?

    I too think not much has changed. It would be interesting to work out why project management seems to lag so far behind the advances in technology.
  9. cjowsey

    Can not enter new record to ADP

    You can't update a SQL Server table through an ADP form without having a primary key unless you write a lot of code to do it. It is not good to use columns that have any meaning as a primary key (don't use something like client name as your primary key). It is much better practice to use a...
  10. cjowsey

    Let Me Pick Your Brains?

    I think it could be fun to compare and contrast between a couple of major projects run 20 or 30 years ago and a couple of recent ones. The evolution of technology and development languages is quite well documented, but have development tools, methodologies and project management techniques...
  11. cjowsey

    Query Help

    Why not simply take your first query, add a set of brackets round the WHERE clause and put AND (final.TXPD <>(SELECT MIN(TXPD) FROM final)) on the end of it. Like this: SELECT final.[SSN P], final.TXPD, final.[LFRZ-RFRZ], final.[TC-150], final.[TC-290], final.[TC-291], final.[TC-300]...
  12. cjowsey

    Query Help

    I get the feeling that I am coming in half way through a conversation, but let's try. DISTINCT is an SQL keyword normally used after SELECT. I don't believe it is a function unless you have written your own. You could use more meaningful names to aid debugging. There is no way I could know...
  13. cjowsey

    Workgroup

    Chas, This forum is for Access Data Projects (ADP) that normally have a SQL Server backend. Workgroups aren't a feature of an ADP so you might have more chance of an answer in one of the other Access forums.
  14. cjowsey

    Subform in datasheet view - can't add new records?

    Make sure that you have a primary key on all the tables you have created in SQL Server. If you don't, you can't update the tables through an ADP. If you are trying to update a view formed from multiple tables, it can help to set the primary table.
  15. cjowsey

    Report Based on an SP

    I don't knwo the answer, but some of the questions below might point you in the right direction. Has he also changed from Office 2000 to Office XP or 2003? Check that all Office patches and service packs are loaded on the laptop. Is the full version of Access loaded on his machine or the...
  16. cjowsey

    SqlServer2000 vs Access2000

    There are only three possibilities that I can think of: [ul square] Convert the ADP to Access 2000 Upgrade the other users to Access 2003 Use the Office Developers Kit and distribute the Access 2003 runtime with the ADP Loading Service Packs won't help you.
  17. cjowsey

    Why isn't recordset updatable?

    Make sure you have a primary key defined on the SQL Server table so Access can uniquely identify each row.
  18. cjowsey

    Date Format problem in a Function query in ADP

    I'm in Australia and have never had this problem with BETWEEN dates in Access 2002. It sounds to me like your date is not what you think it is. Are the fields that you are passing into the stored procedure declared or formatted as dates? Have you tried a debug.print "Day is " &...
  19. cjowsey

    Record Locking and multiple users within Access Project

    I am not sure if I fully understand the problem but it sounds like the data displayed in the form is not being refreshed after you update the individual row. If you are using a stored procedure to populate the form you should refresh or requery your recordset after the update otherwise the data...
  20. cjowsey

    Database Project

    In the front end database, select the menu option Tools, then Startup... and set the database to open with your main form. Then, when you next open the application, it should launch that form. You are better off asking this sort of question in one of the other forums such as Microsoft:Access...

Part and Inventory Search

Back
Top