Make A Form Completely Borderless During Runtime.
Feb 5, 2006
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
View Replies
ADVERTISEMENT
Jul 9, 2014
I have a form with a drop down that links to a table where a user can select or type a record, If they type a record that isn't in the table, the form goes completely blank.
Is there a afterupdate event I can do so that if the record doesn't exist, then a msg prompts and the form isn't completely blank?
View 2 Replies
View Related
Mar 6, 2013
Quick question with respect to Ms-access Forms.I have a few forms on my database. I have created a button and set it's click event to open another form in addmode, but when the form opens all my field borders ar missing. I have attached a screen shot of the issue I am facing. All the text fields are border-less I dont know why.
View 2 Replies
View Related
Nov 9, 2005
Good afternoon all,
Really struggling with my structure and have been looking at it for so long my head hurts so any advice would be great. (see attached)
Basically, I want a DB for keeping track of service / repair of electronic machines. Many of our customers also call us for tech support. There are a number of other items like purchases but once I have worked out one, I can then copy the methods.
Are my relationships even remotely correct?
I cannot get the calls log to work - loosly based on the sample a supplied with Access "contact managment".
:confused:
Any help / advise would be greatly received
View 3 Replies
View Related
Sep 6, 2006
I've been working with this access database for a professor for about a month. Each time I try to do totals, I always get a larger value than it is suppose to be.
Say, I'm suming three fields that have 3, 4, 5 in them, instead of getting 12, I get 50. This happens all the time and I've had to redo the output data several times because the result I got was always outrageously wrong.
Any idea what is going on, or maybe some advice?
View 2 Replies
View Related
Apr 5, 2013
In a report there is a text box that disappears if certain data appears in a record. It is supposed to disappear but I cannot determine why it is disappearing and I need to fix the criteria that make it disappear.
The text box is unbound (the control source is ="Bonus Point Legend"), and there is not any code that refers to it, nor are there any references to it in a query (I can delete the text box and the report runs just fine). Interestingly, if I add a new text box and use the paint brush to format it based off the one in question, it also disappears and acts just like the one in question. But I can't find any code that even references a generic control and makes it invisible. The tag field is not in use either.
View 1 Replies
View Related
Feb 21, 2006
hey,
i want to create a on runtime. i know hoe to do that ... what i don't know is how to make the form format to be the same as the form it was called from.
i want all the visual attributes to be applied to the new form.
thanks
refael
View 3 Replies
View Related
Dec 20, 2005
Hi all,
I am new to all this database stuff and new to your forums so please be gentle :P
I have a database i have made, only a small project atm but filtering by form is a big part of the workings of the database. Now as i understand it the filter is not included in Access RunTime2000 is there any way to create a form to simulate the above filter ?
Thxs in advance
Adam
View 3 Replies
View Related
Feb 14, 2006
I have a form that contains a field with an On Click event procedure to send the value in that field to a corresponding field on a subform attached to another form. Does that make any sense? The On Click procedure looks like this:
Private Sub FieldNameonCurrentForm_Click()
Forms!frmMainFormName!fsubSubFormName.Form!txtFiel dName = me.FieldNameonCurrentForm
End Sub
I’m not quite sure what I am doing wrong. I am getting the Run-time Error ‘2465’ and it is pointing out that it is unable to find field ‘fsubSubFormName’. I have double (and triple) checked the names and I have not misspelled the names of the form or subform. Did I set up the event incorrectly? Could it be that I am not calling the subform the correct way? Any ideas? .....
View 1 Replies
View Related
Mar 7, 2015
I was trying from a button on my form that will go to and bring up the desktop. I want it so I can put this database on anyone's computer and the button will work.
I am using this and it works but only on my computer.
Application.FollowHyperlink "C:UsersBryanDesktop"
I also tried this
Application.FollowHyperlink "C:Show Desktop.scf"
And
Application.FollowHyperlink "C:WINDOWSSystemShow Desktop.scf"
Both gives Runtime error 490 cannot open specified file.
View 14 Replies
View Related
Jun 22, 2014
I am currently creating a form which includes a command button to update a field in a table to show Today's Date, at the time of running a query I am still yet to write.
I have the following code for my Command Button, which is returning the Runtime Error 3464 (Data type mismatch in Criteria Expression):
Private Sub cmdAddTodaysDate_Click()
CurrentDb.Execute (" UPDATE tblMyTable SET TodaysDate = " & Date & " WHERE tblMyTable.ProductCode = " & Me.txtProductCode)
End Sub
The query above seems to be having issues matching the text from the 'txtProductCode' textbox to the table field 'ProductCode'.
View 7 Replies
View Related
Feb 6, 2014
I created a small database with a user login form, along with a password reset form. Running it in my sandbox as an accdr file, the password value resets just fine, but on my test machine with the Access 2010 runtime installed, the password reset form doesn't reset the password. I will try to describe the state of things as of this point.
1. The LoginF presents with a combo box for the user to choose their name, and a text box to enter their password. The code below is on the After Update of the password text box.
Code:
Private Sub txtPassword_AfterUpdate()
'Check if user has been chosen
If IsNull(Me.cboUser) Then
MsgBox "Please Select User Initials", vbInformation, "Warning"
[Code] ....
2. The password reset form has two text boxes for the new password and to re-enter the same, as well as a command button with this code.
Code:
Private Sub cmdResetPassword_Click()
If Me.Password = Me.PasswordTest And Len(Me.Password) & "" > 0 Then
DoCmd.RunCommand acCmdSaveRecord
DoCmd.Close
DoCmd.OpenForm "LoginF"
[Code] ....
As I say, this works as an accdr file, but not in the actual runtime environment.
View 1 Replies
View Related
Aug 2, 2012
I'm trying to open a recordset in vba and I'm getting the 3061 runtime error,Expected 1.
I'm trying to open a recordset with a query that uses a reference to a form control.
Code:
searchtable1 = "qInVisio_RSV"
Set rs = db.OpenRecordset(searchtable1, dbOpenDynaset, dbSeeChanges)
This is the sql of the query:
The highlighted parted is the form referance ( I know it's obvious, just for easier spotting )
Code:
SELECT dbo_FOLIO.FOLIOID, dbo_FOLIO.KIND, dbo_FOLIO.RSVID, dbo_FOLIO.CHKIDATE, dbo_RLIST.ROOMID, dbo_ROOM.ROOMNO, dbo_AGN.LINAPRG
FROM (dbo_ROOM INNER JOIN (dbo_FOLIO INNER JOIN dbo_RLIST ON dbo_FOLIO.RSVID = dbo_RLIST.RSVID) ON dbo_ROOM.ROOMID = dbo_RLIST.ROOMID) LEFT JOIN dbo_AGN ON dbo_FOLIO.AGNID = dbo_AGN.AGNID
WHERE (((dbo_FOLIO.KIND)=101) AND ((dbo_FOLIO.CHKIDATE)>=[Forms]![frmCleaningPlan]![DTPicker]));
also as you can see it's a datepicker control, so the value is a date...
View 2 Replies
View Related
Jul 24, 2013
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 Related
May 16, 2005
I 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.
View 1 Replies
View Related
Oct 8, 2005
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
View 2 Replies
View Related
Jun 29, 2006
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
View 7 Replies
View Related
Jan 2, 2008
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
View 6 Replies
View Related
Sep 20, 2005
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
View 3 Replies
View Related
Jan 30, 2006
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!
View 7 Replies
View Related
Feb 14, 2006
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
View 3 Replies
View Related
Mar 15, 2006
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
View 4 Replies
View Related
Mar 20, 2006
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.
View 6 Replies
View Related
Jun 15, 2007
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
View 1 Replies
View Related
Apr 13, 2005
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
View 1 Replies
View Related
Jun 29, 2005
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 Related
