How To Make Forms Available On The WEB

Feb 13, 2005

Hello all,
I am looking to make my company's access database (forms, reports, etc) available through a web server. Any idea what type of programming will be needed (ASP, JSP, PHP)? What would be the best way to go about this? If there is anyone that can help me with this please let me know. I am willing to compensate them for their time and help. It should be a fun project.

Thanks,
ovadoggvo

View Replies


ADVERTISEMENT

Make Forms More 'User Friendly'

Dec 11, 2006

Hi,

Im coming to the final stages of designing my database - its a Uni project. For extra marks it needs to be pretty user friendly.

One of the things I would like to do to my forms - I will use the following screenshot as an example - is remove the 'X' (Close) tab from the top right but I am unsure of how to do this exactly.

I would also like to remove the grey area around the form including the record navigation at the bottom.

Could someone point me in the right direction?

Screenshot - http://img237.imageshack.us/img237/7909/screenydg1.jpg

View 2 Replies View Related

Forms :: Can Make A Color A String Value

Oct 28, 2013

I'm new to VBA - Access but just dangerous enough to get in trouble. Is there a way to make a variable with the code below? I've been scouring the net all day and can't find answer. What I would like to do is make all the "cirsize1" be a string. Particularly the "Me.cirsize1.ForeColor". if I use the "cs" string it works fine with the Me.cirsize1 = 0 (ie "If cs = 0") This is just a snippet of the code.

Private Sub cirqty1_AfterUpdate()
Dim cs As String
cs = Me.cirsize1
If Me.cirqty1 > 0 Then 'if there is a quantity greater than 0 in circle qty and
If Me.cirsize1 = 0 Then 'if there is 0 in circle size
Me.cirsize1.ForeColor = vbRed 'then make the circle size 0 red
Me.txtCirIPM1 = 0
End If
End If
End Sub

View 14 Replies View Related

Forms :: Make PDF File From A Report

Apr 1, 2015

i have the following code to make the PDF form a report. but i want to make the PDF in landscape mode and also each time with a new name.

If Me.Combo3.Value = "" Or IsNull(Me.Combo3.Value) Then
MsgBox "Please enter order number!", vbExclamation, "Order number required"
' ElseIf Me.cmb_AuftragNummer.Value Like "*[a-z]*" Or Len(Me.cmb_AuftragNummer.Value) <> 6 Then
'MsgBox "Invalid order number!", vbExclamation, "Invalid order number"
Else
DoCmd.OpenReport "rep_CQAReport", acViewPreview, , "[Fehlercode] = '" & [Combo3] & "'"
DoCmd.Close acForm, "frm_rep_cqaReport_filter"
DoCmd.OutputTo acOutputReport, "rep_CQAReport", acFormatPDF, "O:ApplicationsCQA ReportingPDFTest01.pdf", False
End If

View 12 Replies View Related

General :: How To Make All Forms Acquire The Same Look

Jan 20, 2014

Am preparing a db in A2010. Have imported forms and other bits from 3 A2007 db's, and the forms' looks (colour, background colour, fonts, bits sunken/raised) differ.

How make all the forms acquire the same look?

View 8 Replies View Related

Forms :: How To Manually Make New Tabs To Appear On Second Row

Jun 30, 2014

How can I manually make new tabs appear on the second row when they normally would not?

I want to force some tabs onto the second row of a multirow tab control...

View 2 Replies View Related

Forms :: Make Form Exclusive

May 1, 2013

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 Related

Forms :: Make Record Read Only

Jul 11, 2013

I have a Workorder form that I want to not allow edits, deletions, and additions when the Workorder is closed. Is there a way to program a button for this that could be password protected in case it needs to be reopened?

View 3 Replies View Related

Forms :: Make One Field Dependent Upon Another

Nov 2, 2013

If I have a Form that is used to populate a Table can I make one field entry dependent upon another?

For example, if I have a field for Discipline (with values such as Mechanical, Electrical, Piping) and another field for Equipment Type (with values such as Motor, Gearbox, etc) can I set up the Form so that when I select Electrical for the Discipline, only electrical items (such as Motor) are available to select for the Equipment Type field?

Using the table below as an example, if I select Electrical for the Discipline field in my Form, when I go to select a value for the Equipment Type field the drop down shows only Motor and Fan?

