Search results for query: *

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...

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);"...

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 =...

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...

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...

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

Hi, I'm struggling with a bit of code in my database at the moment. Unless it's a reference error I cannot see why it isn't working (tuesday morning blues otherwise hehe) I just cannot get the .additem to work. It isn't even an option to do on my combo box. Private Sub form_load() Set mc =...

What I am trying to do is use access to screenscrap from rumba to pick up data, manipulate it and send it back to rumba. I've looked all through the attachmate forum and access forum and just having no luck at trying to transpose code (and adjust it) from what I've read at how access can do...

Hi, To say I'm a little rusty with my VBA would be an understatment now. I've also been tasked with creating a Database that interacts with a Rumba screen and basically screenscrapes and also sends data to the screen. I have no clue on how to interact with the mainframe screen. I've tried a...

When running XP Pro (apologies for the dumb question, not worked with multiply CPUs before and couldnt find any info on the net elsewhere) if I have a board with a single opteron Dual core then add another on in later, will this require an OS reinstall or will windows automatically pick up the...

Basically my setup is as follows... AMD64 3000 Gigabyte G8KNS mobo 1.5gig DDR3200 Gforce6600 Now I've been given the option of pretty much getting a free opteron swap for my machine and I like the geekiness of having a dual processor system though I could pay a little and do a swap for a dual...

On a thinkpadT41... Running XPPro (bosses laptop basically). Tried running chkdsk from the command prompt which is saying there's an error but not fixing it. Tried just loading up explorer from DOS and task manager and neither will do it. Dos says program is too large to fit into memory where...

Ok, quite a newbie to OO coding, and coding in general but I have picked it up ok. Currently I am struggling with the fact I have some data being read in as a real value and has to be. I am requiring the last two digits of this data. I have basically two ways I know of and can do of obtaining...