Search results

Its not much and should be simple. It will used to store JSA numbers and related Hot work and working at Height permit numbers. The form Im trying to use us the JSAFORM

The JSA can have many Hotwork permits attached to it. On the job site the contractor carries the HW permit that needs to be associated to the JSA with out the need for a computer to link them for the inspector so he can look at the paper form for the JSA. So the easy way is to use the JSA number...

Thank I had put it on the sub form not the main form. It now just returns me a 0 value for all the HWnumbers

I get a compile error Method or data member not found. It hi lights .txtHWNumber =

I have a form JSA that contains a JSA number 1234. I have a sub form called Hot work. That a a perrant and child link feilds are the JSA Number. I have used the following in the query to return the value for the Hot Work number of 1234.1. HWnumber:[JSANumber]+0.1. and this works fine in my sub...

I have an excel sheet that is set out like a form that is emailed to our head office for a purchase request. I have built a data base in access to control our inventory at our end and it can produce a purchase request. I have a report that access can print that looks like the excel sheet but it...

June7 Thanks so much for your help took a while but I found it. Thanks heaps for pointing me in the right direction

If I hover over the word Domain it tell me Domain="Order Details" I need to change it to Domain="Job Details" but can not find how it decides what the domain is or where you can change this

After months of redesigning a Microsoft template to do what i wanted. With the help of to great people here I found out that the table design was no good and that i would continue to have many problems. So I have started from scratch.Please find attached my tables and relationships for any...

Thanks for that I have just spent the last hour looking for that information as I want to do it right I will post my table and relationships when I have them done for all your guys input. I’m so great full for your help

Ok after 3 months of working with this template only to find that it is flawed from the start I’m going to start from scratch and build my own . So thank you to you all and I look forward to hearing from you as I progress though this journey of learning

So if I fix the tables will all the code not work any more or do I need to try and right that as well. Sorry but at entry level and trying to learn fast

Thanks for that I will read them tonight. Thought the template would be good being in the Microsoft templates I will look at a table redesign. and see how I go.

Ok down the bottem in the active jobs sub form #126 double click that. Opens Jod 126 status new, In the parts Detail sub form part number 26-15 shows in the status field No Stock. Dubble click the no stock text, Message do you want to create purchase Request. Click Yes, Then I get the message no...

sorry its the status field where it says no stock

I think I have attached it. So to let you know. The data base is for our store we do not sell any parts they are just consumed by us. I have taken the Northwind data base and been changing it. So I have changed some table names. I have been working through the code and getting it working so...

The only thing that I can find is a Query that is call Inventory This is the SQL for that SELECT Parts.ID AS [Part ID], Parts.Description, Parts.Location, Parts.[Part Number], Nz([Quantity Purchased],0) AS [Qty Purchased], Nz([Quantity Sold],0) AS [Qty Sold], Nz([Quantity On Hold],0) AS [Qty On...

It is started here Private Sub Status_Name_DblClick(Cancel As Integer) Select Case Me![Status ID] Case NoStock_OrderItemStatus, None_OrderItemStatus Quantity_AfterUpdate Case OnOrder_OrderItemStatus Dim PurchaseOrderID As Long PurchaseOrderID = Nz(Me![Purchase...

I have a fault where it says that there is no supplier for a part. The code that I think is looking for this is SupplierID = Inventory.FindProudctSupplier(IT.PartID) I have looked in the inventory query and there is a Supplier ID. Could you please tell me this Is inventory where it is looking...

I have a sale Query that shows me the the date that the sale was made. I want to be able to filter this by year. I would like to add a EXP:field that will show the year of the sale based on the value in sale date field.