Search results for query: *

Of course!! Thanks so much. That's the shove I needed.

Hello! I am wondering if there is a way to copy all the data from Table A and paste it into an identically structured Table B within the same database using a macro. To explain the application of the process, my database manages Project Data and all Projects have an identical set of base...

I have a single Excel worksheet that needs a user friendly interface. In my case I would like to pull up groups of rows based on a common field called 'Submenu' (essentially the exact funcion as the Auto Filter). In addition I would like to utilize a check box instead of a text field to flag a...

Hi Skip, I am not sure if my problem is similar, but perhaps you could give me some advice on my issue: I have a single Excel worksheet that needs a user friendly interface. In my case I would like to pull up groups of rows based on a common field called 'Submenu' (essentially the exact...

JASON, I got it! Hold down *SHIFT* key when opening it. Like I said before, thanks for your help. It's GREATLY appreciated. Take care and good luck on current and future projects. Brian

JASON, That's perfect!! Thanks so much!! However, I have a follow-up question for you. While setting my open screen to my switchboard, I decided to have fun with the toolbar options and now the toolbars do not display...which I like. My question, however, is 'how do I get them back?' I now...

JASON, I would be more than thrilled to make my second option work. I already have the 'Switchboard' created. At this point I would be looking for a way to make it auto-run when the database is opened. If you can help me out with any tips or advice, I would be most appreciative. Good luck...

Hello all. Hope you're having a good day! Here's my dilemma: I have a secured database in Access 2000 and from that database I have created a form which essentially serves as the launch pad for all functions of my database. Therefore I would like to do one of the following: Option A...

Frank, Wonderful idea!! I love it. By some chance would you know how I would create a form where I can use a combo box to select an employee and then click a button to bring up that report for that particular employee?? If not, I will simply start a new thread. Thanks again. That works...

I have a rather small and straight forward database that we use to track Employee Asset. It contains a single Employee database and branching from that are smaller tables that track items like laptops, cell phones, keys, uniforms, etc. There are a total of 5 tables that are linked to the...

How is the printer connected? Is it connected locally or is it a networked printer that you are trying to put on your LPT1 port?

Okay, just to clarify, are you asking me to create a new Workgroup on my PC? The problem I have with this is that I am already a member of a domain. I am not positive, but I don't think I can be a member of both. As a side question, do you know of a way to completely remove the security from...

julius1, I am having this same problem. Can you explain with a little more detail as to how you resolved this problem. Every database I have is secured and I didn't intend it to be this way. Thanks!

Thank you so so so much!! It works!

Lightning, First of all, thank you for all your help. However, I am still having problems making this work. Before when the syntax was wrong, it was simply not working in that the second combo box wasn't displaying any employees. Now with the change that you helped me with, I get the...

This is essentially a copy of what you posted pasted into the Row Source of my combo box. SELECT [Tbl_Employee].[Display_Name] FROM [Tbl_Employee] WHERE ((([Tbl_Employee].[Location])=" & me.Combo106 & ")); Combo106 is a combo box drawing values from a table of depot locations. I...

Lightning, I am having problems making your SQL work, can you maybe post an example? This is exactly what I want to do, but it doesn't seem to work despite close inspection of my syntax to make sure it's right. Thank you, Brian

dobrios, How did you link the tables? I have been trying, but always get a MESSAGE CLASS column with the value 'IPM.Appointment' all they down the list. If you wouldn't mind, I would be curious to know what you did to get 'all kinds of garbage'. Thanks!