Search results

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

I apologize if you feel I posted the same question twice. I do feel that it does apply to both threads. I am unsure if it would be handled on the Access side or on the ASP side. With different people browsing the 2 different areas, I felt I would be able to get help, not criticism.

Hey Wayne, I want to concentrate on the number portion of this post. I have them DM0# thing worked out. What would be the correct way in Access to create the number basing it on the year and autonumber(ID)? If you remember, the last number for 2003 was 1159 and I would like the 1st number for...

Wayne, The "Before Insert event of your form" you spoke of, that would be an Access form? Ron

Wayne, This is great, thanks. I am not sure if I mentioned that I am not using Access to display the data. I am posting it using ASP from Frontpage on our intranet site. So my code now for the number is: <% Dim ID ID = Replace(FP_Field(fp_rs,"ID"),"DM03-", "")...

Wayne, I have 1149 records currently in my database from 2003. I want to still display them and start the suffix number back to zero for 2004. What I have is DM03-0000 to DM03-1149 and I need to add for this year DM04-0000 to ? Thanks Ron