Search results

Hello, Is there a way to program a Next Page button for a tab control that can be put in the form's header and that'll go to the next page, regardless of what page I am on? Thanks.

I can't show those things because don't want people to browse the records at all while entering information. Plus, it looks better. My application is a questionnaire-type db, and the 2 subforms I am talking about are subsets of my answers table, which pulls questions from a questions table...

Ok, that makes a whole lot more sense. I happen to have the selector switched off, but I would assume that generally, the first record shown on a continuous form is the current record. How do I go to record number 6 then? Is there something like "set current = 6"?

Hello, I already asked this question in the Forms section, but maybe this is a more appropriate venue. I have a parent table that is linked in a 1->many relationship to the Answers table via RecordID. The Answers table in turn is linked to a Questions table via QuestionID. The Answers table...

I'm afraid I just can't wrap my head around the idea of this "current record". I mean, how does Access determine which is the current record? And how would it know that the current record is really the record I need? Suppose I have 10 records from a child table that are shown in a continuous...

I guess that depends on your calendar. I found this lovely calendar to enter dates, and to move that from db to db, I don't export, but import the form itself, and the program module that is required, into my new database. Maybe all you are missing is that module, if you need one, or maybe...

Thank you! What you posted here didn't quite work for me, but it led me down the right path, and with some experimentation, I finally succeeded. Now when I enter a location that's not in the list, my entry form pops up as a little window, I enter data [new location name and details], save and...

This may be what you are looking for: http://www.microsoft.com/office/community/en-us/default.mspx?dg=microsoft.public.access&tid=bd8ea019-55f3-479c-bf5d-0859c399295a&cat=en-us-office-access&lang=en&cr=US&sloc=en-us&m=1&p=1

I know this is not really what you were asking about, but at this URL you can find a way to colour command buttons themselves, plus a ton of other very useful utilities. Can't hurt to take a look, can it? http://www.lebans.com/cmdbutton.htm

Hm, maybe I didn't explain this very well. The first subform shows two records - a checkbox and a text field each - and both, either or no checkbox can be checked. So both could be the current record at one point, meaning - if I understand you correctly - that my subform could be made visible...

Hello, I have a continuous subform that shows 2 records consisting of a text field and a yes/no field. I was wondering if it was possible to take the state of one particular of the yes/no fields to trigger an event. Specifically, when one of the questions is checked [true] then I would like to...

Thank you for your sample db, that turned out to be very helpful.

Oh, I figured it out: Me.TabbedMenu.Pages(1).Visible = False Me.TabbedMenu.Pages(2).Visible = False etc.

Hello, I would like to hide some of the tabs of my tab control on load, and make them visible only later via another event. How do I hide individual tabs vs. the entire tab control? Thank you.

What you could do is create a macro that first opens form 2, and then closes form 1. Only catch is that this doesn't seem to work On Lost Focus. If attached to a command button, however, it functions beautifully.

Hello, I am using a continuous form for data entry, and every time I tab out of one record, a new one is created automatically and shows up underneath the first one. The reason for this setup is so that users can add information into a child table, but the number of entries that are added per...

You can set a query property so that only unique data is shown, have you tried that yet? I believe there are 2 different versions - Unique Record, where the entire record has to be unique - and Unique Values, that doesn't look at the entire record. Unless you've tried this already, I suggest...

Tahoma works very well, thank you. It's a bit larger than Arial Narrow, but more legible.

Sorry, I didn't mean to come across as "violent", I was simply puzzled as to what you were trying to do. It sounds like a total misuse of a database, but I guess it's a good programming exercise. Good luck with it.

Thank you! Actually, the culprit in my case was the default font, MS Sans Serif - it just won't scale down below size 8. I found that out when I tried a different approach and select a smaller font. Now I'm using Arial Narrow size 7. That's the smallest I could get that that's still legible. :)