I need a Userform for employee reports which should be accessible for everyone without any struck.If employees update their updates in that form it should be stored in the centralized Data base.Finally the data collection team will take the reports and updates from data base.
View 1 RepliesIs it possible to use the userform when it is protected and shared.
I am able to access when it is protected. but unable to access when that protected worksheet is shared.runtime error message " unprotect method sheet class failed" appears it is shared and used.I have already raised this [b]issue in the forum.I understood from the answers that it is not possible.
" My requirement is multiple users should use the form and they should not have the access to edit the entires made by them"
Please give me a solution.
" Being a moderator myself i should only be able to edit or modify the entries made by the users."
Note:
I dont want to create multiple excel sheets for multiple users.i want to use a single excel sheet (Shared and protected)
Also provide me an alterante solutions if any
I am trying to change the property value of all optionbuttons on userform1 via userform2's deactivate event
Private Sub UserForm2_Deactivate()
If userform1.Controls = OptionButton Then
Value = False
End If
End Sub
I have a userform that employees use to enter production data every day. Originally I had this storing the data in excel, but now I would like it to put the data in tables in access.
Here is some code I am trying, but it's giving me an error: "Run-time Error '3251' Current Recordset does not support updating. This may be a limitation of the provider, or of the selected locktype."
VB:
' exports data from the active worksheet to a table in an Access database
' this procedure must be edited before use
Dim cnt As New ADODB.Connection
[Code].....
I'm currently working on something that requires me to use an access database with an excel userform.
I have a team of around 50 people who will be making outbound phone calls and the data for these calls is stored on an access db. The people calling don't have MS Access so I've created a userform for these guys in Excel, which they have on their computers, and I want them to be able to click the button "Get Next" on the form and up pops the next customers information to call.
I have a userform with some text boxes where I want the info to appear on click.
I have customers name, their mobile handset type which the ordered recently and their phone number.
So I've started off with the following which seems OK:
[Code] .......
What to use next.......DLookup didn't quite work......
I'm also wondering if I'd need something to send to access to basically say that customer 001 has been pulled through already and to move onto the next because there will be 50 people using this (max) at one time.
I've created a userform which contains 20 labels. To access the Caption property of the 13th Label, I use Me.Label13.Caption ..... Can I also access it in a more dynamic way (e.g Me.Labels[13].Caption) ?
View 3 Replies View RelatedI have a workbook, that has a lot of VBA code, & Userforms. I need to be able to share the workbook with a number of users.
View 13 Replies View RelatedI am using Access as a backend and Excel as a frontend for my project. Now I have to display a chart in the userform using data from Access database .
View 2 Replies View RelatedI have a signup record that expected to grow up to row 400. On the top, there's a monthly tally for reports. Column B to count the number of boxes taken and Column C for the users picked up the boxes.
Users should be accounted as one appearence in a month, regardless re-appearance in the same month or different month.
I haven't found the generic formula to uniquely count the number of users regardless their frequency in a month.
NOTE: Timings, box numbering format and usenames are randomly generated. Any similarities with real subjects will be coincidence only.
I want to access the Properties of a number of controls in a running form, and these controls may or may not be contained in a Frame or a MultiPage.
In particular I want the Top and Left for these controls, which means I have to first find out if the control is contained in a Frame or MultiPage so I can get the reference for Top and Left. I'm ok with doing this for controls inside a Frame, but the MultiPage is eluding me. I get an error when I try to access these controls and it looks like they are actually owned by the individual Pages of the MultiPage.
how do I find out if a given control is contained in a given MultiPage?
Validate UserForm MultiPage and Frame Controls
We're trying to use one template to enter data with users being able to start entry from a number of different starting points. this changes they way the look-ups have to work. The attached sample explains it a whole lot better.
View 2 Replies View RelatedI have a listbox to select 1 of 15 items. This selection will allow me to access the proper portion of my data. I want to use this number to concatenate the result * predetermined number to access a cell.
Ex
If result from listbox is
if 1 then I want to access data from cell AA7
if 2 then I want to access data from cell AA99
etc.
I can create the cell I want using the code
="AA"&Y2
but what function do I use to call for the cell?
I am using Access as a backend and Excel as a frontend. I want to count total number of records for todays where Time<13:01
Modify the following code accordingly?
[Code] .....
Please see attached the Workbook. I need to check the policy Numbers in Column A to be present in Access Table. If yes then write the corresponding ScanDate and BatchNo in columns I and J.
Sun Project.xls‎
I am Generating Excel file with Macro using my asp.net (c#) application.
I am able to generate Excel file in development environment, but in Production it gives following error:
"Programmatic access to Visual Basic Project is not trusted Line: Microsoft Office Excel"
I did googling a bit and found that I have to open Excel file physically make few security related changes in macro as below.
1. Open the Office application in question. On the Tools menu, click Macro, and then click Security to open the Macro Security dialog box.
2. On the Trusted Sources tab, click to select the Trust access to Visual Basic Project check box to turn on access.
3. Click OK to apply the setting. You may need to restart the application for the code to run properly if you automate from a Component Object Model (COM) add-in or template.
Can i do above changes at runtime (using some code)?
the spreadsheet needs to be copied to a directory called "C:downloads" as it contains a ODBC query to itself (In reality, this is a query to an External Oracle Database)
On loading, it should pop up a simple userform, with a combo and two command buttons, which when pressed takes you to a (hidden) tab that displays a pivottable.
All works well until I try to close /save when 60% of the time, Excel encounters problems and closes and will not load up the file the next time until either quit excel or disable macros. Messages include "file/path access error", "I/O Error" or get restarts excel.
On a casual run through, I expect you might report back that "All worked ok for me". Please can you give it a bit of a thrashing, comment out the userform show, save the file (frequently) becuase i assure you it will break ultimately!
This is a brand-new file and I've tried it on about 5 different PC running different versions of Excel and generally get the same result.
I have an Excel file ( named "Classes.xsl"), that has a worksheet (named "RawData") that is layed out something like:
Name Dept Class
John 0547 Class 1
Jane 0368 Class 1
Jim 0368 Class 2
Sue 1235 Class 2
I am trying to get an Access-Like report without utilizing Access. Is there a way to generate a report similar to below using Excel as the data source (could be mail merge, perhaps a macro with a printout) I am not sure which way to try and was hoping someone could point me in the right direction...and possibly provide an example.
Class EnrollmentClass 1John 0547
Jane 0368Class 2Jim 0368
Sue 1235
I have listbox on a userform with number and the way it should work is that when I click on a number in listbox the data correspond to this number should be copied from one sheet to another sheet and gets plotted on graph. The problem is when I click on a number in the list box the data moves from one sheet to another and get plotted but only after I exit the userform sheet.
View 14 Replies View RelatedConvert carton data from unreadable form to text box form (human readable form). I use this code:
=MID(n_combo,11,5)&"-"&MID(n_combo,16,4)
But it works if i close the user form and open it.
how to input a data/number into excel through vba userform and get another data/number from excel back to the userform??
View 8 Replies View RelatedThe form that I have created has a number of controls that are created at runtime. If a user triggers the event that originally created the controls, I want to be able to delete all of the controls before recreating them.
Is there a loop that can delete all of the newly created controls? I have 9 controls on the form that need to stay put but everything after those 9 controls I want to delete. Is there something like:
In the attached sample (with macros enabled), you will find the problem when pressing the button “INDTAST DATA” (I apologize for the linguistic challenge, but the XL-sheets are in Danish… To relief – check the crash course in Danish below) and then entering some number in the two last textboxes (called “Forventet ændring i antal timer I næste kvartal (%)” and “Forventet ændring i omsætning i næste kvartal (%)”)… If you enter something there, the result will be multiplied by 100 in the worksheet.
I would like to be able to simply enter a full number – like 12 or 9,5– which will then be entered into the worksheet as 12% or 9,5% (and not 1200% or 950%)… I think the answer lies in inserting some code in the VBA code, when the macro writes the data to the worksheet, but you guys know more about it than I do...
I can, of course, enter a full number in the textboxes – followed by a %-sign, but that will slow down the process significantly as well as increase the risk of errors…
Virksomhed = Company
Kvartal = Quarter
År = Year
Branche = Industry
Fakturerede timer = Billed hours
Faktureret omsætning = Billed revenue
Timeforventning = Expected hours (next quarter)
Omsætningsforventning = Expected revenue (next quarter)
Indtast data = Enter data
The problem is even though the worksheet cell is formated to 3 places the text box in the Userform shows many more than this. I have used the Control Source set to read the cell value.
The answer I've seen 'txtValue = Format(Value, "000.00")' which seems very neat and tidy but I'm not sure how to use it or where to place it.
I have a user form that has a label "txtcompno" which displays a "Auto incrementing" number everytime the user form is opened. e.g. 90001, 90002, 90003 and so on. This was working fine till yesterday, but has since stopped working for some reason: This is the code I wassuccessfully using before:
Private Sub UserForm_Activate()
Me.txtdate.Caption = Format(Now(), "dd/mm/yyyy")
Me.txtcompno.Enabled = True
Dim iRow As Long
Dim ws As Worksheet
Set ws = Worksheets("ComplaintData")
' find last data row from database
iRow = ws. Cells(Rows.Count, 1) _
.End(xlUp).Row
If ws.[A2].Value = "" Then
Me.txtcompno.Caption = 90001
Else
Me.txtcompno.Caption = ws.Cells(iRow, 1).Value + 1
End If
End Sub
but now its giving me error - "Run time error 13 : Type mis-match". and its highlighting the line: Me.txtcompno.Caption = ws.Cells(iRow, 1).Value + 1
i've got a sample database (attached) with a userform for inputting of data. What i want it to do is automatically generate the next number and add it to textbox "our ref" on the userform. the number is in Col C. This is the code i've tried using the code highlighted in red which doesnt work.
View 12 Replies View RelatedI am trying to show the number of years in the userform textbox based from today's date and into the date the eqpt was installed. I stuck with the below code.
Code:
Private Sub DTPicker1_Exit(ByVal Cancel As MSForms.ReturnBoolean)
If TextBox1.Text "" Then
TextBox2.Text = Year(DTPicker1.Value) - Year(TextBox1.Text)
End If
End Sub
Where in textbox1 I have this code that activates on userform initialize
Code:
If Me.TextBox1.Value = "" Then
Me.TextBox1.Value = Format(Date, "dd.mm.yyyy")
End If
End Sub
Textbox2 is where I want the number of years to appear .
I want to require the user of my Excel Userform to input a number greater than 100. How do I do that?
View 4 Replies View Related'TextBox1.Text = Sheets("Shet1").Range("a1").Text'
However I have thirty text boxes on the Userform all linked to cells on a sheet. How do I apply this so that I dont have thirty lines of code. It just does not look elegant. I'm doing this because the number on the userform shows more decimal places than the cells format. Cell formated to 3 places Userform shows about 9 mostly .999999 etc
I have an excel sheet where i have the part number in the Column "A". I have four sets of four columns each which has the details of price for that particular part, currency , lead time and the Vendor Name. Now i want to have an user form where in i can put in the details of a part number and i should get the details of the best vendor in terms of price and lead time Seperately. The best vendor in terms of price is determined by comparing the values in the columns B, F, J & N and The best vendor in terms of leadtime is determined by comparing the values in the columns D, H, L & P. I have also created an user form with out any code just to give you an idea of what i am looking at. So that it can be helpful to you. I just key in the part code and i get the best results for the same.
View 6 Replies View RelatedI have a form using text boxes to enter some data into a spreadsheet. These text boxes appear in pairs for any single point (e.g., name ; location). Does anyone have a code which can actually define how many of these pairs will appear on the form when loaded? For example if there are 5 points to be defined the form should have 5 pairs of these text boxes. The maximum number of these pairs is around 10 and I could make a form with a 'standard' number of 'pairs' but that's not really it. I've tried to attach the form but it did not work
View 9 Replies View Related