Search results

I'v been trying to get this form on my database to work on my own. And well I've not having much luck. I basically want to start with two pages (subforms in said pages). One to show the employees errors, and one to show the employees zone. Both are a per day thing. Meaning if an employee...

I have a 3 column combo box that is the source of some information in a pivot chart in a subform. The problem I'm having is the information being displayed is for the first column. I want the information displayed for the second column or is there a way to change the values of the legend?

Well given the success of the last database, that jz helped me with (thanks again). I was hoping to get help with another database that requires charts and such. Which I still have no experience with access. Basically what I'm looking for is a database to track on which day a forklift driver...

I have a database that I have copied over from an existing database because the setup will be very similar. I have been able to locate the majority of the reference issues in regards to the select statements (i've changed query, table, and field names to be more logical). Now I'm not able to...

I get a syntax error message everytime I try this code. Any idea why? cDB = currentdb.Name strSql = "INSERT INTO tblEmployeeAttendance_archive (pkEmpAttID, fkEmployeeID, dteAttendance,fkAttendanceTypeID) " & _ "IN " & cDB & _ "SELECT pkEmpAttID, fkEmployeeID, dteAttendance...

Is there a way to make the entry field at the top of a table instead of the bottom?

I have a report which uses a query as its source. On the query the results are being returned correctly but report is not returning the same information. What might be the cause for this?

DoCmd.Minimize DoCmd.Maximize Will start the form minimized or maximized but how do I start a form in windowed mode?

I was wondering if it is possible to assign this to a form caption forms!frmEmployee.comNumber. Like this "Employees with more than " & forms!frmEmployee.comNumber & " point(s)" Or something like that. Failing that is there a way to set a query caption?

See the below query, how would I write this into vba and have the criteria be set by cboNumber? If anyone could help that would be greatly appreciated. I got this code from the query designer generated code. I highlighted in red where I suspect I would change this to the combo box. Which...

I don't know exactly what I need in terms of how it is done in access. In real word terms what I need is a query to show how many employees are scheduled by department. How do I create a query that will count the number of employees in that department that aren't off on that particular day...

I have a query that keeps opening wider than that looks nice how do I reduce the width of a query via VBA code?

I have found a few things on this on the internet but none of it makes sense to me. I need a query that will look for persons that are missing jobs. The setup is as follows: tblEmployee contains the following fields: pkEmployeeID as Autonumber txtFName as text txtLName as text...

I'm trying to use this macro (not designed by me) to try to archive records older than 1 year. The part that is erroring out is directly below, the entire macro is below that. Keeps telling me that there is a syntax error. the origin table is tblEmployeeAttendance, the table being inserted...

I'm new to access and have little idea how to lookup a name from an employee ID. Below is the formula I'm trying but it is erroring out and I don't know how to fix it. Can anyone help? Employee Name: DLookUp("txtFName","tblEmployee","Criteria =" & [tblEmployeeAttendance.fkEmployeeID]) Below...

I've been posting various questions about a database I'm working on and haven't been making much progress and as a result I've come to the conclusion that maybe I'm asking the wrong questions. I'm looking for general help in regards to how to create a database to track employee attendance on...

I have 3 queries that have a column titled TotalPoints which uses the below formula to get the information: Then I want to have a 4th query that uses the column created by the below formula to summarize the 3 queries that contain the below formula. The problem I have is getting the information...

It seems to be much easier to add something to an Access database than remove it. How can I remove an entry from an access database? I will know the primary key value for the record I want deleted.

Excel.Application.ActiveWorkbook.Sheets(Sheets.Count) doesn't work gives Method of sheets error.

I need a macro that looks at all the names of the given database, excluses the Msys tables and then stores them into an array. I'm still not totally understanding how to create arrays. Maybe this is simple but I'm not yet there. Can anyone help?