Discipline
Equipment Type
Electrical
Motor
Electrical
Fan
Mechanical
Gearbox
Mechanical
Pump
Piping
DN 150 Pipe

Or, better still, can I set it up so that if I select Motor for the Equipment Type field, the Discipline field will automatically be populated with Electrical?

View 4 Replies View Related

Forms :: How To Make Tab Control Stretch

Feb 2, 2015

I have an application designed for an 1280x 1024 screen working just fine. Unfortunately need hs arisen to run it on a widescreen laptop, with less than 1024 in y-direction.

On the front pge I have a form and subform. I shrink the subform vertically and then anchor it with a "stretch down" and everything is hunky dory. But, on the min operation page accessed form front page, I have a tb control with 4 subforms, and access to the bottom line under the form is essential in each case.

A tab-control has no anchoring properties, so how to make it shrink nevertheless? Essentially, imagine a form, at the bottom there is tab control, in it is a subform. How to accommodate smaller screens by shrinking the subform and the tab control?

View 3 Replies View Related

Forms :: How To Make A Popup Go Away Automatically

Jan 20, 2015

I had used a form to come up as a popup, and on that popup, the person can chose a report to go to (button). Is there a way that once they chose the button they want, to make the popup to go away automatically?

View 11 Replies View Related

Forms :: Make Two Records That Are Similar?

Mar 3, 2015

I am creating a simple inventory db. I have a form that we enter into the table inventory. Right now we enter in everything once as inventory, then again to out to coating or ship to customer. I’m looking for the code to create a button enter the record twice but make two fields change.

So in short terms I want the form to enter a record with all the data as displayed. Then create another record with all the same data but the quantity would need to change to a negative and the Status would change to “Coating”.

I know this code won't work but this is what I want to do.

Private Sub Command78_Click()
.AddNew
!Employee = Me!Combo68
!Material = Me!Combo48
!Length = Me!Combo29
!Caliber = Me!Combo31

[code].....

View 9 Replies View Related

Forms :: How To Make Text In A Listbox To Flash Red

Mar 25, 2015

I'm working on a series of forms for a company that I'm currently employed at, and on one of them I've made a listbox which will display records which need action in the next 2 weeks.

That's all going fine. However, it it possible to make the items in the listbox flash red? Just so that our external worker REALLY has no excuses!

Just to clarify, I want the text identifying the records (E.g. Name, FinalDate) to flash, but not the headers for the columns in the listbox.

View 10 Replies View Related

Forms :: Make One Combo List Depend On Another

Sep 24, 2014

I have a combo: cmb_TrainingType. The sql is:

Code:
SELECT tblTrainingType.TypeID, tblTrainingType.Type FROM tblTrainingType ORDER BY tblTrainingType.Type;

