Printing Form That Allows Only Certain Edits
Jul 11, 2014
We have 3 different sizes 1x3 2x3 4x6..I want to make 3 separate forms that have multiple sections that can be chosen.Upon Request I can Supply each separate Label with arrows to show what fields need to be changed for each Sales order.For the 1x3 Labels we Make:
1. ETL
- We change model #
- We Change if the Labels Says Dry Damp or Wet Listed.
2. MISC.
-One Plain Txt Box that can be edited in the center
For the 2x3 Labels:
1.Box Labels
-Customer
-Item
-Sales Order#
-Shipping Location
(For the Box Labels I was thinking I have a Table that holds all this data and all I would have to make is a Query then a form)
2.ETL
-Change Model
-Wet Damp or Dry
3.CSA
-Change Model
-Change the Wattage (3 Different Places)
-Wet Damp or Dry
4.MISC
-6 Text Boxes (From top to Bottom not side by side)
4x6 Labels:
1.HID Box Labels
-Item
-Watts
-Color
-Medium or Mogul Based
View Replies
ADVERTISEMENT
Oct 20, 2004
Greeting,
I am still struggling with my sub-form.
Have managed to prevent edit by using the form properties.
However I have some fields which have to be updated after the form has been closed.
I tried putting the following code in the (Before Update Event) of date issued field for instance.
If Me![DateIssued]=Null then
Me![DateIssued].Locked=False
end if
Needless to say this didn't help.
I have some fields which cannot be filled in until a later date.
These are job records so I have date open, Technician name date completed plus a whole herd of other stuff which has to be filled in as the job progresses.
Any help will be most appreciated,
Brian.
Zimbabwe
View 6 Replies
View Related
Oct 2, 2006
Have the data settings for the form all allow=true
And tried the VBA allowedits=true on form open but the form is still locked.
Any suggestions about why?
Is updating two tables from a two-table query not allowed or???
Thanks,
View 1 Replies
View Related
Nov 4, 2014
So I have a form that allows me to view the information associated with a specific record. Within this form is also a subform that shows additional information about the record from a junction table. I want to create a button that allows me to edit the information on both forms.
View 4 Replies
View Related
Jan 10, 2015
I'm creating a database about Vets and I need to make a button on my menu form that will open something like message box that will allow me to type in something (in my case Customer ID) which will then apply the filter on the customer form and allow me to do edits. I have only done the macro that will open the customer form but can't figure out how to do the filter part.
View 2 Replies
View Related
Jul 22, 2013
I thought "Undo" was only available while in the current record.Here were my steps:
1 - Loaded form that shows 1 record per form page.
2 - Edited a record
3 - Moved to another record with status bar nav arrow
4 - Verified my edit was in the underlying table
5 - Moved back to the original record, again using status bar nav arrow
6 - Clicked my "undo" control and the original data appeared in the form
7 - Moved to another record
8 - Verified my original data was now back in the underlying table
My undo control has this vba on click:
Code:
DoCmd.RunCommand acCmdUndo
View 1 Replies
View Related
Sep 22, 2013
I have a form "Handover" on this form I have a button that enables edit functionality once clicked, I now have a subform on this form named "Bdown".
The Bdown subform allows edits without having to click the "btn_Edit" on the main form "Handover".
Is is possible to make the edit button on "Handover" control the edit function on "Bdown" also?
Currently "Handover" contains:
Code:
Private Sub btn_Edit_Click()
Me.AllowEdits = True
Me.btn_Edit.Caption = "Editing"
End Sub
[Code] .....
View 2 Replies
View Related
Sep 6, 2014
I have a simple split form with datasheet on the bottom and a couple of comboboxes (unbound) on the form header which the user can use for filtering the data. When some users open the form the allowedit property of the form is set to false, because those users can only view the records. But the result is that also the comboboxes cannot be set, hence no filtering!
View 6 Replies
View Related
May 26, 2005
I am wondering if anyone can recommend shareware or free ware Utilities/code to make Form & Report Creation/Edits easier?
I'm thinking of something like Cub Editor http://www.peterssoftware.com/ce.htm or SmartForm+ http://www.aadconsulting.com/smtfrmplus.html
but alas .... I can't do anything that will edit the registry (company politics says Access and it's Wizards is plenty 'perfect' http://www.dbforums.com/images/smilies/frown.gif maybe I will convince the powers that be but not in short time)
Also the code (or forms / reports built) need to work on Access 2000, 2002 and 2003. or well-commented on how to modify as I'm only modest with writng VBA code.
Any ideas? Thanks!
Mark
View 1 Replies
View Related
Feb 25, 2014
I was having trouble just setting each report with a particular print method - for some reason they just kept forgetting their individual settings and resorting to default on the machine.
This meant reports were printing on the wrong paper, or the wrong size paper, the wrong orientation and some times refusing to print if it couldn't find the paper (which is useful in runtime as it doesn't display error messages)
So I used Reports(rpt).printer properties (I forgot where I found this) to hard code the printer properties into each print command... this meant I had to use another function to insert the variables.
So all I had to do was say:
Code:
PrintMe("Invoice","InvoiceID",iID)
and a report would print to exactly how I wanted... but it's just too slow!
See attached for full code, I have a niggling feeling it may be the function: PrinterOK, to make sure the printer exists or not.
Code:
Function PrinterOK(sPrinterName As String) As Boolean
Dim MyPrinter As Printer
PrinterOK = False
For Each MyPrinter In Printers
If MyPrinter.DeviceName = sPrinterName Then
PrinterOK = True
Exit Function
End If
Next
End Function
I know it's the printing code, because if I stop the printing and just preview then it shows up almost instantly.
View 1 Replies
View Related
Aug 5, 2006
I want to allow users of a database to view data through a form but not to edit or delete it. I have set Allows Edits, Deletes and Additions to "No", but this causes the record-finding combo box I have to search for records to stop working. It works again if I enable Allow Edits, but then users can edit the data through the rest of the form. Is there a way I can allow edits to the combo box but not the rest of the form?
Gary
View 5 Replies
View Related
Apr 12, 2006
i have a search form with a sub form displaying the results, how can i send the results to a report to print out or just print the results?:confused:
View 5 Replies
View Related
Apr 26, 2006
I have a form with multiple subforms. When I hit print selected record I get a blank sheet of paper. What could be set to not allow the data or the background of the form to print?
If I just print the subform out by itsself it works good. However when I have the main form open then try to print I get blank pages.
I am sure someone changed a fairly small setting, but I do not know what has been changed. Thanks.
View 1 Replies
View Related
Aug 9, 2006
:eek: When I go to print the form, it repeats the detail section over and over. Instead of being one page, it is 1414. How can I fix this problem? Thanks
View 4 Replies
View Related
Jul 2, 2007
I'm an Access idiot - please be kind :o
I made a little Access app for a friend, to do his invoices. Access wouldn't allow me to copy the db to a CD, but advised me to convert it to a Master. I followed all the instructions (honest!). Afterwards, I could burn his db to a CD and, on his computer, it opened but wouldn't allow edits or new records - not terribly helpful for an invoicing program :eek:
Since then I've tried creating a new admin in his name, re-setting all permissions, blah blah ... Basically, it looks like there is loads of help on securing a database but very little on un-securing it enough to be transferred to another PC!
The dang thing persists in allowing everything except edits & additions :confused:
I can't find out how to convert it back from a Master to ... what, a slave? :p
Even so, that wouldn't be the answer coz I'd be back at square1.
I use a PC running XP and Office 2003. My invoice-less friend has a PC with Win[NT]2000 and Office 2000. I converted the database to Access 2000. I am way out my depth here, but hoping you Access swimmers will be able to advise :cool:
View 1 Replies
View Related
Nov 29, 2003
Hello,
i am relatively new to databases so this is a fairly basic question.....
I have a form. Within this form all records are locked as i do not wish users to change details. However i am told there is an option allowing the editing of existing records upon request. is this true?, as it would improve my form greatly
help would be much appreciated
thanks.
View 14 Replies
View Related
Aug 10, 2005
Hello,
I have a db where a planner inputs a commit date. The problem lately, is that the commit changes day to day before the part if filled. Management is looking for a way to count the number of times a commit field has been updated? Is there a better way to do this? I have minimal VB knowledge. Please help!
Thank you in advance.
Jymaly
View 1 Replies
View Related
Dec 26, 2013
I have a check box field in table, i want this field to be work as if once checked cannot be unchecked again... no worries if done through queries, vba etc
View 1 Replies
View Related
Aug 30, 2006
Hi
I'm pretty new to all of this. I've set up a simple database. I have a form in it for inputting information and then there is a command button on the bottom which prints out a report I've created with the information on it. This is all working great except it prints evey record and I only want the current record printed out.
I've tried the help and it goes into detail about OpenReport and PrintOut in macros. I have no idea what a macro is or what to do with it.
Can anybody please help me and give me step by step instructions as to how to print out only the current record in the report from the command button.
Your help is greatly appreciated:)
View 1 Replies
View Related
Nov 1, 2006
I have a form (entry screen to enter data) I then created a report in the layout I need for my order form. I want to creat a button that a user can press and it will print the current record to the report (order form layout)
Here is my current code for the print button on the form page:
Private Sub btnPrtOrderFrm_Click()
On Error GoTo Err_btnPrtOrderFrm_Click
Dim stDocName As String
stDocName = "rptOrders2"
DoCmd.OpenReport stDocName, acNormal
Exit_btnPrtOrderFrm_Click:
Exit Sub
Err_btnPrtOrderFrm_Click:
MsgBox Err.Description
Resume Exit_btnPrtOrderFrm_Click
End Sub
The only problem is when I tell it to print if I am on record number 2 on the form, it prints both record 1 and record 2. I only want the current record i am in to print. Any ideas much appreciated
Dean
View 2 Replies
View Related
Dec 10, 2005
Hello all- New here and working with a database for my boss. I did not create this rather am modifying it. I have a table (vehs) that contains information for three different departments regarding their vehicles. This database also has a form that prints (when clicked once) all of this data to the local printer. I need to make three sub forms to print similarly but just by department number (in other words only department 1's vehicle data) I'm not too big an access guru so if I need to supply any more data please let me know
Thanks,
John
View 11 Replies
View Related
Jul 28, 2006
I had made my own database for my own business.
I am trying to print a report from a form. Once i enter an order detail i finish off by printing a letter. At the moment we are doing this via a query by entering the order id.
I want to automate this so for the form record i am in i want a button to print a report for that record only.
I know this can be done as i rember doing this in college but i cant get my head round it at the moment.
Please help
View 2 Replies
View Related
Aug 22, 2006
After having designed a series of forms, I have just been told that users would like to occasionally print the data.
On testing this, it seems that the data does not print onto 1 page.
Are there any settings to fit data to 1 page wide only?
Aternatively, is there a better way of doing this? Perhaps by using a report or something like that?
The form has a whole load of calculated fields (calculated control boxes with expressions) so would I run into any problems doing it ths way ?
Thanks.
View 1 Replies
View Related
Oct 25, 2006
Having trouble printing after I performed a filter. Have a subform with continuous forms that I put various filters on..., however when printing, all the records print and not just what was filtered...Is there a way around this. Basically, I would like to be able to print out only the filtered records in my form view.
Max
View 7 Replies
View Related
Sep 1, 2004
I created a form that opens to a blank form. I also have a print button on the form. I want to be able to print the blank form, but nothing happens unless the primary key has a value in it. Is there a way to print just a blank form? I have been working at this problem for a few weeks. Please help!
View 1 Replies
View Related
Sep 3, 2004
How do you setup the form to default print to a legal size paper?
View 3 Replies
View Related