Search results for query: *

Thank you for the quick reply. I read the posts and got it to work. For anyone whose interested, the working code is: DECLARE @CurrentRow int DECLARE @RowCount int, @strResult varchar(255) DECLARE @temptable table(Id int primary key identity(1,1), HTEFund int) INSERT INTO @temptable...

I am new to SQL Server (from MS Access) I would like to concatenate a recordset into a single string such as: FieldA ------- 101 210 206 Into 101,210,206 I have stored procedure started but it returns a null value: ------------------------------------ DECLARE @CurrentRow int DECLARE...

I figured it out. You can still create custom toolbars using: dim cmdBar as CommandBar Set cmdBar = CommandBars.Add("CustomToolbar", msoBarTop) Set cmdBar = Application.CommandBars("CustomToolbar") etc, etc To make the 'Add-Ins' tab appear with this commandbar, insert the following at the end...

You can also make a macro named 'Autoexec' and Access (including 2007) will do whatever commands you put in there when the database opens. For instance, you could create a macro, choose the 'Open Form' command and then name it "autoexec

I am re-creating an Access 2003 program in Access 2007. I had a custom toolbar in the older version. Does anyone know the code to make a custom toolbar on the Add-Ins tab for Access 2007? The command: application.commandbars.add does not seem to work. Thanks!

Awesome! That worked perfectly. Thanks for the help

I am trying to read the DateModified property of a form in another db (to compare it to a form in the current db that has the same name) I know how to get this property in the currentdb using: Dim Obj as Object For each Obj in CurrentProject.AllForms Debug.Print Obj.DateModified Next Obj I...

I want to know when an object was last updated. MsysObjects seemed like a good starting place, but the field "DateUpdate" doesn't keep track of this. Microsoft KB 299554 describes this problem. http://support.microsoft.com/kb/299554 I'm wondering if there is an add-on out there that can log...

My goal is to eliminate a user id and password popup that users get when they access a table that is linked from an AS400. I think I need to re-link all tables using a DSN-less connection where I hard code a generic username and password so the user never has to do this. I have looked at...

CautionMP, Thanks for the help. Using OLE fixed the problem. I hadn't thought the two would give different results. Alex, thanks for the code.

I hadn't even thought to try it with OLE. I'll give it a try. Thanks for the help!

I posted this previously but the subject line may have been confusing. Anyway... I'm sending email from VBA via Outlook using the following sub: Sub EmailReport(ReportID As Long, ObjectType As String, ObjectName As String, OutputFormat As String, Subject As String, MsgText As String) Dim db...

Any suggestions?

I'm sending email from VBA via Outlook using the following sub: Sub EmailReport(ReportID As Long, ObjectType As String, ObjectName As String, OutputFormat As String, Subject As String, MsgText As String) Dim db As Database Dim rs As DAO.Recordset Dim strBody As String Set db = CurrentDb...

I don't suppose anyone out there has any more info on this topic?

Thanks! I've actually read it recently though trying to find out more about the so called "pseudo indexes" tht can be made on linked ODBC tables but it doesn't appear to reference multiple, non-unique indexes. There's an additional reference to this pseudo indexes at...

I am trying to create a non-unique index on a linked ODBC table but when I use the following code I get a unique index and the field is set as the primary key. currentDB.execute "CREATE INDEX idx1 ON tbl210AP(Fund);" Does access only allow unique indexes on linked ODBC tables or is there a way...

The function isn't really as simple as I wrote above. The real function uses recordsets, calls other functions, compares multiple values, etc. It currently has 7 "IF" statements that get evaluated per record. Each record takes about 1 full second to process and the query currently takes...

HandsOnAccess, Thanks for the reply. My reply after yours was to BoxHead. I am using your format to get the 'Amount' value, but I just don't know how to get the query to see the current value of the global variable, which I want to show in the third field, 'FormulaType'. Sorry, its been...

The global variable isn't the same for each record because it is just holding a value representing which of two formulas was used in the function for each record. The end result datasheet should look something like Account Amount FormulaUsed 101 205.26 1 101...