Search results for query: *

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

Hmmm... Thanks Paul. Your setup makes good sense and is set up much more logically, however: If the initial value of StrCriteria is "" rather than "1 = 1" and the rest of the tests add to it, it results in a string that starts with " AND ". I guess I could do an if then at the end of the...

I'm writing a sub to filter the results on a form. Right now I have two filters, but would like to add more and am unsure of the best way to continue. I want to add combo boxes for 5 more filters. This is going to turn into a lot of nested if statements if I continue going like I am...

Thank you for all the replies, I've been out of town on business and haven't worked on anything until tonight. So I'm trying JoeAtWork's idea of hiding controls... Does using something like below this as a procedure On Open form work? 'checkusergroup() is function which return true or false...

I'm stuck.... I'm expanding my company's database to include some sensitive information that I do not want all users to have access to. I want to have one form that both the non admins and admins can use. Admins would see all the data and non admins would just see an XXXX or something in...

No. Right now we both access the same front end, which obviously doesn't really make sense. I split it before i posted here just to see if that would help. Should two users be able to access the same unsplit access db? I guess i understood it this way, but each user have his own fe would...