Tab Pages To Change Automatically
Nov 11, 2007
hi...
im trying to create like a test in access. this is the idea. the user open the first form to enter the info like student number, name and so on. when he clicks the button he goes to another form where is the first question. in the top part is the student number wich was obtained from the First form and an option group with the answers to the question of the label box. Also a timer was included so the form close after one minute using the form_timer event. everything seem to work fine but when i go to the table to see the answers of the student, it look like if the student took the test for the number of questions, in this case forms, so if there is 20 questions(forms) it appears 20 times under the same student number, cuz all the questions are in diferent forms. then i try to take out this line from the first form when the user click the button:
DOCMD.GOTORECORD,, aclast
when i take that line out it seem to work fine only that when the user click the cmd button it goes to the first record instead of the active student record.
So then i thought of tab pages making them not visible until the user click the cmd button. it work fine with the cmd button but how do i put a timer to all the tab pages so that when time expires the next tab appear??
is that a bit hard??/
any help would be appreciated, thanx
View Replies
ADVERTISEMENT
Nov 3, 2006
Hi,
Is there any way to change orientation of report in report footer? I mean, I want to produce report header, detail etc in landscape and after detail I have given page break, at last page only report footer should be in portrait.
Rahul
View 3 Replies
View Related
Nov 3, 2005
Hello to all the xperts out there,
I have a query with this criteria for Date field:
Where (([tblList].Date)>=#11/1/2005# And ([tblList].Date)<#12/1/2005#))
Is there any quick way, besides creating a form and run the query based on it, to have this criteria updated itself when it's a new month? I've gotten tired of changing it every month.
Thanks in advance
View 2 Replies
View Related
Feb 13, 2006
I'm creating a leave (holiday) database but each year must be kept seperate for analysis. (I have split the front and backend of the database) I thought of using a dropdown on the main page which could be used to select the year which relates to the leave being dealt with. Depending on the choice selected (present financial year as default) the links would update to the required database.
Any ideas?
View 6 Replies
View Related
Dec 5, 2012
I am new with Access database and I found almost everything i needed on the internet. There is only one thing I just cant figure out when this looked like one of the easier things. Im making a database where all soorts of keys of all kinds of companies and homes are stored. In this database I want to keep track of the keys that are being used, who has the keys and when the keys are taken and brought back.
Most of these things work except one thing. In the table where I have the keys I have a field wich is 'In use'. This is a yes/no field and I want it to be yes when someone takes a key and to switch back to no when someone returns it. This is possible if it is done by the employees who use the keys but i want it to go automatically so no mistakes are made.
I have one table for the keys, one for the employees that take and return the keys, I use a master with detail form for when someone takes or returns a key and this is all shown in a query.
View 14 Replies
View Related
May 18, 2014
In a field called PSSheets I want the number to be update every new entry, if I use the AutoNumber feature it won't let me enter the number I want to start with, which is 1421001, then the next number would be 1421002 and so on right up to 1421200 and then the number would change to 1422001.
14/21/001 relates to Year/Week/Entry.
View 4 Replies
View Related
May 9, 2006
Hello,
This is the first time I am join this web & forum. My name is Angie.
I have face some problem for Ms Access. I would like combo box to be auto change when date due. Eg: combo box name: Status. Inside have info such as Expired, Active, Ignore. This info will base on the text box name txtenddate. When the date is due, (eg:today:09 May 06), combo box will auto change the status from Active to Expired.
Any VB code can be used. Thanks.
Hope to heard from you soon.
Regards,
Angie
View 1 Replies
View Related
Feb 24, 2014
I have a table named days contains two columns (Day_Number, Day_Number_text)
and another table named information contains many column two of them is (Day_Number, Day_Number_Text)
so what i want to do when day_number = 1 for example so day_number_text = Frist automatically
View 7 Replies
View Related
May 26, 2012
I'm making a db that will import a spreadsheet from Excel, then separate it into 3 different tables using queries, but then I need to put all the 3 different tables together one after the other. The problem is that the 3rd column on each table have different names on each table, so I can't append the tables together.
So, how can I use a Macro or something to change the column name on all 3 different tables so that they match and can all get appended together.
View 2 Replies
View Related
Dec 8, 2012
I have a form with one control field that I paste a 17 digit alpha numeric value into. I have a command button that then runs a query based on the pasted value.
Is there a way to automatically change the data I paste to include the first eight characters, replace the 10th and 12th position with wild cards, and delete the remaining 6 characters ?
Example:
Copy: 1GTEM14M0WZ526688
View 3 Replies
View Related
Mar 16, 2013
Is there any way of making data that is inputted in lower case to automatically change to the first letter of each word being a capital ...
View 4 Replies
View Related
Apr 3, 2006
I have a database with 4 tables One for agent info and 3 for property info.
I have linked the agent table to the property tables.
I need to setup a link for the agents. If I have an agent and they click on see my property, Do I have to have a page for each agent or can it be done with one page?
View 2 Replies
View Related
Aug 29, 2006
Hi,
I want to open up a certain page of a tab control using VBA code.
For example: when user presses a button in a form, tab number three of a tab control opens in an other form.
Any help will be very much appreciated.
B
View 14 Replies
View Related
May 6, 2007
This might be a question that isn't possible, but I have three html pages made in my database, and i was wondering if there is a way to link the pages into the switchboard somehow because then everything would be accessible from one central location?? if you have any answers or sugestions they are greatly appreciated! thanks
View 4 Replies
View Related
Nov 13, 2007
Hi im trying to see if there is a way to put a timer in tab pages. so that when the time expires it changes to another tab. I have it working fine with the command button. I have like 20 tabs all hidden until the user clicks the cmd. Now is there a way to put a timer? I know that i can do it with the Form_timer, but that dont seem to work with tabs.
thanx
View 8 Replies
View Related
Sep 23, 2005
I am using the "Tab Pages" on a form. On one of the pages I have a subform. If I'm doing a routine in VBA regarding that subform, do I need to reference the Tab Pages object as well as the form and the subform?
View 2 Replies
View Related
May 26, 2006
Hello,
I have a form with a lot of controls. To make it much more clear for users, I was thinking of adding tab controls or page breakes.
I have placed a tab control with two pages on my form and tried to move the existing controls on the required page but of course the control will show on all the pages.
Is there a way to bypass this without having to create a new form and placing controls one at the time?
Thanks
View 2 Replies
View Related
May 9, 2005
Hello visitors,
I have a report base on a select query but in the report i get the following:
page 1 = record 1
page 2, page 3, page 4 = are empty (nothing to see on the pages)
page 5 = record 2
page 6, page 7, page 8 = are empty (nothing to see on the pages)
page 9 = record 3
...........etc...
So there are three empty pages between every two pages(records).
I have checked in the settings of the report and all properties but cannot find the solution.
Can any one help me to solve this ?
Thanks in advance
View 3 Replies
View Related
May 13, 2005
Hello Experts..
I am new to Access. I have Access 2003.
When I try to create a data access page using Wizard, I am getting the following message.
'The wizard is unable to create your data access page'
When I click on Database and select Refresh, I get the other msg
"Microsoft office access is unable to connect to the data source specified in the connection string of this page"..
I am very badly stuck here..Please help.
Thanks in advance...
Arun.
View 1 Replies
View Related
May 13, 2005
I am getting very frustrated(and surprised) to see there was no answers to my question regarding Data Access Pages yet. I searched the web and manuals and help in Access, but no luck yet...
Can anyone tell me if Data Access Pages really works? I just came to know about it while developing MS Access application...I just thot it will be cool to go web with less effort...
Thanks very much...
------------------------------------------------------------------------
Hello Experts..
I am new to Access. I have Access 2003.
When I try to create a data access page using Wizard, I am getting the following message.
'The wizard is unable to create your data access page'
When I click on Database and select Refresh, I get the other msg
"Microsoft office access is unable to connect to the data source specified in the connection string of this page"..
I am very badly stuck here..Please help.
Thanks in advance...
Arun.
View 7 Replies
View Related
Aug 9, 2005
I'm setting up data access pages that will be accessed over the internet. Because of this I want to make sure that everything is secure. I am using IIS 5.0 (Windows XP) as the web server. I used the three-tier authentication approach discussed in the microsoft article here (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k2/html/deploydap.asp) So I'm pretty sure that the authentication is secure. But what about the communication between the browser and MSDE during databinding? Is that secure?
Wanting to make sure I set up a SSL certificate which secures the page and set the Remote Server in the connection settings in the data access pages to "https://domain.com". Does this secure the comminication between browser and the server?
Thanks in advance
View 1 Replies
View Related
Dec 6, 2005
If I build an access database that uses data access pages, are all users required to have a copy of the MS Access software, or does the database run strictly off of the browser?
View 1 Replies
View Related
Aug 21, 2007
This is the first time ive used the switchboard so hopefully this will be just a quicky!
Bascially i have a main switchboard which has 3 buttons. These buttons all link to different switchboard pages.
THE PROBLEM :- I have labels on the main switchboard and these are all appearing on the consequent switchboard pages. Is there a way of assigning these just to the main switchboard and not the other pages?
Thanks, any advice would be most appreciated!
View 11 Replies
View Related
Nov 19, 2007
Novice user here. I have created a database with tables,queries,forms and reports. I'm now trying to create a webpage that will run the reports i have created. At the moment i'm the only user that will run these reports (via webpage) so the database is on my computer.
I have created a data access page using a query but the records are displayed 1 by 1. I need it to display like my reports.
Sorry if you're confused. Thanks for any feedback.
View 1 Replies
View Related
Jan 20, 2006
Please can anyone tell me how to make this pages editable when displayed as a web page.
I don't know what property to set that would allow data entry.
View 1 Replies
View Related
Jul 16, 2005
I have a number of tabbed pages and I was wondering if you could increase the size of the tab to make it (Vertically) larger so you could write the headings over two lines.
Also what does "Multi row" mean in the tabbed row pages?
View 1 Replies
View Related