First quetion
how can i make some form to be with two frames, one is the navugation tree and the second one is a frame that is changing akk the time, which means the navigation tree is not changing ever.
i am trying to build somthing like asp with two frames and a record set and i dont know how.
the second question i have is how can i put an html frame in a form? i have some link to sme web site in my database, andd i want this data base to be open inside the form of the access and not with my browser in a new window.
First quetion how can i make some form to be with two frames, one is the navugation tree and the second one is a frame that is changing akk the time, which means the navigation tree is not changing ever. i am trying to build somthing like asp with two frames and a record set and i dont know how.
the second question i have is how can i put an html frame in a form? i have some link to sme web site in my database, andd i want this data base to be open inside the form of the access and not with my browser in a new window.
I've created a frame but I'm not able to actually to put textboxes inside it, only radio buttons. Is there anyway to force textboxes inside the Frame? Thanks in advanced.
I need, in some way or another, to be able to import an HTML code from an HTML file into Access. It would be ideal if the end result is a table with one memo field named "HTML".
I know is seems strange, but I need the code itself. I've managed to do a bit of duct-tape work, and import from HTML, but this results in only the text of the HTML code (Meaning the text of the web page, not the tags).
I know I'm crazy for wanting this, but is there anyone out there who can give direction/guidance?
Well, I apologise now, because this will probably be badly explained, but anyway, I was wondering if there is a way to create a button in a form, which would act like a frame (or inner.HTML, etc). So for example ::
Button 1 | Button 2 | Button 3
And when you click "Button 1", it comes up with a certain section, and makes the others disappear, which could for example be a section of text, and a button to open another form, etc.
You get me? Sorry if you don't. I've always been quite bad at explaining this kind of stuff. If you don't, I'll gladly explain myself again.
I've used Access 2003 to create a database which contains a table linked directly to the "Orders" table on my mysql server. This table holds all of the customer orders placed on our website. I next created a form in access to give me a nice justified view of the orders.
My Problem? The field on the mysql server that holds the line item details for each order is a "Memo" field, and all of the text is formatted in html it appears. When viewed on the form, I see the all of the raw code, and not the nicely formatted text. If i highlight a section of the code from the form, and paste it in a Html editor (Frontpage for example), I see the line items nicely formatted as intended.
Is there a way to get this memo field to display the formatted html text instead?
My access skills are pretty limited, so detailed steps would be appreciated.
I am in the process of trying to build a template in forms for my boss to quickly enter information and construct a PowerPoint presentation from this information.
Basically, I have a form that he can enter information, but it needs to look professional (not datasheet view). Is there a way that I can make a subform and frame it, so that I can copy the entire form (not just the data) and paste it onto powerpoint? I need the formatting to be consistent and appealing!
I have a form that I am working on. I have enabled queries to be run by selecting on command buttons. All of my queries have a year field. I want the user to enter the year in a text box and then run the queries based on the selected year. I do not want any of the data in the queries to update except for the year field. I am not sure how to link the text box that I put on my form to my queries and get everything to update correctly.
If anyone could give me advise I would appreciate it.
lets say i have a data field which contains hyperlink for a html file, can i display the content of the file from the hyperlink in the form when the form is loaded?
I have a frame on a form with 2 toggle buttons in it - i want to be able to toggle the buttons to set criteria for a query which i can load as a report from clicking a button - is it possible to do with IFF? or is there an easier way - is it possible to have the report as a sub-report on the form and it to change when i toggle the buttons?
I am trying to figure out how to count the number of Yes's and No's on one record to produce a score. There are 39 total questions and each question gives the user a choice of Yes, No, or N/A. Each record will need to have a score attached to it. I appreciate all the help I can get.
On a continuous form, i have discovered how to enable/disable fields by checking/unchecking a box, but is there a way of enabling/disabling the fields for only the relevant record and not for all records?
Also in a continuous form, i would like no further record additions after the first record until a button is clicked on. Is this possible?
I have attached a copy of an excel sheet that my company has been using since the ice age. I would like to set up an access db, so as to eliminate the multiple files and make it easier to create new orders, rather that saving as a new file name all the time. However, does anyone have an idea of how I could use this same format for order entry? I need to ease our sales staff into this new idea and don't really want to disturb the form they have been using forever. Thanks for any and all suggestions, Chad
Hi all, i got a problem which i hope you guys will help me on. I created several forms, the main form with command buttons that leads to other forms where users can key in their conditions for queries, i.e. parameter forms
After building the SQL string using createquerydefs
i use the code:
DoCmd.OpenQuery "Requests_open_module", acViewNormal to open the query.
all these is assigned to a command button on click event. however when i click on the button in form view, the query result appears in a window behind the parameter form instead of on top of it.
so i tried: DoCmd.OpenForm "weekly_open_requests_result", acFormDS, , , acFormPropertySettings, acWindowNormal
where weekly_open_requests_result is a form linked to the Requests_open_module query. And i get the same result, upon clicking, the form appears at the back instead of on top.
finally i went to the weekly_open_requests_result form and enabled popup in properties window and it worked! however...it doesnt have "File" which i need as the user upon looking at the result, needs to export it to excel.
so what is wrong here? or is there any code that i can use to make the exporting to excel automatically; i will need the form to prompt the user for a name and directory to save to.
I'm not entirely new to Access, but I don't have the formal training or experience to accomplish what I'm attempting. And, after hours of research, I haven't been able to find anything that quite works. I know it's do-able, I just can't figure it out. Any help is much appreciated. I'm using Access 97.
In a form (MasterBadgeForm), all fields require completion. However, I want to force the user to complete 2 fields before any of the others are visible.
The 1st 2 required fields are: - HostLastName: ComboBox (user's last name based on a simple query called HostMasterQuery) - Visitor_Guest: Bound option group frame with option buttons "Visitor" (option value = 1) and "Guest" (option value = 2).
Note: The logic behind using an option group frame (instead of check boxes, etc.) is to force the user to choose "Visitor" or "Guest", but not both or none.
After both fields ("HostLastName" and "Visitor_Guest") are completed, I want 2 things to happen:
First: Depending on the choice selected in the Visitor_Guest option group frame, I want respective combo boxes to either be visible/available, or not. For example, if the user selects the "Visitor" option button, I want to make visible a combo box named VBadgesCombo (based on a simple query that has pre-defined "Visitor" numbers) and "hide" the combo box named GBadgesCombo. The same concept applies if the user selects the "Guest" option button.
Second: I want all the other required fields to become visible.
I've done a ton of research, but I just can't quite figure it out. Any help is much appreciated.
Code: 'Pacer frame set to proper background If Me.FrmPacer.Value = 1 Then Me.LblPacer.BackColor = vbGreen ElseIf Me.FrmPacer.Value = 2 Then Me.LblPacer.BackColor = vbYellow ElseIf Me.FrmPacer.Value = 3 Then Me.LblPacer.BackColor = vbRed
[code]...
I have multiple frames on one subform that when selected sets a unassociated labels back color. Then when cancelled by undo code the back color stays on the color that it was changed to on afterupdate event from the frame with option controls. I would like to loop thru but could not come up with the proper method if it is even possible.the above code works after refreshed, but just wondering if there is a shorter or more efficient method.
In my DB I have a query that I need to create a static webpage from, now in excel I can do the record button and bingo, but access is a lot more confusing.
I have a template named doc_tplt.html that when I do the export from the query it creates the webpage using this template.
I want to have a form with a selection of command buttons on it to export to html using the template for various queries and tables.
What is the VBA code to export the query (qry_docs) and apply the template (doc_tplt.html) and save to the same directory as the DB itself.
I am using the following search function to search my database:
Private Sub cmdSearch2_Click() Dim strLastName As String Dim strSearch As String
'Check txtSearch for Null value or Nill Entry first. If IsNull(Me![txtSearch2]) Or (Me![txtSearch2]) = "" Then MsgBox "Please enter a value!", vbOKOnly, "Invalid Search Criterion!" Me![txtSearch2].SetFocus Exit Sub End If 'Performs the search using value entered into txtSearch 'and evaluates this against values in strStudentID DoCmd.ShowAllRecords DoCmd.GoToControl ("LastName") DoCmd.FindRecord Me!txtSearch2 LastName.SetFocus strLastName = LastName.Text txtSearch2.SetFocus strSearch = txtSearch2.Text 'If matching record found sets focus in strStudentID and shows msgbox 'and clears search control If strLastName = strSearch Then 'MsgBox "Match Found For: " & strSearch, , "Congratulations!" LastName.SetFocus 'txtSearch = "" 'If value not found sets focus back to txtSearch and shows msgbox Else MsgBox "Match Not Found For: " & strSearch & " - Please Try Again.", _ , "Invalid Search Criterion!" txtSearch2.SetFocus End If End Sub Which i got from here: http://www.databasedev.co.uk/text_search.html
Question #1
I have my own record counter setup at the bottom of the form via this:
Private Sub Form_Current() 'Inserts current record number and total number of records Me.txtCurrent = Me.CurrentRecord Me.RecordsetClone.MoveLast Me.txtTotal = Me.RecordsetClone.RecordCount End Sub
I would like to have this show how many searchs were found. I really don't care about how many entries at this point... but if you do a search via lastname for "johnson" I have 15 right now.. I would like to let the end user know their are 15 enteries with the last name "johnson"... how can I do this if it is possible with what I have setup..
Question #2 How do I get the search lastname field to go blank after I hit the search button??
I have created a table with ole object types and linked word documents. I am now trying to create a report with the word documents showing up. The problem is that the size of the word document varies, some are half a page some are several pages. When I create the report with the object frame, I can't seem to find a control property to 'can grow'. Is there some way, possibly using VB, to create that feature. I'm thinking the VB way might be to access the embedded file and find out it's size and then size the object frame accordingly. I don't want to make the frame set to the largest document because then there will be blank pages that I don't want in the smaller documents.
I want to give the user the ability to run a report but display records based on different user defined time frames. So when I run the report it allows (on the Enter Parameter Value prompt) user to enter 30, 45 60 etc (to represent days). The report then looks at all records with a start date in the next x days based on what user enters
For a separate report, I want to be able to run the same report but give user (based on drop down) ability to view all reports or only those from today's date only.
Can i make an html of login form, whose data is saved in access as back end. I am curious to know. but of course simultaneous saving is considered yes in here...
2nd: i started doing access about 3 weeks ago. and 90% of my knowledge goes to this forum. ur just great guys (or woman, if any here). cograts. (well to brag a bit, i made a form, subform table on it, can use checkboxes to filter data on the table (4 checkboxes), can add open a new form and add the data while the table subform is refreshed,etc... and like i said, i got it 90% from this forum). Who's da man?? YOU ARE!
3: my problems: a) i want to either: - change a face (pictucture) on mouseover or onclick - use a picture for a button and change it on mouseover or onclick
b) i want to set a default size for my forms. now the problems are: - the unists are in centimeters (or inches). i want pixels. screensize is in pixels so it's easier to adjust the form that way. i know that if i type for ex. 400px and move away it is converted to px, but is displayed in cm. any way to use px as default display units?
- the form has the size of the whole window instead of just the grid. what's the trick? (i mean if i say 400px, the grid is 400px. but if i have a gray area 200px more (design view), then when the form is opened, it will be 600px). huh?
c) can i get rid of the scrollbars if i don't need them? and they will auto appear when needed.
Thanks for the answers. And again, even if i don't get any, this forum is by far the best. (well for access anyway ;)
d) is there a "mailto" function i can run with onclick [command button]?
Bye for now Josh
(oh you can reply here or by mail: joshlyman_slo@yahoo.com)
I have recently finished a data access page and have one last thing to do on it. When you press a button (Command0), it saves the record into the table. This is fine, but I want it to display a message box as well. I am not sure what code to put in and where to put it. Below is a shortened copy of the code from Microsoft Script Editor, i have chopped the top bit off:
I have a local intranet where I have a link in a web page to .mdb file. For some reason it does not consisitenly open the database when clicked? Any ideas? Links to Excel work fine.
Check around and can't find anything useful, more of a case of can't see the woods for the trees really :p but here we go:
I doing a very simple form which I want to output to HTML (directly), it work fine and is ideal for what I need but I want to use a template to alter the colours and add a meta refresh tag but I cant get it working.
Help file next to useless so I wondered if anyone can point me in the right direction - Is it a css file ? or can I use a html file ? I've tried with both but still no joy :(
I'm trying to get a field in my Data Access Page to display the last time a field was updated, I figured I would have to do this in HTML, after a lot of dead ends elsewhere. Here is the code:
<SCRIPT language=vbscript event=BeforeUpdate(dscEventInfo) for=MSODSC> <!-- Dim DateModified DateModified = Date 'Current System Date dscEventInfo.DataPage.Recordset.Fields("DateModified") = Date
--> </SCRIPT>
Any clues where I would enter this in the HTML source?
