Recent content by forman

Thanks Thanks for that, going to play with it now Alan

Open PDF Hi Kiwiman Can you clarify where the two pieces of code sholud be, I'm assuming that the first code is attached to the 'On Click' of the button, but I'm stuck on the second piece of code. Thanks Alan

Hi I'm trying to finish a query that calculates the time worked in the AM and PM, adds them together, then takes that away from the standard working day. I've done everything else, but when I take the hours worked away from the standard day it always ends up with a positive number, regardless...

Thanks Chris Wow, who would have thought it would be so simple, I've seen the light. I worked for ages to get that code correct, and didn't need it anyway. Thanks for your time & help Alan

Loop, If..Then, or ????? Hi Barclays give me the feature of downloading my statements in csv format. There are several fields, but the important being 'Amount'. I've imported into a table and added a 'debit' and 'Credit' field. I've created a form, and using a button at the end of every row...

Hi I'm trying to run a bit of code changing each record, starting at the begining of my database and stopping at the end. I've looked at a For...Next, but then it doesn't start at the begining, and will only step to the TO number. Any ideas what I need please. Thanks Alan

Thanks Thanks Paul Super-fast and spot on, it's working Alan

Hi all Barclays give me the feature of downloading my statements in csv format. There are several fields, but the important being 'Amount'. I've imported into a table and added a 'debit' and 'Credit' field. So far so good When Barclay's data comes down debits are shown with a - (negative)...

Basically I want to have a Diary sheet. I want to end up with dates down the left side and car registration numbers across the top and the values in the grid being the times when the cars are booked. Thanks

I've got a database that records booking of Cars. I now need to show a 'Diary' I was thinking [Car_Reg_No] across the columns, [Hire_Date] on the rows and the [Time_Of_Hire] in the value area. Problem : Can't get the value [Time_Of_Hire] in crosstab. Any thoughts......Anyone Thanks

I've created a box on a form that opens another form (with one field 'Notes') 'on click'. I now need this box to change colour if there is any data in the notes field, so that the user can see if there are any notes to read. What code do I need, and where do I put it. Thanks for your time.

Been working on this for a few hours now, can't see the light. Two tables, one with a list of British Postcodes, one with a list of companies. Easy so far. Companies can cover several postcodes. and Postcodes can have several Companies. I need to relate them so when a postcode is chosen...