Checking If The Same Name Is In The System?
I have a form where I enter student names, and it often happends that I enter the same student a couple times, Is there any way to let the user know that there is allready someone in the system with the same name, like a pop up message.:confused:
thx
View Complete Forum Thread with Replies
Related Forum Messages:
Mail System, Checking If Letter Has Already Been Sent,
Hi, I've just started a new project where customer details will be inserted into a database ready to be mail merged onto labels. It'll be dealing with around 50 records per day so it will need to be automated. These records that we get may very well contain duplicates so im hoping to build a system that can check if a letter has been sent to that recipient already. For example, in one month there could be 60 records for the same recipent - wouldnt want to send 60 letters to them!! This is the process im hoping to build Person inputs data into a form - which goes into a table called ToBeSent | I need a way to check if the added record is already in table 'History' . If there is a record in the history table = dont send | If there are no matching records in the history table, send. I'm thinking of using the Name of the person or the post code or both if possible? to check if there are any matching records. My question is what would be the best way about doing this? Thanks
View Replies !
Checking One Box
It should be exceedingly simple, but I got mashed potatoes between the ears today. I make a query looking up for Name+Firstname+Ref number which I display in a tabular form . Now, I want to use check boxes to select the ones I wants to print. But the thing is, if I add a check box in the main part of the form, it'll be the same box for all records. Not what I want. So, how to create (add) a column so I can check individual records in the form?. Thanks
View Replies !
Checking A # Field
Hi guys, a company in my city is giving out prizes, and for each buy you get a sheet with 25 numbers ( kind of bingo thing). Well I have like 300 sheets . So i did an Access where I enter the SheetID and the 25 numbers. Now I have to do another table where I can insert the number that will be draw and whenever one of the sheet is complete, it let me know that I win!!! and the SheetID. Any ideas!!! please please
View Replies !
Checking For Renewals
Hello, The general layout is, premCust contains a customer's information, which is tied to premInvoice, which lists all the invoices, which ties to premInvoiceLines, which is all the items in the invoice that the customer ordered. In premInvoiceLines is a field called ExpDate, which indicates the date on which the customer's particular subscription will expire. Also tied to premCust is premRenew. This table is manually updated whenever an existing customer renews their subscription (which requires a new invoice, obviously). I need your help designing a query. I want to find everyone whose account has expired but they have NOT renewed. So it would be something like: Find CustID where (MOST RECENT RenewalDate < MOST RECENT ExpDate) OR (MOST RECENT ExpDate < Now() AND IsNull(RenewalDate)) I have made two queries to get back MaxOfExpDate and MaxOfRenewalDate which solves the first part. For the second part where I check for RenewalDate being Null, I have only 3 fields in the premRenew table i.e. RenewID,RenewDate,CustID. So what I want to achieve is: Identify clients who have NEVER renewed AND their account have expired. This is what the null part of the query is for - clients who don't have anything in the renew table. Any help is appreciated. Thanks,
View Replies !
Set A Value In A Field By Checking A Box
Hi, i want to set values (=numbers) in fields of a table by selecting check-boxes in a form (based on the same table). as checkbox1 =1 checkbox2= 2 etc If the box is checked the value should be entered, if unchecked the value should be removed. Afterwards i want to show the sum of these values in another field in the same form. I suppose this requires VBA. Could anybody help me plz ? Thx
View Replies !
Checking Field For A Value
I've had a search in the threaqds for an answer but cannot find anything specific, plus this one has stumped me. What I need to do is check if a certain field has a value if another field has a specific value ??!!? Ok so if Combo Box 1 is set to 1, then Combo box 2 must have a value selected. If ComboBox 1 is set to 2, then Combo Box 3 must have a value. for any other value for ComboBox 1 box 2 & 3 do not require a value. If either of these statements are not correct then a message box should come up Any help would be greatly appreciated MattP
View Replies !
Error Checking
hello all, I have no idea how to run error checking I get this error can't append all the records in the append query. i want a custom error to come up instead of that. PLEASE HELP.
View Replies !
Checking Multiple Records
I have a text box on my main form with this equation : =IIf(Child123.Form!Combo27="2","Active"," ") It is supposed to show the word "Active" if the combo box in my subform has the second option selected, the options of the box are "Pending" "Active" and "Complete". It works great as is, as long as the active record in the subform is showing. Is there any way to make it search through the subrecords for all the values for Combo27 (Which is stored in a table under the value "Status")? It would even work fine if I could just make it so the most recently added subrecord would be the first one displayed, because there cannot be more then one active at a time.
View Replies !
Checking Date Availability
Hi all, hope you can help me: Basically what im trying to do is a database which checks to see if something is available. The database is a booking system for services. I need the database to check a "booking" table to see if there is a booking on a specific date. If there is, then you cannot make a booking. If there isn't then you can. In my "booking table" there is a list of dates of bookings. Each booking lasts a week. So if someone wants to make a booking, it cant just check to see if the first day is available, it needs to check for 6 additional days. (i.e. a booking on 01 Jan 2006). If someone wants to make a booking, the database needs to account for a whole week, so the next available booking would be on 07 Jan 2006). How can this be done in the simplist way? Thanks all.
View Replies !
Checking The Integrity Of Db After Processing
Hi, All, Background (questions: see below) --------------- I have a db whose one and only table has recently been split up into three tables as follows: 1Main table (containing contact column; name, tel, fax, email, etc) 2Memo table (containing long fields of type Memo) 3Non-memo table (containing short fields of non-Memo type) We now have to submit Table 1 to a data cleansing company, which inserts columns about telephone and fax suppression (people who we are not allowed to phone or fax), validity of address, etc. When we first did this (when the three tables where still only one, which should have made processing errors less likely), one of the tables came back in mangled form. Data were all right for, say, ten or 20 records, then came records where "DNA splicing" had taken place, i.e. where parts of one record had been spliced into another record. However, it had been done in such a way that it was not easy to detect by visual inspection and comparison with the original table, especially since many records looked all right. Typical splicing error: the memo field of one record had replaced the memo field of another record, but NOT that a text field of one record had replaced the memo field of another record or another text field of another record. ---------------------------- The data cleansing company (DCC) told us that it was not their fault but that we had made mistakes in the way in which we submitted our db for 'automatic' on-line cleansing. This may or may not be the case, but certainly the initial instructions from the DCC were misleading or unclear. Therefore (1)we are now taking measures to prevent this from happening again and (2) we have to check on tables which come back from the DCC to make sure they have not been corrupted again (just in case it IS the DCC's fault), since this would be absolutely disastrous for us. Step 1: we divided our one and single table in to three tables, linked by ID as Primary Key, as above. So now only Table 1 has to be sent for cleansing, but we are, of course, concerned, just in case when returned, the records in table 2 and 3 are no longer linked to the correct records in Table 1. Step 2: we altered Table 1 so that its structure corresponds as closely as possible to what is taken as normal by DCC. Step 3: We removed all commas from our Table 1 before converting it into a csv file. Note: We submit our table as a comma delimited file (csv file), using double quotes as text qualifiers. We had been told by DCC (perhaps quite mistakenly) that the occurrence of commas in our memo fields had screwed up their program. ---------------------------------------- We are now experimenting with a variety of formats for submitting our data and receiving them back. We need a convenient way of checking whether the csv file which we receive back and which we convert into an Access table and substitute for our original Table 1 has not been corrupted. *** We want to be sure that none of the records in Table 1 on its own have been spliced up and wrongly spliced together as described above. *** Secondly we want to be sure that the fields in Table 2 (memo) and Table 3 are still related to the correct fields in Table 1. We know that this SHOULD be the case if we and if DCC have done their jobs correctly, but then things have gone wrong before and therefore we want to check and confirm this positvely, rather than lose our invaluable database. Question 1 --------------- Are there any routine procedures, perhaps incorporated into Access, to compare the original related Tables with the Tables which we received back. Is there perhaps some ready-made utility to do this job? Question 2 --------------- If there is nothing ready-made, we are thinking of doing the following: Create a query which shows 26 hand-picked records (i.e. one screenful) of the 4000 records in the database, and shows of each record a few memorable fields taken from each of the three tables (as much as can be seen on one screen from left to right without scrolling). Apply this query to the original db and to the cleaned db, make screen-prints of the results, print them and compare them manually. Is that a good and workable idea, or is there a better approach to the problem? Thanks for your help. Adrian
View Replies !
Checking To See If A Table Exists.
I'm running the following line: dbs.Execute ("DROP TABLE [tbl_No Certs]") the problem is that sometimes the table doesn't exist... Instead of trapping the error code, is there a way I can check to see if the table exists? If it doesn't I'll simply skip this step of my code and move on. Thanks!
View Replies !
Checking If A Table Exists
I have tried the attached code from a previous post http://www.access-programmers.co.uk/forums/showthread.php?t=98727&highlight=table+exists but some of the code doesn't work on Microsoft Access Project. Does anyone have any ideas how I would amend this code so that it works? Regards Carly
View Replies !
Checking Isnull For Two Fields
Hi all, I had a little problem with delete query. I would like to delete the records by checking two fields if both fields are empty. I mean if a records had both these fields are empty only. If one of the field has data , the record should stay there.. Is there any way I can do this? Thanks in advance. Thanks
View Replies !
Checking For Attached File
I would have thought this was easy, but I keep getting an error. I have a form with a save button. When the save button is clicked, I want it to check if user has attached an OLE object to a bound object frame. If they have, I'd like a checkbox to be true. Here's the code I tried: If Attachment.LpOleObject = 0 Then Attach.Value = False Else Attach.Value = True End If This seems so incredibly straight forward and it does work if there is an attachment. If there isn't I get the message that my database can't retrieve the value of this property. Any help would be greatly appreciated.
View Replies !
Checking Credit Limit
Hi, I'm trying to do up a database for a furniture company. I used Northwinds as a guide and made a similar Orders form. However, I need another functionality which Northwinds do not seem to have. I want to check whether the currect Order would cause the customer to exceed his credit limit. WHAT I DID For this, I made a query to find the amount any single customer owes to date and the amount that he can still borrow(creditlimit-amountowed+amountpaid). I then made a button which launchs this query. PROBLEM The problem is I want when i click this button, the query prompts me for CustomerID, which i have to key in again. Then, it launchs the datasheet showing me the credit he would have remaining if this order went through. It would be better if I do not need to key in his ID again, since it is already on the form when i keyed in the Order. Further, it would be much better if I could get the button to display APPROVED/REJECT(postive/negative balance) and also display the amount of the remaining credit. Sorry for the long description. Thanks for reading and please let me know if I missed out any crucial details.
View Replies !
Checking For Duplicate Values
Hi, I have a form in a database for our products (doors). I have a button that duplicates one of these records (all new products are based on standard template records). When this record is created a new product number is produced by the system which was the number of the original (template) record plus the customer enquiry number. I want to be able to warn the user if they are trying to save this newly created record with a product number that already exists so that they can alter the number to be unique. It will also warn them if they re-number an existing record to another already existing product number. Since the field is defined as unique, at present the system says absolutely nothing and just doesn't save the newly created record which seems is a touch annoying! I have tried several things with dlookup, dcount arguments but can't seem to get anything to work. Hopefully someone here can point me in the right direction? Thanks in advance John
View Replies !
Problem With Checking For Duplicates
I have a table that stores jobs. The primary key field is JOBID which will correspond to company invoice #'s. Because the Invoice #'s are generated by a different system, I don't not have this as an autonumber field, I want to control it programatically when the user enters a value into the JobID textbox. At first, I was using DCOUNT on the BeforeUpdate event of the form to check if there was already a matching JobID in the table, and if so, cancelling the update. intInvoiceCheck = DCount("[JobID]", "jobs", "[JobID]=" & Me.JobID) If intInvoiceCheck > 0 Then Response = MsgBox("You have entered an Invoice # that is already used." & _ Chr(10) & Chr(13) & Chr(10) & Chr(13) & _ "If this is a secondary invoice considering adding 'a' or 's' to make it unique." & _ Chr(10) & Chr(13) & _ "For example, " & Me.JobID & "a, " & Me.JobID & "s...", vbOKOnly, "Duplicate Invoice") Me.JobID.SetFocus Cancel = True Exit Sub End If However, if the user is changing say a jobsite address, they can't, because it checks and sees that intInvoiceCheck = 1 and won't continue. I tried moving my routine to the BeforeUpate event of the JobID textbox like this (this is not the final code, only what I testing with) 'Check that the entered Invoice Number value is unique Dim intInvoiceCheck As Integer Dim Response intInvoiceCheck = DCount("[JobID]", "jobs", "[JobID]=" & Me.JobID.Value) If intInvoiceCheck > 0 Then MsgBox ("Dupe") Cancel = True Me.JobID.Undo End If However, I getthis long error message saying I have changed the validation rule of the field without first checking to see if it's valid.... I can change the to Me.Undo, which works fine, but I don't want to undo the whole entry, only the JobID and set focus to it, and make the user enter a new one. Can anyone help me out with this? Thanks, Hammy
View Replies !
Spell Checking Forms - Pop Up Box
When using DoCmd.RunCommand acCmdSpelling to spell check a form in an on close event, is there anyway I can stop the pop up box 'Spell Checking is complete' to avoid having to click OK each time
View Replies !
Checking For Duplicate Numbers
I have a form in which new equipment is added. I want to be able to check when the ID number is added (first field on the form) that there is not a duplicate ID number. If I wait till the end of the form and save, then Access tells me that there is a duplicate present but by then I have spent time putting in all the rest of the data. If have added this code in the before update section for the relevent field, but it doesn't seem to work. Can someone please help clarify or suggest an easier way Dim IntIDCheck as integer Dim Response IntIDCheck = DCount("[EquipmentID]","Equipment Inventory","[EquipmentID] =" & Me.EquipmentID) if IntIDCheck > 0 then Response = MsgBox ("Duplicate Present") Me.EquipmentID.SetFocus Cancel = True Exit Sub End if Thanks
View Replies !
Help Checking For Duplicate Entries
Hello, I'm new to using VBA for MS Access. May I enlist your help, Please. I'm working on a human resources database for a group of employees. I'm trying to automate their login process after they have opened the database so that each employee's privacy is respected. Using an initial form, employees are separated into "New User" or "Returning User". My problem concerns setting up the "New User" in the database. The New User is directed to form "frm_NU". The form has several unbound fields which are later carried to the table "tbl_Employees". Two of the fields on the form are used to create the EmployeeID. Those are Initials [INI] and Phone Extension [EXT]. The EmployeeID will be used in a filter so that only that employee's information is made available to the user (simulated Privacy). Because the employees are unfamiliar with MS Access and its cryptic error messages, I need to create a message box which will give a plain English warning when a user attempts to use an existing ID to create a new record. [EmployeeID] is a field in the table. it is set as a key and does not allow duplicates. When a new user enters his/her initials and phone extension I want the new ID to be compared to the table and if found, a message should appear. This is a preemptive strike to prevent the user from getting to the more cryptic MS Access error message. I've tried using Dlookup and Dcount to try to pass some meaningful data to the If statement variable VarX to trigger the message box; assuming that Varx should be something other than Null or Empty Dim EmpID As Variant Dim VarX As Variant EmpID = [INI] & [EXT] VarX = DLookup([EmployeeID], "qry_Employees", [EmployeeID] = [EmpID]) If VarX <Is Not Empty> Then X = MsgBox("Another record already exists by that name", vbOKOnly) Else Y = MsgBox("Passed", vbOKOnly) End If I keep getting an error at the DLookup formula or DCount formula saying: Run-time error; 2001 You canceled the previous operation. It also appears that the DLookup never looks up anything nor does DCount count anything even though I'm purposely entering duplicate information which exists in "qry_Employees". I was expecting VarX to be either the duplicate ID or a record number or record count or something. Any ideas or constructive suggestions? Thanks, Goh
View Replies !
Checking Email In Database Already
I currently setup a form for a survey which works fine and all the information that is gathered is stored in an access 2000 database. The thing i want to do is to only let the person fill out the form using only 1 email address. So if they try to come back and fill out the form again using the same email address, i want there to be a check on the database to see if the email is there. If it is the form wont submit and it will let the person know. If it's not in the database things will work as planned. this is what i have so far, but when i submit the form it continues on, but it doesnt check and doesnt email or add to the database like it used too... Code:<%Dim DSNtemp, Conn, SQLDSNtemp = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=DATABASE LOCATION"Set Conn = server.createobject("adodb.connection")Conn.Open DSNtempemail = Request.Form("email")SQL = "Select * From users Where email = '" & email & "'"Set RS = Conn.Execute(SQL)'HERE WE CHECK TO MAKE SURE THE USERS EMAIL EXISTS, IF IT DOES, WE STOP HEREIf NOT RS.EOF Thenx = "Sorry The Email Address You Entered Already Exist!"Set RS = NothingConn.CloseSet Conn = NOTHINGElse'CONTIUES ON WITH DATBASE INSERTION AND EMAIL TO USER.End If%>
View Replies !
Checking Multiple Columns + Asp
Question concerning how to check a value against multiple columns in Access with ASP. Need help converting this to proper ASP and Access syntax Code:myId = "test"myName = "monkey"SELECT * FROM table1 WHERE (programId1='" & myId & "' OR programId2='" & myId & "') AND (name1='" & myName & "' or name2='" & myName & "')" is this doable with asp and Access? If this helps explain it better, the following is how I would call it with PHP & mysql: Code:$myId = "test";$myName = "monkey";SELECT * FROM table1 WHERE (programId1 = $myId OR programId2 = $myId) AND (name1=$myName OR name2=$myName) Any help would be appreciated
View Replies !
Checking Empty Field
Im trying to check if a field is empty (i.e hasnt got anything in it)- but how do i do this. Ive called the field in my sql statement and then Ive put it in a variable- i, I am then running a if statement Code:If i = "" theni = "1" ElseEnd If But this is not working?????
View Replies !
Checking Whether Path Is Valid
I am making an application in Access where a number of image files are copied to a folder in the server. I need a way to find out whether the folder in which the images are being copied to exist so that a new directory can be created if it does not exist. Please help with a code to check for the validity of the existing path.
View Replies !
Looping And Checking For Null
I am trying to build an email string and have been sucessful...although there are times when the Email Field in my table may not have a value.... Currently this creates an error....I am trying to test for Null and then SKIP that record if it is null and move on... Any thoughts? THe problem is that I can click the Msgbox that gives me the varialbe from strTo endlessly....I am stuck in the loop...it never gets to EOF??? It never even gets passed the first record it finds... Something is messed up.... Anyone have any thoughts... ????????????????????? ' START CODE ================================== Dim dbs As Database Dim rs As DAO.Recordset Set dbs = CurrentDb Set rs = dbs.OpenRecordset("Select * From tbl_Groups", dbOpenDynaset) Dim strTO As String Dim EmailString As String strTO = "" EmailString = "" Do Until rs.EOF strTO = rs!Email If strTO = "" Then MsgBox "NOTHING" Else MsgBox strTO End If Loop DoCmd.SendObject acSendNoObject, , , EmailString, , , "Subject Line", , True ' END CODE ====================================
View Replies !
Checking For Strings In A Field
Hi I am trying to read a large file and to check if the phone number field is valid. If there are more than 6 "1"s, "9"s or "0"s in the field, then I want to replace it with a null otherwise, I will treat it as a valid number. Can you help? Noel
View Replies !
Frontend Revision Or Version Checking
Hi Guys, Does anyone have a code to check if the frontend version being used is the latest? I have a frontend in the server linked to a backend which I distribute to users via a batch file. The batch file simply copies the frontend unto the users desktop. When I do an update, I simply overwrite the old one with the updated frontend and tell the users to run the batch file again. Any ideas is highly appreciated. Thanks. Luther
View Replies !
Counting And Checking N Levels In A Recordset
Hi, I need to work out how many components we have in stock that make up a Part - identified by being the PrimaryPart. Each part has a component, which in turn has another component, but different part have a different number fo sub-components, a simple display of the table I am using is shown below: ID PartName ComopnentID No. in Stock PrimaryPart 1 Part X 2 12 Yes 2 Part Y 3 14 No 3 Part Z 15 No 4 Part T 5 1 Yes 5 Part U 6 11 No 6 Part V 7 25 No 7 Part W 20 No The problem I have is that I need my vba code to check if there is a sub-compnent for the current part and if so make sure that is counted. So in the instance above Part X has 2 sub-compnents (Part Y, Part Z) and there are 41 bits in stock, whereas Part T has 3 sub-compnents (PartU, PartV, PartW) and there are 57 bits in stock. How do I get a script to recurse X number of times to check. Thanks
View Replies !
Need Help With Checking Room Availability Query
Im looking for help for checking for room availability by date and accomodation type. I will be selecting the query from the following tables and fields. [1]Reservation Table Reservation ID (PK) Hotel Number (FK) Room Number (FK) Customer ID (FK) Employee ID (FK) Arrival Date Departure Date Number of Guests Methood of Payment [2] Room Type Table Room Type ID (PK) Room Type Name Price Bed and Breakfast Evening Meal Business Facilities No of rooms per Hotel
View Replies !
Checking Multiple Check Boxes At Once
Hi there, I have several check boxes, that are however categorised, in my form. I was now wondering, in order to save some time, how could I make a check box that marks/unmarks all the boxes under that specific category ?? Cheers, Pekka
View Replies !
Checking Selections Against A Date On A Form
Hi , I am very new to access and I have made a database for a small wedding car hire firm as an assignment for college. The database works fine , I can add my customers , staff , vehicles etc.. and make orders ok but I have some criteria I need to meet running through criteria A-Q I have met all options except for D and K which I guess are the hardest ones of the bunch D) is produce a list of available vehicles and drivers for a given input date. This relies directly on K) working as far as I can tell as once k is done this should be simple. K) is search for an availability that satisfies a customers criteria for example is a car available on a certain date. this is made more tricky as if a vehicle has already been booked for the date I am searching on then it has to return a negative result e.g this vehicle is booked on this date,also if a driver is on holiday on this date I have to again return a negative. I have made a form whereby the user can make their order , choose the car they want and the company can then assign a driver to the order. the form has an order date and simple combo boxes with driver names in and vehicle names , probably not the best way especially for expansion , but I only want to pass the final criteria and get on with my final assignment which has a higher grading weighting. once I select a vehicle for the customer I assume there has to be some kind of a process probably to do with the after update command such as if the vehicle has already got a booking on this date then return a negative message else book this vehicle on this date for this order. the same pretty much for the drivers , though it would be if the booking date is between the drivers holidays start and finish then return a negative else book this driver on this day. I am not altogether sure of the process involved in the check and also if a driver and vehicle are booked for a date e.g 01/01/2007 how I can prevent double booking etc.. at the moment for example I can have Driver1 and Vehicle1 Booked 4 times on the same day. even though Driver1 is on holiday and vehicle1 is booked already :rolleyes: I took it into college to be checked but our usual tutor is off having a baby and the back up one isnt much help (far too busy etc.) so im trying to sort it alone. any advice would be ace thanks.
View Replies !
Checking Email Input In The Form
I need some direction. I have a table with a email as a row in a table. I would like to make sure that the person entering in the data enters the same twice before submitting the data to create the recourd. I know to do this in PHP. Thanks Tom
View Replies !
Checking For Null In Multiple Fields
If I have about 9 Text fields, How would I go about checking to see if all of the text fields are empty, then hide all the fields, but if any of them have anything in it, show them all. Here is my code, but it doesn't work: Code:If SpecAgent = "" And SpecArea = "" And SpecBenefit = "" And SpecCompany = "" And SpecCSR = "" And SpecDoctor = "" And SpecHospital = "" And SpecPlan = "" And SpecRx = "" ThentglNo = TruetglYes = FalselblSpecAgent.Visible = FalseSpecAgent.Visible = FalselblSpecArea.Visible = FalseSpecArea.Visible = FalselblSpecBenefit.Visible = FalseSpecBenefit.Visible = FalselblSpecCompany.Visible = FalseSpecCompany.Visible = FalselblSpecCSR.Visible = FalseSpecCSR.Visible = FalselblSpecDoctor.Visible = FalseSpecDoctor.Visible = FalselblSpecHospital.Visible = FalseSpecHospital.Visible = FalselblSpecPlan.Visible = FalseSpecPlan.Visible = FalselblSpecRx.Visible = FalseSpecRx.Visible = FalseElsetglNo = FalsetglYes = TruelblSpecAgent.Visible = TrueSpecAgent.Visible = TruelblSpecArea.Visible = TrueSpecArea.Visible = TruelblSpecBenefit.Visible = TrueSpecBenefit.Visible = TruelblSpecCompany.Visible = TrueSpecCompany.Visible = TruelblSpecCSR.Visible = TrueSpecCSR.Visible = TruelblSpecDoctor.Visible = TrueSpecDoctor.Visible = TruelblSpecHospital.Visible = TrueSpecHospital.Visible = TruelblSpecPlan.Visible = TrueSpecPlan.Visible = TruelblSpecRx.Visible = TrueSpecRx.Visible = TrueEnd IfEnd Sub
View Replies !
|
TRACKER
