Set Size Of Inputbox

Apr 13, 2006

Hi all,
I have an Input box that appears on certain criteria, using the folllowing code
Code:inputbox: myqty = inputbox("Please Enter Quantity!")If Nz(myqty, "") = "" ThenMsgBox "You must insert a value" GoTo inputboxElse![Issued] = myqty End If

Does anyone know how i can set the size of the Inputbox as at present it appears to big for what i want.

Thanks in advance
1E1V

View Replies


ADVERTISEMENT

Masking Inputbox

Feb 25, 2007

Would anyone know if it is possible to mask and input box with a password mask (*****)

my code is simple:

StrPswd = InputBox("Enter Password", "ENTER PASSWORD")

I was trying to mask the entry in ****** when the user enters the password.

Any ideas ??

Thanks

View 2 Replies View Related

How To Put InputBox Value In Field

Mar 28, 2005

Hey All!

Well I got a little problem and well... is simply but just I didnt know How.

When I pop op a inputbox and then i enter value I want this value got parse under a field

The code is the follow:

Private Sub SetPSW_Click()
Dim Boite As String
Dim PSWNew As String

PSWNew = PSW.Value
' The current password is sotre under this field PSW
Boite = InputBox("Entrez le nouveau mot de passe", "Nouveau Mot De Passe")
PSWNew = Boite
' Here I want then the value of Boite is putting on PSWNew
End Sub

Thx for help cuz i can't figure out how to do with a inputbox

View 2 Replies View Related

InputBox TExt Box

Sep 22, 2005

Is there any way to change the password character that MSAccess uses (*) to
something different?

I want to use the lower case (L) from Wingdings (because it would look just
like the Windows XP password

Any Advice would be appreciated.

I like to apply this to a text box

MSAccess 2003 (2000 Database)
Windows XP

Thanks

View 1 Replies View Related

How Do You Save Inputbox Value To Table?!

Aug 10, 2006

Okay, I've been working on this database for weeks now, I'm almost done, there is a light at the end of the tunnel and my boss is anxious to implement the db as I'm only here for 3 more weeks and it MUST be completed, tested, error checked before I leave. So I'm running out of time FAST!

Okay, the problem is simple. I'm using a Data Access Page in Access to build a nice little front-end for my database for my co-workers to use. On this DAP (Data access page) I have an Input box that allows the users to browse their directory and select a file. I need to take the path/file name that pops up in the input box and just save it to the table. I can take care of all the other elements.

So, through DAP, how do I save the value in the inputbox into my table. Please, any help would be great! :eek:

View 2 Replies View Related

How To Mask Input In A InputBox

Jul 12, 2006

I have an input box in which the user types in a password to enable the shift bypass, when the user types in the password it show it letter for letter, is there a way to mask the input so that it shows the characters as the traditional *

[CODE]strMsg = "Do you want to enable the Bypass Key?" & vbCrLf & vbLf & _
"Please key the programmer's password to enable the Bypass Key."
strInput = InputBox(Prompt:=strMsg, title:="Disable Bypass Key Password")CODE]

View 5 Replies View Related

Modules & VBA :: InputBox Search With (Like)

Oct 2, 2014

I am using an input box to find a Street name in a record using the following:

Dim rs As Object
Dim strCriteria As String
DoCmd.OpenForm "frmStreets"
strCriteria = InputBox("Please enter Street Name")
DoCmd.OpenForm "frmStreets"

[Code] .....

I know that if the search criteria is a number, then the .findfirst will work OK, as I am also using that, but I am not seeing where the " or ' or * should go so the correc

View 5 Replies View Related

Running Two Queries From One Inputbox Result!?

Feb 25, 2005

Hi,

I have created the following function in my datebase so that i could specify the date a query works from.

Option Compare Database

Function GetParmValue() As Date

GetParmValue = InputBox("Please enter the date you wish to update!?")

End Function

I have a button on a form that runs the query in question, there is also an identical query that needs to be ran using the same result from the input box but rather than it display the input box twice i wondered if there was a way i could use the result from one of the boxes with both queries!?

Here is the code for the button;

Private Sub bImport5_Click()

DoCmd.SetWarnings False
DoCmd.OpenQuery "Update"
DoCmd.OpenQuery "UpdateFuture"
DoCmd.OpenQuery "MoveFuture"
DoCmd.SetWarnings True
MsgBox "Files have now been updated to the specified date and moved to the Future Dated table!", vbOKOnly, "Update Complete"

End Sub

Any ideas guys?

Many thanks
Tim

View 2 Replies View Related

Modules & VBA :: Use InputBox To Open Form

Jul 24, 2014

I want a user to enter a number into an input box and then based on the number in this box a form will be opened with records associated only with that employee number. (All employee numbers are stored as text)The code below opens the form, but it is blank.

Private Sub cmdOpenAddKeys_Click()
Dim EmployeeNumber As String
EmployeeNumber = InputBox("Please Enter Employee Number:")
DoCmd.OpenForm "frmAddKeys", acNormal, , "[Forms]![frmAddKeys]![empno]=" & EmployeeNumber
End Sub

View 3 Replies View Related

General :: Moving Record From One Table To Another Using Inputbox

Jun 20, 2014

I am trying to get a record from tbl_new_accounts to tbl_closed_accounts, based on the number entered in a input box.

Code:
Dim StoreNumber As String
StoreNumber = InputBox("Please Enter The Store Number", "")
CurrentDb.Execute ("INSERT INTO Tbl_Closed_Accounts SELECT Tbl_New_Accounts.* From Tbl_New_Accounts WHERE (((Tbl_New_Accounts.Fld_Store_Number)=" & StoreNumber & "));")

