Search results

Thanks spikepl Looking at it now, but it still makes no sense. Will keep try though

I have form which is based on table (I know I know!!!) However, I have created several buttons to do the work manually. I have a save button of which this code is part of If Me.Dirty = True Then If IsNull(ContactName) Or ContactName = "" And IsNull(CompanyName) Or CompanyName = "" Then...

Hmmm, I thought that would be the case. I have dne word merges before, there not the best of things though.

Hi Paul Thanks for that. Sounds like the way forward. Not interested in saving the information though. What concerns me however is getting the report to print all 6 pages. I just can't seem to get my head round how to format the report for all the pages.

Any advice here would be great.... I have DB which will allow engineers to print a copy of the H & S Policy and Method Statement when they go on site. Basically, the only changeable values on the report are company name, site details and engineer name. These all go on the first page. The other...

Ah right. I'll have a play in the morning I think. Too much heat here today :)

Bob Thanks for that. I knew it must have included some VBA. :)

Hi Having a mental block here :) I have an unbound form with two Unbound Combo Boxes. The first is for Customers and the Second is for Sites. Customers can multiple sites) The second combo box is synch'd with the first so only the sites relating to that customer are displayed in the drop...

Dave That works well, but as you and david have both mentioned, it is prone to error especially when people 'forget' to clock or as in the extreme case mentioned by David, smokes several times and then travels etc. But it has given me more food for thought. Thanks for you very welcome help :)

Yes, He clocks in with a 1 and clocks out for lunch with a 3, clocks back in for the afternoon with a 1 and clocks out to go home with a 2. Im not going to be using this as the final table, this table is how it comes from the clocks to the sql table.

Gemma Unfortunatly, the terminals just record consecutive time stamps.

For this particular customer there is a matching key yes. Here is the sample data. Function Numbers are 1 = Clock IN 2 = Clock OUT 3 = Lunch 4 = Travel 5 = Medical 6 = Smoking

Thats the problem. The software polls the data from the Clock Terminal into a SQL table, every clock transaction is entered into a new record. I cant change that. However, having found the code above, it puts the records into pair and like I say it works well for a limited number of records...

Hi all I have been making a T & A Database with data coming direct from the time clocks. Trouble is it puts each clockin on a seperate row. I have been using the code I found on this forum posted by Jon K Assuming DATE, TIME are date/time fields in table tblPunchCard, try these two queries...

Hmmm. I'll have a rethink and see what I can do Thanks for the advice. Your right, it's going to be hard work

On the issue of people forgetting to clock in, the company in question are saying that they would have to manually input the missing data. So basically if there isn't 4 entries then it should be ignored. So for the interim, i guess we can assume that all clockings are there and none are...

Mmmm thanks for that David The softweare that polls the data pouts it in that structure in the datatbase, we cannot change this. Is there an easy way to change the structure in Access? I guess by way of query/tables etc

Hi all Been away from Access for a number of years so bear with me:) I have been tasked with creating a simple Access T&A system. The company use time clocks whereby the data is polled automatically to a SQL database. I can connect to the tables no problem and link to the data etc. Each...

Have a look at the sample database I have created for you. Its very basic in design and there are much much better ways of doing it, but at least it shows the basic queries you need. The totals form will currently show all dates, not just one specific date so you will need to think about that...

David is right in what he says. You really only need one table and one form. The form will allow you to enter EITHER income or expenditure transactions. The date & Time will be automatically recorded in the table in a field called transDateTime. Table will be along the lines of the follwing...