Search results

Ive looked at the file goppo but i think you mis-understand what im trying to do, thanks for trying anyway

Ok thanks for your replies ghudson & goppo. goppo i cant open your file, im using MS accsess 97 so that could be why if youve created it in a newer version. Would you be able to save it in 97 format & upload it?. ghudson the fields i want to do this code on are already in a subform (the fields...

Ok ive searched these forums & the internet and think what im tyring to do could be impossible on a continuoes form, :mad: could anyone confirm this? or does anyone know a way around it? if this is not possible could i display a message if both drop down fields are filled in on the continuoes...

all list boxes are disabled/hidden instead of just 1 on current record Thank you Summerwind & ghudson it works what you both said, but i have 2 very similar problems i would like to fix: 1)When i select field1 for example all of the field2 list boxes are disabled/invisible but i only want...

Thanks for your reply Summerwind, that Sounds like a good idea, but i really dont know how to do that, (the form id like to do this on allows entry of more that one record) anyone help? ive tried the below code on the: "after update" & "on change" of the field but it doesnt seem to do anything...

Ok thanks for that iago18, sorry about late reply, ive been away, yes sounds like form would be better, im trying what you suggested now, will get back to you to let you know how it goes.

hello I have 2 drop down list boxes in a form that both contain numbers & would like to prevent the user from selecting them both together, ie the user should only be allowed to select one of the drop down llists & not the other, if they do i would like a message to be displayed if both are...

Ok fair enough, cheers

yeah thats what i mean, would like horizontal & vertical lines dividing each record & field headings, is there not an easier way of doing it other than manually inserting lines?

Ruler lines on report can you get automatic ruler lines to display on a report after each record is displayed?

Yeah sorry i did ask for quite a lot, thanks very much iago18 for taking the time to explain all of that! & in steps, might take me a while but i will give this a good go and let you know how i get on. I guess it cant be created directly from a query first and has to be created in a form instead?.

Hi, i have a query which looks at a table named "attendance" the query includes the fields: "employee number", "absent code" (a 3 letter code), "absent reason" (list of different reasons) "shiftdate" (weekly shift dates in format: DD/MM/YYYY). If possible i would like to be able to promt the...

Ok ive got something else that i would like to fix, i have another field in the same query named "department" with the 2 names "dirrect" or "indirect" for each record which i would like to be ordered by "direct" first at top, however if i try to order the "department" field list then the...

Ok thanks neileg & richary. Richary i used your code (but took out the +1000) as shown below and it seems to work, i guessed i probably dont need the +1000 bit of the code because employee number goes up to 1,500 and agency number is set to start at 4000 onwards?. MySortedField ...

Thanks richary been trying to get your way to work, as i have the 2 field names: "employee number" & "agency numbe" in 2 different tables i think i need to include which table it needs to look at in the code but not sure how to do this?. ive tried something like: (but it doesnt work)...

i have a query which looks at 2 fields: "employee number" & "agency number", i would like the query to list the employee numbers in order first (1,2,3...) then the agency numbers in order (100, 101, 102...). ive changed the ascending/ descending order for them both but doesnt help. Its mainly...

Thanks very much Colinessex & Neileg for your great explanations, couldnt have done this without your help, feel more happy now i understand what the code is actually doing, ive no doubt what ive learnt here will come in handy in the very near future.

Many thanks for your quick reply Neilreg!, that seems to be working great, if possible would you or anyone care to tell me a little about how it works so that i can understand better for another time?, although ive got the table "employee master" displayed in the query how does it know from this...

Ok thanks Collin, guess ill have to remove the labels (captions) directly on the buttons, bit of a shame but i know now for another time.

Hi, anyone know if it possibe to create a field within a query that looks at a 3 letter number code in a field of a table named "employee master" to see if the last number is an "I" or not. So for example a number code in a field named "Department" is "KTI". I would like to display "indirect" in...