Recent content by cnut1

What should be happening in the database is when several Bin Numbers are entered into the form (frmBinNo) such as 200200.0100, 20020.1200, 200200.1412 and 200200.1523 and you then press the Run query button. What this should do is pull the Bin No. from the tblParts and move it to the tblTemp...

I have a tblParts that has data in this format 200200.0100 (these are bin numbers). I have created a form with a bound field (field name on the form is BinNo) that goes back to the tblParts. I need to be able for the user to enter on the form the Bin number as it appears above. However at the...

I did change the bin no. on the table to text. But then it would drop some of the zeros. i.e. correct number 200200.0100 now shows as 200200.01 thus dropping the last two zeros. As for the properties on the datasheet I am not sure I did set them correctly, I did not see an area to set your...

Rich I changed the data type from integer to double on the table, however when entering the bin no. in the appropriate field on the form it still only takes the first 6 digits and nothing after the decimal. Also I found out I may run into bin no.'s that do not have anything after the decimal and...

Rich I changed the data type from integer to double on the table, however when entering the bin no. in the appropriate field on the form it still only takes the first 6 digits and nothing after the decimal. Also I found out I may run into bin no.'s that do not have anything after the decimal and...

I need to have a field on my form to accept the user keying in the number in this fashion: 200200.1234 but as I currently have it set it accepts only the 200200 portion of this part number. I am a beginner so I am sure this is an easy question for some of the pros out there. As a footnote the...

Neil Thanks for the example. That helps me greatly since I am more visual in the way I learn. I will work on it and let you know how it goes.

Neileg Not sure I am clear on what you are describing. All the Bin numbers, descriptions, etc. were on a spreadsheet in excel and imported into Access creating a table with all this data already in it. Working from this table what would I need to do other than create the form with bound forms...

I have DB with a Switchboard that has a button for Bin Number (Part Number). It is based on a parameter query that asks you to input your Bin Number. Once you enter the Bin Number it pulls all information for that Bin Number from a table that contains the Bin Number, description, Manufacturer...

I managed to work it out neileg. Thank you both for your assistance.

Neil The purpose in the database is for scheduling of technicians to customers in the same area. Example: 3 different customers have annual service in the month of Jan. They are all in the state of New York. The goal is to be able to determine this in advance to make arranges for the tech to...

Forms used: frmAnnualService frmPostCardback Tables used: tblAnnualService tblCustomers I have a database created containing 2 tables. (tblAnnualService and tblCustomers). I have the Repair Order set as the primary key in both tables since it should never have a duplicate. I have a one to one...

FoFa Will give that a try and let you know how it turns out. Thanks for the tip.

I have a form that is similar to a post card. The fields are linked to a master table that contains all the customer data such as dates of service, street address, PO Box, City, State and zip. What I need to do is have a method to pull into the post card form a range of dates, so the form would...

Sergeant Thanks for the info Sergeant. Gave it a try and it seems to be working for me!