Search results

I'm not sure if this is the correct place, so u'r welcome to move if necessary :) I have MS Office 2010. I created a DB which is connected to a SharePoint Tasks list. For that DB I created a form that shows each Task, and each has a field named "Client". Each of the clients has a specific...

It's ok, don't worry about it. Haven't had much time to actually look into it a bit further, but as soon as I have any news I'll post it here. And thanks again.

I'll try to explain. I received the query from someone who worked with me, and who I can't contact again. I use it on the SQL Designer to bring up information, and was working under the assumption that it's giving me the correct info. Now, since I want to "move" everything to Access, I've set...

The reason I want to do this on Access, is that many people here (including myself, as I'm going step by step here) don't know SQL. So, when I have this ready, I will be able to design forms, so people will only need to enter the information they are looking, without the need to actually write...

SQL codes - SQL Studio vs. Access SQL Sorry it took me some time to reply back. Well, as you requested, I will now post the query as I do it in SQL (I use MS SQL Server Management Studio) and then the one it creates on Access. Note that since this is work related and a bit sensitive, I...

I was wondering if there was any tool, online or freeware, which I can use to "translate" a query from SQL (Management Studio) to Access? For some reason Access changes the query, and it doesn't bring the same info. Any ideas? :confused:

It's working Ok, it seems to be working as it should, so I guess I was wrong :o. Just 1 more question. To connect to the SQL server the tables are linked to, I need to enter the password each time. Is there anywhere I can enter it, so it doesn't ask for it, since there's no option for...

Well, u might b right. I'll try it again and check it out. If it doesn't work, I'll come back here. Tnx again.:)

I want to make an Access Form and queries (kind of a portal), which relates to tables on an SQL server. For this I need to have Linked Tables in the DB. I use Access 2007, and tried the option in 'External Data > More > ODBC DataBase', and then choose 'Link to the data source by creating a...

I have a form, which has a combo box, with a list of states. I want to have a flag of each state, that will change automatically when I change the selection in the list. Can anyone please explain how I can do this (if it's even possible? Just to clarify, I don't want a link to the picture, I...

Possible resolution Well, I don't know why it worked, and I got to this "solution" accidentally. I changed the name of the form, and wanted to design a new one. While I was designing the new form, I accidentally clicked on a button in the older form - and it worked. So, I tested this again by...

Hi, I use Access 2007 at work, and made a form with several buttons, which open other forms. At first I labeled each button with what it does, but then decided to change it, so that I'll have a small button and a label beside it. However, when I add a label, close the form and then go into it...