Search results

Note: Its a new database, so I dont have any old records so to speak. I have just been doing tests with it and these are the results Im getting, so Im trying to plan for the future when I know I will have to edit descriptions. It always happens here. What I have is a 2 column list made from...

David, I tried the code and what Im getting now is when I put in the Part Number, the same part number comes up in the next field. If you could cook up an example, it would be greatly appreciated! Thanks. John

Im a little confused..... Do I need to have 2 tables? One for lookup and the other to store data? Actually how I have it now kinda works. The old records show the old description, but the part number disappears. Any suggestions on why? Thanks David for replying, you helped me a great deal...

I think there is a little bit of everything in this question so I hope this is an okay forum... Heres what I have and what do I still need to do? Purchase Order Database I have a table (Part Number/Description Table) with 3 Fields: 1. ID 2. Part Number 3. Description I have a query...

I have a query that is linking 2 tables together by a ID Number. One table is for the part number. The second table is for the part number description. I use this query in a subform and it works great. I click the part number combo field and the description automatically follows in the second...

I got it. I had to switch the long integer to single. Thanks. John

I am making a simple subform in a form and have a quantity and a unit price to figure a total cost. I got the total cost to work easily with an expression, but for some reason the unit price field keeps wanting to round up or down automatically. I dont remember setting anything for this. In...

Sorry if that was confusing, let me try to clarify.. I have a Purchase Order form and inside that form there is a combo box that when I double click it, I want a secondary form pop up and then I can add any pertanent information. For example: In the combo boxes there are suppliers, I go to add...

Heres what Ive done so far: Created a table called Suppliers with basic address fields Created a form called Suppliers with the same Both have a Primary Key using Autonumber What I want to do is like in the template database "Inventory Control", when you go to enter a Category name it tells...

What kind of jobs are out there for Access Programmers?? Im no where near at a position to try but I was curious. Thanks. john

I have Access2000 and 97 on my computer and have 3 shortcuts on the desktop to the various databases. Two built upon 2000 and one upon 97. I start up the computer and open lets say one that was built on 2000. It opens up fine. Then go to try and open up one that was built with 97. I get an...

Thank you very much!

How do I put in a start up window that will just pop up and go away as the database opens. A little screen that has the name of the database on it and the version. Thanks. john

I am designing a query so I can look up records that apply only to the Supplier and the Start / End Dates. I want to make a pop up form called Supplier Records. In there have a blank to enter the supplier. And 2 blanks to enter the Start and End dates. Along with the report preview button. In...

David, Thanks for all your help. I made a new query with all the info and then redid a report based on that. Works perfectly. I used a Modal/Pop up form to enter in the dates (start/End) for the report and was wondering what event will make the form close after I hit enter for the preview...

Maybe I dont want a combo box. Then can I have a text box that links to another text box? For example I have 2 boxes, and in the first box i enter in the part number. I then want that part number to automatically pull up a description in the other box. THe description needs to be editable...

The parameter looks like this: Enter Parameter Value Rating Average Query __________________ Okay - Cancel I dont know if this is screwing it up or not but I do have a record source for the report itself on another query. It is for a Between Dates parameter. So I actually get a Enter the...

Thanks for replies DavidR, Okay the query is working fine. I did a Run on it and looks great. In the report I used the "AvgofReportNumber" in the control source and am still getting the "add parameter window". Stuck here. j

I couldnt find a sigma button, but I found some info in the help section and heres where im at: I created a select query. In the first column i put in the information for the Supplier name. And had it Total by group. In the second column i put in the Rating number and had it Total by AVG. Dont...

How do I edit that list?