Search results

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

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

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

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

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

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

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

i have a query that returns data per week number. To obtain the week number i used this : Format([Date],"ww"). This gives me the week numbers great but when the query is sorted the week numbers are not sorted numerically, ie i get this 1 10 11 12 2 3 4 5 6 7 8 9 is there a way to sort my data...

i have a database that uses queries to create pivot charts to display the data. The query asks the user to first enter a month and a year as a filter and then displays the chart. My problem is that because it asks the user for the month and year it doesnt display the data labels on the chart...

is it possible to send the results of a query in access 2002 to excel and for excel to create a chart from the data automatically instead of just creating a data table in excel and my having to manually create the chart

Ive created a query that asks the user to enter data (month and year) before it can be processed. This is causing a problem for me as i need to produce a chart from this data and access isnt letting me (access doesnt like me asking the user to enter data). So i thought if the data could be...

i need the results from a query to be displayed in graphical form ie bar chart or pie chart. is this possible in access and if so how?

is it possible once a record has been entered, to lock it so that it can not be changed by just anyone but that the administrator could change it using a password?

i have a date variable that i wish to be automatically set to the system date for each new record. is this possible and if so how. Many thanks.

i am wanting to find some way of turning off the menus and toolbars in a startup macro and is it possible to turn off the warning messages that appear when appending or deleting rows in a table. many thanks