Search results

hmmm. i thought the only way to get a date from a calculation was by using date add. how do i write the calculation. ie. 01/01/2013 + 3 months would be? thanks for your insite so far. very useful

there is no definition of what define duration of the course. a course doent really have a duration but an expiry date. ie if a client has not used all or the course item by 'x' date then the course has expired anyway. i am looking for a way to say not this cannot be used as a course item as...

have you selected continuous form?

i need a method to store an expiry date. i have a column prepared in my table but i do not know how to reach the desired result. the date will always be different depending on certain criteria the course length. some courses we have are valid for a month. some for 6 months. some for a year...

just another note. do you have an audit that logs what each user has done?

In all honesty i dont know how to extract the logged in user info either. you need someway to tell access who is logged in, who the user is. i use a opening screen(password screen) where the user has an individual password and that tells access who that person is. my opinion is you should do...

that should be quite simple. on your ribbon click report design. i find it much easier doing it this way then once a blank report has opened. go into properties for the report. click data tab and then record source. here you have your query builder. click the table(s) that you need for the...

youve just made it muddier. i think i know what you mean. so you have all the data inplace(what collection is assigned to what driver etc) and you just need to display it. that should be easy enough. do you want a report for each driver or do you want a continuous report?

my understanding of pie charts is that pie charts are not meant for this kind of data. area 1, 100 area 2, 150 area 3, 175 not multiple values. you might aswell number them as area 1-xxx and have the value beside them. you would be better off with a bar graph or a pie chart for each area.

do you have many fields in your record source for each time frame the products code has taken to design.

im sorry to say it and i know that you wont like it. you need to learn vba. i was on here virtually every day with problems that i had encountered. most of the replies came back as vba. unless it was a simple copy and pastei would ignore it and ask for macro's etc. now i have no macros...

you could even do it by password. i presume the login screen remain open but invisible after they have logged in. the criteria for the combo box could be their password. you could put an iif expression in excluding your password from the criteria.

i have this on my database. i have a login screen. on that there are text boxes that dlookup via the password. the txt boxes contain name and importance. importance what i have dictated each user can have. i have the highest importance and my receptionist has the lowest. you can do it either way...

first. what is go ahead. what will they be editing(current record)? do you want to be able to navigate to previous record or next record or last record etc. we could do with more information

you could have a button on the subform that does the same thing as the main form. set your tab controls to forcus that and voila.

can you give a little more info and how it doesnt agree. ie error code etc.

this is soem code that i use in a combo box to sort my date. im sorting a date field so it may be a little easier. Private Sub comboSortOrder_AfterUpdate() If Me.comboSortOrder = "Ascending" Then Me.OrderBy = "DiaryDate ASC" Else Me.OrderBy = "DiaryDate DESC" End If End Sub i have this on a...

for me it will all depend on what information you have. if all of the locations will be in the same town area etc you could arrange them by postcode. you could assign a value of distance from the depot and then arrange them by this. i think you are after a logistics program. i have a friend...

if you are creating a new record when you input the new price then you can do it in your tbl. just set default to Date(). or if you would like to do it in a form ie txtDateInput then you can also change the default to date() in the properties. you coould even use Now() which would give the exact...

thanks, thats what i thought. ive managed to send an email through some vba i found on here so i think ill forget the table linking thing. might be good for future reference as i would like to store my emails and i think in a database would be the best thing.