Search results

Hello, I know I am behind the times but since I updated my Access database to 2007 my append query no longer works. The query is taking values form an unbound form and appending them into a simple customer table. Did something change that ([Forms]![AddCustomer]![LastName].[Value]) no longer...

Hi, I have read many of the threads relating to this error, and have tried some of the things in those threads with no sucess. Here is the situation: I have a table called ForecastedSvcLvl1 I have a query called FCST_SL_QUERY_2 I am trying to update 2 fields in the table for various days...

Hi Folks, I use this to get a week number for a date range: WeekNo: DatePart("ww",[Timestamp]) Is there a way that I could also get just the first date from that week number to appear in the query as well? ie. if Week 1 is 3/1/07-3/7/07 the query would show 3/1/07 as well as week 1. TIA

Hi, I am trying to create a historical record of Employees at our business. What I would like to do is have a query that will create a begin date and create that date for each day starting w/ like 1/1/06 and continue thru Date()-1. For example: Jane Doe and John Doe started employment on...

Anyone know a good site w/ help creating charts in Access 2k? I have a few queries id like to display as charts but just playing w/ the chart feature is getting more confusing by the minute. Any tutorial would be great. TIA!

Is it possible to actually change a number to text? I cant seem to figure out how. I have 2 proprietary systems one uses a number and one uses text for the same item. I know how to change the text to a number however the more efficient way for me to do this is the other way around. Its the...

Hey folks, What I have is a query that results in some general employee information including: EmpID EmployeeName TotalHrsLogged The original query looked like this: SELECT EmployeeID, EmployeeName, Min(TotalHrsLogged) As LowestOcc, Max(TotalHrsLogged) As HighestOcc FROM qryName GROUP BY...

I have a scheduling unit that associates a number to a particular name. In this example Break=66 and Lunch=76. What I would like to do is setup something that will tell me "which break". Like "Break 1" and "Break 2" Here is what I have to work with: Emp# ID# Code StartMin...

I am trying to convert a whole number to a start time w/ no luck. Assuming "0" is 12:00 AM, I have a start minute of "480" which would in essence be 8:00 AM. Can anyone tell me if I can somehow convert this to time in my query? Thanks.

I have 2 Data Access Pages that are almost the same. They both pull data from my dB. The issue is that when I open one of the pages it works fine the dropdown list has all the things in it that it should, but when I open the other DAP the dropdown list is blank. What could cause this to happen...

I have a report that has 2 subreports in it. In order for the subreports to run you have to enter a date range that come from the query. Is there a way that I can set an [Event Procedure] so that it sets the date range the same for both subreports? Something like this..this doesnt work but...

I use Access to open a workbook from a Simple Form. What I want to know is can I add code or a macro of some kind that will select Range("A:A") and Delete that column after the workbook is opened w/ the Command Button in Access. This is kinda an extension of a problem I had earlier... Here is...

I am trying to open a workbook with a command button on a form however the path to the file is giving me a fit. The path for the file location contains spaces and I am going blind trying to figure out how to rectify the path. Heres the line. I am sure someone here will see this problem quick...

I have a DAP that many users have access to.When opened the Dropdown is blank on some peoples and populated on others. Is there some setting that can cause this. I have checked to make sure that they have the allow ActiveX Controls to run files on this computer checked. Any other setting that...