Advertisement

635 organizations, including eBay, Ericsson and Lockheed Martin, now work smarter with Corporate Accounts. Save up to 42%

 
TechSoEasy

Welcome! If you have any general questions about Experts Exchange, feel free to ask me.

 
Top Access Coding/Macros Solutions: 451 - 475 of 613
 
chart object, pop up the "Format Axis" dialog
I have a chart ('Microsoft Graph Chart') on my form. I want users to be able to change the scaling of the X and Y1 and Y2 axes of the chart. They can do this by:   clicking on the chart   d...
Counting the number of lines in a memo field and saving the result to a string
I wonder if anyone can advise on a code snipet to count the number of lines contained within a Memo field. The mmo field in question will never contain more that 6 lines, but I need to output ...
Update form to show progress
I have a control form, with one button on it, to initiate a VBA routine. I'd like to show progress on the form, with unbound fields that I can update during the VBA routine. 1)  What's t...
How do I set the default filepath in the Common Dialog Box?
I have the following code which works:    Dim obj As Object        Set obj = ComDialog.Object    obj.Filter = "Access database (*.mdb)|*.mdb"    obj.ShowOpen How do I set the default...
Deleting a record from a table
I need to delete the record itself not just the data from the record which is what is occuring with the code that I am using. This code is attached to a command button on a form.
String Manipulation on a file path VBA
Can someone help me with some string manipulation code on a file path using VBA. Here is an example (please try and give me code that will pertain to any given file path) "C:\Documents a...
Calling a function from a module in another Access mdb
I have about a dozen Access mdb's that each generate only one dedicated table that is intended to serve as table that feeds a master Access program-only mdb. The dedicated table in each of the...
Why does Ms-Access 2003 Visual Basic Editor stop responding when I type 'Enum' in vba-code?
Hello. I am writing a visual basic application using ms-access 2003 and vba, and have this problem: Whenever I write 'Enum' in the visual basic editor code, ms-access freezes completely a...
Insert Into Syntax
Experts, I have a syntax error on the & '" & Me!LCNo & "' & part. It is suppose to be single quote double then double, single and Me!LCNo is surronded by this.   LCNo is text not number a...
Setting a value in a subform
I am trying to set a value in a subfrom. I want the value to be blank (" ") so I created a macro with the following: Action: SetValue Item: [Forms]![frmProjectAttendance]![sbfrmROCSpiritLi...
How do I used Error Handling and Transaction Processing in the same function?
I need a detailed outline of how to integrate DAO Error Handling and Transactions (Begin, Commit, Rollback) in the same function.
Creating a calculated field with an Identity value
Hi there Is it possible to create  a calculated field in an SQL query that holds an identity value? Something like: SELECT        IDENTITY(1,1) AS ID, EmailAddress FROM Customers
How would you load a recordset into a table ?
I am developing an MDB type Access application. I call a stored procedure and load its result set into a recordset. How would you load the records of the recordset into a table. For examp...
Filter a report from form error
Hi, I have the following code an a cmdButton which opens a report to print: Private Sub cmdPrint_Click() If OpPrint.Value = 1 Then DoCmd.OpenReport "rpt_scannedfiles", acViewPreview, M...
Help identifying all key combinations that change/add/delete records
I'm writing code to mask out Access's normal keys/key combinations that change the selected record, add a record, or delete a record. Here is what I have come up with so far: Tab Arrow Key...
Calling a sub from within another sub
In VBA, I need to run a sub from within a different sub. I tried the following: docmd.OpenFunction(OtherSub) but this did not work (the compiler wanted other parameters).  Thanks!
AccessQuery: show data in table + "Miscellanous"
I have a table with one field titled: "Field1". How do I create a query that will show all of my data in "Field1" + the word "Miscellanous". "Miscellanous" must always be on the top of the lis...
Error in Access 2003
We've just installed Access 2003 on a PC. When we open a database we get an error that it can't find mfimgvwr.ocx. Opening the same database on other PC's doesn't generate the error ...
subform navigation
Mainform - Leads Subform - HIstory Subform field - Disposition When Mainform changes records,  ie Current_event is triggered I would like the Focus to be on 1st subform field with a empt...
Search for text in table with VBA
Hello, I've built a form for our users to be able to created IDs and add contacts to our database as they complete surveys for us. In the form there are two buttons, the first when clicked ...
Pulling value of a field on a main form to a subform using VB
I want to pull a value from a form to a field on the subform. If you look at the code below, on this line "MRBTimeElapse = Me.ElapsedTime" I moved the "elapsedtime" to the main form. The m...
Seperate Error Codes from a Cell in Access Table
I have a table with a column name SUBM_ITEM_ERROR_CODE and the cell has an error code which tells me there is certain information missing in the row. For example: 'H02 L01 L02 EE' in a cell...
Displaying a zero when a subreports field is null
I have a report with a subreport. The subreport counts a field and would give a number eg. 4 When there is nothing to count (ie no records to be counted) the subreport/query has no records. ...
How do i display the sum per month if the sum is 0?
Morning I have little problem that i just cant work out.  I have made a cash book that records money coming in for 5 different debts.  What i want to do display the total that has come in p...
How can VBA send an email that includes both text AND html formats?
I am using VBA in Access 2000 to email to all recipients on a list (on email at a time). It uses Outlook objects for each message and works well with html as the format. How do I include the p...