Recent content by jreynold

Sorry for late response, I have not had time to work on the database since I posted. I pretty much can only work on it in spare time which is hard to find these days. I will try to implement your idea soon and post back with status. Thank you so much!

I am rebuilding a database for my small construction company. I did the initial design of it but it has been a while since I have worked on it. I am having trouble wrapping my head around the following issue. I've read and reread the article by Paul Litwin, "Fundamentals of Relational...

I don't quite remember the circumstances when this happened to me, doesn't sound like exactly the same, but here is my post I made after it happened and some helpful repies. http://www.tek-tips.com/viewthread.cfm?qid=1456218&page=1

I want to use access to kind of keep my files organized. I own a contracting company, each project has a folder, each "job folder" has a folder in it called "admin", that only specific users on the server can access. Two questions, is there a way to create a folder with permissions already in...

Thank you so much Golom! I was hoping for some constructive criticism on bits an pieces, but you helped out way more then that. I didn't try timing the speed of it or anything, but it seems faster to me, we'll see what eveyone else thinks :) I also found in the Allen Browne code for...

I apologize in advance for the ridiculous length of this post, but i figure the more info the merrier! Okay, I have a continuous form that I am trying to upgrade to include an unbound textbox which will filter the records in an "As you type" format. I tried using Allen Browne's coding, but...

Mark - thanks, i'm going to look into that right now. Remou - In my particular form I have 16 controls, 5 go to one page, 5 go to another page and 6 go to another page.

I have a continuous form [ProjectList] with 16 different fields on it. I would like to be able to double click on any of the fields and open a tabbed single form to a particular tab. I have code to do that below. What I am wondering is what is the best way to repeat the same event for lots...

That's just way too easy for me... Not nearly complicated enough! [2thumbsup]

Thanks for the support everyone! I quit on it and took the night off and am just getting back to this. I am thinking I will just rework my 3 hours on the backed up pre crash database. Before I just start there though, how can I tell if my backed up copy is corrupt? I want to stave off...

[sad] So i've been working on this database MSaccess 2003 and all my code disappeared. Gone. No modules, no class objects, there is nothing left. I was working on a form, closed it, opened it back up and poof, no buttons worked. They didn't work because the code had instantly disappeared...

I have a user who wants a button to open a link in Firefox (His default internet browser) rather then IE. The code for my button control is below, and is pretty handy. It creates a url for google maps for a location when given the address, state and zip code. Private Sub MapItButton_Click()...

Hehe, okay, so I'm new at this... [bigsmile] . What about all of the records where 1 = 2 ? Ha! Thanks everyone for all the help and Randy for clearing the fog there for me!

Wow, very nice. Following the directions on the website I was able to fix all the labels in about 2 seconds! Thank you much missinglinq!

I have a form with three sections. I labeled each section with an unassociated label Project Information: Project Status: Project Notes: The labels are for ease of viewing purposes only. When the form is viewed in "Form View" all the controls showing data flashes for a split second. It does...