Search results

Thanks for your help i will have a play about and see how i get on

Hi sorry to be pain - can anyone help me with this one please appreciate your help

hi yes this is correct please it copies the content of M3 (this is calculating based on a fomula) and copies it to column P is fine and keep a history - so copies to next available cell in column P - can start at Cell P1 many Thanks

Hi I have a formula constantly calculating in Cell M3 I would like to make a record of this every 30 seconds in column P Thanks

Hi again i have selected view code, selected worksheet from the drop down but what event do i need from the right drop down. thanks scott

Hi thanks the help one of the cells in the row is a date the acct closed and i just wanted the account closed sheet to be sorted by date - if that makes sense? thanks again

Hi if you can help i would be really grateful I have worksheet with 6 columns for each row of information. If I type say the number 3 in the status column, then the row of information should transfer to a separate 'closed account' worksheet, and automatically filter by date. There are formulas...

Hi I was wondering if anyone could help. I am trying to write a formula and not sure whether the IF function is the correct one. I would like the following: If say cell A1 has a range of -10 to 10 then Cell A2 will return a 0, if it is between 10 and 15 retrun a 1 and if over 15 then return...

Hi I would like some help with the Vlookup function and I will try to explain as best I can. I have sheet that lists company names in one column and then costs in another column. e.g company 1 - 1200 company 2 - 1300 company 1 - 1000 company 4 - 300 company 1 - 600 etc On another summary...

Hi I would like to specify more than one criteria of an if statement. e.g, if = ? then ? but i would like to add more critreria as i have more than one selection in my combo box. Thanks in advance

me.refresh on the form using the on activate event. that little bit of code took me all day to work out - sometimes things seem so hard and it is as simple as that. i was opening form, moving focus, requerying, closing forms etc etc. thanks

Thanks that works for a control on the main form as i refrsh the form and the new employee shows in the combox box. but i can not get the subform to refresh. also if the Purchase order form is not open when the employee form closes it causes an error. e.g. someone might want to see a list of...

Hi I double click a combo box which takes me to a new form. e.g. a purchase order form does not have an employee so they need to be added. When the employee form is closed i would like to refresh to combo box so the new employee appears in the combo box. Please help Thank you

Hi I have recently started using queries to base my forms on. Even for basic forms i am using the query as the record source. If for example i have a standard query with no criteria e.g. a employee form. How would i then use that query to create a report that filters for example a list of...

Thanks for that clarification - as always after asking people on here - it all seems clear. Onwards to the next step in my access development - this is fun! All the best

Hi I am wondering why you would use a query as the record source in s form and not a table? could someone just clarify this for me - or point to where i could read up on this to uderstand it better. Thanks Another quick one - when for eg. i have two table linked - do i select the foreign...

Thanks Pat Thanks for that - I am going to have RT, OT & DT fields and then leave the ones empty that are not used. This way i only see the employee name once on any timesheet. All the timesheets are set up for a work description by company per day. Hopefully this will work. Scott

Yes - sorry i agree - i am just stuck on table structure/forms - i have not even got to the reports yet. thanks again for your help - as i am really stuck here scott

Hi ScottGem I was thinking that it violates normalization rules, but if I only have an hours field with an hours type this will mean an employee name can be repeated twice so does this violate normalization rules as well? How would you deal with the hour classification? - it makes a difference...

db attached I have attached the db - if you would review it for me?? Please! I was thinking more of fields named RT, OT, DT and set as number and leave blank the OT or DT if no hours worked? At least that way i will only see the employee name once. I mean to extend the timesheet from a day...