Preventing Copy & Past For Selected Controls
Dec 5, 2006Is They A Way I can prevent copy & past too some of the controls on a form these contols would be in the main ComboBoxes.
Many Thanks
Mick
ADVERTISEMENT
Modules & VBA :: How To Refer To Controls In Selected Report
Jun 3, 2014i have created a module under module section of my DB My Report Name : "PURCH VB Query"
the code is as follows : (what is want tell you later..)
Code:
Sub Erlick()
DoCmd.SelectObject acReport, "PURCH VB Query", True
'"PURCH VB Query", acViewPreview, "PURCH VB Query"
For i = 1 To 3
DoCmd.PrintOut acPrintAll, , , , i
Next i
'This is for creating Seperate Text Per Copy in RptHeader Preview End Sub
i've placed a TextBox in my report named Text25 to the value :
=+1
properties-->data-->running sum--> Set to OVer all
i've also set a textbox in my report named CpyWord to the value : =IIf([Text25]=1,"Original Buyer Copy", IIf([Text25]=2,"Duplicate File copy",))
Now what is want is Three Copies of Report with Two copies marked seperately as per above IIF statement
As i want Three Copies with each Rpt-header as Different Text
Possible solutions (ba donna no a script) How do i refer to Report's control after Docmd.SelectObj.... if any facility then i can do easily thru the dazzling for next loop How do i increase Report's control Text25's value, if three copies r there I know there are many events in Report
I've stucked over this point. My all App in db is ready
General :: Copy A Folder To Location Selected By The User?
Sep 4, 2012I have a folder with Access files, subfolders, and some .vbs files in it. It requires one person to navigate through a setup process. Once the setup is completed, they need to copy the folder and its contents to a location on a shared drive, which is unknown to me and will be chosen by the user at the site. There could be many sites.
It basically works like this:
Files are downloaded to C:Program Files.
A vbscript is run and extracts a folder directly to the C:Drive and opens it. I'll call it C:Test.
The user manually moves the BE file to a shared drive.
The user opens the FE file and is walked through using the Linked Table Manager.
The user then follows a series of forms to input data.
After this, the FE closes and another DB opens.
The second DB walks them through the Linked Table Manager and closes.
Option #1 At this point I would like to have a script and have it copy that folder, C:Test, and its contents, and have a dialog box open telling the user to paste it in a location where all users have access to.
Option #2 A script that will backup the folder and all its contents to a shared location selected by the user.
Either option will l allow others to navigate to that location, copy the folder, and paste the folder to their C: Drive.
Forms :: Right Click Listbox To Copy Selected Items To Temp Table
Mar 7, 2013I'm trying to create a right-click event on a listbox that will copy selected listbox item(s) to a temp table. So far, I've got this code to acknowledge the right click:
Code:
Private Sub List0_MouseDown(Button As Integer, Shift As Integer, X As Single,
Y As Single)
If Button = acRightButton Then
MsgBox "You pressed the right button."
End If
End Sub
Problem is the selected item on the list box doesn't move until after the mouse down event so whatever code I would run would involve the wrong record(s).
I'm using Access 2000 and 2003. How to get the the correct record selected on mouse down, or point me to a working example of right-click functionality on a listbox.
Forms :: Copy Specific Fields From Selected Record To Specific Fields In Subform?
Jul 9, 2015I am new to access i have a problem which is i have made a form which contains a subform and a read only subreport, what i want is the ability to select a record in read only subreport as in the picture attached and make a button that when i press on it, it should copy the values of the itemsID field, Packing field, ContainerNo field and origin field from the selected record and then paste them in the subform below.
Also i want to add more then one item, so the when i press on another record it should paste the values below the first record.
Results Of Past 7 Days
Nov 8, 2007I have a form in which the user inputs crane inspection results (a series of check boxes). When the user clicks the save button, I would like to run a query (I guess a query is how to do this) that searches records for the past seven days (less weekends and holidays) and alerts the user to days that inspection results were not entered for that particular crane (cboCrane.Value) and that particular shift (cboShift.Value) via a message box.
How do I get it to only look at records for the past 7 days (less weekends and holidays)?
Any help will be greatly appreciated.
Limited Records Past Date
Jan 3, 2007I have a query that returns a set of records which details stock items that are older than a date given in a form. However i need to limit the results to the number of items held in stock
i.e say i want to look at stock over 1 year old, i get a list of all the stockids, and the date added.
Say there is a stock level of 3 for a particular stockid the results should be limited to the first 3 records that are over 1 year old. Rather than the whole list of dates I get now.
Any help or direction with searching terms would be appreciated
thanks:confused:
Query To Pull Past 3 Months
May 22, 2007I have a query that I need to always pull data from the newest past 3 months, so if this query were ran today it would take from months 2,3,4 (Feb, Mar, Apr). Any clue on how to do this?
View 14 Replies View RelatedRetrieve Records For The Past Year
Mar 21, 2008I trying to create a query that just returns all of the records in my database for the past year. I've tried to somehow do it using the date() function but haven't had much luck yet.
Any help is most appreciated.
Textbox Populates Only After Tabbing Past
Sep 20, 2005I have a combobox where users can select classes. In the AfterUpdate event for that combobox I have the following code:
Me.ClassCode = DLookup("[ClassCode]", "Classes", "[ClassID] = " & Me.ClassID.Column(0))
I want to populate the Class Code field based on the class they select. The code works fine except that the Class Code field does not update until after I tab past it. There is a field in between Classes and Class Code so I have to tab 3 times before the textbox populates. I expected the textbox to populate immediately after I selected the class. I also tried putting the code in the On Click event of the combobox but that didn't work either.
If I just keep clicking on different classes I'd like the class code to change each time without having to tab to another field. Is that possible? What am I doing wrong?
Rod
Viewing Past Records On A New Form.
Jul 18, 2007Greetings All,
I'm not sure if this is possible but I've been asked to devise a way of viewing past record entries from an old form on a new form. Our database contains yearly records of student details; each year has a separate form. What my manager would like is that when a student ID number is typed into this year’s form, that old data from previous years is retrieved and placed in the database OR some sort of command button that searches past records for that particular student ID.
Hope that makes sense, I'm completely confused about the whole thing, I'm not sure if it’s even possible...any kind of help will be gratefully received!
Time Difference When Past Midnight?
Jan 29, 2014I have a field that works out the difference in time between two fields. However, whenever the end time goes past midnight, it calculates the difference as a minus figure. I understand that this is because of the date issue, but I cannot seem to find a way around it.
Here is what I have so far:
time_of_referral field. This is the start time. It is a short time field that is filled in by the end user.
time_of_arrival field. This is the end time. It is a short time field that is filled in by the end user.
Text31 field. This is not visible to the end user, and has the following control source =DateDiff("n",[time_of_referral],[time_of_arrival])
Text33 field. This is an unbound text box with the following control source =[text31]60 & Format([text31] Mod 60,":00")
This works out the time difference and presents it as hours and minutes.
I have seen solutions that add a day to the end time, but unfortunately this does not work when the end time DOESN'T go past midnight. Some will go past midnight, some won't.
My New Form Wont Past All The Data Into The Table
Feb 3, 2007My new form won't paste all the data into the table, only the first two fields will go in, the other fields are empty.
The other fields are brought into the form automatically from another form. Is there something I have to turn on to get this data to go into the table?
Queries :: Show All Amounts Past Due Date?
May 10, 2013I have a table in this manner:
Customer | Debit Amount | Credit Amount | Date of Transaction
My goal is to have the customer's name | (Sum of Debit amount MINUS Sum of Credit Amount) and it will only show if it is past a certain due date.
How To Do NFL Predictions By Using Past Data From Multiple Tables
Jun 20, 2015I have these tables set up.
1) tblTeams.
2) tblDefensiveStats.
3) tblOffensiveStats.
Tables 2&3 hold data for the past 3 seasons for the 32 teams in the league.
I don't know how to get access to perform these functions.
Query The Occurrence Of A Particular Absent Reason In Past 12 Months?
Sep 3, 2005Hi, i have a query which looks at a table named "attendance" the query includes the fields: "employee number", "absent code" (a 3 letter code), "absent reason" (list of different reasons) "shiftdate" (weekly shift dates in format: DD/MM/YYYY). If possible i would like to be able to promt the user to enter a employee number, then a absent reason (ideally from a list box) and show all occurences (with all the shiftdates) only of that particular absent reason within the last 12 months, and ideally calculates in another field the number of times that employee has been absent for that particular reason for the last 12 months.
Does this make sence?, i know how to promt the user to enter a employee number but not sure how to go about the rest, any help with what seems to be quite a challenging task to me would be excellent.
Query Expression To Find Records 30 Days Past Due
Mar 22, 2005I am trying to run a query to print invoices that are 30, 60, and 90 days past due. What expression do I use to search for records that were purchased 30, 60, 90 days prior? I was able to find the expression to add time for the due date but was unable to find the expression to subtract time for my search. Thanks for any help!! Beck
View 1 Replies View RelatedForms :: Auto Fill Textbox From Past Records
Aug 26, 2013I have a form for creating new entries in a table. In it there is a textbox for a City field that I would like to have some kind of auto-complete based on past records in the database--similar to how Excel provides auto-complete options within a spreadsheet based on entries in previous cells.
In other words if "Binghamton" has been entered in a past record and the user starts typing "Bing" in the textbox, then "Binghamton" will become an autofill option. Is there a way to set this up?
General :: Date Query Not Extending Past The New Year?
Jan 2, 2014Now that the year has moved into 2014, the query below no longer works. It appears that it is not extending back into 2013.
Code:
Private Function multiDateClause(dateStartQry As String, dateEndQry As String, firstOp As String, secondOp As String)
multiDateClause = dateClause(dateStartQry, firstOp) & " AND " & dateClause(dateEndQry, secondOp)
End Function
Private Sub b_last7_Click()
Me.resultsFrame.SourceObject = "FollowUp_bystaff"
Me.resultsFrame.Form.RecordSource = todoListQry(multiDateClause("Date()-6", "Date()", ">=", "<="))
End Sub
DatePicker - Disable Any Past Dates On Calendar Popup
Apr 4, 2012Is there a way to ONLY allow users to select a date starting today or in the future using the DatePicker? I want to disable any past dates on the calendar popup.
View 2 Replies View RelatedForms :: Unbound Listbox - Change Text Color To Differentiate Between Current And Past
Apr 24, 2014I have an unbound listbox on a form which displays a list of staff, both past and present, based on an SQL query.
I want to be able to differentiate between current and past staff using different colors, i.e. Black text for current employees and red for employees who have left, based on a field (True/False) in the original staff table.
Preventing Duplicates
Jun 27, 2005Hi,
I have a form and within that form there is two combo boxes and one text box. When one choses a value from one combo box, and then chooses a value for the other combo box and then enters the value into the textbox I don't want the user to be able to enter the same arrangement. That is I want to prevent duplicates on that combination. Also if they do this I want a Message Box to appear saying that that this combination already exists
I was thinking of using a multiple field index to prevent the duplicates, but I don't know if this is a wise thing to do. Can someone give me some help to see how I can prevent duplicates or offer another solution to prevent duplicates on the combination of the values.
Thanks
Greg
Preventing Duplicates
Jun 13, 2007Hi, How do you normally prevent duplicates being inputted into you forms.My Idea is thisThe input text box doubles up as a dropdownlist of current values held in the database for that field.So when you access the organisation form and go to the first text box as you enter the 'I' for IBM All the orgs with 'I' appear. When you see that the organisation your inputting already exists you will stop and move on to the next form.I dont know how to do this, so currently I have set the field OrgName as Indexed: Yes (No duplicates) but this isnt really any good as the user enters all the other details and clicks submit before the error message comes up.I have attached my file for you to understand this better.
View 2 Replies View RelatedSum Of Current Year Minus The Year Of A Date In Past?
Apr 25, 2014I'm trying to add a couple of fields to the Contact database in Access 2010.
In the Contacts table, I created a field called "Sobriety Date" that has dates formatted like 12/27/1995
I am trying to add a calculated field called "Years Sober" which should be the current year minus the year in the 'Sobriety Date' field (1995 in the example above).
I have been trying to tweak this:
SUM(DatePart("yyyy",[Date]) - DatePart("yyyy",[Sobriety Date]))
but it's not working. Keeps giving me "The expression that you entered is not valid for web-compatible calculated columns"
Preventing Certain Rows From Being Deleted
Sep 7, 2005Hi
I would like to prevent the first 24 rows in a table from being deleted by the user, after these 24 rows they can be deleted. Is there anyway of protecting them etc without putting them in a separate table?
Preventing Form From Resizing
Sep 7, 2005Hi
I have a Switch Board and when I click to view a report on it the report automatically opens in maximize view, this is what I want. What I dont want is when I close the report for the Switch Board form to be maximized as well
How would I be able to prevent this??
Cheers
bikeboardsurf :rolleyes: