Recent content by IP076

Thanks guys for the info. I'm connecting to a MySQL server....not an MS SQL... I found the drivers online at MySQL.com. Works great! Thanks for the info!

Can I get a clue to which driver I should use? The only ODBC one I have is for oracle. Should I be able to download driver's for MySQL off the web somewhere? Thanks Again!

Hey, thanks, That gets me to the manager. How about the wizard? The manager will not work with out any linked tables currently in the database. Thanks!

Just an idea from a newbie... I've ran into this situation before, but with small apps, so I dont know how it will work for you. I created a new file, and went to the Import menu and imported, well, everything. Dont remember if I was using the security feature or not, but it might be worth a...

Just wondering, is the wizard for linking tables included in Office XP? I have office XP (access) and can't seem to find it. Anyone help? I'm trying to connect access to a MySQL server online, and after searching this forum I determined I should be able to do this using the wizard. Anyone...

Just curious if anyone has any examples of code that will auto fill forms on a webpage. Basically I would like to be able to autofil a few single text field web forms, submit them, and then open the browser, or if possible, bring the text into a report. Just wondering if someone could point a...

Thats kind of what I was afraid of. RE: Outlook My situation gets a little more complex I think. Here's the situation, I have students who are enrolled in a course that has units that need to be completed. I have instructors who have about 8 or so students assigned to them. Instructors have...

I'm wondering if anyone would have some access/code examples they would be willing to share concerning making a schedule... What I'm trying to do is have a list of people, with the times they are available, each person would have a seperate meeting with me, and then I have the time I am...

Here's what I'm trying to do, I have 5 points that I would like to plot on a chart and connect with a line. I think the XY Scatter chart is my best choice. For Example, I'd like to plot the following points that are stored in a table: 1200 lbs, 31.5" 1280 lbs, 31.5" 1600 lbs, 32.9" 1600 lbs...

Thanks for the ideas. I do have several teachers per course. Basically, I'm trying to see if I can come up with a way to track Instructor Loads in a flight training environment. We have instructors who have about 8 or so students which could be in any of 6 or 8 courses. Doing it in an excel...

Hey all, I'm trying to design a Database that keeps track of student loads per teacher per Course. I have a table that includes all the teachers. I also have a table that includes all the courses. Now, what I want to be able to do is keep track of how many students each teacher has in each...

Thanks for the idea! I got it to work...now, I dont exactly know how! But, I'll remember your tip for future use! Thanks!

Criteria Question.... I've got a field in my query that calculates distance between the point in the query, and the point selected on a form. Also, on this form, I have fields for Max Distance and Min Distance. I'm trying to get the query to return points that are within the max and min...

Okay, Here is my whole module Option Compare Database Option Explicit Public Const PI = 3.14159265358979 Public Const RadiusEarth = 3437.74677 ' Nautical Miles Public Const CircumEarth = (RadiusEarth * 2 * PI) Public Const NMPerDegreeLat = CircumEarth / 360 Function CalculateDistance(lat1...

Public Function CalcAz(lat1 As Double, lon1 As Double, lat2 As Double, lon2 As Double) As Double 'This Function takes into account great circle routings Dim x As Double Dim phi As Double Dim d As Double Dim Lat1Radians As Double Dim Lon1Radians As Double Dim Lat2Radians As Double Dim...