Search results

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

700 instances of one survey! Thanks for all the help, i wish i had thought of searching under survey before i posted, to save your energies! Anna

Then perhaps i do need help. 700 + surveys have been carried out, each survey has 500 + questions, many of the questions have a choice of answers, some of them the same answers. My thoughts were to make the answers to questions be seperate tables, used as a look-up for the relevant...

Really? There are hundreds of each survey - isn't each field a question, and each survey a record? Anna

Thanks Ken, I'm happy doing it, i just wasn't sure whether to have a few tables with 200 or so fields, or more tables with fewer fields, from an efficiency point of view. Anna

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

Wayne, Thanks for the reply. I did half try this before, but got into trouble because i couldn't figure out how to pull the field i wanted to compare into the function. It appears in the query that drives the report, if i am running the function from within the query, how do i name the field...

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

Busterthedog, Thanks for the information. Do you still get a box titled 'Choose Table' which lists some of the queries (the ones without form specific criteria). I do, and then by pressing cancel, the box disapears and the mail merge works beautifully. Have you discovered a way to prevent...

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

Sorry, I've just gone back to try it again - should have done that first - but its the OLE DBfiles that replicate the list of available tables and queries, though queries are listed as views. Anna

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, Access can't add a null value, which is different to a zero. I have two thoughts: 1. Set your default value for each of the four figures to zero, then it will never be null, and the addition will work - note: you will have to go back and amend the records already entered as default...

Am I right in assuming you have already created a query that calculates the numbers you want, you just want to be able to display those numbers in a form? If so you want to use Dlookup as the source for each of the 5 textboxes on the form. =dlookup("[CountofProd]","NameOfQuery","[prod] = 1")...

Hello, Date() means the current date. So if you change your criteria to: between [enter start date] and [enter end date] you will be able to enter the two dates you require. If you are not located in the US, be careful of the BETWEEN function and dates not specified mm/dd/yy Anna