Recent content by LeeSmith

Thanks for the advice, helped a treat :)

I'm Agnostic. I don't really know what I believe in. The cleaner at work yesterday told me that God loves me, I just replied "Not today", to which she said "No, he loves you regardless of what you might have done". The whole mentality doesn't really appeal to me. The more religious people are...

I am working on a report in SSRS. I have created a calculated field using the IIF function. I now want to group my data by the values returned from the if statement and use them as parameters. The grouping seems to work well, but when I create the parameter I end up with more than one value the...

I put a space next to = and long date in the formatting, it comes up blank still as opposed to the overflow error

As a follow up to this, I have now discovered the root cause of the problem. When executing the VB code it searches for the date in mm/dd/yyyy format, where as I need it to search in dd/mm/yyyy format. My code currently looks like this and gives an overflow error on execution. Private Sub...

I've tried it and it's still coming up blank :S

Hi Apologies if this has been answered before, but I cant find it anywhere. I am currently trying to open a form and show records on a specific date. I have created a form which isn't bound to a table and has one field for the date which is being searched for and a button to open the form that...

Apologies for my n00bness, but what would be the easiet way to find them?

Hello I am currently trying to get a spreadsheet to import into an access table at the click of a button. The code I am currently using is below DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel8, "Details", "filepath\LearnerSupportCollegeProvision.xls", True, " " I have tried this...

I've set the properties to 2 decimal places, yet it still only gives me a whole number

That gave a % of 2500.00 when I tried with a simple one (four instances of 5)

Hi. Apologies if this question has been posted before, but I couldn't find it when I searched. I'm trying to populate 4 fields with percentage amounts when a button is pressed. It appears to work fine when done as a number, but when I change the format of the 4 result fields to percentage it...

I did this on a test copy of my db and it deleted lots of records:confused:

Ah, sorry, knew there might be a better way of doing it. What do I have to do to the properties to add the 2 zeros to existing data?

Hi there Im working on an update query to add 2 zeros to the front of a field where it is less than 8 digits long. I'm not sure how to go about this, can anyone help me out? Cheers