Search results for query: *

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

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

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.

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

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

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

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!!

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

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?

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.

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

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,

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?

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

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

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

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

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

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}

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