Search results

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!

I have a form that pulls data from a table. Basically the form is just a postcard. I have our company name, address, PO Box, city, state and zip in the upper left corner. My fields in the center of the postcard tie back to a table that contains the contact companies name, street address, PO Box...

I am attempting to create a parameter query to show a specific range of dates of service for my customers. Example: I want to see data from my table from Jan. 1st, 2006 to Feb. 15th, 2006 for any customers serviced in that time frame. In the query I have under my Date field, I have the following...

Thanks ScottGem. That was easy enough. I suppose I was trying to make it hard.

I have a combo box that has a list of Techs that do service work. I do have the tech names in order but I noticed that if you are a keyboardist and attempt the following function it isn't working. I have three techs with names that start with "J" (Jack, Jimmy and John). If I keyboard and press...

RuralGuy Thanks for the info. Such a simple fix. I bet I don't forget that one anytime soon! Thanks for the assistance.