Search results

Then you can calculate the totals. Normally, id advise calculating totals on the fly and not storing them but in this case, I'd store them because of the likelihood of employees getting payrises which would screw up your old pay records if they were always calculated on the fly.

Hi there, keep the payrate fields in the employee table. Then create a table for work rate levels. So, on your emplyee worklog table you can store the hours worked and the level they should be paid at.

Well I suppose the question is, are you ok with creating forms? If so, then you'll be ok at creating reports. They work pretty much the same way, only you have to be careful of running over the edges of the available paper width on the right hand side. The other thing to bear in mind is on a...

Good effort! nearly there! But it does go in the design of the report rather than being a calculated field on the table/query. Many thanks, Rich

You need to use an unbound control combined with the nz function. So =nz ([field1]) & " " & nz ([field2]) etc. Then set visible=false on the original field1/field2 etc. I'm tapping this out on my phone so apologies for any errors but hope this helps. Many thanks, Rich

I agree with SHADOW. My recommendation (with my Microsoft certified systems engineer hat on) would be a remote desktop server either providing a full remote desktop experience or just the databases as remoteapps. It'll be easiest to deploy and manage! If you're worried about costs, then...

If this was an outlook/ exchange server environment, id setup distribution groups in Outlook or on the server. Then you only need to send to one address and let the server worry about it.

Hi there, A bit of a strange one this... A client of mine has their mailboxes hosted up in a multi-tenanted Exchange 2007 environment. Although they trust the supplier to be backing up regularly, they still want something tangible that they can back up locally onto their tape drive. The...

Cool. Good work!

OK, how about copying the contents into a text file in notepad and importing them? Use a semi colon as a seperator. Then once they're in a table, you can copy and paste the table's structure only. Then set the email address field to No Duplicates. Finally, you can then copy all the records...

Hi there. Add a new table with two fields. The first field will be an ID Autonumber, Primary Key field. The second field will then contain the item you want in your combo box. For example: CountyID and CountyName or whatever you want. Next up, Add a field to your original table called...

hehehe good point! I got confused when I looked in the welcome thread and saw others that said hi from the uk and assumed it was a US site (despite the glaringly obvious .co.uk in the domain name!) Anyway, in that case, Hi from Essex!

I found it. It's an Access 2007/2010 thing. If you go into database options for current database, change the "Document Window Options" from Tabbed Documents to Overlapping Windows. It's been bugging me for a while! Cheers, Rich

ah I'm with you. thanks for taking the time to explain.

fair enough, every day's a school day! how does it give you more flexibility? thx

Set the record source on the modal form to be the same table as the main form. Then set the filteronopen property to yes, and filter the form to match the same ID as your main form. ie something like: filter=[mainform].[yourID] filter on=true hope this makes sense! Rich

Hi there, When you open multiple forms and the forms are maximised (ie not popup etc), a row of "navigation" tabs appears along the top, immediately above the form header. Now, somewhat annoyingly, and despite the fact that I use various command buttons to force users through my database as...

Hi there, I've been a lurker on the forum for a while, unashamedly using it for bits of VBA code and I figured it was time to join up and maybe put something back into this awesome community! Anyway, I've been using Access since version 2, and do quite a lot of development for customers and...