I am getting data passed to me in one field that needs to be broken apart. The data is first name, middle name, last name and birthdate but its in one field that looks like this:
john/mark/doe/06121972
Is it possible to break apart this field into 4 separate fields?
how to populate a textbox with a line break?
=[Forms]![Violations]![cboSection4] & i want the line break here & [Forms]![Violations]![cboSection5]
how to make a line break in a rich textbox in access 2007? Chr(13) & Chr(10) worked until I changed the textbox to rich, which is necessary because certain words in the textbox need to be bold.
View 2 Replies View RelatedIs there an equivalent to Alt-Enter in excel to put a line break in a text box from the keyboard?
View 2 Replies View RelatedHi!
1. If accidently a record or two in a sequence are deleted, how will you know that this has happened! What type of validation can be enforcedto prevent this?
2. How do you make your Tables, Quries, Forms, Reports, Macro tamper proof?
Please help!
Orsonros
I am a struggling low level user and any help will be appreciated. I’m trying to get data out of an old database and into a new one. The following addresses will give you some idea as to what my problem is. :confused:
I would like to break up the following single field address (Note the different pieces of data.
Washington Blvd 1407
Jefferson ST 234 N
Benjamin Ave 2105 N #1
Lincoln Cir 1407 N Unit 201 (Notice the space after Unit)
and have it look like this
Field one: 1421
Field two: N,S,E or W
Field three: BENJAMIN ST, Ave, or etc
Field four: Anything left over
If you can help, please talk very slow and loud cus I'm old and not too bright. I have limited experience with Instr, Mid, Left and Right functions, but can never seem to get them to work in a SQL statement I think I need to use multiple append queries but I’m guessing and then how do I get all the pieces into one table. :o
Thank you in advance
I have 4 fields that are unbound on a form. img1 img2 img3 img4..When these are entered they are all combined and autofill another unbound textbox = imagename.. what i would like to do is from this unbound textbox 'imagename' ..i would like to populate a textbox that IS bound called FileName
[Event Procedure]
Private Sub imagename_Click()
Me.imagename = Me.FileName
End Sub
How Can I remove line breaks in a string.
View 6 Replies View RelatedFirst of all, thanks for any help in advance, I really appreciate it. This is my first big project in Access. I am trying to design a database for timesheets for all the departments at work. We have 21 departments with various numbers of employees in each department. At this point, I would like this database to be able to have users enter their own hours each week and print their individual report of hours worked then designated users add employees, look at previous payperiods and print out a master report as well as past reports. One pay period here is two weeks, with the days starting on Saturday, though I would like the database to keep track of one week at a time and then be able to group two weeks together to make a pay period. Each employee can work regular hours in a day and can also take up to 6 type of leave plus work overtime. So there will be 8 types of hours that could be entered. So far, I made tables for each different type of hour and created fields for each day of the week and created relationships to the employee table and pay period table. I made a form in datasheet design, but it didn't work out well. For lack of a better thought for them to enter their hours, I was going to design the form to look like this (but with spaces like a table);
Employee(fn) Employee(ln) Payperiod
Sat Sun Mon Tues Wed Thurs Frid Totals
Regular Hours
Vacation Used
Comp Used
Sick Time
Overtime
Holiday
Unpaid Leave
Paid Leave
The only thing is that I can't get the forms right and it seems like a lot of wasted space since employees will rarely take holiday, paid leave and unpaid leave. Is there a better way to design this?
I also have to take into account security. I eventually have to be concerned about departments only having access to their own records and employees within those departments only being able to access their own hours (except for designated users to do the master sheet). I haven't had any training or experience in access database security. Is there a way to limit records in a table or would I need to create a seperate database for every department?
I am attaching my table relationships in case I didn't describe this very well.
Thanks again for any help. If you need any further information, let me know.
Hi.
I have a table that has 1 field called IP
it containes IP addresses as data like this.
IP
255.254.253.252
255.251.250.0
Is it possible to have a query that would break this up so it becomes a new table with 4 fields like this:
IP1 IP2 IP3 IP4
255 254 253 252
255 251 250 0
I'm a beginer in this and I could not find a way so for to break this apart correctly.
Please help.
I have a very annoying problem with my break points that I can not figure out how to fix. I have a database that when I place a break points on code it will not break the code and go into debug. I have created a very basic form with one button and the following code:
Option Compare Database
Private Sub Command0_Click()
Dim str As String
str = "this is a test"
MsgBox (str)
End Sub
The message box will pop up but the program will not stop on either on the str... line or the msgbox... line. I'm sure some how or another I turned off the debugger but I do not know how to turn it back on.
Thank you for any help.
Hey, I tried searching for this one, but I'm not really sure what to search for.
I am running a report that is double sided. However, I do not want the start of the next group, on the same physical page. I also do not want a starting blank page (as I thought about inserting a blank page after the section).
Any way to do this?
Maybe I have to write a function or something? Depending on if the page is an even or odd number? I honestly have no idea.
Thanks for the help!
I have text in a number of fields that I want to insert into a text box on a report. The size of the text box is large enough to accommodate, but I want each line to have a linefeed (or carriage return) before it.
The report is based on a query. I created a field in the query that consists of something like:...txtText1 & CHR (10) & txtText2 & CHR (10) txtText3 AS MYTEXT.
What I did was to set the control source on the text box to MYTEXT, hoping that there would be nice linefeeds in between the fields. Unfortunately, all I got were some funny-looking boxes.
What's interesting is that you CAN insert a linefeed into a memo field and that linefeed will display properly. I just don't know how to force one in there to separate lines of text.
Any ideas?
SHADOW
I am trying to page break my report to have it where the first name and surname of the employee has a separate page with the details of each appointment.
I have tried to do it via format on properties but it does not work..
I have attached an image of how the report appears.
The BIG problem is this.
I need a basic string graph over time recieved from a cross tab query. The data points all come in fine, but the "strings" / lines connecting the points do not show up.
I believe the reason is because there are just too many records.
I culled the data down using a vba loop to only show 1 stop per minute. (BTW, is there a way to do this using only SQL?) I now show all record points, but still do not show the lines between points. Some of the lines show up, but the more data points on the graph there are, the less the lines show up, till only one or two show.
This is an Access limitation that I'm unsure of how to get around. This really shouldn't be an issue though, because Excel handles the graph just fine EVEN BEFORE the culling of the data down to access acceptable limits. And it shows the lines between each record as well.
Does anyone know of a resolution for this?
Kelemit
Hello all,
I want to create a query that looks for a manual line break in a memo field. Is there a code or some way that I can do this? (i.e in a Memo field the user has entered some data, hit Ctrl-enter to get to a new line, entered more data on the new line. I want to find the records where this has occured)
Also, on a similar note, is there a way I can deny my users the option of doing a manual break (Ctrl-Enter) in a Control in a Form? (to prevent me needing to run this query in the future)
Please advise.
tia,
Angel
I have a report with grouping on a code - I would like to do a page break on the second code - I don't know where to start on this.
View 1 Replies View RelatedIs it possible to do conditional formating after a page break?
I have been given someone elses mess to clean up. It is a massive procedure which runs dozens of queries, then formats the results and pastes them into a word file at given bookmarks
For most tables there is one record for each lake. However there are several where many entries per lake. The logic being applied is that the font colour for the column is made white, then for each first instance of a lake name the font colour for that cell is made black again.
The problem is there are many times were the first row of data on a new page is not the first record for a particular lake making the reader have to flip back to the previous page to double check which lake they are looking at data for.
So what I want to do is leave the existing logic, and just add turning additional cell's (Column 1, after a page break) font colour back to black.
Is it possible to force a page break after 15 line items ....
View 3 Replies View RelatedRight now I have a flat database with too many unnormalized fields. I am trying to figure out how to break down the repeated "QuantityOrdered" 1 through 5. "QuantityReceived" 1 through 5.
"RequestedItems" 1 through 5 and "Price" per unit 1 through 5. I'm not sure if they go into the same tables, if they are each listed 5 times and if in different tables how many instances 1 or 5 to show each as seperate and how to create a relationship between them.
I have a report that needs to be set up in 2 columns using the school year, 2012-2013, 2013-2014, etc. My issue is this. The columns go down the page and continue on the right side for column 2 in the correct order. Is there a way to have the columns break for the school year?
I currently have this:
2012-2013 2014-2015
2012-2013 2014-2015
2012-2013 2014-2015
2013-2014 2015-2016
2013-2014 2015-2016
I need this:
2012-2013 2012-2013
2012-2013
2013-2014 2013-2014
2014-2015 2014-2015
2014-2015
2015-2016 2015-2016
We 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)
I have a single field in a table called "Client Contact", where users enter a semicolon between the name, address, and city state & zip. My reason for this was so we could copy client info with a single copy and paste (like from an email). But, on the final report, it needs to have these three parts split up into different lines, or even different textboxes. I can't find a way to do that.
View 1 Replies View RelatedI have a Form Display Data in my Access Database, which is working really well. However, users was asking if there is a way we can make Font Color Could/would change if The text in A field or Any field in my display form contained the word "SAD or MAD". Is there code for such thing in display form?..
View 3 Replies View RelatedI'm trying to pull a date from a table into a text box on a form tab control using DLookup and I just can't figure out what is wrong with my DLookup expression:
=DLookUp("DateOrdered","tDateOrdered","PrNumber=" & [PrNumber]) ----- (DateOrdered is short date, PrNumber is text, db is split Access 2013)
Whats missing in this expression? I've tried every criteria variant I could find but to no avail.
Hi! I'm a newbie and have very very basic understanding of Access...I'm running a small group of about 19 members that is expected to grow within the next two months to 11 more members...
I haven't been able to find a freeware club/membership database so having the fun of creating my own.
I used the "membership database" that microsoft offers and I figure out (very easily) how to do the page breaks, but I tried to add an option on the top of the form to goto page 3 and have access take my viewer to "page 3" of the form...
I've looked at the coding for page 1 and 2 that is already in place for the form where member info is enter, but it's just over my head and hoping someone can help me figure out how to build an event that when someone clicks on page 3, it will take the viewer to the "third page" of the form for additional information I hope to add.