Search results

Unfortunately, this isnt for me, otherwise I would have no problem creating a report when ever I need it. It is for someone else at my work..and I am sure they arent computer savvy enough to......oh god, create a report in access... I tried making a parameter query and then making a report that...

Ok. That is what I am doing right now. just making a new field, that is the same project id, except without the hyphon (you said int is best :D) although ALL entries in this field will be of the format xxx-xxxxx, i think it would just be better to have an integer as a key :) thanks so much for...

its set to: I tried changing it to an integer, but like i said, the project numbers are in the form "200-20503' so when I did that they all changed to just "200" or "100" dropped the stuff after the dashes (had to re add all manually >.<) the only thing i can think of maybe is instead of using...

sorry >.< i will try to get my terms correct lol. but anyways...and as to if the data type is what I want, nope...it says that it is a memo...not a text like my mysql has...but I cant change it to text..when it is linked, it saves it as a memo, even though it is text in mysql...(an example of...

Hey, so I am trying to create a query based on 2 tables. first table is just a boring normal table, but the second one is an OCDB DNS link... they are related by one field, but when I try to view the query in datasheet view, i get this error...not sure if it is because of the link...thats the...

oh. i think I am using a DSN conection (I hit the New.. button next to DSN Name combo box) :P shouldnt be a big deal tho...it will only have to go onto 2 or 3 machines, so I can walk them thru it, or go over to their houses and do it for them. thanks again for the info!

ok, thats not too bad. will I have to set up the OCDB connection on every computer, or will that be saved within the access db?

Sorry it took me so long to respond/test, i just got back from vacation yesterday... but anyways THANK YOU!!!!!!!! works great! and at no point asked me for an IP address, so hopefully that obstacle has been avoided, lol. and a uto updates my access db when ever any changes are made in my sql...

Hey...So I need a report that will pretty much look like this: (excuse my crappy artistic skills :P. but as you can se pretty much just a report that displays data in a spreadsheet like display, then underneath two combo (or select) boxes that someone can select a name or project and it will...

not sure what I use exactly...on the screen it has possibly the information... MySQL client version:5.0.321 ... never meant to say i was using sql server >.< lol! Ok. so from what you are saying, i should be able to get the DNS set up for my online mysql thingy? i can do this in access? I dont...

Ok. thanks for the info! I guess I will just try my other alternative, and set up a php page that downloads and saves the sql database as xml, so that I can import it into access.

Yeah...I dont know my terms for this stuff...lol...and im not sure exactly what phpmyadmin is. I get stuck here when i try to create a odbc connection. i hit new DNS name, enter SQL server, then select next and I get here. Also in the screenshot i have a picture of what my sql interface looks...

So Im not sure how I am going to go about doing this...I want a macro that will pull data off my sql server. I know that there is the odbc option under the import...but that seems to only work with sql servers that are on the same machine..not web based sql servers (im not sure if thats what...

Hey...So I have a treeview that is prety sweet....I was working on it months ago, but another project came up and I am just getting back to it now :) So I have to start where I left off. Trying to find a way to findout if a node is active by IF ITS CHECKBOX IS CHECKED. It has been (like i...

hehe thanks, but you looked at the wrong post >.< !! :P the file you got isnt mine at all hehe.. I already know how to add everything to the treeview, its just making the treeview realize that once a CHECKBOX is checked, then a node is active (instead of saying Treeview_Click() for the sub...

I still am wondering about this, no one got back to me on it :( post #3 is where the most recent question is :) Thanks

Thanks John, this is really helpful...Now i know i dont really need to use SQL (only 9 of us in the Consulting company :P) ...for some reason I had this impression that SQL was all online. See, since we don't have an office (we all work from home), It makes it harder..i think...to get the...

I hope this is the right spot >.< sorry if its not! im having some trouble grasping the concepts of a front end/back end database...im relatively new to access, and have never even looked at SQL..so yah, lol. So I have done searching on google/these forums for info...but I just cant seem to...

Wow!! 1.5 hours. thats amazing, thanks!! haha. :D << yeah thats a smiley face...cause i got it working! I realized that your PK doesnt have to be an autonumber..heh..who woulda guessed?! Here Is my database if you want to have a look :) Thanks again, Paul

Wow, thanks so much for all your help!! I'm currently working on normalizing my database :D Like I said..Im new to access...I have been databasing for like 2 days now hehe (the course i took a month ago was useless! we spent like 20 minutes the first day discussing selecting multiple items with...