Search results

thank you for your help thats great

yes the sizes go from 0.4mm all the way to 50mm

hi thanks for your reply. sorry i am not too confident with access i have picked this up from somebody who did it before and trying to understand. can you advise me that an idiot could understand, if you need me to post the form or table or query name then i will do so, as i dont understand the...

hi guys i have a form with a combo box. The combo box information comes from a query, in the query i have sorted the information in the query to ascending which works fine (the information is a list of drill sizes for example 0.5mm 0.6mm etc up to very large sizes). the issue is when i want to...

hi again ive been trying to do waht you said in the privious message however i have been having the following error message Private Sub Date_Of_Next_Calibration_AfterUpdate() dateadd ([termid], [termtype], [Date_of_last_calibration]) End Sub i have placed the date add function in the...

hi sorry i tried what you said but i dont understand how i can get this to work for me. my problem is that the user selects a term and this is whats listed in the combo box eg 6 months 1 year 2 years etc i cant get the third box to add the first date to the term and then udate. sorr for being...

Hi guys Ive got a form with a text box that has a date field that the user has to pick a date. I also have a combo box on the same form with different lengths of time in there the user also chooses eg 6 months 1 year 2 years etc. What I want to happen is the third date field text box To look at...

hi privateer within the form the user has to populate there are menus with 5 combo boxes to select from. what i was trying to achieve if for instance the user only needs to select from 3 of the combo boxes i dont want there to be a blank in the other two when i run the report. i created a...

hi all i have created a query based on a form i have created. however the form will not have data in all the fileds how do i create a report from that query but exclude the fileds that have no data in them please help!! thanks

hi thanks for your reply exactly how or where do i do this in the query????

hi guys can anyone explain to me how i can get a query with specific information including a date field to start april the 1st as week 1 and month 1 please bear in mind i am new to access and need it in simple terms thanks simon

hi guys please help me!! i am trying to extarct information from 2 different queries. basically thje first query gives me the number of quotes per month from a class customers. the second query gives me the total quotes per month across the board. what i need to find out is how many quotes as...

what happens the user types a quote number in a combo box to search for the quote when this is entered the details of that quote is displayed eg drawing number customer name etc then in the subform the quote details are displayed for that quote number eg the date of the enquiry no of parts...

sorry what i have done i have created a makro called last record and dropped this in the on open section of the properties for that form so what your saying is that on the query that this form is based on i need to put order by last record in there???

hi guys i have a form called quote number which stores the information about the quote then i have a subfrom for the details of that quote. i have set the subform to show the last record entered. this has worked fine however i have now come across the fact that if i enter a new set of figures...

hi guys i am running a database at the moment. i have a select form which allows me to select a specific piece of data which highlights when i select it. however if i want to select more than one item of data which is usually the case when the report is printed out the is no order in which...

hi thank you im not sure what i do with the code do i drop this into the SQL view of the query?? another thing my field name is Quoted Date so i change that to suit????

hi guys i have a query that sorts date information into weeks. i use the function format([date], "ww yyyy") for doing this my question is how can i sort the date information so April starts as week 1 and month 1 thanks

hi guys i have a query which puts a date field in order i use format([date], "ww mm"] this in my query to give me the date in order by weekthis works but now ive got week 10 in the query this goes to the front of the list which is correct because it recognizes the 1 in the ten to come first...

thanks guys i just have to adapt this to suit my needs thanks again