Recent content by Qrackerman

I got it. It was a security setting in IE. Thanks for your help!

I am using Win2k and have just upgraded Office 2000 to Office xp. When I opened an Excel file off the server after I upgraded, it gave me a similar error which I corrected within Excel. Now when I opened the db, I got this issue. When I open the same db on a machine with Office 2000, the db...

I have recently upgraded to Office XP. My database is Access 2000 accessed through our intranet. When I try to open the db, I get the error: "Microsoft Access cannot open this file. This file is located outside your intranet or on an unrestricted site. Microsoft Access will not open the file due...

Sounds great, can you explain in a little more detail as to how you set the tables up??

This will be used on a daily basis and the Foxpro tables are not static. Would I have to run the make table query each time I want to use the database and if so, is there a way to automate it??

What is the proper procedure to create an Access table from linked Foxpro tables? I know how to link the tables to Access. I need to create a table that displays info from the linked tables and has new fields that can be modified without modifying the linked table data.

I have created a query to collect info from 3 linked Foxpro tables and would like to display the info from that query in a portion of a form. Based on the displayed info, data would then be entered into the rest of the form. How can allow a user to input data and still display the linked table...

Here is an example of what I am trying to accomplish, not really sure if I am explaining it correctly ID Date Number 0001 01/01/03 0001 0002 01/01/03 0002 0003 01/01/03 0003..... 1200 12/01/03 1200 1201 01/01/04 0001 1202...

A new record is entered via an ASP form posting to the database

Great, I got that part to work but when I do the update query, it updates the new field on every record with the same number. How do I have it check the number in the last record and update it by 1 in the new record each time??

Sorry, I am confused about: "Year([Date_Entered])= portion of that formula. What does it do??

Thanks, I will give it a try

Great thanks, My confusion is where would this formula be placed, in an update query??

Thanks for the reply dcx, The database was started in 2003. the PK is autonumber and is around 1200 records. I want to keep going from 1200 in the PK but create a field that will start back at zero if data is entered in 2004 and again at zero in 2005?? So the first record in the year 2004 would...

Is there a formula/module/macro that would be used to populate a field based on the date entered and primary key? Date entered is just that - date entered and primary key is autonumber. Or would it be a new query of some sort??