I have a form that is mainly used for data entry (for call logging). Ideally it will be linked to 4 different tables, however I need to get the basics working.
My new problem is being able to look up data that is selected in a combo box to see if it is out of date. I shall clarify, as stated the form is for call loggin, when someone calls I ask for their postcode, this is in the combo box.
I want to then use the postcode selected to data from another table that lists services due, and if the service is due for that postcode within two weeks highlight the text box in red.
I have a form with a combo box (it has two states (In process / On file)) and a checkbox and I need that when the checkbox is checked, change the status of the combo box..The combobox and checkbox are in different tables (Assigned and Movements, respectively) and refer to different types of data.
The checkbox Refers to a set of tasks FINISHED, then, if that's the case, They must change the values of the ComboBox That has two values or options (In process / On file). Note: These two values are searched fields in a table "Status", and searches for values in a table with the wizard searches
For example: While ComboBox contained in "In Process", the checkbox is unchecked and if this "On File" checkbox is marked.
When I checked my Check box(YES) few steps turns invisible which works fine...but when i unchecked(NO) it should display again but it doesn't show up..how can i make it to display when i unchecked it again.. My code has shown below:
Code: Private Sub BreechDellst3mnths_Click() If BreechDellst3mnths Then Me.AvalaHumaResoO.Visible = False Me.TranIssuesO.Visible = False Me.Supply_Equp_drugsO.Visible = False
On a form I am making, I have two combo boxes. Box 1 has "Title" and Box 2 has "Full Name". In the table associated with FullName, there is a Check Box name "Still Attached".
What I am trying to do when choosing a "Title" in Combo Box 1, I would like only the people with that "Title" and a check in "Still Attached" to be available in the drop down list.
I have tried and I can get combo 2 to filter by title, but not by the "Still Attached" value.
Today and yesterday I added new fields to a table and they are showing wrong when everything is right. I added yes/no fields and a combo box look up and when I drag them over to my forms they are just showing as textboxes and not a checkbox or combo box. When I look at the backend and look at the fields it clearly says it should be a checkbox or combo box. Iv done it the same way I always have and this time its just wrong.
I am wondering if it is possible using VBA to update using either an option group or check boxes as shown in the frmDefaultValue in the attached file to update two tables tblLabelNumber and tblMediaType.
The form frmMedia contains two combo boxes. I am trying to use the form frmDefaultValue with an option group and check boxes as shown as not sure what is the best method here to update the values in the two table tblLabelNumber & tblMediaType at the push of a button Update as in the form?
I have a form wich includes listbox of employees. When I click on them, it shows his or her data (date of birth,address,etc...). For every employee there are also three diferent checkboxes - if he is regularly employed, temporaly employed or student.So now what I need is to filter listbox of employees - only student or only regular or only temporar or all.I was wondering if I can do that with combobox, but I really dont know how. I am prety new to VBA.
im trying to enable/disable checkboxes based on a combobox selection for instance,
i make the selection in a combo box called terms and conditions. i want it then to only enable the business,domestic and summary check boxes for that type, with the onther check boxes staying disabled. is there a way this can be done through code like the statement "only enable if this letter type selection has been selected"
I put a Dlookup function to compare the new entry in a form and the code is like this:
If (Not IsNull(DLookup("[empno]", "Attnd_tbl" , "[empno]=[empnotxt]")))then MsgBox "This Employee Already Exists" cancel = true Me!empnotxt.undo end if end sub
this works for comparing one field only, since I want to check if the employee is already entered on a certain date, how do I put two fields in this function to be looked up if for example "[empno]and[date]","Attnd_tbl","[empno]and[date]=[empnotxt]and[datetxt]"
I have some fields on a form that are update once a cmbo box is updated. They are updated by dlookups. However the fields that it looks up maybe empty so nothing is entered. So the user can enter the information themselves. On exit i would like to check to see if the field on the form is empty if so to flag up a msg.
i.e. if me.field = "" then msgbox "You havent completed this field" end if
However when i run this it doesnt detect that the field is blank. Is this because the field is being updated with a blank field from the dlookup. I have even tried = null.
I have data, in which want to keep Job Id as primary key. Now, there are some Invoices as well as Invoice reversals with the same amount against those invoices. Check those Invoices & Invoice reversal of the same amount & delete that data of that Job ID. How to do it in Access or is there any other way to do it?
When a part number is set up in our manufacturing software, the user clicks a check box to mark the part as purchased. I'm creating a similar form and want to have a check box display the same information. The manufacturing database stores the check box as Y when checked and N when not checked.
I tried 2 different ways to add code in the BeforeUpdate but neither is working.
First Example:
if Purchased = "Y" then check295 = True else checkbox295 = False
Second Example
If Purchased = "Y" then check295 = -1 else checkbox295 = 0
What changes do I need to make to this code to get it to work? Thanks for your help,
I have a user input form to enter traffic counts. There is a subform within that form that shows the total. I want to have a check box which, if checked, will multiply the data in the box by two. I have tried building expressions, macros...nothing worked. Dont know what I'm doing wrong. Any idea?
I have a database where a user imports data into a table monthly. She saves the Excel file and then clicks a button in Access to import the data. My instructions say to only click that button once, but so far, she has clicked it THREE TIMES, thus importing the data three times. How can I prevent this? Here is a copy of my import code:
Option Compare Database Option Explicit
Public Function ImportTableData() On Error GoTo ImportTableData_Err
Dim strPeriod1 As String Dim strMM1 As String Dim strYY1 As String Dim strYYYY As String Dim strFormName As String Dim strMDPath As String Dim strMDFileName As String Dim strDCPath As String Dim strDCFileName As String
'No Warnings DoCmd.SetWarnings False
'Import Current Month data in a temporary table DoCmd.OpenForm "frmEnterAgingDates", , , , acFormReadOnly, acHidden strFormName = "Forms!frmEnterAgingDates" strPeriod1 = Forms!frmEnterAgingDates.Period1.Value strPeriod1 = Format(strPeriod1, "mmddyyyy") strMM1 = Left(strPeriod1, 2) strYY1 = Right(strPeriod1, 2) strYYYY = Right(strPeriod1, 4) strMDPath = "S:FinanceAccounting OperationsNational AccountsAccount Recs116405.100 and 117630.300116405.100-AR Due from PAR Plans NASCO" strMDFileName = "MD AR Due from PAR Plans_" & strMM1 & strYY1 & ".xls" strDCPath = "S:FinanceAccounting OperationsNational AccountsAccount Recs116405.100 and 117630.300117630.300-AR NASCO Refund Due from PAR Plans117630-2007" strDCFileName = "DC AR Due from PAR Plans_" & strMM1 & strYY1 & ".xls"
working through validation rules etc at the minute on my database. Have come across this one is sort of stumping me. I have a tick box in the field "Medication to be repeated" the next field after it is "Date to be repeated on". I am looking a validation rule which makes it that if the checkbox is ticked then date to be repeated must contain a valid date value.
What I would like to happen is when either of the check boxes are checked it will either save the username and password or just the username, something like if you would log in to facebook and it asks do you want it to remember you log in details that's basically what I would like to have.
I am new to Access, and I need some help for this project I am working on. Please let me know if my question doesn't make sense.
I have created four tables: Clients, Tenants, Property, Contract
Clients Client ID | Client Name |
Tenants Tenants ID | Property ID | First Name | Last Name
Property Property ID | Client Name | Contract ID
Contract Contract ID | Clients ID | Client Name | Tenant ID | Tenant Name |Property ID |
Is there a way that when I enter Client Name in the Contract table, Client ID would automatically come up and check against other fields in the table if the information entered in Contract table is in sync and relevant against to data entered in Client, Tenants, and Property table?
Please let me know if this is not clear and I need explain more. Thank you.
hi, I have 2 Tables: tablea & tableb. The field names in both tables are: user_id, firstname, lastname, from these i have 2 querys (querya & queryb) both of which just look at the fields from the repective tables, & from this i have 1 form (entry form) that pics up the fields from querya. I would like to be able to enter details (records) into the entry form which puts all the data into tablea then automatically copies all the information into tableb, then automatically checks to make sure there are no duplicate records in tableb and finally deletes all the records out of tablea (probably after the form closes). This might sound a bit strange why i want to do this but I hope if its possible it could be used in a larger database.
I think i need to do querys but not sure what I need to do, Any advise would be very helpful.
I have a data field (status) that is either Graduated, Terminated, or Current. I also have a report that has a check box representing each (such as a check box for graduated and another for Terminated etc).
I am trying to get the report to read the status and check the appropriate box in the report.
I have tried this in the control source of the checkbox =IIf([status]="terminated";True;False) but this does not work
I have also tried this on the OnOpen
If [status] = "terminated" then termcheck = true else termcheck = false end if end sub
But this does not work either - what am I doing wrong :confused:
We have a table, JobRegister that people enter information on using a form, FrmOrderEntry
I would like to run a check when a serial number is entered in the field SerialNo to see if the same serial number exists where CompletionDate is null.
this would stop duplicate open orders being put on the system, or new orders being entered where the previous order hasn't been completed.
I have an input box and wanted user just to input 7 digital data. However, I am afraid user may enter string data. Is there any way to check and ensure user can only input 7 digital data to that input box?
I have a form (Access 2010) that we use to keep track of client data. When I enter a number equal to 6 or above in one field (Client Rating and this field is actually formatted as text because it could be 6 or 6a, b, c or 7 or 7a, b, c, etc), I want anything =>6 to automatically check a box in another field which is the Watch Indicator box (a yes/no box), how would I do this?
I tried to create an expression like the below on the Watch Indicator check box and it does not work - not sure why - it did not say it was incorrect, I think I may have it in the wrong place?
I am new in MS Access programming and is trying to create a search form for all records based on selected dates and check box. I was able to filter the records by dates but can't find ways to filter the records that meet the dates to be filtered again based on the selected check box/s. Basically what I wanted to is display all the records within the selected dates and check box/s.
I have written an extensive Access DB Application for my company and have placed it on a cd for distribution. When we try to copy it from the CD to a folder on another machine the above mentioned error comes up. Any Suggestions. Jeff
