Recent content by kalebson

Sorry that worked CJ, I had the form in design view when I tried your code. Thank you both very much.

That unfortunately gives me the same error I was getting before: Enter Parameter Value Forms!AddEmployee!First_Name

That is what I did. I simply created a blank database and imported everything from the old 2003 database.

Is says Missing Semicolon (;) at end of SQL statement. But its there. Never saw that error before.

Here is the SQL. This worked perfect until I switched to Access 2k7. I have a button on the form that simply runs this query. INSERT INTO CUSTOMER_LIST ( First_Name, Last_Name, Zipcode, Phone_No, Email, Referred_By, Referrer ) SELECT ([Forms]![AddEmployee]![First_Name].[Value]) AS First_Name...

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

Thanks I will give that a try.

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

I think I got a solution for this I appreciate the info. We just needed a way to show a history of when a rep comes and goes. and so we dont drop their stats if they arent currently in the system. It a nutty process for sure.

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!

Absolutely perfect. Thanks a ton.

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

HAHA genius..thx that worked perfectly. Getting late in the week im about burnt 8).