Search results

Hello, I am not getting paid for this as it is my company and I am wanting to pay someone for the help. Forgive me if it came across as wanting something for nothing. So, I am looking for someone to assist me in setting up a relationship between three tables for a specific purpose. It is a bit...

Hi, I am working on a Access application and need just a bit of help getting a couple things off the ground with it. I am looking for a developer to work with me to resolve a couple of development issues to get it started. I think it is pretty simple for a skilled developer. Can anyone point me...

Best case would be if I select a stock number in the Lease Form and when I double click on it it would open the Inventory form and go to that truck. Fen

Ok sure, the stock number is a unique value assigned to a truck, ie last 6 of VIN. The stock detail would be all other information about that truck like Color, Make, Model etc. The idea is when I am creating a new lease, I can use the Inventory table to select the truck and relate that truck to...

Thanks, I am running into a bit of trouble. On my Lease form I have a lookup field "Stock Number" which pulls from the Inventory table. In my Inventory table I have a field "Stock Number" What I am trying to do is when I select a "Stock Number" from my lease form it creates a relationship on...

Yes a customer can have one or more lease agreements. A truck can only belong to one lease agreement but can be potentially released later. Thanks

Hi, I have three tables. 1) Lease Agreement 2) Customers 3) Inventory The Customers and Inventory table are populated. I am trying to figure out how to relate a customer and an inventory selection to a Lease Agreement. The idea is one of my customers comes in and buys a truck. I want to...

Perfect! Worked excellent. Thank you.

Hi, I have a query that has several checkbox fields. When I open the query it shows the checkbox not the value (see attached 1), when I export the data it comes into excel as TRUE and FALSE. Is there a way I can in the query show the value ie True or False and secondly add some code in the query...

Bang! that's it! Many, many thanks. Fen

Ok Thank you. I am not sure what I am doing wrong. I simply copy and paste the code just as shown, when you run it are you getting it to show: Notify Before Initial Entry, Notify Before Each Phase Mine just shows "Notify Before Initial Entry" Many thanks. Fen

Paul, thank you. Yes that is what I want but when I do that it only shows the value of the first IF statement. See attached Screenshots. 1 is code, 2 is result. Thanks. Fen

Hi, I have hit a road block and am hopeful someone can iron it out. Quite simple I think. I have this formula and it works great, =IF(D2=FALSE,"","Notify Before Initial Entry") What I am trying to do is add another criteria in the same cell as this formula to show the following...

Great, that worked well. Thank you. Have you ever used this code? The only issue now is I have a single table that has the same scenario where I need to group many rows into one with a common key but the code you send works with relational tables on a one to many situation. Is there a way I can...

Hi, I am trying to merge data from multiple rows into one row for each unique ID. Does anyone have an example that I can replicate on how to do this on a table, maybe a query or something like that. Attached img shows what I am trying to do. Thanks. Fen

Thank you. I don't think I am explaining clearly enough. If Primary Table has a PK (auto number) ie 1,2,3,4 etc. and my related table has a join to the Primary Table on PK (one to many) In the related table I want a field that takes the PK1 from Primary Table which is now in the related table...

Thanks. It is a two table database. The primary table is Tracts and only one tract per record ie TractID Acres 1 15 The second table is the owners of the tract so if I had three owners for the tract #1 TractID OwnerID Name 1 1.A Fen 1 1.B Mike 1...

Hi, Looking for a solution. Table has a relationship with master table. Joined on TractID primary table - auto number, TractID child table - number. This works as it should when adding a new record. What I am trying to do is create a new key for each new record added in the child table...

Hi, is there an easy way to do a conditional format on a report where the value is 1,2,3,or 4 from an option group. I want the 1=Yes, 2=No, 3=Maybe etc. Thanks. Fen

Thanks, so here is the scenairo. I have a Bill of Materials that has several hundred parts on it. In many cases there are duplicate parts in different places as the BOM is built from the CAD drawings. We want to consolidate the parts so if I need to order say 10 items of one thing but they are...