Search results for query: *

I took the Employees form from the Northwind sample data base and am trying to use it to make a data base for labels for wine bottles. I scan the labels and am trying to insert them in the picture part of the Employees form. Maybe because wine labels are complicated images or maybe because I...

I live in a non-English speaking country and my workplace has technicions that speak English and managers that speak the local language. So when I program in Access I always have to fix the reports so the managers will understand. Access reports, even though they appear like FORMS in DESIGN...

I worked hard and managed to get some important values calculated in code. Now I want to make a report and add these values to text boxes in the report. Like: txtPlan.value=lngChardonnayPlan I have not succeeded and I suspect that I don't know where to put the event procedure. Thank you all...

It must be possible to program a text box in a new record to show wht the user entered in the previous record. Anybody want to reveal me the code? M.

We get a written report with the "ProductName" and the "DateSold" on the top of the page and then the list of customers and quantities they purchased. (They refuse to send table as a file. So we must enter the data by hand. ) When entering the data, I don't need to change...

I have had it happen twice. I put an access program on a pc and the forms appear without vertical scroll bars. I can't understand it. The form is set with property "Both" and NOTHING. Anybody every see something like that? Any ideas? Michael

I have a program for a professional winemaker. The wines change year by year and are identified with the "Vintage" year. I really would like to code a filter for a recordset to show the only those records with the chosen vintage. I don't know how to code such a filter. I could also...

I have access 2000. My program is about filling wine bottles. I have a crosstab query that returns the number boxes of each kind of cork we will use (based on the number of bottles we will fill) Like this: ALTEC 177 CHAMPAIGN 3 N44 104 The names of the corks are the ROWS. I have another...

I have access 2000. My program is about filling wine bottles. I have a crosstab query that returns the number boxes of each kind of cork we will use (based on the number of bottles we will fill) Like this: ALTEC 177 CHAMPAIGN 3 N44 104 The names of the corks are the ROWS. I...

I have a form for a winemaker. He enters the name of the wine by choosing with a combo box. The combobox saves the WineCode (three letters) in a field called WineCode. How do I know if he is entering a WineCode that already exists in this database? Thank you much.

If I have have 1000 bottles in each pallette of bottles and I need 1100 bottles, I therefore will order two pallettes. In access how can I always round a fraction upwards? Michael Unger

I need to create a form exactly like one already in the database and then give it a new recordsource. The objects appear in the database window but access refuses to change the recordsource. What is missing? Here is the code. Feel free to change anything! Thank you. Function...

One command button is supposed to open word 2000. There I have a macro which is supposed to open. The Word 2000 Help says to open like this: winword.exe/mmacroname . I can't get that to work. What I am doing wrong? Michael Unger

You are all so helpful out there! I have a form with several option groups and I would like to make a table to store the values clicked on the form. I don't know how to make a table that connects to such a form. Any helpers?

I need to print mailing labels from my access 2000 database. I found the "label wizard" hidden inside "New Report" button. The "label wizard" is not very good, especially in determining how many rows and columns on a page. Is there any "add on" to access...

I have a table called "members" and a form based on it called "members". I wanted to write code with dot notation something like this "members.recordset.count". Access doesn't recognize this so I conclude that access is using a different name for the database and...

A plumber works at several schools. We need to make a schedule for him. We have Access Tables for each school including the pipes and sinks, etc. When I try to make a query that takes from one or more items in each school-Table Access doesn't let me fill in the data complaining that the data...

I have an old application that uses a .dat file for the data. If I want to convert it to something from the 21st century, how do I do so? I haven't succeeded in viewing the file properly with the few file viewers at hand.

I have a form that fills a table. I thought I would make a subform that looks like spreadsheet so that the user can see the previous entries. Perhaps this would prevent a user from reentering data that he forgot was already in the data base. When I use the subform wizard I am not offered...

I have a combo box named "LicenseNumber" that successfully displays from a table named "Trucks" the two fields: "LicenseNumber" and "Weight" The user is to click on the proper License number which then appears in the combo box. The "Weight&quot...