Search results

dont know why but i had a play with the code and it now works Dim cust As Variant Dim bvalue As Variant Dim stotal As Variant cust = Nz(DLookup("[Factory_Stock]", "tblTool", "[Tool_ID] =" & Forms![frmBookOut]!Tool_ID), 0) bvalue = Nz(DSum("[Book_Value]", "tblToolBooking", "[Tool_ID] =" &...

just finishing my database and cant get my head around this. i am using cascading combo boxes to filter tools and DLookup to calculate stock levels of the tool in the final combo box and depending on the results either writing the record or undoing it. here is the code: Dim cust As Variant...

still get the same result, was wondering if i should abandon the query and do the calculation in sql using DLookup's

tried the query without the HAVING clause and it still isnt working, '2' is returned every time now which happens to be the number of records in the Booking table and it still acts as if the stock level is less than 1.

i have a form for the user to book in tools, the list of tools are filtered through three cascading combo boxes. My problem is this, i am using a query to calculate individual tool stock levels. now if i book tools in and run the query separately it works ok but i need the query to run...

sorry about that , not sure if the Dlookup would return a null as its the first time ive tried one and not sure if syntax is correct tried to shrink the dbase but the smallest i can get it is 1.2mb and thats too big to post, if you PM me i can email it to you if you wish

The data type of ToolID is number and yes it is the bound column of the combo. Didnt think the combo could return a null if there wasnt one in the table.

i have a database that allows the user to book tools in or out of the stores. To keep a check on the bookings and to ensure that a tool isnt booked out when it isnt available i need to check the stock level of the tool being booked. To do this i have a query that calculates the current stock...

sorry if im sounding a bit thick but i thought a String was for characters and Integer was for numbers because the fields im trying to access are numeric

i tried it in BeforeUpdate but that made a popup box appear and ask for the value to be entered into the combobox. i dont know if i said this before but i am using cascading combo boxes to filter the data and the calculation that is performed is dependant on the results of the last ombo box...

not sure how to get my database to do what i need. i have a form that uses cascading combos to filter records before they are entered on a form. When the last combo box has had its value selected i need something like an AfterUpdate event to either trigger vba. i need a simple calculation...

dont know what i have done but i closed my database , copied it and deleted all the un needed rubbish as i was going to post a copy for you to lok at and lo and behold it is working fine. God only knows what was up with it.

ive done that, i check my records using a query . when i am entering new records, the date is set on the form as default = Now() and i have a date field on the form so i can see the date being recorded but it isnt the system date, its way out and with each enry it seems to be counting backwards

Hi guys i need some help. i have a simple enough database that books tools in and out from a store. my problem is the date field i am using (Book_Date) I have set its default value in its table to Now() and also in the form that i use to book in or out the Book_Now fields default on the form is...

i am writing a database (Access XP) that will allow users to book in or out a particular tool from the stores. Rather than have the user look through a combo box with an enormous list of tools i am using 3 cascading combo boxes to filter the results (Internal/External, ToolType and ToolName)...

The table is set up like this Tool_ID Tool_Name Quantity Most of the tools only have a quantity of 1 but a few have upto 8 i dont know if a checked in/out field would work with the way i have the table set up and that table is dependant on another which is dependant on another.

Firstly i apologise if ive put this in the wrong section but i didnt know where it should go i am writing a database that will allow users to book out tools that they will use for a job and then book back in once they have finished with them. i have a 'Quantity' field and i need to reduce this...

Just followed the tutorial in your link and it worked a treat, Cheers missinglinq

i have a form which will book in information and i need to make it 'idiot proof' so i decided to use combo boxes so the user can only select the data i let him. what i need to do is this. My first combo box would list values from a table, the second however would list values probably from a...

i am using a parameter query that produces a pivot chart and the user must enter a value (use name) before the chart is produced. My problem is that the user must know exactly how to spell the name for the query to work. So i was wondering is it possible to have a form with a combo box and...