Replies

Legare,
Thank you very much.
Works like a charm.
Scott

Sorry they will never both be 0’s
I want to use VBA because of the the code that will insert an option group into column H.
I found that if I have values already in column H and the code for creating the option group runs, the 3 options arent selected and all the values that were in column H
are changed to all 0’s.
If add, copy, move, etc. the 1,2, or 3 in column H after the option groups are created, the correct options are filled in.

Scott

Thanks,
That did the trick.
Scott

Thanks, I modified the Left, Height, Width parameters and that did it.
Thanks.

Hans,
In the code the the group box is created then the option buttons are placed in the box in each row.
Or thats what is seems to do. I can click on the box in each row and it has a different group box number.
But it still doesn’t act right.

Thanks, Sam and Hans
I didn’t design the workbook. It got put in my corner to modify.
Lucky Me.

Hans,
Thanks.
Can you explain Absolute/Relative
and
A1 Style(type of reference)
Scott

Gwenda,
I had some extra time at the meeting so I put this together.
Here is a stripped down version of the components you need to do web downloads.
It incluses the .asp file and the database components.
There are a few items you will need to edit.
The asp file:
On the 10th line, change the database name to the name of the databaes that is on your website.
On the 14th line, change the table name in the sql statement to the table name of the web database you want to get the records from.
The actual name of the asp file. I usually call it the same as the table I’m getting data from. As you see this one is getting customer
data. The name will also be used in the local database code.
Upload this file to the same folder on the website where the database is located.

Now to the local database:
In the module modConnected edit the first line after the Dim statements in the isConnected function.
Replace http://www.google.com with the name of your web site. Save and close the module.

Table setup:
Create two tables with the same structure containing all of the fields you need from the web database.
Call 1 table tblTempImport and the other one whatever you want. In keeping with the theme I’m calling it tblCustomers.
We import the data first to the tblTempImport in case you need to do any manipulation of the data before you append your main table.
In my applications I delete all the data in tblCustomers before appending the table to make sure I get any edited data from the web.
It can also be modified to only capture certain records. eg. only data after a certain date range if you have an input date field in your web data.

Code in the form frmGetData:
In the declarations section of the code change the URL to the url path to where the web database and the asp files are.
Your web master should be able to give you this info.
In the Form_Open code edit the getCustomers.asp to what you named your asp file on the web.
Edit the 2nd DoCmd.RunSQL statement and replace the table name with yours. This will delete the existing records.
Finally Edit the table field names in the rst.addnew section of the code to match your table names.
The !rs field names are from the web site table, the !rst field names are from the local table
The !rs table names don’t have to match the rst! names
Finally open the form frmGetData after your routine to open your database or from the click of a button or wherever you want.
The form doesn’t usually show up on the screen. I open it on the close event of my splash screen (about), this way the splash screen stays
visible and has a message that it is downloading current data.
Have fun
Scott

Gwenda,
I am away from the office at a meeting this week. I will post an example next week. Basically you have an .asp page for each table you want to download the data from.
These pages will be in the same folder as the .mdb file on the web site.
The code in these pages access the data in the tables on the web site.
The local database when opened or whatever time you want(button click etc…) runs code to see if it can connect to the web site. If it can, it deletes the current data in the local tables, connects to the .asp page and appends the local tables with the data from the web site tables.
You do this for each table you want to get data for.
The only thing you will need to edit in the asp pages is the table you want to get the data from and the actual name of the .asp file. This name is used in the Access database code.
Scott

Gwenda,
Is the data kept in an Access database on the web site and can the website handle .asp?
If so, I can help you. Some of my databases do this daily. When they are opened they download the data from the database on the website and
populate the local tables with current data.
Let me know.
Scott

Thanks,
I’ll give it a try

Hans,
I don’t know enough about ASP either to answer that. I think your solution will work.
Thanks,
Scott

Hans,
That works in Access but I don’t know if I can use 2 queries like that with recordsets in asp. Is there a way to combine the two into one(use a subquery?)
Thats what I was playing with but I haven’t written many of them.
Thanks

Hans,
The $ was what I was looking for.
I was going to do a search but didn’t know what to call what I was looking for.

Thanks again,
Scott

Hans,
Thanks again. Thats just what I needed.
Scott