Search results

Thanks DCrake. Unfortunetly I will need a little more help putting that into practice. I am an amateur.

The 510 represents the total minutes between 6:30AM and 3:00PM. I am assigning breaks to the entire department so each individual in the department has the same breaks. My requirements are to provide the time it takes to complete a project that is scanned "started" and "stopped" where the time...

Hello, I am trying to format this code so that I can use it for several applications within my company. I am calculating my elapsed time via the code below. What I would like to incorporate is to have lunch and breaks taken out daily if the Start and Stop time were to encompass the lunch and...

Hello, I was not sure what to search for regarding this question. I am using Access 97 and I have a form with a header that contains information for a project. Beneath that header is a subform running a continuous form of steps for that project. I currently have a field in which the user inputs...

I open the form and I enter a title and a date. That title and date needs to apply to every record in my subtable. I want to apply that via the ID of the main form. I would like a procedure that once you enter the title and date... the autonumber that is generated automatically fills in the...

well, i have several records displayed in a datasheet view form that need to apply to that autonumber. I have linked the tables so that it will "Include all records from .... and only those records from ... where the joined fields are equal" this allows me to view all the items I need to in...

Hello, I have a question. I would like to be able to have an autonumber in the main form be applied to text boxes on the subform. So If I enter a name in the main form, an autonumber is generated, then that number is automatically entered into the boxes in my subform. My subform is a datasheet...

I apologize, I have been trying so many things that I am confusing myself. This database is so basic. I am taking a forecast for 10-15 models. So I want the models to be listed as records because the models dont change. Each of those models is comprised of parts (majority are the same). I...

Thanks, that would work nicely. Do you have more information on what code I would enter into the event procedure so that the box corresponds to the record I have selected? Thanks, Adam

Well I would like for the main form to always be composed of the products and the parts list for that product. So if I have 15 products each with a list of parts, I want them to be visible when using the record selector. I just want the one field, the ExpectedQTY field to be blank each time...

I have the many to many relationship and I looked up information that told me to make the FK's from the parts and products tables and make them both PK's in the PartQTY table. I guess my main problem is to be able to enter in an ExpectedQTY into the text box related to the ExpextedQTY table on...

Hello All, I am new to this forum :) and learning Access :confused: . The Database Tables: Employees Products ExpectedQuantity PartQTY Parts Most of the products are similar so they have the same parts for the majority. However they do not all have the same parts. So I created a...