Search results

There will be a relationship, but since actions are coming in via a seperate unrelated SQL database I need to perform this task manually. So the only reliable connection will be the name. What I need is a way to do an initial (and subsequent periodic) update on the actions table based on the...

Hi all, I have tblEmployees as an employee list. tblActions stores records of employee actions (many records for each employee). In order to link the tables i need to enter the EmployeeID from tblEmployees into tblActions based on the "name" field. The name is unreliable but it will fill in 95%...

updated for clarity

I need to relate one database (db1) with names only: Name: Smith, John to another database (db2) with actual employee records: empID Lastname Firstname 1234 Smith John Of course the names do not always match, database2 may look like this: 1234...

Ohh, i never knew you could build queries for that! but I see it now. Ah thank you, I had a requery on update for other purposes. I'll find a way around that. Thanks for your help.

Actually, this brings up another question i had but I may as well post it here since it's somewhat similar. In a seperate form I have a listbox with all the employee names. Typing in this box searches for the name but only the first letter - subsequent keyboard input will jump to the first...

Hi, I have a small table with 2 columns (and a Pkey) both are lookups from other tables. The purpose is for matching up an employee ID with a name from 2 different systems, so the user might need to set a value in one or the other lookup field. The first lookup "ApplicableAgent" looks like...

works like a charm, tyvm

Hi, I am trying to reuse some code that was taken from an Excel external connection. I think it is useable but I am getting errors trying to run it. The error is "Syntax error (missing operator) in 'aTable.SkillTargetID=bTable.SkillTargetID LEFT JOIN (select SkillTargetID, sum(Duration) as...

Datediff is more or less what i had been trying, but just by math. If i search for letters within 6 months but not Between hireDate and hiredate+90, then it works except that if the employee is STILL in probation, it returns no results. Still stumped by this..

Hey, I'm not sure this is an Access specific problem but more programatical than anything. But maybe someone here has an idea to help me out. I am creating an employee database, a large part of which is "letters" meaning employees get a warning letter if they are late etc. If they need a...

Thaaats what i was looking for! i had CurrentDb.Execute "UPDATE agent_letters SET warningLevel = 0 WHERE ID = Me.ReportID" Thanks so much for that! And thanks to AccessMSSQL, i am going to use your code to update my tables in other ways, too.

Hey, in that example, I guess since the recordset is the table, it updated every record in the table. Then again if i switch the recordset to the query, presumably it would update all the records in the query. Is there any way to get it to update just the one query result? You know what i mean...

Thanks for the advice. To be clear, I don't want to update the 5 or 10 records, i want to only update one at a time. So each iteration of the report has it's own button. I've tried your code for example: CurrentDb.Execute "UPDATE agent_letters SET warningLevel = 0 WHERE ID = 2434" ID is my...

Hello, I have a report (rptLettersList) based upon a query (qryLettersIssued) that uses 2 tables to gather data. The report prints out 5 or 10 results, and for each result I need an option to edit a relevant field in one of the tables (agent_letters). This is what i currently have for the...

Very nice, this is what i ended up with: Dim db As dao.Database, rs As dao.Recordset, qdf As dao.QueryDef Dim strSQL As String Dim i As Integer Set db = CurrentDb() Set qdf = db.QueryDefs("6-abandonment") qdf.Parameters(0) = Forms!frmlookup!AName.Value i = 0 Set rs = qdf.OpenRecordset If...

Hi all, I have a query that returns various dates, in my case it's the dates that an employee was absent. What I need to do is take the highest date, and see if any days in a row are present in the query. Lets say the query returns this: 2/5/2012 2/4/2012 1/1/2011 I'd want it to be able to...

Hi, I am new to Access and even newer to VBA, so I'm hoping someone could help with what seems to me like a failry simple issue. I am trying to import an excel sheet and append it onto the end of a table. This will be done on a monthly basis so I need to concatenate the filename and have it...

Dude! Brilliant! Thank you so much for your help, i would have spent days on this. You truly are an Access jedi.

Holy crap that works! I just need to modify the way my reports are set up now, because since they are based on that query as well, each report prints one iteration of itself for every employee in the query regardless of the max level. Not sure how to do that at the moment but thanks a lot for...