Search results for query: *

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

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

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

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

Does anyone know how to see a global variable value per record if that global variable value changes per record? My actual process is more complex, but in general I have three fields in my query (Account, Amount, FormulaType). The 'Amount' field calls a custom function. That function runs one...

I have a report with 2 subreports. The subreports are in a groupheader. I want to insert a page break in between the subreports if the second subreport happens to be more than 8 inches (11,520 twips) below the top of the paper. I can get the distance of the group header from the top of the...

I want to see if any of the values in Table 1 appear in any of the fields in table 2 (actually in every table in the db) Table1 FieldA XYZ ABC 123 Table2 FieldX FieldY FieldZ Jane 25 Tom 12 XYZ Joe 15 123 The field...

I want to compare a table that contains 8 fields to all the tables in my database to determine which tables contain all 8 of those fields. Unfortunately I can't visualize the code. What I have so far starts with: Dim db As DAO.Database Dim tdf As DAO.TableDef Dim fld As DAO.Field Dim cpRst As...

My custom format for the textboxes on my report is: #,###;(#,###);-;- The problem is that some records have decimals, which I want to show, but most are whole numbers and I don't want the whole numbers to show trailing zeroes. The 'General Number' format works fine except for 0 and null...

I have my report that I set the grouplevel and a label in the group level when the report is run, based on the user selected criteria. The error I get at runtime is 2427 'You entered an expression that has no value' The string sGMFNDS is highlighted as the error and when I place my cursor over...

I have a table with canned formulas such as: (FldA + FldB)/FldB I want the user to be able to select one of these from a combobox and then have this become a formula in my master query. Unfortunately, I can only get the query to display (FldA + FldB)/FldB instead of this formula's result which...

I have a table with canned formulas such as: (FldA + FldB)/FldB I want the user to be able to select one of these from a combobox and then have this become a formula in my master query. Unfortunately, I can only get the query to display (FldA + FldB)/FldB instead of this formula's result which...

I have many tables that use the same field names and in my queries I always add a formula to concatenate those fields into an account number. Could anyone help me figure out how to automate this in a public function? I learning VBA but am not too knowledgable yet on creating my own functions...

I've reading through posts for a couple of days to figure out where I'm screwing up and can't figure it out. This code borrows from several authors on the site (Thank you all) to send emails via Lotus Notes. It is suppose to open a query showing who will receive emails and for which department...

I am trying to figure out how to show sequential line numbers over an entire report. If I put a running sum in the detail section then the report shows no line numbers in the headers (which the user is going to ask me why I can't make it look like their old Excel reports). Does anyone know of a...

I have been researching this but don't understand VBA enough to figure out how to do it on my own. I have a accounting report grouped by department. It is based on a query that shows department, fund, etc. I would like a text box under the department name on my report that shows the funds...