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. nobull613

    Passing Value to Subreport's Command Prompt

    Thanks for the reply Madawc. I actually found the issue was in my subreport link configuration with the main report. Within the Change Subreport Links window I needed to use the bottom-left drop-down to select the Subreport Parameter versus the bottom-right drop-down box that uses a specific...
  2. nobull613

    Passing Value to Subreport's Command Prompt

    I have a main report pulling data from a Date Dimension table and am grouping on a formula that cals the first date of each month as DateTime. Within each group I have a set of subreports hitting a MSSQL Database using a Command. Within each command I have created a DateTime parameter which is...
  3. nobull613

    DSN Less Connection Code Works in Access 2003 but Not 2010

    Resolved, I put the code into a new 2007 database and it created the connections. I was able to import the other objects and it still worked.
  4. nobull613

    DSN Less Connection Code Works in Access 2003 but Not 2010

    Correction to my initial post, I actually have Access 2007, not 2010. Thanks again for any help that can be provided.
  5. nobull613

    DSN Less Connection Code Works in Access 2003 but Not 2010

    PH, I tried that and it still yielded the same result (the Call-Failed error). Thanks for the advise though.
  6. nobull613

    DSN Less Connection Code Works in Access 2003 but Not 2010

    I have used the following code referenced in the following link and it works fine in Access 2003: http://support.microsoft.com/kb/892490 When I attempt to use it in Access 2010 it kicks a Run-time error '3151'. The specific line that highlights when choosing to debug is...
  7. nobull613

    Roll-Back Entry if Primary Key Condition Fails

    Well that was much easier than I thought it would be. Seems almost too simple. That seems to do the trick exactly as needed. Thanks BikeToWork!!
  8. nobull613

    Roll-Back Entry if Primary Key Condition Fails

    Good Morning. I have a table where a composite Primary Key is used based upon a unique Date and Location being entered. I want to check the table to make sure the Date and Location haven't been entered already while the user enters data (After Updating the Location). If they enter the date...
  9. nobull613

    DSN-Less Connection Not Allowing New Records

    Well, it doesn't appear to be limited to the checkbox. The Update isn't completing before the form reopens and executes a Select. It's creating a lock. Is there a way to explicitely commit a change through the VB in Access other than accmdSaveRecord?
  10. nobull613

    DSN-Less Connection Not Allowing New Records

    As an update, we've tried updating the data type from bit to int and it didn't work either. Same thing regarding the ODBC Call Failed after unchecking a checkbox.
  11. nobull613

    DSN-Less Connection Not Allowing New Records

    Thanks for the replies Duane. I'm still having a heck of a time with one piece of this. I was able to get the connection to MSSQL to work. Some of the users connect to MS Access through a Citrix client. They can open, add and edit data. I am running into a problem with a checkbox. If it was...
  12. nobull613

    DSN-Less Connection Not Allowing New Records

    Would there be an issue that the connection wouldn't close properly, or leave records locked when the database is closed? Also, is it possible to make sure that no record locks are left in place when a form that uses one of the linked tables is closed? Thanks,
  13. nobull613

    DSN-Less Connection Not Allowing New Records

    That worked, thank you. If I may ask another question, would you remove the linked tables from the database when the user exits the database? If so, do you know what code would be used to do so?
  14. nobull613

    DSN-Less Connection Not Allowing New Records

    I'm attempting to link an Access 2002 database to an MSSQL server and need to do so without setting up ODBC connections on all user's computers. I used the code specified in the Microsoft Article (http://support.microsoft.com/kb/892490). It pulls in the tables just fine, but I cannot add a new...
  15. nobull613

    Code for Creating Worksheets in Excel

    I'm not sure I explained it well the first time. John, you are right, the data is stored in one worksheet, with the template (and subsequent Employee worksheets) linked to that main data worksheet to display the individual employee's data. I gave the code and try and it seems to work...
  16. nobull613

    Code for Creating Worksheets in Excel

    Is there a way to use VB code in Excel (version 2002) to automatically create worksheets and rename them to a list of values in another worksheet. I would have a list of employee numbers in one worksheet and worksheet that is a template, that would use the specific employee number to do a...
  17. nobull613

    Calculating Time without entering date - into next day

    Assuming that the Stop time always occurs after the Start time (hate to assume) you could try: iif(DateDiff("n",[StartTime],[StopTime])<0,DateDiff("n",[StartTime],[StopTime])-[BreakTime]+1440),DateDiff("n",[StartTime],[StopTime])-[BreakTime])) You're probably getting a negative value for your...
  18. nobull613

    Summarizing the data for last 13 months based on Selected Month

    Sorry, that's because your PC probably has the default setting for numbers to include commas as thousand seperators and decimals. If that happens then it tries to set the year to 2,009 instead of the 2009 that's needed. Try...
  19. nobull613

    The Result of selection formula must be a boolean

    I believe that you need to set the Sales_Code field equal to something. If you're trying to get it to return all Sales_Code records if the user enters "NA" then you may need to try: if {@SalesCode} = "NA" then {Job.Sales_Code} like "*" else {Job.Sales_Code} = {@SalesCode}
  20. nobull613

    Summarizing the data for last 13 months based on Selected Month

    You could try something like: {table.date_field} in CDate(Month(DateAdd("m",-12,{?Parameter}))&"/1/"&Year(DateAdd("m",-12,{?Parameter}))) to {?Parameter} Entering 7/31/09 should return a range of 7/1/08-7/31/09. With it grouped by the date_field and appropriate summaries, that should give...

Part and Inventory Search

Back
Top