Search results for query: *

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.

I've got a form with a combo box on it and some text boxes. The combo box is prepopulated with a list in the 'Row Source' property with the following SQL SELECT [qryStaffEnt].[StaffName] FROM qryStaffEnt; So basically just trying to populate it with a bunch of staffnames. The 3 other text...

Unfortunately I have had the exact same issue with an old gigabyte board I used to have. One of the slots had fried somehow and the whole board had to be replaced. Luckily for me, I wanted to upgrade at the time anyway.

Well, it would be handier to store them but not strictly necessary. I suppose I could just store it as a hyperlink and store the documents somewhere else, but there's a chance I might have to send this on where the documents would need to be stored. I personally would avoid internal storing and...

I have a form that's linked to a table. I'd like to add in a section onto the form where I can save word documents (displayed as icons) which are embedded into the table in the appropriate record. I've tried searching around to no avail on how I would achieve this. Anyone got any ideas? Thanks :D

Ahhh typical, serves me right for using 2002 at home and in my new job being given 2000 =P