Search results for query: *

I read your response twice, I don't understand. Take me thru, as a user, and tell me what I am doing and what the expected results are. (unless someone else is able to understand and answers) C-D2

This is definitely a multipart answer. 1. You need to put a multi-selectable listbox on your form. 2. You need to make sure that the BOUND column is set to the correct column (i.e. – the ID field in the table) 3. You need to create a report in which the SQL statement has a WHERE statement that...

SAwilliams, We'll do this the 'long way' so you can learn how to mess with settings in the future. 1. Go into design view on your form. 2. Single click on the combox that is bound to the phone_type 3. Look at the properties window for this object 4. Look for the field that says "Row...

BACKUP EVERYTHING FIRST.... Do this on your backup.... :) 1. First of all, I don't ever do that at table level. I would remove that lookup and do this at the form level. 2. Create a new combo box on your form. Do the following in the properties of the new combo box 3. Bind that combobox to...

I am guessing here, but I think you have the default set in the table, not in the form. Go into the design view of your table and find that field. I'll bet you have a default value set there. Remove it. Let me/us know if that works. C-D2

Is this specific to Microsoft Access or just a general Microsoft Windows question? Please advise. C-D2

Steve, That's an interesting question. IMO there are some things that need to be done in order for this to happen. 1. You need to take away admin access to the db. (no db window for users). 2. You need to create a way for the users to run (see) the report and maybe one output method...

Also, you may want to try <Alt>+<F4> That just kills the current application. HTH C-D2

Not sure how your table would ever be empty, but whatever. here is a possible way... 1. Put both TimeStamp fields on the form. 2. On the timer event (or whatever you are using) put code to see if either object is null 3. Re-work your code so if the if tests true, then the e-mail/query/code that...

:::KIS::: "Keep it simple" Remember that..... Just my $.02 C-D2

Is it an option to create another database, not password protected, that ONLY has the macro and necessary objects to run the macro? C-D2

What is the exact question: How do you create a mouse-over event? How I am sure that the popup form has the correct data (via the SQL where statement)? I'm not sure where the question is. C-D2

The solution that you are looking for is not going to be found using multipule tables. You need to re-work this. I'm more than happy to try to help, if you want it. Please let me know. C-D2

OK, if this were me I would attack this a different way (and probably not the 'best' way either). OK, so you have 1 form and 1 subform and you want the subform to behave differently. Instead, have you considered having the "If Then Else" on the main form and having 2 subform? 1 subform that...

Mike, Any why can't you have multipule people updating the same table? This is definately not a limitation of MS Access, it has to be some weird business rule that you have. MS Access can handle like 12 users updating the SAME table at the SAME time. C-D2

J, OK, so you have multipule versions of the same database and you are trying to create a database that goes to the other databases to see what version of the database each person has installed? I am totally lost.d I am not trying to be a pain, I am just trying to figure out what you are...

Wow, that is a lot of posts. OK, tell me this: "without going into your solution, tell me what it is that you are trying to do". What are the requirements? What are you trying to do? Give as much (general) detail as possible. C-D2

J, If you have not figured this out yet, would you mind telling me/us why you are trying to do this? I can't fathom a reason that you would need to do this. Its seems that there is something I don't get!?!? C-D2

Mike, Why can't you put the Frontend on the network and have a shortcut on everyone's PC? Then you make only 1 Frontend and therefore only have one to update. Also, I would think about having a 'gateway' app that they are linked to. Then you can point that gateway to multipule apps in the...

Surfside, That is not long-winded at all. Actually there is more detail needed. Anyhow, first and foremost you need to write down EVERYTHING that you need this form to do. Then take it one step at a time. Get each step working. Make them independent of each other that way if you screw one...