Design With Full Traceability

Jul 12, 2005

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,

View Replies

See Query Design FULL Field's Contents?

Feb 22, 2006

Hi,

I have some queries that I created in 97 and convert to Access 2000.

However, when I go to query DESIGN view, I would like to see all the contents of long functions (iif) that I wrote for some fields as a result of running the query, but each field only shows a portion of it (as if it was truncated). I also use the "Zoom..." of that field or Shift+F2, still the same thing, only shows portion of it, the last portion was truncated.

Do any of you know HOW to show all, so I can check and revise if I need to, pllllllease.

Thank so much,

View 1 Replies View Related

Form Opening In Full Screen Mode Instead Of Size Set In Design?

Aug 9, 2012

I just imported all of my objects (tables, forms, etc.) into a brand new database file and all of my forms are now full screen instead of the size I set them to in design. What caused this? I can't get them back to their normal size.

I am using Access 2007 but imported files into 2003 .mdb file.

Form View

Design View

How it should look?

View 1 Replies View Related

Traceability In Access 97

May 9, 2006

Hi

I have access 97 and I need to find if there is a way to keep a track of changes made in data entry and if you can identify who input the message

thanks

View 1 Replies View Related

Queries :: Crosstab Design Is Slow When Opening And Saving In Design Mode?

Oct 6, 2014

I have had to use my first crosstab queries.

I now understand that when opening and saving crosstab queries Access (2010) runs that query to ascertain the column names. Unless you hard-code them. Running the query takes at least 20 minutes.
I have hard-coded where I can, but one report takes arbitrary dates so I can't hard-code them.

I believe that turning off AutoCorrect might make a difference to whether the query runs - but I don't want to turn it off.

View 6 Replies View Related

DATASHEET --- Allow Design Changes: Design View Only DOES NOT WORK

May 18, 2007

I have a sub form in DataSheet view and I would like to lock the design so that the User should not change the layout

Even when I set the property of the Datasheet �Allow Design Changes: Design View Only� users are able to unhide the hidden columns and they can also change the size of the column by dragging the column end line

Does any one know how to lock the design of datasheet ( I am using this sub form datasheet for data entry but do not want users to change the layout)

Thanks
Rahul

View 1 Replies View Related

Full Screen

Aug 29, 2006

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

View 5 Replies View Related

Split Full Name Into Last And First Name

Aug 14, 2006

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.

View 2 Replies View Related

Good Design? Bad Design? Problems..

May 5, 2005

I'm going to make up names and values -- I'm interested in the structure.

Table ALPHA:

COLA DAT1 DAT2 DAT3
1 5 7 9
2 4 14 8

Table BETA:

COLA_IND DAT1 DAT2 DATN
1 a b c

Table CHARLIE:

COLA_IND DAT1 DAT2
2 d e

Table DELTA:

COLA_IND DAT1 DAT2
2 f g

Ok, the idea here is that the data in table ALPHA contains data with COLA a key such that selecting 2 would yield the data row "4, 14, 8."

Now, COLA_IND is a "COLA" key for table ALPHA (sorry, I can never remember which side is called the foreign key). So, from tables BETA, CHARLIE and DELTA, I can access any row in ALPHA based on the key "COLA_IND"

Here's the fun part. When I build my query, it wants to use an inner join on the keys from all these tables... In order words:

SELECT blah blah blah INNER JOIN blah ON (ALPHA.COLA=BETA.COLA_IND) AND (ALPHA.COLA=CHARLIE.COLA_IND) AND (ALPHA.COLA=DELTA.COLA_IND)

What I'm looking to do is expand BETA, CHARLIE and DELTA with the information from ALPHA based on the key COLA_IND. I don't think this is doing what I want.

Any comments?

Thanks in advance...

View 1 Replies View Related

Query Design.DB Design Question

Sep 10, 2007

Hey,

I've got this problem and im 95% sure its going to need a query in order to achieve this answer im looking for.

I'm creating a Software Licensing Management db and its all working lovely. However my only problem remains is the graphical representation (text box within one of the forms) of howmany licenses are/aren't(doesnt matter if this number is a +/- number) available.

In order to achieve this answer I dont think you'l need the table structure of any of my tables other than these two:

tblLicenseInformation
License_ID
LicenseDescription
NumOfLicensesPurch
SoftwareOverview_ID

tblHardwareSoftwareLicense
HSL_ID
Hardware_ID
Vender_ID
Software_ID
AppEdition_ID
AppVersion_ID
SoftwareOverview_ID
License_ID

However I would like to add a column to either of these tables named 'Availability' or something similar which will show the licenses available.

I've tried a number of Update/Append queries but all have failed. I want this Available running variable held within the table due to it not changing to much of the current db design as i baisically finished the project and they asked for it! any ideas of how to efficiently achieve this will be much appreciated!

cheers

View 3 Replies View Related

Display Full Name Other Way Round

Aug 23, 2005

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

View 1 Replies View Related

Returning The Day And Not Full Date...

Feb 13, 2006

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

View 14 Replies View Related

Full Name In Text Field...

Jun 14, 2007

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?

View 1 Replies View Related

Full Name Import From Excel

Mar 14, 2006

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

View 1 Replies View Related

Date Full Day Query

Jul 26, 2007

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.

View 10 Replies View Related

What's The Syntax For A Full Join?

May 4, 2008

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?

View 1 Replies View Related

Full Screen Display

Jul 11, 2006

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 Related

Full Screen Access

Jan 27, 2005

is it possible to make the menu-toolbar go away?
and can you put you access on full screen?

if yes, how?

thx in advance

View 9 Replies View Related

Design View Keyboard Shortcut - Expand Columns In Design View Of A Query

Jun 5, 2014

I'm looking for a keyboard shortcut to expand the columns in "design view" of a query.

What I mean by this is rather than selecting all of the columns and double clicking to see the entire text, I'd like to be able to a shortcut.

The entire process as I see it involves 3 steps so I will need thesolution to the 3rd step.

(1) [ctrl+spacebar] to select initial column
(2) [shift+arrows] to select all of the columns I need
(3) [keyboard shortcut] will expand all of the columns "field" names to the size of the column heading

Alternatively, if you know of a shortcut that will expand the columns without having to select them first I'll take it!!

View 4 Replies View Related

Full Outer Join For Dummies

Mar 21, 2007

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 Related

Switchboard Does Not Return Full Screen

Sep 11, 2006

I 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 Related

Tabbing & Displaying Full Page

Jul 23, 2007

hello,
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 !

View 1 Replies View Related

Disable / Enable Full Menus

Feb 19, 2008

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,

View 2 Replies View Related

Queries :: Extract Names From Full Name?

Dec 17, 2013

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],","))))

View 1 Replies View Related

Modules & VBA :: Get File Full Path

Jan 12, 2015

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

View 7 Replies View Related

Modules & VBA :: How Many Full Records Have Been Selected

Sep 25, 2013

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?

View 2 Replies View Related