Search results

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

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

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

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

Hello, Is it possible to have an access backend sitting on a web server somewhere and have the front ends in access on the individual pcs. I have a database -fe/be - that is currently operating happily on a network. Now people want to be able to use the database remotely. My concept is...

Hello, I am designing a system for a client who wants to store answers to a survey with over 500 questions, broken into a number of sections. I have devloped a numbering system so that the fields aren't named by the words of the question, so that each field is immediately identifiable as a...

Hello, I am trying to send a set of characters to a point of sale receipt printer, which will make a cash drawer kick out. I have the set of characters, and have studied the open...for output as .... command. The probelm i am having is that in every example "lpt1" is listed, and this printer...

Hello, Without getting too longwinded, i am having to produce a report which translates my client's personal shorthand method of noting the medication of a patient - they do have consistent shorthand for a given medication, but not a consistent order, or number of medications - into a...

Hello, Has anyone else had difficulties merging to WordXP? If i build the document in Word, and then find data source, i can't access any queries that involve unions. I've managed to get around it by appending to a table, and merging the document with that table, but still.... I never get...

Hello, I have just encountered my first client who has both accessxp and wordxp. The database, which happily mailmerges on my computer, will not on hers. I've tried every which way i can think of, but always when I'd expect to have the message asking for dde or odbc connections etc, it never...

Hello, I have just placed a new system for a client, on a newly established network. It has 5 machines, each with their own front-end, and a back-end on the server. What appears to be happening is that error messages saved as text documents are appearing in a folder called mdbdata, a sub...

Hello, I have recently noticed that the code i used to be able to use: dim r as recordset dim q as querydef can no longer be used and now i have to define all my recordsets and querydefs as objects. I have accessxp, and used to use access97. It is possible that all my previous programming i...

Hello, Do pivot tables exist in Access 2000? I've jumped directly from 97 to XP, so don't know. My XP version, set with Access2000 as it's default, allows me to build pivot tables, but when i use the database on a true Access 2000 version the pivot tables aren't as it were. Thanks - Anna

Hello, I have just put a copy of a database i have built, onto a new laptop with windows xp and access 2000. The strange thing is that none of the forms show any fill colour - background, text boxes or rectangles. The text boxes and rectangles will show a border colour, so it's not as if the...

Hello, I have just tried to mailmerge a query to word xp, and i can't seem to get anywhere except by using the wizards. Somehow, through one of the wizards i have linked the switchboard items table to the document, and now i can do nothing else. I've tried new documents, and the only...