Search results for query: *

Good morning, I have a form that is used to enter a log of daily activities for each of our customer service representatives. In the header (DAL_Header), there are two fields that are required: the CSR's employee number (CSR-Num, and the date (DAL_Date). In the detail section is a sub-form...

Tried posting this before, but I'm not sure it went through. Good morning. I have a problem with a subform locking up the database on a multi-user application. The details for the data is as follows: Header Table Employee ID (Primary) Date Subform Table Employee ID (Linked to Primary above)...

Good morning. I am working on an idea for a form for a project and need some advice. The form will have several fields on it, but I'm only interested in two of them. They will be called [Start_Time] and [End_Time]. I know how to get the difference between the two, but what I need is for each...

Good morning. I need some advice on a problem. I have created what amounts to a time and tracking application, but I've run into a problem. In the application, I have a field where the employee enters their employee number and the date in the header, and then enters their daily activities in...

Good morning. I need to have a way of changing time field's color on a form. I have tried several ways, but without success. Basically, I need the font to turn red if the time is before 8:00 AM. Any ideas?

I have a database that has two lines per record (This was an import from an Excel File!). How can I tell Access to pull a field's data from the second line, and insert it into the same field on the first?

Hi all, I am currently working on a call log database that shows the percentage of people called broken down by state. Ex. AL=65%, AR=14%, etc. Is there any way of pulling this data into a report where I can show the percentages for each state on a map? I have successfully set up the map, but I...

This one has me puzzled. I recently bought a new case for my system, and after transferring all of the hardware over, I ran into some issues. The most annoying of these is that the system will boot up, will go into windows (all the way to the desktop), and then lock up. This happens after about...

Ran into this just a few minutes ago and thought someone out there could use it when they run into this error. I am in the process of moving a large database from my old system to my new one. The file moved just fine, but all of a sudden, I couldnt run any of my reports that used the Date()...

OK, I'm stumped. Currently, I have a VB module that goes through and prints out several weekly reports for our supervisors in order by department. What I need to do is to show the supervisor's name on each report as they print. The same report may go to several different people, but the names...

OK, I'm at my wits' end on this one! I need to be able to take a query of all of our open orders, and have a field that shows a running total on a line-by-line basis of our stock levels. For Example: Item # Qty OH On Order Balance 123 100 10 90 123...

Good afternoon. I have been working on a project that has me stumped. I have set up what amounts to a multi-part Report. The report prints multiple times without any problem. What I'm stumped on is how to change the footer on each page automatically. This is a pick ticket that I'm generating...

Help! I must be missing something simple! How do you tell access to take data from a field and multiply it by a user-entered amount? I'm working on a production planning database, and am stumped!

Does anyone out there have an answer for this one? We are currently in the process of changing out our existing accounting package for a new one. When we started importing the data into the new system the decision was made that for each vendor the vendor's old ID number would be tacked on to...

I am working on a form for our accounting department and have run into a brick wall. What I'm trying to do is to create a receiving form for our S/R department that would have all of the necessary data from our PO database displayed, but would also have a field where the receiver could enter in...

Does anyone out there know how to add a comment field to a query? What I'm trying to do is to link an Access databse to external sales data that is on our server, run a query to show only the past due orders, and have a field either on a form or in the query where someone can enter the projected...

I have been going around in circles on this one. Does anyone have any suggestions on how I can set up a search in VBA on a linked SQL table? I've tried every way I can think of including the rs.index and rs.seek methods, only to find out that they don't work on linked tables! What I'm trying to...

Here's one for all you gurus out there! We do a lot of work with the Federal government and as a result, we have to do things their way. One of the things that they require is that for each order that comes in, we have to send a response back to them. The response is always in an 80 column line...

Help! I'm trying to link an Excel spreadsheet into an Access Report as an object. I can link the spreadsheet but unfortunately, it doesn't import completely. I only get about half of the spreadsheet. Does anyone know what might be causing this or how to fix it? Thanks.

Does anyone out there know of any way to import an Excel spreadsheet into Access as a report? The spreadsheet is a form that we use and took a long time to create. What I'm aiming for is for the form to print out with data from a table. I would rather not have to recreate the form from scratch...