Recent content by carpetbelly

Thankyou both for the ideas... Much appreciated. The joys of being rusty with my SQL is embaressing =)

Just using the standard query builder in access the SQL I get is the following SELECT tblData.OriginatorName, tblData.DateIncidentRaised, tblData.IssueTitle, tblData.System, tblData.IncidentStatus FROM tblData WHERE (((tblData.IncidentStatus)<>"Closed")); Now this just doesn't return any data...

Yeah, I've tried that and all I get is a prompt up to enter the parameter value for 'Name' etc. I've also tried doing it with double and single quotes to show it's outside of the sql string without any luck. It's quite baffling.

I know this is now working but I'd like to make my code a bit nicer. Is there anyway I could use variables declared in the code rather than the full path to the value of the variable in the SQL code. So for example rather than using forms!frmStaffInput!txtStaffID I could use dim StaffID...

Yep, drink and coding prob not the best idea... lol

I'm having one last bit of problems with my SQL (which should once sorted finish my database w00hoo!) strSQLStaff = "INSERT INTO tblStaff([StaffName], [TeamID], [StaffPayroll]) " & _ "VALUES (forms!frmStaffInput!txtName,forms!frmStaffInput!cmbTeam,forms!frmStaffInput!txtPayroll);"...

Some other good suggestions there as well which are good to know going forward. Thanks people :D

Thanks for that Ed. Worked perfectly.

I keep getting a Run-Time error '424' on the following bit of code. Weird thing is I am positive I had it working pre xmas. I guess I didn't and I'm just still drunk from xmas lol Private Sub Form_Load() Dim adminWin As String Dim adminTab As String Dim Str As String adminWin =...

CaptainD, yep, I was able to call my function within the IIF which got it working. Spot on suggestion you've given there though, bang on the same as the code I ended up with. Which makes me happy as I know I got something right at least ;)

I was doing this in access... Hence why I couldnt use the CASE statement.

Now I feel like a wally just realising you cannot use the CASE statement from what I've read and now it works... Doh!

I'm trying to create a query. I have a field called 'HalfDay' that's a Yes/No. I also have another field that works out how many working days between dates there are. What I am trying to do is when the Yes/No field is set to true how I can default the working day field to 0.5. Below is the SQL...

awesome, worked first time. Thanks SeeThru and made my code a lot neater than the mess I was looking at :D

well, they're text boxes but other than that I think you might be right and I could just be over complicating things which I wouldnt put past me.