View 1 Replies View Related

Modules & VBA :: Update Multiple Records With Value From Inputbox?

Sep 11, 2014

Instead of using an update query, so my Audit Trail will continue to update correctly, I'd like to use an input box and run a function that performs much like an update query.

My problem is, only one out of 4 records updates correctly.

Code:
Me.txtTranTo = InputBox("Enter Location Transferring To:", "Location Transferring To", "")
Me.txtTranFrom.Value = Me.Location 'Old location
Me.Location.Value = Me.txtTranTo 'New location

The txtTranTo and txtTranFrom are unbound text boxes.

EDIT: Forgot to mention that this is in a continuous form.

View 1 Replies View Related

Determine If InputBox Cancel Button Clicked?

May 21, 2014

How can I determine if the InputBox Cancel button was clicked?

View 4 Replies View Related

Large Field Size = Larger Overall Database Size?

Aug 29, 2005

Will keeping your field size shorter result in a smaller MDB file?

Or does Access only use as much space as there is real data in its fields.

Way back in the dBASE III days, dBASE would pad all your "real" information with as many spaces as necessary to fill up your field. I suspect that the MDB structure is probably smarter than that.


Another question on the same topic - I believe there is a maximum number of characters in a record (4000?). Can your field sizes add up to more than 4000, as long as the actual data, all combined, never totals 4000...?
Thanks............
..dc

View 3 Replies View Related

DB Size

Sep 18, 2006

Hi,

What should be done when the size of a database keeps getting bigger and bigger?

Regards,
B

View 14 Replies View Related

MDB Size

May 10, 2007

I'm trying to create an mdb that is well over 2 gig and everytime it gets to 2 gig, I get an Invalid argument statement. Is there any way to bypass this process and create an mdb in excess of 2 gig? I've tried linking tables, queries, etc and I have also compacted and this mdb is simply that big.

View 14 Replies View Related

Access Size

May 20, 2005

I'm still in design phase but I'm going to have more than 30 tables. I know I'm going to have a pretty good number of forms, queries and reports. Should I start preparing for the worst in case this db gets too big? What kind of techiques can I use to make sure that it still runs quickly enough?

Thanks

scratch

View 4 Replies View Related

Field Size

Jun 9, 2005

I have a query that consists of three fields. This query is then placed in a form. I would like to set the physical length of my fields because one field consists of 4 digit numbers (I want the size of this to be relatively small) and the other two field consist of categories (field that need more space so that the user may see each letter of the category) Please help.

View 1 Replies View Related

Size Matters!

Jun 14, 2005

In the time-honoured fashion of reducing the size of the front end of a db I imported everything into a new db. The size reduced from 32mb to 17mb. Success.

When I change anything, no matter how small, in the new db, it immediately increases in size back to 32mb. I always compact on exit.

This is annoying, rather than a major problem.
Am I doing something wrong or is this a “feature” of Access?
Access 2000 on XP professional.

View 2 Replies View Related

Display Size

Jan 24, 2006

Is it possible when loading a control form to set the users default display size to say 1024x768. I'm creating quite a complex form and it will be too large on an 800x600 display.

Ta

View 1 Replies View Related

Size Of Access DB

Mar 26, 2007

Hi there..

we have one access database with size about 600mb and 1 million rows in one table.My concern is is it bad to have so much data in access database. If so what is the possible solution for that.

Thanks
Danny

View 3 Replies View Related

DB Ballooning In Size!

Apr 4, 2007

Hey guys,

I'm not sure what happened, but my database size has gone from about 60MB to 290MB. I have added about 10 new records and had an AuditTrail function keeping track of history. I had problems with too many entries in this field, so I deleted the field and started fresh. I have also tried to compact and repair the database. Can anyone give me some light on this situation?

View 3 Replies View Related

Access Size

Dec 20, 2007

I will like to know if access can store a lot of data. I am using a database that was written in access and the database has been in use since like 2004. How long can we still use this database. It is becoming slow and having one or two error messages.

View 2 Replies View Related

Zero Size Mdb Files

Mar 11, 2008

Hi, I am new ( as of today) to this forum. I have been using Access for a few years following on from using Q&A. I manage a database for membership for a club and more recently designed my own database for another personal application. Last weekend I did a full backup on a new laptop I have that has both Access 2003 and 2007 on it ( I don't use the 2007 version at the moment) and following that most of the databases, including backups have gone to zero kb in file size. I tried a system restore to no avail. I can see the files but they are 0kb in size and won't open. Does anyone have any idea why this should happen and more importantly how (if) I can resolve it ?. The laptop has Vista as the O/S.

Kind Regards & greetings from a wet and windy Dublin,

Ian

View 4 Replies View Related

Size Of Datasheet

Mar 16, 2008

Is there any way you can specify the size of a datasheet?

Say the datasheet opens up with 600x800 size?
or 10cm x 15cm?

View 5 Replies View Related

Size Of Table

Feb 2, 2005

unfortunately I am making a form using more than 255 fields which is the max for access 97. I tried using more than 1 table but still no help.
what can I do? will upgrading help?

thanks

andrewm

View 14 Replies View Related

Table Size

Mar 6, 2006

There is probably a real simple way to do this but a couple of us are here racking our brains. :o Is there a way to tell how big a table is size wise? example 1.2mb

Thanks,
-Sandy :)

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved