I am writing text to a database from a web form and need to encrypt the text in the Access database to ensure that the information is kept secure and only accessible from the web form that is password protected.
View RepliesWhen using SendObject to send an e-mail, is there code to turn on the following?
- encrypt,
- digital signature and
- read receipt
Or must the user activate these when the e-mail is generated?
I am looking for a function that will allow me to encrypt/decrypt single image files as and when required. I have built my own simple one to encrypt a string that will be stored in a filename as all the ones I found created unusable filenames.
However I don't know where to start with the image file encryption.
(Any better way to encrypt a string that can be used in a file name that would be great too. My method is a bit basic).
Im creating an update form for users that arent particularly tech-savvy, so i want them to be able to insert page breaks without having to manually insert "<br />" into the form field as it saves into the access database. is there a script or maybe just an option within access to render the field as plain text (with page breaks whenever the return key is pressed)? thanks!
View 1 Replies View RelatedHello Friends,
Thank you for all the help i have gotten over the past couple days, as you can tell i am new and seek somebodys experience and wisdom to solve my issue.
I have a simple Form, That allows the users to enter contact information.
At the very top I have "Name" and "Age" and below it i have other fields such as Address, city, state, etc...
How can I make it so the user does not have access to the other information until they type in BOTH fields "Name" and "age" first.
Can somebody please show me how the Code might look like.
Thank you for your time.
I am very new at Microsoft Access. I have two forms, A and B, that are filled out by two different users. Form A gets filled out first than form B gets filled out. Each has a name box as well as a birthdate box and a few other similar text fields. However, each form also has a few distinctive fields. I was wondering how I could input the common information in Form A to Form B so the user of Form B does not have to spend time retyping the name and birthdates again. In other words, I want to synchronize the similar records between the two forms. I would like the values to appear in a table as well. I would greatly appreciate it if someone could help me with the visual basic code. Thank You.
View 1 Replies View Relatedhow can i disable a textfield or two in a form when the textbox is unchecked also how do i add a default value for it while the textbox itself is disabled, can i get away with it by adding a default value on the textbox?
View 14 Replies View RelatedWe need to move rich text from an Access memo field to a Word text box. So far the best Ive been able to come up with is in the code below. In this code pprs!What is a record set field of a table memo field that is bound to a text box enabled for rich text. The rich text seems to be stored as html as so I can get word to convert it by enclosing it in html tags.
Dim What As Word.Shape
Set What = doc.Shapes.AddTextbox(msoTextOrientationHorizontal , doc.PageSetup.LeftMargin, 225, 534, 0)
Dim sPath As String
sPath = "G:Temp.html"
Open sPath For Output As 1
Print #1, "<HTML>" & pprs!What & " </HTML>"
Close #1
What.TextFrame.TextRange.InsertFile (sPath)
Hi all,
I have a text source file and inpul layout i.e. field names start and end positions in excel file. I want create a table in access from the text data using excel file layout.
Can you please help me out in this. I am a mainframe programer and recieved an request to work in access.
Is there a way to populate fields in Access from fields in Excel in Office 2010? If so, what do I need to do?
View 6 Replies View RelatedI have imported a link table into access.
The Year field I wish to search on is Text.
I have entered a wildcard before the year i.e *2003 within the criteria, but still cannot read the number.
Can anyone suggest anything?
what code do I need to put behind my txt fields on my form so that it automatically writes to the relevant table?
Also, how do i program an unbound txt field on a form to link to a field in a table?
many thanks in advance, Steve
I have many rows of information i am entering in access. I want to setup this spreadsheet to look at previous rows of information so when I fill one field it will automatically fill some of the other fields in the same row with the information from the rows above.
if this is not possible then I want to create a dictionary of information so if information is typed in one of the fields it will automatically populate some of the other fields on the same row.
Hi all,
I have been given the task of cleaning up an old db. One thing I'd like to do is combine 3 text fields into 1 new field.
In the old db there was a form that included 3 memo text boxes, when the first one was full the user then started using the second and then the third. The relating Table fields are message, overflow message & overflow message extended.
I'd like to combine the fields into 1 and then design a new form to suit so that the memo text in the new db goes into 1 field only.
I have many rows of information i am entering in access.
I want to setup this spreadsheet to look at previous rows of information so when I fill one field it will automatically fill some of the other fields in the same row with the information from the rows above.
sorry cannot explain very well
if this is not possible then I want to create a dictionary of information so if information is typed in one of the fields it will automatically populate some of the other fields on the same row
Hi people,
I have a report that is linked to a data entry form. Is there a way to not show certain labels and text boxes if a text box on the form has the value "N/A"?
Something like:
Private Sub Report_Open(Cancel As Integer)
If txtFireType = "N/A" Then
txtFireType.Visable = False
End If
End Sub
This doesn't seem to work by the way!
Really appreciate all of your help.
Just say I want to summarise in a text box the options given in three option groups.
For instance I have chosen A then B and then C and then in a text box I want to put ABC.
Do I need to set up a query to do this? or do I need to write some code?
Can anyone tell me how to count (sum) text fields. My current query will search for:
1) Name
2) Ticket Number (ww*, beginning of one type of ticket)
And it works fine except that after running the query I have to manually add up how many of the ww tickets each person wrote. Is there a way to make it change the ww* tickets to a number, like 1, so that it can be added up or to add up by the persons name how many tickets they wrote. I'm using Access 2000.
Thanks
Hi people,
I have a report that is linked to a data entry form. Is there a way to not show certain labels and text boxes if a text box on the form has the value "N/A"?
Something like:
Private Sub Report_Open(Cancel As Integer)
If txtFireType = "N/A" Then
txtFireType.Visable = False
End If
End Sub
This doesn't seem to work by the way!
Really appreciate all of your help.
Hi All,
I have a field with a bunch of records. All is formatted the following:
CAN-2007-US-00001
CAN-2007-US-00002
CAN-2007-US-00003
CAN-2008-US-00001
CAN-2008-US-00002
CAN-2008-US-00003
and so on and so forth. Is there a way Acess can break the fields out? I want 1 field with CAN, 1 field with the year, 1 field with US, and 1 field with the number (4 different fields broken by the hyphen).
I can do text to column in excel before I import, but just wondering if it can be done in Access. Thanks in advance, guys...
Caliboi
I have text boxes that combine two fields into one, for example the control source is =IIf(IsNull([BuckC])=True And IsNull([BoostC])=True,"",[BuckC] & " , " & [BoostC]) . For simple its just =[Buckc] + ": "+[BoostC]. I am trying to set a condition that if one of them exceeds a certain number the background color will change to yellow. I know how to do this if its only for one field but I am wondering if it is possible to do it with multiple fields?
View 9 Replies View RelatedIs it possible to use <enters> in text or varchar fields??
In this way users can easily switch to the next line instead of typing everything all together
How do I handle " in text fields - I have a few customers names like "Zoom" - who insist the name is with " in it.
This buggers up queries and filters etc - becuase of the confusion the " creates.
How do i solve this?
Hi
Is there a way of changing the case of text that has been entered in a table?
Want a form to display capitalised names, say, no matter how they were entered. Know that they can be displayed in all caps using >.
Thanks
We use two different systems in our office that have notebook facilities. One of them stores only a limited number of characters in the note field per record and as such, some notes actually span several records.
The other system stores the whole note in one record.
We want to transfer all the notes from the first system (1 note over several records) to the second system (1 whole note in 1 record).
I have a table with the notes from the first sytem which looks something like
Note1 - Line1 - Text
Note1 - Line2 - Text
Note2 - Line1 - Text
Note3 - Line1 - Text
Note3 - Line2 - Text
Note3 - Line3 - Text
What I want to do is, for each note, combine the separate lines into one record.
I have been able to do this in Excel with some formulas (see attachment) but am wondering if it is possible to do this in an Access Query (i.e. GroupBy the note number and have a calculated field combining the individual lines of the note, or something similar)?
In a form I can easily combine and display the content of two text fields in a third text field with the formula =[field1] & [field2]. Very well. Now I would like to combine and display only the first letter of each of the two text fields. This I would expect to go somewhat like this =(letter,1,1[field1]) & (letter,1,1[field2]). How is the correct formula?
View 4 Replies View Related