Search results

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...

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...

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.

Can some one p-lease tell me where I can find this as I need to change Customer Extended to Machine Extended. strSQL='SELECT*FROM [Customer Extended]WHERE [ID]=2'

I have a form called Jobs on that form I have a sub form Parts. As i enter part numbers each one returns a status for that part. ie: in stock, no stock or on order. What I want to do is look at all the parts and return a result if they are all in stock so that I can then use that to change the...

Could some one please explain to me what this means. Dim Status As CustomerStatusEnum I get a user-defined type not defined when I open my form [Sub SetFormState(Optional fChangeFocus As Boolean = True) If fChangeFocus Then Me.Machine_ID.SetFocus Dim Status As CustomerStatusEnum...

When I set the lay out of a form on my laptop it all looks good when I put it on a larger screen I get gaps between fields. I see that some of the fields have a dotted box around them. This makes them all move to with each other when you move one. I think that this is causing my problem as they...

I am working with the northwind database and adding to it for my need. I have a parts detail form that when opens all the fields are empty. It is set to open to a new record. There is a combo box in the header that allow you to chose a part number and then all the information is displaced in the...

I am not sure where to ask this question. I have a table called parts a field in that table called part number, this is a text field The part number from my suppliers can be any format ie; 245-678-00, 8W-957, 89 07 68, 568.897.RB When some one enters a new part if they do not get the - . or...

Im trying to prevent duplicate entry when entering data into a field in a form. I want to know as soon as I enter the data that it is a duplicate. I have found that I can do it by using a macro Refresh in the after update The problem I now have is the standard response dialog boxes. I am...

I have a form that is used to add new parts to my products table. The fields are Part number Description Location Supplier Cost When I open the form it goes to a new record that I can add a new part. all good The problem is that I can type a duplicate part number that is already in my products...

Im using northwind to create a inventory database. I have found that when i receive in goods it dose not change the purchase order status to closed. Looking at the code I can see that I have met all the criteria but it does not change the status to closed. I can upload what I have but it does...

I have made a form and are able to open the query with a drop down box selection. It only works if I put in all the correct information but I want to use the * wild card to bring in more information as below. Field contains values FS1A12 FS1A11 FS2A13 FS2A15 BA1A5 and so on. I have created a...