Search results

I have a large database with many tables filled with student demographics etc. Each student is tied to one of 7 supervisors Field->SupID. I now filter these students for reports, input etc. by having the supervisors input their SupID number. What I need is someway to restrict them to ONLY...

I have converted a number of applications from 97 to 2K and in almost all cases they get smaller, sometimes less than 50% their original size. All are split databases. I see a greater shrinkage in the front end than the back end tables, but both show some decrease. Something else must be...

Use the Linked Table Manager and set "Always prompt for new location"

Could be size of text box Even when set to number type = single, you may get the APPEARANCE of rounding on the screen if the textbox showing the value is not wide enough. Interestingly, different screen resolutions can lead to different behavior on different computers. When I am trying to...

Make a clickable calendar I have developed a system that records the attendance for 600 students per month. The underlying table has the following fields: StudentID DateAbsence TypeAbsence ChargeAbsence On my form I have a combobox to get the student number and an option box to click on the...

Thanks for all the help -- I still haven't found a solution. The reason I put Access97 on my new computer is that I am a system developer and my most important client (who is running numerous applications I wrote in Access97) PROMISED me he was upgrading to XP and if I wanted to keep the...

I have installed Access97 on my new XP computer. I applied the SR-2b patch and my existing applications seem to be working OK EXCEPT the date function won't work. In a textbox for the controlsource I have =date(). This worked fine on my old machine. On the new one I get a #NAME error. If I...

Excellent. Just what I was looking for. The only thing else I had to do was set a 1 character input mask or you still need the enter key.

I have been asked to summarize the results of a survey that has already been conducted. Each participant was asked to respond to 200 questions with a multichoice answer null or 1 to 5. My table has 200 fields A1 to A200. I need to populate these fields with the answers but there are over 4000...

I have a table (query) that has over 5000 records with two fields, transdate (date), transreason (text). I need to sort them ascending by month (easy to do using format(transdate,"m") but I also need them grouped and sorted in the order July (first) to June(of next year, last). The school year...

I've had this happen when I replaced the controlsource of a bound field with an expression. For example, in the bound textbook [LastName] I typed "=[LastName]&"' "&[FirstName]" and then reference the [LastName] textbox on the report. Got the #Name error. You need to create an UNBOUND textbox...