Search results

Just realized that I needed more information to be collected for these errors. Pallet Tag # and Pallet Tag Location; 2 tables for Location and 1 for Number (I think). Pallet Physical Location, Pallet System Location, Pallet Tag # I'm having trouble being able to enter info into the form. Not...

Thanks for that tip bob. That looks like it will be all kinds of useful, the before event code.

Thanks Bob; however Zone is required. How do I make that field required on the form? Thanks for the explanations and the assistance.

I got the combo box and everything to work but I get an error message now when I try to add a new entry. Tells me that I can't add a new entry because a missing record required from a tbl. Gah, just can't win.

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?

I've kept trying to make this make sense. I feel like its getting closer to being coherent. But I can't get it to work still. I've attached another version of this database. With the attempts I've made to get the db structure correct. With this project I really want to learn this stuff...

I attempted to get started on this, but I'm getting confused already. If anyone wants to help I've attached my database that I've started.

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'm having trouble finding which forum or query is throwing the error. A few queries have similar select statements and I can't find the query / form that is throwing the error.

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 took a step back and decided on a different approach. I made a query that shows the points for an attendance mark, date of attendance mark, the text value for that attendance type, and fkEmployeeID to get the information needed. Worked pretty well. Not the way I tried it at first but it...

Subform in report I'm trying to make the report I've created that shows an employees name , ID Number and points, more informative by adding the data from frmEmployeeAttendance to it as a sub form. However when I do this it is causing the employee (which is selected from the active employee...

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

Data access page. How would I go about creating a data access page instead of a form while still retaining all the functions the form has on it? Is this possible? Why wouldn't I want to do this? or why is this a good idea?

Jz I don't know if you still have the sample database you made for me. But I'm having trouble with a query using employeejobs. the table employeejobs has a sub table with employee names that have said jobs. Not sure if I'm explaining this correctly. Anyway what I want is 1) a query with a...

Since this is a subform that I was talking about I just put it on the click event. So anytime someone clicks on the form it will take them to the new entry field. Good suggestion thanks.

Well then how would I do that? The way I have it setup is a form with text boxes showing in datasheet view. The entry field is at the bottom of this datasheet view form. Which after awhile would get annoying to scroll to the bottom to enter data.

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

Absolutely brilliant, that was the only thing that I did wrong, was have the table in the query with the job descriptions, this was causing the employees points to be multiplied by their jobs.