Microsoft Access / VBA Forum

I am new to Access and having real trouble working out how to do the following I have an excel table that has 20 columns and a few thousand rows, Excel works in the right way by using autofilter I can filet my records with no problem. However I canno seem to hide the thousands of rows. All I want to see is the header and when I click on...

I am try to pick out email address from one field and put into another field since email is mixed out in that field. It looks like this: "ffffffdfer mymail@yahoo.com" I am trying to pick "myemail@yahoo.com" out and put in a seperate field. Can anybody help me with this? Thanks

Looking for Java to MSAccess interoperability tools? Thousands of companies world-wide are using J-Integra for COM for interoperability between Java and Microsoft COM applications. J-Integra for COM is a pure Java implementation of the DCOM protocol, making it several times faster than Web Services. J-Integra for COM Features: * Access...

Hey, Does anyone know which function to run updated query in macro? I used "OpenQuery" function, but it seems doesn't work. No error message. The query is correct because I could run it independently. Thanks a lot. Mindy

hi ! i am generating a report with a lot of fields. if the value in a field is null , that field cannot be not included in the fields on the report. how do i do this ... with a query or some other way ??? thanks brino

Is it possible to limit the number of Subform records using MS Access 2003? That is, my end users want the capability of entering up to 12 records on their subform. Is that possible? Thanks!,

The database I am working with contains a field with as many as 12 different values (09,10,11,12,13,14,15,16,17,18,19,20) My end user has requested that the number of times these 12 different values appear in the table be grouped in the following 8 groups (15 or 19), (13 or 17), (16 or 20), (14 or 18), (09), (11), (12), (10) That is, for...

An excellent resource on Software Configuration Management has been added including principles functionality for those who want to explore and intend to get benefit. Must Read!! http://www.it-techexperts.com/SCM.asp

I need to create a report or query that will show the last step completed in a process. Here are the details Part number serial no Discription Date 10068206-302 0225 KIT READY CHECK 6/26/2007 6:32:06 PM 10068206-302 0225 KIT PARTS 6/26/2007 6:32:21 PM...

Is it possible or feasible to load one version of Access (2003) and the new version (2007) on the same hard drive and run appliecations on each one separately ? If you can, how do you load the new version (2007) on your hard drive? -- Message posted via AccessMonster.com...

1. Is an ODBC link activated when you first open the database? A customer gets some kind of network message when his users activate his ODBC link through a query, form or report. I made some changes in the database for him so that only the admin can access queries, forms and reports that are tied to his ODBC link so users never get the...

I'm trying to create a catalog through Access that can be posted on-line. I have set it all up, but in designing the "access page" I cannot get the OLE objects (pictures of the products) to appear. It only allows me to insert pictures from files, in which case the picture doesn't change with the record. If I try to add the OLE object as a...

Hi. Awhile back I got some useful advice in locking records using tick boxes. Eg a field called 'Locked' was used to tick (yes/no format) any record in the datasheet view. But I would like to know how to do the same when a particular date field (field name: 'File Date') is populated by the user. Below is the example of the tick box...

Hello all, I am converting an Axs 2.0 application to a2k (I know A2K is not the most current version but Axs 2.0 support ended and A2K is supported in our company amd on every PC). The form is part of an access projcet (ADP) and runs against SQL Server 2000. I have an bound form in endless view which contains a header with a combobox....

Hello gurus. I have a function that queries our mainframe using an ADODB ODBC connection via a SELECT database. One of the fields is Premium. When I query this data via something like query anayler or MSquery, the data value read $6,690.00 for example. However, the access recordset value - for that same record - is

Hi I have built a database using Access 2000. For one of the reports I am trying to create I need to calculate working days. I have written code in VB which takes a start date and an end date and has a counter that counts all the weekends and bank holidays and returns the number of working days between the two dates. This all works fine....

Hi All, I'm a bit new to VBA and wanted to know is there any way you can format the command button? i.e make it a slightly different shape (rounded edges) and things like that. cheers Dav

I have a database I'm working with which has tables and reports. The controls in the reports are bound to data, but I'm at a loss to explain where the data is coming from. I have gone so far as to delete the tables of data, yet the reports are unchanged and show the same data as always. Anyone know what's going on, and how I can get to the...

is it possible to take data values added in a report and insert it into a form?

I have a tick box control that when checked opens Outlook and attaches a report. If the user clicks send then everything is OK. BUT if the user clicks the close on Outlook without sending the email I want to trap the error message 2501 and ask the user what to do. Here is my code so far: Private Sub Loadtxt_Click() On Error GoTo Exit_Handler...

I'm developing an A2K adp that contains doctor info and the months they are not available for teaching. A doctor can be unavailable for some months for one year and other months for another year. I want the user to enter the year then use a multi-select list box to choose the months not available, then go to a fresh screen, enter another...

I'm developing a small program that I would like to have a front and backend, so when I change the forms, all I have to do is upload the file on the frontend and if I change the tables, I can append the data. The problem I'm having is when I break the db, the front and backend go flawless. When I package and place in the P&D Wizard, I place...

I'm using ADO from AutoCad to try and resolve this query from an Access2000 database: SELECT * FROM qryAllnotes WHERE tblProjNotes.KeyText = '*grade*'; It doesn't return any records, but without the WHERE clause, it does. I know there are records there because I pasted into the Access query builder and I get two records back. qryallnotes...

I am having problems with an Access2K ade installed on a server running Windows 2000 Server OS. The app makes a connectin and authenticates with the server running the SQL Server backend, but the ade keeps asking for parameters that it doesn't do when installed on a Windows 2000 OS. Any help is appreciated. lq

How to display result set in random order?