Advertisement

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

 
MHenry

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

 
Top Access Coding/Macros Solutions: 476 - 500 of 596
 
Access control define code question...
Hello,      I am using Access 2003.   I am having a problem when I drag controls on to a form I get a "Out of Memory" error.     In VB v5 and v6 you can edit the code that defines a contro...
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 ...
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
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...
How do I obtain the highest value from one table, write this to a record in another table, then repeat this for all records in the second table?
I have one table of defined parcel numbers, and another table of consignments. I need to get the next available parcel number, write this to the consignment table, then repeat this for all rec...
How do I change a VBA Reference for Outlook 12 to Outlook 11?
I built a database in Access 2003 on a machine with Office 2003.  I opened the file on a machine that has a mix of Office 2007 and Office 2003 products . My Outlook 11 reference upgraded to Ou...
Extract Customized MS Access toolbar properties from VBA
Is There a way to extract MS Access Customize Menu Properties from VBA code?
unable to open Access 05 MDB/MDW with Access 2003. I have MDW passwords
Hi, I've looked and manyof the EE KB on this.    I'm just getting nowhere. I am a consultant asked to upgrade/modernize an Access 95 app, MDB with MDW file.  The original user and develope...
text instead of hourglass
I have used the  DoCmd.Hourglass True  for the hourglass to show while something is processing in Access How do I put something else in  for example  IN PROCESS to be showing instead o...
Microsoft, Access, VB, Filter - Opening a form with a filter
Hi, I have a piece of code which is supposed to open a form with a filter on the specific ID the code is DoCmd.OpenForm "Job_Failure_reasons_form_view", , "job_no = " & Me.Job_No, ,...
Cannot access netflix.com
Hi there...1st post :) My dad hosed his pc and downloaded some aggregious stuff.  Anyway  cleaned it all up but now he cant access netflix.com thats the ONLY site he cannot access. Us...
Error 3061
I am receiving error 3061 when trying to retrive records from a query based on the criteria of an open form.   Any suggestions? Here is the code for the query (qryAccess) SELECT tblAcces...
Access a field in a Table to a Dim
Hello Guys, I have the following table: Requested By     Account Name     E-maill address Ian                                     Support                ian@emailadress.co.uk I want to assign my var...
run to open and run a query in a remote database
Hi I have a query in a remote database that I want to run. I do not want to link in the tables involved and do not want to import the query (i,.e. do not want to make a frontend). So what ...
How to setup a subform to display blank record fields in subform until parent form combo box selection.
I have a parent form in my DB that contains an unbound combo box that upon open has a blank field which when a selection is made in this drop down it populates the subform with the correspondi...
Can Access be used with SOA ? I am considering writing an application in either Access or C# that uses SOA ?
Can Access be used with SOA ? I am considering writing an application in either Access or C# that uses SOA ?
Cant stop a loop when criteria is met
Afternoon, I have 2 questions, hopefully someone could lend me a hand regarding the attached code.  What I am trying to do is automatically apply a user to record on a table (I have just st...
How to check if a table has records based on a pick from a combo box
I have a form to add a new record to a table.  The table is tblActivities.  A field in the table is Village. The Village field on the form is a combo box. I want the user to pick a village...