I have a text box that I only want people to add new data to. I would like them to be able to view previously entered data but not able to edit it. I've tried to lock the data but then I can't add new data.
Any suggestions appreciated,
Joe
Hi,
I have the following situation.
I have a switchboard form which has 2 buttons (Add And Edit)
I have a patient record form, which has 2 fields, (DateRecCaptured and DateRecUpdated)
Both buttons on the switchboard open the Patient Record form (one opens it in Add mode and the other in Edit mode)
This is what should happen.
If I click on the add button on the switchboard, the patient record form should open to allow me to add a record. The system date should then automatically be saved in the DateRecCaptured field.
If i click on the Edit button and edit a record, the system date should be saved in the DateRecUpdated field. If no updates are made, the field shouldn't be updated. If you scroll among records, the DateRecUpdated field shouldn't be updated. When editing, the DateRecCaptured field should remain unchanged.
Thanx
I total novice at VBA. I am trying to code a button to modify (the last) record in a subform list and then add a new record based on values in unrelated or unbound fields on the button form.
The following code is based on the first of two YouTube tutorials (this bit on the edit) and looks like it should work. Except that my Access 2010 with Visual Basic for Aplication v7 does not recognise the type definition Database or Recordset
Code:
Private Sub ANOwner_Click()
Dim cn As Integer
Dim db As Database
Dim rs As Recordset
Set db = CurrentDb
[Code] .....
I have a report in an Access file that someone created for me. I have
NO real experience in Access, it was all done for me, and now I want
to do some editing.
What I have is a letter with "letter head" at the top (text box 1.) This text is centered.
The date (text box 2),then body of the letter follows in the main
larger text box 3. This text is left justified.
When our Principals change I need to change the first text box sometimes
this means there are more or less lines in this box. I have done this successfully, although I'm not sure if it was "correctly" I have replaced names, and made the box smaller to get it to wrap so there is the correct amount of text (Name) on a line. I'm not sure what I would do if I had a line that I don't want to wrap that is longer than the line I do want to wrap. but that is working for now.
The first thing I'm trying to do is put the date in the third larger
text box instead of a seperate box. To do this I figured I needed to
add a blank line before the first paragraph of the 3rd text box, then
enter the current date code. I tried to copy and paste the code from
its current seperate box and paste it into the third box, but then the
report only shows the code/no date and the following paragraph isn't
aligned properly since the only way I could figure to move it down was
with spaces. I tried ctrl/enter, and that just gave me some pop up
dialog box with some tools in it that I don't know what to do with.
The second thing I wanted to do is bold only part of the text in the
large/3rd text box.
Some how I ended up with some blank space between 2 paragraphs so what
I did to get the bolded text paragraph I want is add another text
box, bold it and place it on top of the existing larger text box, but
I always have to move the 2 boxes (3 if you count the date) when I
need to shift the text up or down for any adjustments I do in the
first box. Is there a way to only bold one paragraph of a larger text
box?
I have tried different things, and I have searched "help" as they like to call it, but it is NOT!
I hope this is clear.
TIA
Susan G
P.S. I have tried different things, and I have searched "help" as they like to call it, but it is NOT!
I want to edit a specific textbox depending on a number which is dependent on a number of things and varies each time the form is run.For example, if the number is 0 I want to edit tb0.value. If it's 1 I want to edit tb1.value etc. I have specifically labelled my text boxes in this way.I thought something like this would work
textBoxName = "tb" & number
textBoxName.value = "this is the value I want to enter".
However, this does not work and it produces an error saying 'Invalid Qualifier'.
I currently have a form that has an OLE Object on it that was created by copy-and-pasting from a Microsoft Word document.
The problem is that it only allows me to edit the text when I double-click the Object in Design View. In normal Form view, double-clicking does nothing. Is there any way to change this?
Thanks.
I've looked around and check the help file, I'm sure I'm probably not looking for
right thing here.
What I want to do is include text in the text box that would appear prior to the user
typing in their text.
So say I have my text box and in it appears <Type E-mail message body here>.
Then when the user clicked in the box to type out their message my instruction message
would either disappear or the user could erase it.
I know this is something simple, I just don't know what I'm looking for here. Sorry for the trouble.
Hi
Is the following possible?
I have the code to add the text to a textbox, but what I would like to do is rather than to keep adding the text onto the end.
Make it so that it will add it before what I previously added, so that the newer data is always at the top.
Can I do this? The following is how I'm currently entering the data into the textbox:
If IsNull(Me.LastContact) Then
Me.LastContact = Me.List35.Value & " contacted " & Me.List38.Value & " by " & Me.cmboEngagement & " on " & Date & vbCrLf & _
txtInput.Value
Else
If Not IsNull(Me.LastContact) Then
Me.LastContact = Me.LastContact & vbCrLf & Me.txtInput.Value
End If
End If
Thanks
Am I missing something simple here? I have several text boxes, which I want to add the values. I have tried these formulae, but dont work:
=Sum([Postage],[ProgTotal])
=Sum([Postage] + [ProgTotal])
=DSum([Postage],[ProgTotal])
Any help would be greatly appreciated!
Hi
Apologies first if there is an easy answer to this post as I'm new to Access.
I have a notes box on a form that users update with the latest progress of work done. At the end of each progress I would like Access to automatically add the date, time and user's network id so that I can track who did what and when.
Is there an easy way to code this?
When I send a customer a work order, I want the final page to be a list of conditions of the current sale. In Word, it is nearly a full page of 7pt font with bold and italic. What is the best way to add this to the end of my report in Access?
View 14 Replies View RelatedI am trying to add text to a report. I am using Access 2007.My report is tied to a query. The query contains 2 fields-Hostname and MAC Address
I want run a report against the query, but need to add several commas. So the output of the report would look like this: hostname,MAC Address.
I then want to export the report to a plain CSV file.I thought I could just add a textbox with a comma in the report, but that didn't work well. When I added the text box, Access also created a column header that I did not need.I've also noticed that when exporting a report to CSV format, there are several characters (pipes and such), that work with the formatting of the report. Is there any way to remove this formatting?
Basically I have a text box on a form that needs to be a certain size. The actual text that is populating the text box is too many characters to be displayed. How do I make the text box display the first 3 characters and then an ellipses following?
Also I thought about making a new unbound textbox with ellipses, however, my form is continuous, so even though the some text boxes have empty strings, the ellipses will still be present.
Some pseudocode of what I'm guessing it will look like:
[(If(String(Me![NotesField] > 3 characters) then Return(Left(String(Me![NotesField], 3)" & "..."))]
Hi,
I'm importing the contents of lots of text files using a combination of a loop and DoCmd.TransferText.
This works fine and I can get the contents of several hundred files in a few seconds. The files are called 1.dbb, 2.dbb... and each has an associated image file, 1.bmp, 2.bmp... etc. After the import I move the files to a new folder.
I need to create a link to the bmp file but this information is not included in the text file so I need to rely on a field which contains the file name.
How can I populate a field at import time to include the name of the imported file?
Anyone give me a clue please.
Regards,
Bernard D
I have a daabase that I am importing via excel. I want the entries to be numbered
ex: MT0001
MT0002
etc....
I would like it to promt the user for the last number(or next number in sequence) entered, then fill in the blank records with the next increment number.
The prefix will also change to so eventually the user would enter into the prompt RD0001. then autofill the 140 imported records with RD0002, rd0003... etc....
I can't really make seperate fields because the MT0001 number will become a barcode and putting them seperate causes many issues.
can this be done? Any help would be great I am still a beginner but slowly learning!
Thanks!
Trying to make a simple clock inside my form.
So far I got my clock but it isn't running.
It only get's the time when I open the form but I want it to keep track of time.
Searched the forums but couldn't find anything that relates to this problem.
Hey, im developing a taxi service database and i am working on adding new customers to the customers table through a form using text boxes. Im wondering if its possible to have text boxes as inputs and once all the data is entered (first name, last name etc) have a button to simply click and have all the data transferred to the table. Im also trying to do this without having all other records shown as well.
I've included a screen and the db to show you what i mean:
http://shieldfilez.fasthost.tv/images/screen.jpg
I am trying to sum the row in a access form. There are 3 text boxed called TXT1, TXT2, TXT3. I have added an additional text box and typed the following txt;
=([TXT1]+[TXT2]+[TXT3])
Instead of totalling the row it just puts the number together. For example TXT1 contains 1. TXT2 contains 2, and TXT3 contains 3 so the answer should be 6 (1+2+3) but it shows 123. I have tried putting SUM in front but that gives me the total of the whole column not just that row.
I was checking if it is possible to add a text option after creating Look Up Tables, and I am also getting extra spaces while creating lookup tables where the drop down list goes more than 100 items.
View 2 Replies View RelatedI have copied a VBA from the net and it is working fine and producing my report on outlook body text but one problem me facing is that it is pasting only first page if the second page is there it is not coming in outlook text body this what i want rest every thing is correct the code is:
Private Sub Command88_Click()
Const ForReading = 1, ForWriting = 2, ForAppending = 3
Dim fs, f
Dim RTFBody, strTo
Dim MyApp As New Outlook.Application
Dim MyItem As Outlook.MailItem
[Code] .....
I have globally defined 'Progress' as integerer and using the following code on my splash screen - i want to add a "." to the end of the label caption until progress = 10 (10 timer events)
Private Sub Form_Load()
Progress = 0
End Sub
Code:
Private Sub Form_Timer()
Dim Dot As String
Dot = "."
Progress = Progress + 1
Me.lblProgress.Caption
If Progress = 10 Then
DoCmd.OpenForm "frmLogin"
DoCmd.Close acForm, "frmSplash"
End If
End Sub
I have a form AddNewEquipment. This is bound to a table, EquipmentDetails.
EquipmentDetails has a Yes/No field, 'ParentChoice'. So when EquipmentDetails.ParentChoice = Yes, I want to open up a new text box, AddNewEquipment.ParentDescr, into which someone can put some text. This text I want to append as a new row in a different table, ParentList.ParentName. (that table also has an autonumber field)
I only want to do the save when I save the whole form.
Is this something like using an On Lost Focus event from the ParentDescr field which only invokes when the overall form save button is clicked? What would I put in the On Lost Focus event.
I have 2 tables Master table (Jobs) containing the primary key ("Job Reference") and 2nd table (Candidates) with the foreign key ("Job Reference")
2 Forms
frmJobs Form to view job details
frmCandidates form to view Candates information
I have placed add new candidate button on the frmJobs form which opens the candidate form in the add mode as a blank form. This is fine but I'm looking to add a record where it picks up the "Job Reference" text field value from the main frmJobs and update it in the "Job Refernce" text field on the frmCandidate when I click add new candidate.
How can I achieve this? I'm fairly new to access/vba
I am trying to add a calculation field "Status" (text box) to Assets template form i.e
IF Asset item = X
Status = present
But am getting #name? in the text box
I'm trying to make a database to track inventory or several items. Basically, I have four tables:
1) RawMaterialList - includes a list of all raw materials.
2) PartList - includes a list of all finished product using said raw materials.
3) RawMaterialRecieving - contains details from each packing slip of incoming raw materials.
4) ShipmentRecord - contains details of daily shipments.
Each of these tables is fed by a form of the same name. I should note at this point that I basically taught myself how to use Access and I imagine I'm in the dark about quite a few things it can do. I've made several databases over the last few years, but I'm stumped at this point.
Here's my problem. In the form RawMaterialReceiving, I have several fields aside from basic information:
1) Item - a list of of raw materials from table RawMaterialList
2) Description - also dependent on info entered into table RawMaterialList
3) Quantity
But, I have 12 of these instances.
Item1, Item2...Item12;
Description1, Description2...Description12;
Quantity1, Quantity2...Quantity12.
My problem is I want to add up the quantities of each raw material and I'm not sure how to go about that. Lets say on May 13, I received 15pcs of Part A and 20pcs of Part B. I enter this information as Item1 and Item2 respectively. On May 14, I received 30pcs of Part B. I enter this information under Item1. Now I want to add up all of Part B (50 pcs). But Part B has one value listed in the field Quantity1 and one value listed in the field Quantity2.
Example:
1st Entry:
May 13
Item1 = PartA Description1 = PartA's description Quantity1 = 15
Item2 = PartB Description2 = PartB's description Quantity2 = 20
2nd Entry:
May 14
Item1 = PartB Description1 = PartB's description Quantity1 = 30
How do I get it to add up Part B to get 50pcs?
Hello,
I've got a somewhat urgent question;
When i'm editing in my database other users can't open the database and when they have the database open i can't edit it.
Is there a possability where i can make it possible to enable me to edit while others are viewing, something like a developers database and a user database that update eachother?