Search results

Problem solved (due to typo!) :o :o :o :o :o :o :o

Thanks for the prompt reply! I'm not typing the '. It was just ment to show the begining and end of what I was typing. Yes there is a record in the table [Training] where StaffPIN = 12177 Yes, it's defined as a long integer. Sorry, I should have pre-empted those questions in my original...

SELECT Training.ID, Training.StaffPIN, Training.Module, Training.DatePassed, Training.DateExp, Training.Comments FROM TrainingModules INNER JOIN Training ON TrainingModules.[TrngModule] = Training.[Module] WHERE (((Training.StaffPIN)=[Forms]![TrainingFrm]![StaffPIN])); Does anyone know why this...

It's bad practice to store calculated data in a table, but I can see why you might want to when allocating unique reference numbers to complaints. So, you want to know what the last reference number was so you can calculate what the next should be? As Rabbie said, the 'last' record is a bit of...

This is not that unusual, check out BMEzine's web site, the extreme page. I can't post the link as I can't remember it off the top of my head, and there's no way I'm looking it up at work. IT IS NOT SAFE FOR WORK! Or anyone easily offended. In fact, best stay away... How did I find it? Well...

I think you're going to have to store the new value in a variable that keeps it's value between events, and possibly between shutting the computer down and starting it up the next day? Not sure, but would the only way to do this be to store it in a table? You could get the onupdate event to...

What's happening in the background between you entering a new value and it displaying the old value? Is it being entered in to a table or are you using a query of some sort? Is nothing happening, do you want it to just display it and then work with it later?

What format are your dates in, UK or US? I don't know if it's the same with SQL, but VBA doesn't like UK format dates where the day value is less than 12. It tries to convert it to US format but can't decide which is the day value and which is the month. I don't know much about SQL, so I may...

I’m sorry, but this article is about something called “normalization” :confused: I meant a sticky on “normalisation” :D

It might be an idea to have a noob forum where newbies like me don't feel like an idiot for asking simple questions. It could have stickies for the most common questions. The top sticky would have to be froum rules: search before you ask, what info should be in question etc... A sticky for...

Wouldn't you need to use Nz() on each field rather than using it on the sum of them? If only one of the above fields is null, wouldn't the whole expression work out to be 0 or #Error#?

Thanks for the post, but I may have 50+ dates and about 12 staff. Having the dates as columns and the staff as rows would cause even more headaches. I can't believe Access doesn't support crosstab reports with dynamic columns. I'd have thought it was such a common requirement.

Where are you putting the answer to this calculation? You've posted in the 'tables' forum. If you want to put the result of this equation in to a table, you shouldn't/can't. Tables shouldn't/can't store calculated data. You need to perform this calculation each time you want to display the...

If anyone's still interested I found a work around by using a PivotTable as a sub form. It's quite messy, and doesn't give you any format abilities but it works.

Sorry, I was talking crap there. You can't use a crosstab as a subform. How are you getting on? I've done quite a bit more to mine.

No, the above work around doesn't work. :( I get an error message saying i can't use a query with an unfixed number of columns as a sub report. Is it possible to export the table to a pre-formatted spread sheet in excel? I'll workout for my self how to do it, I just want to know what route to...

I've found an interesting work around: http://www.dbforums.com/showthread.php?t=1605962&page=4 It uses the crosstab query as a subreport. It's not ideal as I cant do the formatting I wanted to, but it will display new columns.

Solved it if anyone's interested (quite a common problem by all accounts). In my example it was because VBA will only work with dates in the USA format. Regardless of system settings. I had to re-format the date from UK to USA format (mm/dd/yyyy) at the beginning of the function. When the...

I'm replying to the pm here as it wouldn't let me send such a long pm. In my db it's the supervisor that enters the data for everyone, so access to each other's data isn't an issue. 1.) My initial thoughts would be to crate a table of staff ID's and passwords. 2.) Create 2 forms. One's...

Managed to get it working. Thanks. The problem I've now got is the number of report columns doesn't change if the number of crosstab columns change. The info I've seen on how to create a report with a variable number of columns is very complicated. The examples I've found don't have a similar...