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 tried that and it didn't work at all. I put the code in On Open with ' msgbox lngChardonnay ' and after that the line that should put it into the text box: txtPlan.value=lngChardonnay but nothing happens and the report comes without it.

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 figured it out! The culprit is the "Tab Control". When the Tab Control is on the form there is no vertical scrollbar. I don't know why this should happen. I also don't know why there is a problem only on some computers. I guess I'll devide the one form with two Tabs to be two...

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...

Sorry! The macro is NOT an access macro. Those I do all the time. I have a WORD macro that goes to a table and sets up the data in a certain way. I want to press the access command button to start word with its macro. But word starts without its macro so I am asking how does one make word...

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...