Search results

Thank you dportas, that's really helpful. Do you know if i can have sql 2000, and 2008 developer running on the same machine? Anna

Hello, I have a client with a large database running on Sqlserver 2000, accessed from an access 2003 front end. They are looking to replace their server, and therefore possibly their version of sql server. At the moment, i have sql 2000 on my machine, and regularly take a back up of their...

Hello, I have a situation where a front-end works beautifully linked to a set of web based Sql Server tables. However the client now would like a read only copy to be downloaded on to the local pc, so that the information can be browsed while not online. The pc's do not have sqls server on...

hello, I have a report with two columns, showing stock locations. I have a header for each new location, with a force new page before section set on the header - the aim is that 1 set of pages can be given to each guy for stock take purposes without the beginning of the information for the 2nd...

That worked perfectly, thanks,

Hello, i have tried to find an answer but can't seem to find any posts that apply. I need to limit the records returned in a query to 3. Well, that is fine, i have set it to do the top 3, and it is working well, I am looking at the top percentages received in a number of criteria. However we...

Hello, I apologize in advance if there have been lots of questions like this, but the search won't let me use AND as a search term! I have two related 1 to many tables. The parent table contains clients, and the child table contains categories, each client can have many categories. (i...

Hello Grznzbra, I have just encountered the same problem - the apparently invisible tables, from which the database continues to draw information. My situation is slightly different in that the linked tables are not visible in the front end. However, it has had a diasasterous effect, in that...

Hello, Is there a way to display a date in a report using the th, st, nd, rd extensions at all? i.e. december 1st 2005, rather than december 1 2005? i could do it in code, but that would be a little annoying if there was a trick to it! Anna

Hello, I have a system that has been working quite happily, sending a set of emails to the correct set of people at the push of a button. My client has just had an exchange server installed, and apparently what now happens is that the from address, that is on the email that is sent, is...

Thanks SJ, What is odd is that when i ran the query itself, the teams were what displayed, because of the relationships. I was just surprised that they didn't display in the list box. Or that what happened in the underlying query wasn't passed across to the listbox. I have now added the...

Hello, I have a linking table between two other tables that require a many to many relationship. All i am storing in this linking table are the ids from the original table. My problem is that i need the set of linking data to be displayed in a list box (or combo box if i have to). I've...

Thanks Pat, The linked table manager doesn't work on my access 2003, annoying, but i just remove and relink the tables each time. I'm not having any noticeable effects with outlook. If i remove access xp, and only use 2003, are xp/2000 systems created and maintained on 2003 still fine on xp...

Hello Pat, I was wondering what do you meant saying that AXP and A2003 can't coexist. I have them both on my machine (XP installed first) and haven't noticed a problem with either of them. I always open the version of access i want to use and then open the database, otherwise the database...

You can. There is probably a more efficient way, but what i've done in the past is look up ascii in the help, get the number for the character. Then use the immediate window in the vb screen to print that character. ? chr(13) then copy whatever it prints and paste it into the find and replace...

Hawka, I assume you mean delimited by commas, with a text qualifier of speech marks. In that case i would remove the CR's by doing a global find and replace, I would probably replace with a space. Good Luck Anna

Hello Hawka, When you set the export specifications, there is a text qualifier option. If you set that to ", then text in any field is surrounded by speech marks, which means anything in there like a comma or cr will be ignored. Anna

You could set up a text box on your report with the following record source: =dcount("[pcsets]","query2")/dcount("[pcsets]","query1") set the format of the text box to percent and that should work. Basically you are counting the number of records returned in the second query, and dividing it...

Thanks FOFA, I tried that - but still no good. I understand that it doesn't seem to think that the value is an integer. Is there a way to set the data type of a calculated value? I've tried in the properties, but it only give me the option of format. I've tried to format it as text even, and...

Hello, I have a fairly complicated query that pulls information from various tables to populate a report. Basically, i want a letter sent to all people who meet a certain set of criteria. I have a calculated field in the query: Let: DLookUp("[letter]","diagnosis","[type] ='" & [d1] &...