Search results for query: *

Thanks for your help anyways. We found all stored procedure work for certain periods, but not one particular one, so it's definitely a strange one.

Public connMiner As New adodb.Connection connMiner.CommandTimeout = 1000 For i = 0 To maxSteps psrCode.connMiner.Execute aActions(i), , 132 Next ---Here'se the array that populates aActions aActions(0) = "psrOverheadMakeTableQry('" & strActualsPeriod & "')"...

I am running stored procedures in Access. I keep getting a Timeout error, I changed the timeout time to 700 seconds, but it still doesn't work. Is there a way to prevent this from timing out?

Hello I'm adding fields to a table and am having problems setting the format for two of them. 1) Date/Time the format should be Long Time 2) Boolean the format should be Yes/No I can set the field types, but not the formats? Is there a way to set these formats?

Is there a way to modify a report stored in a separate Access db.

Did anybody get this to work? I want to create a right-click menu to copy, paste or move the selected node.

I can check with the web developer. Once the .NET object is wrapped, how can I call this from Access?

Is there a way to call a .NET object from Access? What I need to do is put a link to an internet site. The website uses .NET encryption. I'm not really sure how that works, but I need to create encrypted links to the website. (I'm not a web developer) Is that possible?

When I link a table, the leading zeroes are stripped off a field. How can I stop this from happening?

Thanks anyway!

That didn't work. I have a page footer with the page numbers already. That still prints at the bottom. When I added the textbox to the report footer, it printed right after the last record (in the middle of the page). Thanks

Hello Is there a way to print the report footer at the bottom of the page?

Thank you!

Thanks!!

Is it possible to create an mde file using VBA?

How can I close the VBE using VBA

Is it possible to increase the report size to greater than 22 inches?

I am creating a subform. Users will be enter number of hours in each textbox. I want to use the AfterUpdate event to total the hours for each week. (Each textbox represents a week). I will be creating this subform each time they import a data table, so I need to do it dynamically.

Hello I'm creating a new form using vba and need to assign an event procedure to each of the controls. Is it possible to assign an event procedure to a textbox using vba?

Here you go: SaveFileName = "<" & InputBox$("Enter Path and file to save project to: ") & ">" FileSaveAs Name:=SaveFileName, FormatID:="MSProject.mdb8", map:="Export Resources