My second combo (the one that should be filtered based on the Type chosen above) is cmb_Project_Title. The sql I have written (which isn't working) is:

Code:
SELECT tblCourseDetails.CDID, tblCourseDetails.Project_Title FROM tblCourseDetails WHERE (((tblCourseDetails.TypeID)=Forms!frmResourcing.cmb_Training_Type) And ((tblCourseDetails.Type)=Forms!frmResourcing.cmb_Training_Type)) ORDER BY tblCourseDetails.[Project_Title];

Both of the tables that are referenced have the fields TypeID and Type.

View 1 Replies View Related

Forms :: How To Make A Continuous Form Look Like Datasheet

Jul 18, 2013

I have a continuous form that I need to appear as a datasheet (one record per row). The data fields are "locked" to the left edge of the form. How do I free them for realignment inot a row (instead of a stack)?

View 4 Replies View Related

Forms :: How To Make Form To Always Open To New Entry Only

Jul 15, 2013

Is there any setting that I can use that will make a form always open to a new entry?

I don't want people to be able to edit the form.

On the form I have created a New form button and a Save and clear button, but i would prefer it to be that when they open the form its always a new entry and when they hit save it just save and clears and comes back to a new entry form.

These are my buttons.

Code:
Private Sub Command103_Click()
DoCmd.RunCommand acCmdRecordsGoToNew
End Sub

Private Sub Command90_Click()
RunCommand acCmdSaveRecord
Me.Requery
End Sub

View 3 Replies View Related

Forms :: How To Make A Text Box Entry Required

Nov 27, 2014

I know how to make a text box entry "required" such that one cannot exit a record until a value is entered but cannot figure out how to make it required only if another field on the form has an entry. None of the form events seem to support that when focus moves to another record as far as I can tell. What I want to do is display an error message if the condition is not met on exiting a record but to also remain on (or go back to) that record so the required text box entry can then be made.

View 4 Replies View Related

Forms :: Make A Field On Form Invisible

Mar 24, 2015

I have a main form that has 2 subforms. I have a field on both forms that I have marked as "Visible="No". Both are text box controls and I have made sure that both the label and the text box itself are marked "Visible="No". In the first subform, it works correctly, while on the second one, it still displays.

View 2 Replies View Related

Forms :: How To Make Combo Box Remember Previous Value

Jun 30, 2014

Only thing left is a combobox (dropdown) with predefined values. What i want is, as soon you have picked a value from the combobox, save the record and go to the new blank record, the last picked value of that combobox auto appears in the combobox for the new record.

View 1 Replies View Related

Forms :: Make Listbox Autoselect If Only 1 Item

Sep 26, 2013

My form utilizes five list boxes. The user must choose from each of the five list boxes in order to filter out a specific product from a products table.Every time the user makes a selection, the next listbox is filtered, and set focus to. Each listbox often contains more than 1 choice within it, however, there are a few cases where there is only 1 choice to be made.

How can i determine with code when a particular listbox only has 1 choice so that I can have the choice be made automatically and then set the focus to the next listbox in the series?

View 2 Replies View Related

Forms :: Make Visible When Field Is Not Empty

Oct 6, 2013

I've got a memo field on a form where the name is TextEXTRA

The Control Source for TextEXTRA is EXTRA.

I've got a box called BoxSHOW (Visible = No)

As I browse through records or find records, I want the box to become visible when there is something in the EXTRA field and become invisible when the EXTRA field is empty. This is what I've tried .....

Private Sub Form_Current()
If EXTRA Is Not Null Then
BoxSHOW.Visible = True
End If
End Sub

I tried many variations on the first line such as ...

Me.EXTRA "EXTRA" TextEXTRA

but I always get errors.

View 5 Replies View Related

Forms :: Make Multiple Entries At One Time

Nov 4, 2014

I have a text box linked back to a table and I am needing to be able to make multiple entries at one time for this text box but when I enter the first number and hit tab all the other text boxes that are linked to this one in the table show the same number....

View 2 Replies View Related

Forms :: Make Fields Selectively Updatable

Nov 6, 2014

I have a form consisting of a list box and some fields belonging to a single record. When the user highlights a row in the list box then the fields show the details of that record. Now the whole process is Read only. But I wish to put a toggle switch on the form so that the detail fields of the record become updateable. I have tried the following constructs but I could not make those fields updateable.

Code:
Me.AllowEdits = True
Me.DataEntry = True
Me.fld1.Enabled = True
Me.fld2.Locked = True

View 12 Replies View Related

Forms :: How To Make Calculated Field Stay On Top

Jan 14, 2015

My form has a button that has a calculated field on it (a dcount(...)). When the button is clicked, a couple of conditions are checked and if all is ok, it runs the vba code. If the tests fail, it returns to the form without running the code. All works correctly, except that the dcount number has disappeared. I finally figured out that it is now hidden behind the button. How do I bring it forward again programmatically?

View 11 Replies View Related

Forms :: Is It Possible To Make Pages In A Datasheet Form

Aug 19, 2014

I have a form in datasheet view, and I am wondering if it's possible to specify "pages" with a set amount of records per page.Think like the search results of Google, you get a huge number of results, but only so many are displayed per page.

View 1 Replies View Related

Forms :: Possible To Make Pass Through Table Editable After Filter It?

Jan 8, 2015

So what I have created is a form with 4 combo boxes which filters a subform with a click button by running a sql query.It was working great yesterday but then when I made the subform a pass through query it seems to no longer run (or just runs so slow it takes a large amount of time to query). To get a better sense of what I'm talking about I basically have a button and inside of the button it takes this query template:

SQL = "SELECT * FROM queryname WHERE 1=1"

concats with if statements to the end of the Where clause with the values in the combo box and then sets

subFormName.Form.RecordSource = SQL

how I can get this table to query...Also, for my second question, is it possible to make this pass through table editable after I filter it?

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved