Microsoft Access / VBA Forum

Hi all. I have an access 2000 database with one table with two fields. Both fields have telephone numbers(like telephone calls).I need to make a query to count how many times one number call another and if its possible wich numbers call the same telephone number.Thank you.

Hi alls, I have 3 files...which are (main database,securefile,shortcut access) for main database I can modify it ..but for secure file I can't do any modification on it.. all those two databases can access through (shortcut access which set its property (wrkgrp to securefile) :);

I send data (percentages) to Excel with 1 decimal. The number before send to excel is 1.2%. When send to Excel the number becomes 1.20%. This is the default setting of Excel for percentages. Can anything be done in order to avoid formatting numbers again in Excel ?

Dear listmembers, Is it possible to change default values in the table design view. for example: De default value for the fieldsize of a textfield is 50. Could I change that value by default. I don't refer to de default property of a field, but the startvalues in the designenvironment of a table. I suppose that there is a sort of a...

I am trying to create an application in Access that I will be able to print bar code labels. A stumbling block that I have hit is the Serial Number on the bar code. I would like to be able to read the Serial number from a Customer table. This serial number just starts at 10000 and goes up. This number is incremented everytime a label is...

does any one know how i can make it so that when a number (15) is inserted into a field in column A, the corresponding field in column B always enters the date that the certain # was entered into column A. or a good tutorial will help im using access 2000 and the generel date/time format thanks

I am working with the Invoice report in the Northwind sample database. How can I see the SQL statement that provides the data to the report? Thanks.

I have a DB and all of a sudden the DB window is gone - and I can't get it back. Note: I am having trouble with my laptop keyboard and it seems to have a ghost so things "happen" when I'm not pressing the key (I think some key is sticking). So, I may have done something, but can't find what. All boxes are checked (Startup) as to allow to...

Hello, I'm new to access, I've used vc++ and sql, but I was required to program this project in access. I have two questions in one. First let me explain my program. It's a huge database which takes the accounting of a construction company. One of the most important things of the program is to load all the bills of the different suppliers. The...

In Access 97, I have a form to track order status. For each record, there is a Customer Master table, an Order Master and Order Detail tables. When I call a record, the Customer number appears on the form along with order details. I want to add the ability to show a photo of that customer on the form. The photos would be stored in a...

>From a combo box the user can select a supplier. They then click the order button and are then taken to the orders page. From here comes the problem, I want the user to select a combo box unique to the supplier. Currently the combo boxes I create show all records for every supplier.

I have the following 2 tables: location: place lft rgt ------------------- Europe 0 99 England 1 10 France 11 20 Italy 21 30 Asia 100 199

Thank you in advance for any and all assistance, it is GREATLY appreciated. I have a Query that shows an AnimalName and Damof and Sireof. When I click on the unbound lookup combobox, I can populate the Dam and Sire of the Animal in question. What I would like to be able to do is also populate each successive Dam and Sire in the family line...

I am looking to buy the above. I notice that access 2002 is more than 2003? I need to buy these versions because 2002 mde will not work on a 2000, and you must have a copy of 2000 to recreate the mde in 2000. you can't export the 2002 mde to 2000, only the mdb. What do you recommend for somebody who needs to distribute the mde to many...

Any way to create an Access 97 MDE (programmatically) from within an Access 2003 application. I can do it from within my Access 97 adn when I do it from within my Access 2003 app it create a 2003 mde. Any way to force 97 from the 2003? Ira

What about DDE & Access 2003? I see in msdn and I found methods for Access 2002/XP and 2000, but nothing for 2003.. Is the same method like in 2000 or 2002? Thanx in advance. -- ¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤º°`°º¤ø,¸¸,ø

hi, I have a base splitted in a front-end and back-end. the fe is on the local harddrive et the be on the network harddive. My question is: Is there a way to speed up connection or something else to make the froms openning faster ? The purpose of the base is to make a planning. Given a week, the base permit to put some task on a list...

I have a textfield in my database which stores the location of an image. Each time a record is selected, the right image is loaded based on the path stord in the textfield. Now I want to print a report with these pictures. Is this possible??

Sorry, CDMA, I searched this NG on several combinations of words, but I didn't find a relevant hit, so here's my newbie question: I have an Access 2002 table which contains data extracted from Oracle 9i for a specific date. The table is then queried and about 15 different reports are generated, based upon those queries. My problem is that...

A97. If you set a forms properties to ShortcutMenu = No, the entire form is disabled from displaying a shortcut menu. If you set the property to Yes, all controls have a shortcut menu. I have a form that I would like a shortcut menu on 1 control and no shortcut on any other control in the form. But the controls that have no shortcut...

Hi I hope you bare with me on this - I want to highlight a record in a subform, whose data is based on a query. I.e. I want the marker to jump to the record that has the field = 23235 for instance. I've tried several solutions I found when searching the forum, but none worked. I have a main form, containing a text box where I enter the...

Anyone know how I can access a MS Access database from perl? Any help appreciated.

I have a simple database comprised of two tables. tbl_employee_info stores employee info (name, hire date, title, etc.) and tbl_departmental_history stores departmental transfer history. The two tables are linked via the EmployeeID, which is an autonumber. What I need to be able to do is tell how many employees I have in which departments...

I'm new at VB code. This was a database created by someone before me. I'm trying to make some modifications. I want it to search in the logbookID of a form to pull up information about only that specific record on the form. Here's the code I currently have. Private Sub DATA_Click() On Error GoTo Err_DATA_Click Dim stDocName As String...

Hi, This is very wierd...but from what I can tell here's what happens: I click print on an access form...to print current record. It goes to the printer. Says "Printing" then it quickly says "Delete-Printing" and nothing gets printed? Anyone seen this before? thanks in advance