I have 3 tables.
1. Bulding numbers....1 to 15
2. Rooms....each bldg. has 22 rooms so altogether 650 rooms
3. Maintenance work...for each room every maintenance work
Now I need form where by choosing room# I can found what work was done.
I would post a file but it excedees 100kb
thank you
how to make my form controls change size / position as my form is resized / loaded on a computer with a different resolution. Several of the tutorials out there suggest putting code on the "on resize" property of the form. When I looked at the Northwind database to try to mimic their code however, it looks like they must be doing something different as there is no on resize code under the form properties and I was unable to find the code they do use.
View 4 Replies View RelatedI have several forms that can be called from more than one other form, but I need to build my forms so that the user is returned to the form from which they started.
I have looked in the help files and FAQ and I can't find what I am looking for.
Please, can someone direct met to the required information or tell me how to achieve this?
Thanks,
Kev.
hi i am making a database and i need some help trying to make this form if anyone can tell me how to make this form can you MSG me!!!!!!!!!!!!!!!!!!!
i trying to make this Form
http://office.microsoft.com/en-au/templates/TC010178391033.aspx?CategoryID=CT011366681033
it the CALLS tab on the form
anyway thanks for trying to helping out if you dont know how to do it
Can this be done?
I would like to genreate a query from a form. So when I want to run a monthly report for a month I can pick a mont or a date range and a criteria for the form such as crew meetings attended, paperwork in on time or up to seven different points of interest for a particular person.
I can do this relative simple in parameter query, but he users want a more efficient input form. Or maybe the word i "quicker". And if they use a drop down box from a data table to start the form/query, there won't be as many input errors.
THANKS,
Nav4
Greetings. I have three forms that are open at the same time. They are related and cascading. The first form (frmEventAdd) is the anchor. Each event can have many Trials. The second form is frmTrialInfo. Each Trial can have three Classes. The third form is frmClassInfo. These forms are used for update and adding new records.
The user displays an event for update (frmEventAdd). Then clicks on a button to display the Trials for that event (opens frmTrialInfo). frmTrialInfo displays information for one Trial at a time. The user clicks on a button to display class information for that trial (frmClassInfo).
One of the fields on frmClassInfo is called cboJudge. It's a combobox with names of Judges (judges of dog competitions). The judge information in the combobox comes from two tables: tblPeople and tblJudges. If the user wants to add a new judge they may click on the btnNewJudge. btnNewJudge will open a form that is used to add a new person (frmPeople).
Because frmPeople is opened from many different points in the application, I found it easier to simply make the three, already opened, forms INVISIBLE.
So...command button btnNewJudge opens frmPeople and makes frmEventAdd, frmTrialInfo, and frmClassInfo INVISIBLE.
When frmPeople is closed (btnClose), it checks to see if each of the previously opened/visible windows is open and then makes each VISIBLE, again. frmEventAdd and frmTrialInfo reappear just fine. However frmClassInfo does not.
I have traced the btnClose_Click routine in frmPeople and it certainly looks like every line of code is being hit, but the line that should make frmClassInfo visible does not do anything (nor does it generate any error).
Here is the code from btnClose_Click in frmPeople. Can you help me?
********************************************
Private Sub btnClose_Click()
On Error GoTo Err_btnClose_Click
Dim blnEventAdd_Open As Boolean
Dim blnTrialInfo_Open As Boolean
Dim blnClassInfo_Open As Boolean
blnSecondChance = False
If blnDataChanged = True Then
If DataHasChanged() = vbYes Then
Call btnSave_Click
End If
End If
'================================================= =======================================
'blnSecondChance=False = NO SECOND CHANCE ... Close this Form
'blnSecondChance=True = USER GETS A SECOND CHANCE ... Do NOT Close this Form
'================================================= =======================================
If blnSecondChance = False Then
'Zero out Relative Record Number from Array
svRecNo(intCallerIX) = 0
blnDoUpdate = False
blnDataChanged = False
DoCmd.Close acForm, Me.Name
'Is the frmEventAdd form open?
blnEventAdd_Open = SysCmd(acSysCmdGetObjectState, acForm, "frmEventAdd") And _
acObjStateOpen
'Is the frmTrialInfo form open?
blnTrialInfo_Open = SysCmd(acSysCmdGetObjectState, acForm, "frmTrialInfo") And _
acObjStateOpen
'Is the frmClassInfo form open?
blnClassInfo_Open = SysCmd(acSysCmdGetObjectState, acForm, "frmClassInfo") And _
acObjStateOpen
If blnEventAdd_Open Or blnTrialInfo_Open Or blnClassInfo_Open Then
If blnEventAdd_Open Then
Forms("frmEventAdd").Visible = True
Forms("frmEventAdd")!cboContact.Requery
Forms("frmEventAdd")!cboSecretary.Requery
End If
If blnTrialInfo_Open Then
Forms("frmTrialInfo").Visible = True
Forms("frmTrialInfo")!cboTrialRep.Requery
End If
If blnClassInfo_Open Then
Forms("frmClassInfo").Visible = True
Forms("frmClassInfo")!cboJudge.Requery
End If
intCallerIX = intCallerIX - 1
Else
DoCmd.OpenForm PopCaller(), acNormal
End If
End If
Exit_btnClose_Click:
Exit Sub
Err_btnClose_Click:
Call ShowError("frmPeople", "btnClose_Click", Err.Number, Err.Description)
Resume Exit_btnClose_Click
End Sub
******************************************
Regards,
SueB
Hello,
I have a query by form named QBF_Form, I use it to help users query a form without having to open the query directly. A query, Cert, is based on this form using expressions like:
Like Forms!QBF_Form!Sales & "*" Or Forms!QBF_Form!Sales Is Null
This Cert query is a source for a form called Manage. I have a macro to open the "Manage" form, run the Cert query, and close the query . Everything works fine when I do this.
But when I click on the Manage form directly, I get this: Enter Parameter Value:
Forms!QBF_Form!Sales
How can I prevent this from happening? How can I change the logic?
Thanks for your help again!
I have a form that has a subform in it. I want the key field in the form to dictate what fields show up on the subform. When I try to set the Link child and master fields, I get a 'can't build a link between unbound forms'. How do I make this subform bound to the form????
Thanks, JOe
Hi, I am new to Access. Pardon me if I post it in a wrong post. I've a field name "HotelAmt" in "Meeting Members " table. I've four fields on the form 1.Hotel arrival date 2. hotel depart date 3. Hotel Cost/night 4.Total Amt.
All these fileds are in Meeting Members table. I gave the formula to calculate "Total Amt = ([Hotel Depart date]-[hotel arrival date])*hotel cost" I put this formula on Total Amt field on the form (properies-control source).
This one is working on the form.
My question is, when i make query for this to pull total Amt, its coming $0 (defalult) . I checked back in the Table, there its not inserting the Total Amout.
Anyone can you please give me the answer.
Thanks,
Sam
I am trying to make a class attendance form, where user chooses classType
ex:"English, French" then the program shows all of the students from tblStudents that are enregistered in that class. And some how make it so that user could select on or many users in the same class and press add button which will add the students into attendance table for the current class and the current day,
**Allso what I would like to do if possible after the form above works, is to if the student has been allready added for the current day, the check box becomes un editable with appropriable comment in the comments line for that student or for examples the student registered for 12 classes, the attendance keeps track of the classes and when the student tryed to go to 13'th class the check box is uneditable and in the comments line for that student metions the reases.
Hi.
Is there any way to make a form open up when every thing else is closed.
Can I make a macro that will check if everything else is closed and then open the startup form again?
Is anything like this possible?
Thanks
Richard
HI all
I have form containing some filtered records. What code do I need to put on a button to trigger a make-table query; the make-table thus containing only the current filtered records (not the entire database).
The following will use the entire database:
Dim stDocName As String
stDocName = "qryMakeTableCompanyID"
DoCmd.OpenQuery stDocName, acNormal, acEdit
Thanks
John
Okay this i definately need help with. I want my form to behave in the same manner as a datasheet in that it just displays rows of data. I want to create this how do i do that.
View 3 Replies View RelatedI have a form display project hours and also caculation of total for each project.
A user can spend time on multiple projects each day, I would like all zero invisiable. I had tried to set all default values to null (nothing) instead of zero. It causes problem in caculation of total.
I remember in Excel, it can make zero not to display, can we do this on an Access Form?
(Something I also want to know if this is possible. This is a time sheet, is anyway we can do on the form that projects (records) can be displayed horizonatally (on the top) while the dates can be displayed vertically (on the left), ,more like a transposed. But it would not change the struture of database (just display) so the date remains a field and projects are records.)
Thank you for help. Happy July 4th
Access 2003
Database for tracking job search/applications
I have three tables: Job (includes employer, contact) and Contact (First name, Last name, employer), and Employer (Employer name)
Form.Job is the main data entry mechanism. On this form, I enter the job details. I select the employer from a combo-box that draws from the Employer table. I would like to select the contact from a combo-box that filters contacts and shows only those that match the Job.Employer selection.
:confused: 1. How can I make a bi-directional link so that a new entry in the employer combo-box creates a new entry in the employer table? At the moment, I get around this with a "New employer" button on Form.Job that just opens up the employer table, but there seems to be an updating issue - new names don't show up in the combo-box for a while
:confused: 2. How can I get the contact combo-box to show only contacts with an employer that matches the employer selected in the employer combo-box?
Note that I got this to work once by using a sub-form, but I don't really understand how (presumably Access defaults that did what I wanted), and I don't want to have to use a sub-form.
Ben
Hi,
how do i make the fields in my form uneditable(cannot delete or add but can copy a field from form), i tried setting the properties..allow additions deletions by setting it to no, but even then when i open the form and when data is dispalyed , if i go jus delete (say address field)a field it just gets deletd,
i tried locking the fields too!..nothing worked,
so how do i do this,?
p.s IF i set allow edits to No then i am not able to copy the field (say name has to be copied and pasted into another application or something) how could this be accomplished.
tried setting it in VBA as formname.form.allowdeletions=false , still no luck!
Pls help!
Thanks!
When a certain button on a form is click it makes a sub form become visible, I am trying then to make this form exclusive aka, must be complete and stop the user clicking on the main form until this sub form has been complete.
View 5 Replies View RelatedI have built a database and setup my Queeries and Reports and setup my securities. What I want to do is make the Form open from a short cut. I can create the short cut with the security privilages but after the proper name and password is entered I want it to open straight into the Form. How do I get my database to do this?
View 14 Replies View RelatedAfter data is entered into text box, on the "On Enter" event, how do I make it click a button on the form?Similar to the effect of when you enter your username then password, most people just hit enter on the keyboard to auto click the login button.
View 1 Replies View RelatedHi,
In Visual Basic of the form,
Suppose I have a form "na",
I want to create another form using the VB, the form style and format as sama as the "na", all the fields are same, same positions.
Dim frm As Form
Set frm = CreateForm(, "na")
DoCmd.Restore
frm.RecordSource = "na"
I tried these code, the code is created based on "na", but it still needs to add the fields, and it will automatically open the design view to design, i want to VB to copy the "na" design to the new form.
How can I write? Does VB copy the same design and format to the new form?
Please let me know,
Thanks.
Having had a pretty good look around, I think I must have missed something...
I just want to try and make a Forms single Address textbox = multiple table fields values:
Add1
Add2
Add3
PostCode
Cheers,
Pailin
Hi,
Just wondering how can I make a form that shows only 5 months old records. I know it has to be through a query but don't know how to proceed.
Thanks
Rajput
I want to make my Intro of Database. When I open it. Just like you open NorthWind(Sample) database.
How to Remove the Title WIndow of Form.With all sides just like in NorthWind.
also removed the Record Navigation (|< < 1 > >| >*). I saw every option in Form Properties but didnt find.
Please Let me help in this Regard.
My second Question If I only want to remove Record Navigation only.But Title window displays.
May be from first question I can also get my answer.
Thankful in this regard.
Hi.
As you know it's not possible to set the "BorderStyle"-property of a form during runtime.
But thats a kind of functionality, i need to use in my Access 2003 application.
I need to 'simulate' the value "none" during runtime, that means that there is absolutely no frame/border around the form.
Design-mode is not possible, because i need to use a MDE file.
So i dealed with the APIs and nearly got it.
But i always have had a kind of very thin 'sunken'-frame around my form.
I also played with the extended window-styles, but the result was that i got a 'raised'-frame around the form.
Over all i really got wired in my head.
Maybe someone already did that too and can post the right api-calls / styles here?
I would be really thankful, because i quit that now after hours...
Regards,
AtzeX
Hi,
I have 2 forms, a master and a subform.
In the subform form there are some required fields. In the table behind the subform I choose the property of these fields to be required.
but in the master form, when I start enter the information I can go to the next record without even touching the subform.
How Can I make the subform required in the master form?
Regards,
CS.
Hello-
I have a database form where I have a lot of like data I type.
Can I make buttons to automatically put text into the form field?
How do I do this?
-Tim