Is there a way to split the field record into 2? My field name is structured like this: De Jesus, Sheila
I would want to separate the last and given name.
I hate to do it manually because my record currently is now close to 5,000.
Hi,
I searched in this form and on the internet on how to display a form in Full screen; however, I could not find an answer that worked.
Does anyone knows how to display forms full screen please?
Thank you,
B
Since the latests post I have received from The Doc Man, Pat Harman and ScottGem I have been spenfding a lot of time on stock, really interesting and challenging indeed. (Thanks very much for the advice)
I've design a database with a working transaction table.
But by using this method, there is no way to have full traceability, how can i keep track of the advice note of each individual batch if i am using such a system? Is there any way to go round it?
Thank you,
I have a field within a table entitled "Name Display" This displays names in the format:
Surname,forename
I have used the following:
Full Name: Right([Name_Display],Len([Name_Display])-InStr([Name_Display]," ")) & " " & Left([Name_Display],InStr([Name_Display]," ")-1)
To rearrange so format is displayed as forename,surname
However my output with some fields appears as:
SARAH WAILES, with spaces inbetween.
Can anyone suggest a way of removing these spaces?
Thanks
I was wondering if there was a function in access which allows the user to type in a date, and instead of showing just the date, it shows the actual day of the week as well, in a seperate field. Is this possible?
Thanks
Adrian
I have a text field that has a full name (ie. Smith, John). I need to somehow split this into a first and last name...or at least reverse the order for a mailing list.
Can anyone help me?
Hi everyone, i am creating a database by importing data from excel than normalizing it. In the excel spreadsheet thre is a full name field and want to import it into access by splitting it up into first and last name. Some of the data in the spreadsheet have middle initials. ANy idea on how to make this easier for me?
Thanks in advance
Joso
Hope someone can help.
I have a table with a bunch of fields. There are two critical fields. The Date and Time. I have these set to Date() and Time().
Now for a report. I would like to have a report that takes the input of a user to display the entries from only one time frame to another time frame.
For example, if a user is in need of the report for 01/01/07, they can choose the query and input in the date and time, but a full day is considered 01/01/07 starting at 6:00 am to 01/02/07 at 5:59 am. Therefore, if a user inputs that they would like to see the report for 01/01/07, entries that were inputted in prior to 01/01/07 at 5:58 AM should not appear.
My Query, criteria ask for the date and time, but I cannot figure out to ask the user for a logic that would be able to pull the whole "full day" reports.
Hope I'm making sense here.
I literally named my tables as follows and then literally typed the following into the query editor (SQL View):
SELECT * INTO FullJoin FROM LeftTable FULL JOIN RightTable ON RightTable.ContactID = LeftTable.ContactID
The error I get is, "Syntax Error in FROM clause"
What's my error?
How do I achieve a full screen switchboard display so that the only way to access the (table, query, form...) is by holding the shift button while clicking on the file icon. Thanks!
View 1 Replies View Relatedis it possible to make the menu-toolbar go away?
and can you put you access on full screen?
if yes, how?
thx in advance
I'm the dummy in question. I'm new to Access and have a fairly simple database that I'm using to find potential customers. I am targeting them by two criteria using two different queries (both queries are looking at different fields of the same table). I want to create a combined query that pulls ALL of the results from both of my target queries. Searching around this forum I see that I need to create an Outer Join which Access doesn't exactly do. I also see that there are ways to simulate this, but I can't seem to figure out those ways. If someone could please explain this to me in a very simple way, I would be very grateful. Thank you.
View 14 Replies View RelatedI have set the switchboard to maximise when opened, when I open any form fand then close it the switch board will not return at full screen, How can I have it maximise every time a form is closed!!!
View 2 Replies View Relatedhello,
I have a main form with one child form. This child form also has a child form. This last child form has two tab controls it. When I tab through fields on the form, I have to reposition the form so that I can see these last fields. Otherwise I have to tab blindly through them. How do I get the form display the fields as I tab to them ? I have to design the forms on the larger size because the users like that. Any suggestions would be appreciated.
thanks !
I accidently unchecked the "allow full menus" option in Tools - Startup. When I did that, the menu bar at the top of my database no longer displayed the "Tools" option.
Does anyone know how I can restore the full menus option?
I am new to access and can do nothing with my database until I get my menus back.
Thanks,
Model Full Name: "Jones, John P." (this was the one not in MS' examples)
Last Name Extract = Jones
lastN = IIf(InStr(1,[Model Full Name],",")=0,"",right([Model Full Name],len([Model Full Name] - (InStr(1,[Model Full Name],",")+2)))First Name Extract = John
firstN = IIf((InStr(1,[Model Full Name],",")+1)=InStrRev([Model Full Name]," "),Right([Model Full Name],Len([Model Full Name])-(InStr(1,[Model Full Name],",")+1)),Mid([Model Full Name],(InStr(1,[Model Full Name],",")+2),(InStrRev([Model Full Name]," ")-1)-(InStr(1,[Model Full Name],","))))
Im trying to programmatically (without any user intervention) retrieve the long path name for a given file. It seems to me this should be a rather easy thing to achieve using Access VBA. Ive tried using various FileSystemObject methods with no luck. Ive Googled many variants of VBA get full path without any meaningful hits. provide the first string as a parameter to some object and have it magically return the second string.
String 1: C:PROGRA~2COMMON~1MICROS~1VBAVBA7VBE7.DLL
Stint 2: C:Program Files (x86)Common Filesmicrosoft sharedVBAVBA7
In a form's VBA code, I'd like to know whether a full record has been selected, like when the user selects one or more rows before deleting with the Del key.
Is this possible?
According to [URL]......, Me.SelHeight returns the number of rows that have been selected within the selection rectangle. If I select a rectangle of cells in Datasheet view, for example, Me.SelHeight will be > 0 even though full records have not been selected. I want to know how many full records have been selected. Is this possible?
I had the Main Menu open when clicked on access file. I put a autoexc.bat file somewhere. Where? Also how do I get a form to open in full screen again?
View 3 Replies View RelatedIs there an easy way to make a full page address labels (30 to a sheet) without having to create it by dimensions? I can't seem to get all the dimensions correct.
View 14 Replies View RelatedHey.
My database would like, to make itself feel complete, a rele snazzy opening form.
I have flash 8 and I've created a 1024x768 movie with some simple animation on it.
I've managed to add the movie to the database as a ActiveX flash object and the animations play.
The problem is making the object larger! It's staying very small no matter how I change the properties of the control.
Any help would be much appreciated. For the sake of my databases mental health... of course. :cool:
To attach the movie I did so:
http://www.databasedev.co.uk/flash_movie.html
JoeyTheBean
My database contains an embedded thumbnail image, one per record, and I would like to be able to click something on the form of that record to open the full-size image in a picture-viewer of my choosing.
Can someone give me some direction?
Thanks!
Im trying to open my database switchboard without having the whole Access program open. Is there a way to have only the database open without the whole program?
Thanks
Apologies if I am covering old ground here but unfortunately I cannot find a suitable solution after searching the forum.
Basically my switchboard on Open includes DoCmd.Maximize so that the switchboard does indeed open on full screen. However, say I then leave my database open and work on a different application on my PC then when I click on my database on the taskbar then the form is not longer full screen.
So what I am basically asking is, is there a way of 'locking' it to appear full screen even if I flick between applications on my PC?
Many thanks in advance,
Paul.
I must be missing something simple here.
The opening switchboard of my db is set to popup but on opening the db it is showing full screen. On reopening once closed it pops up. How can I make it popup to start with?
Settings are:
Default View - Single Form
Auto Centre - Yes
Auto Resize - No
Border Style - Dialog
In a table called Appointments and the field called Plastics we enter the initials of surgeons.
However in a report i want the initials converted to full text - in the example below the initials are HJC
The expression below doesn't work - it just returns everything in the Plastics column.
Any ideas?
Expr1: IIf(HJC([tblAppointment]![Plastics]),"Heather Cleland")