Search results

I think this was a case of being too clever for my own good. (hard to believe, I know) I have a table that is basically a survey form. The same series of options was available for 35 questions, and the table used to have a text string written for each answer. Because of all the repetitive...

Another one of those that should be a piece of cake but I'm having one of those :banghead: type of days... I have a form where users can enter the beginning and ending dates into text boxes. They could also do it for the number of the week (1 to 52) or a single text box for the quarter. I...

I apologize for this one, but I inherited this for my new job last week. The company I work for has a database of safety cards recorded in an Access database. They use pivot tables in Excel with the data linked in from a union query in access. The reason why is because they were attempting...

I'm sure this has been discussed before, but have any of you made a pivot chart, and then went back and made changes, only to have the form open up as a single form? I already checked the properties, and nothing was changed there. And ordinarily I wouldn't use Access to make a chart, but the...

I know this is an easy one, but I can't get it to work. :banghead: I have a form where, if you double-click on a text box, a smaller form will pop up and it has a single text box where you can type in a number, hit [ENTER], and search for the number you typed in the table the first form is...

I apologize for the caffeine not kicking in... I have a form based on a query that filters a series of vacation records. There's a separate field that tells the database what year to charge the vacation to (just in case people use 2011 vacation hours in 2012 or vice versa). What I want to do...

Hello. I was trying to diagnose why a form I created, which will search for a record in a table based on criteria in the form, then ask to create it if it doesn't exist, crashes whenever someone answers "no" to the question. Here's the code I cobbled together (or configured for my use, as it...

I have a very weird one for anybody who wants to tackle it. I've been trying to create a roster for our production lines which will print X number of extra blank lines once all associates assigned to a line are listed, up to 20. I adapted Microsoft's "How to Print a Constant Number of Lines...

OK, for once I have a complicated one. :D I have a form containing work order descriptions that are used to generate production orders on a daily basis. Right now, a person would have to click on a button on a continuous form next to the proper work order and fill in information like the...

I'm sure the answer is here somewhere, but I can't find it and it's driving me nuts. I have three tables. 1. COURSES 2. COURSE SCHEDULE 3. COURSE ROSTER As you might suspect, they are in one-to-many relationships with each other. (Courses -> Course Schedule -> Course Roster) What I'm...

This is a bit of an unusual one. I have an unbound form with a set of 17 text boxes that users can input order numbers in and receive data on those orders, depending on the report they select. What I need to find out is if there is a way to create a command button or macro to clear the data...

I looked for this solution through the forums, but I could not find it. And I'm sure this is one of those "why didn't I think of that" moments. So I apologize in advance if I waste anybody's time. I have a query that gives me a list of orders to be run on a particular date. One of the...

This might be more suited for the Queries section, so please tell me to move it there if you agree. I have a table that has columns for the starting date and ending date of an order, along with the number of personnel to be used and the quantity generated in an 8-hour shift. What I want to do...

I've seen similar threads for this before, but not ones that specifically meet my issue. I have a Database that takes the scan of an employee's badge and marks the time by default. What I want to do is set up a field where, if the scan is made within 10 minutes before up to 20 minutes after...

I probably should know the answer, but I'm having a brain freeze this morning. (forgot to feed the hamsters on their treadwheels) I already have an Access Pivot Chart that totals labor costs for jobs in a particular month, and the axis is separated by month. What one of my bosses wants is to...

I'm sure this has been covered before, but I'm having a tough time with it. I've created a database (with a lot of help from people online), that has a hidden form storing the UserID and Department of a person on a "hidden" form so this data can be used to filter out records specifically...

I apologize if this has been asked already, but I couldn't find the answer. I have a field in a table that timestamps the date and time in which a record is entered. (using general date format: mm/dd/yyyy hh:mm AM/PM) I want to put a calculation in my query that will display all records...

I'm sure this has been done before, but I can't seem to find it. I have three tables: 1. A list of training courses (Course ID is primary) 2. A list of dates and times for each course (Session ID is Primary and is linked to the one above it through the Course ID) 3. A list of students in...

Hey folks. I'm working on a form that, when a combo box is set to a certain status (from "In Process" to "Ready"), another field in the underlying table should be populated with the current date. Now this can be done in a macro easily if you only needed to record when the combo box's selection...

This qualifies under the "dumb question or one that's been answered a million times but I can't find it" section... I created a form with a combo box in the header for the purpose of selecting a specific record. I want to synch up the combo box with a text box so that someone types a person's...