General :: Lookup Data Type In Access 2013 Web App?

Jan 2, 2014

I want to create a Web App in Access 2013 that contains a table of client names, addresses etc, and a second table that contains order details, including client name. It would be nice to ensure that as someone adds a new order they are give a drop down menu containing existing client names, and I can see how you can do this for a brand new table using the lookup data type. But I already have an Excel spread sheet containing client names. If I import this into my Access web app to create the client table, and import the existing orders to create the order table, I then try and change the data type of the client name (in the order table) from short text to lookup, it won't let me!! (If I create an empty client table from scratch, it lets me define the company name as a lookup data type - but I can't then import from Excel into this empty table)

View Replies


ADVERTISEMENT

General :: Some Fields Intermittently Not Showing Data In Access 2013?

Feb 13, 2014

I've recently moved up to Access 2013 (from Access 2010) and everything went well, until one day my splash screen was blank and the program had empty fields...after seeing that all the links to the BE were OK, I re-booted and everything worked fine....until the next day the same thing happened...... The program randomly falls over about once or twice a week and I have to re-boot to cure it.....

My splash screen has a standard dlookup ( [=DLookUp("Banner","tblCompanyInfo")] ) to display the active company name...and sometimes its populated and other times its not..... if its not populated then loads of other fields on the forms are also blank - even if they point to valid data in the database!

I run Win7 (both 32 and 64bit) with Access 2013 32bit on three PC's - same problem on all!

View 3 Replies View Related

General :: Create A Field Lookup With Value That Specify In A Form That TYPE In

Jul 17, 2013

I wanted to create a field lookup with values that I specify, not on the table sheet, but on the form. User can click on a text box or combo box and can select a list of value that I specify, not values that are listed on a table but ones that I type in, in the form.

View 11 Replies View Related

Data Type With Lookup Wizard

Nov 1, 2004

Heres something I dont understand about the lookup wizard:

Ive done a lookup wizard on one of my fields, so that now the user gets a drop down list of options to choose from:

0;1;2;3;4;5;6;7;8;"NTSC";"PAL"

Ive also set "Limit to list" to yes, so that these are the only options the user can enter.

However, it will still let me change and play around with the data type settings under the general tab. I dont understand why it lets me do this. I can set the lookup to the above list, and then specify a date type of type "date", and it will allow me to do it.

Why is this the case? Which datatype should I set it to, if I have a list of values like the one above?

View 1 Replies View Related

Fields In Table Created With Relationship / Lookup Data Type

Jul 17, 2014

I created a table in MS Access using a Lookup & Relationship data-type. This means that my record cells call upon a particular table for values. It creates a LIST of values for that cell.When I query a particular value in this table I get every possible combination of the value. My query and code are below:

OR,

SELECT MainT.Content.Value, MainT.Source, MainT.[Entities Impacted].Value, MainT.Update,
MainT.[Divisions Impacted].Value, MainT.Announced, MainT.Effective, MainT.Stakeholders.Value,
MainT.[Ref#ID], MainT.[Issuing Agencies].Value
FROM MainT
WHERE (((MainT.Content.Value) Like "*" & [Forms]![SearchF]![ContentCB] & "*" Or (MainT.Content.Value) Is Null)

[Code] .....

This means that if I query STATES: "California", I'll get back every possible combination that exists with the name California in that particular field.The issue with this is that I'll get MULTIPLE primary key values rather than just 1. So, if one record, under STATES has California in it, but the other fields in that record have the Lookup & Relationship data-type, then every possible combination of that record will query instead of the multiple field-values form that you'll see in the table I am querying.

notice that my primary key (REF#ID) is repeated numerous times! This obviously causes problems with generating records and forms concerning information for 1 particular primary key. Is there a way around this problem other than specifying search criteria down as much as possible?! Perhaps there is some SQL code.

View 1 Replies View Related

General :: Access 2013 - Compact Database To New Name

Jan 30, 2015

Access 2013 ... Is it possible to compact a database to a new name?

(In previous incarnations of Access I regularly 'compacted and repaired' databases to USB sticks rather than simply copy the file in the (mistaken??) belief that this was a more reliable approach)...

I can't see where to do this in Access 2013!

View 1 Replies View Related

General :: How To Sum Multiple Columns In Access 2013

Nov 28, 2014

I made a new column in a table in access. The table is not linked and linking unfortunately is not an option. In the new column, I want to create a sum for 5 years of funding. There are multiple columns for a different fiscal year.

In excel, it is simply =sum(range), but I am drawing completely blank how to fill in the column with the sum data.

The end result is the data from 4 tables will be displayed in Forms and Reports.

Essentially what I need is an ability to bulk update a column in access table without a need to reupload the entire datasheet (over 100k rows with about 30 columns).

View 2 Replies View Related

General :: Disable Close Button Access 2013

Jul 18, 2013

how to disable the main close button so the user is forced to click the Quit Application button on my main switchboard?

View 8 Replies View Related

General :: Query Parameters In Access 2013 Web Apps

Feb 2, 2014

I'm creating my first web app with Access 2013 and I'd like to allow users to run a query after supplying a parameter to be used in the query.Simple example might be to display a list of all records that contain a date older than "x" in a particular field - with the user supplying the value for "x" I understand that query parameters don't work with the web browser and that I need to use a macro to request the input of "x" and pass it to the query, but I can't find any examples of this kind or macro action (OpenDialog, I understand from Jeff's book).

View 3 Replies View Related

General :: Access 2013 - Possible To Play Sound File

Jun 3, 2013

Is it possible to play any kind of sound file from Access?

View 1 Replies View Related

General :: Access 2013 / Error - Not Enough Memory To Update The Display

Dec 16, 2014

I am regularly getting the error "There is not enough free memory to update your display, close unneeded programs and try again"

Access 2013 on a windows 7 machine with 4 processors and 24GB total RAM.

Today I have 14 GB free memory (unbelievable! my first laptop had 136 MB total memory!) when I got this error (Access using 38MB) which makes me believe its not a system memory issue but to do with how much (or quickly) memory is allocated to Access.

View 5 Replies View Related

General :: Access 2013 - Sort Database Window By Description?

Oct 10, 2013

Through a set of circumstances, I have had to quickly migrate a long-standing (and business critical) database from Access 2003 to Access 2013, without the sort of prepping and planning that I would normally do in such circumstances.

Most functionality appears to be working ok...

Many of my database objects, especially queries, were given meaningful descriptions.

For example, a number of queries might have been described as "Accounts Data Validation".

When I wanted to run validation of the Accounts data, I would simply sort the database queries window by description, then scroll to the relevant section and run all of the tagged queries in turn.

However, having migrated to Access 2013, although the descriptions are still shown, I can no longer sort by them !

Medium term, I could probably assign different database objects to "Groups", but we are talking hundreds, perhaps even thousands of different objects and that would be a laborious and extremely tedious process.

Any way of sorting the database window by description in Access 2013 ?

View 3 Replies View Related

Transferring Data From MS Excel To MS Access 2013

Mar 27, 2014

I am setting up a database using Access 2013, and am trying to test downloading files from Excel. For some reason it is not allowing me to have more then 4 columns in the excel file, it gives the error "Subscript out of range". I thought it was the type of variable at first, but when I tried deleting different columns on both files, the transfer always worked with 4 columns. How do I allow more columns to be transferred?Also, is there a way to not include the row numbers of the excel file as an ID column and only include the ID given in the first column?

View 4 Replies View Related

How To Collect Data From Outlook In Access 2013

Feb 21, 2013

In Access 2007 and 2010 there was a "Collect Data" group under "External Data" where I could click "Create E-mail" that would build an email form for an outbound email in Outlook based on a table. I would then send the email out, then collect the data back into the table from Outlook when the recipient of the email responded with a filled out form. I don't see how to do that with Access 2013. I do see the "Email" button, but that's for something else. I see no 'Collect Data' in Access 2013 like the picture below shows from Access 2007.

View 6 Replies View Related

Some Fields Intermittently Not Showing Data In Access 2013

Feb 12, 2014

I've recently moved up to Access 2013 (from Access 2010) and everything went well, until one day my splash screen was blank and the program had empty fields...after seeing that all the links to the BE were OK, I re-booted and everything worked fine....until the next day the same thing happened...... The program randomly falls over about once or twice a week and I have to re-boot to cure it.....

My splash screen has a standard dlookup ( [=DLookUp("Banner","tblCompanyInfo")] ) to display the active company name...and sometimes its populated and other times its not..... if its not populated then loads of other fields on the forms are also blank - even if they point to valid data in the database!!!!!!

Win7 (both 32 and 64bit) with Access 2013 32bit on three PC's - same problem on all!!!!

View 14 Replies View Related

Forms :: Access 2013 - Multiple Data Sets On Chart?

May 5, 2015

I have a simple line chart plotting price against date.

I would like to plot a secondary line on this chart from an array of data that I calculate. I've searched hi and low but can't seem to find a way of doing this.

The closest I've found is from this:-

[URL]

I can create my array of data but I can't seem to get it to work and think it may be for pivot charts....which access 2013 can't do anymore.

how to plot multiple data sets on the same graph in Access 2013.

View 9 Replies View Related

Access 2013 Report Data Showing Up As Number Rather Than Text

Aug 13, 2015

I have a people table; Ethnicity Table; Program Type Table; Attendance Table.

I enter the people into the people table then enter people into the attendance table with lookup for name from the people table and a lookup for program type from program type table and enter date attended. I then run a query on the attendance table to remove duplicates. I created a form from the attendance query there are 3 headers Program, Ethnicity, Name. but the program type comes up as the ID number and not the text name.

The Ethnicity did the same thing but when I added the Ethnicity from the people table to the ethnicity header it show up as the name and I hide the box with the number but when I add the program type from the program type table to the program header is changes the source of the report to the program type table and then nothing shows up. It did not do that when I added the ethnicity type from the ethnicity table to the ethnicity header.

View 1 Replies View Related

Forms :: Entering Data Into Table - Syntax Error With Access 2013

May 20, 2013

I am pretty new to access and trying to create a form to enter data into a table. I keep getting a syntax error. Below is the part of code where I keep getting the syntax.

CurrentDb.Execute "INSERT INFO [Tb1 - Information]([Zone], [Controller], [Controller Type], [Panel], [CB #], [Controller Unit], [IP Address], [Modbus Address], [Sub Address/ HTC#], [PP Location], [Opp Priority],[ Startup Priority]) " & _
" VALUES('" & Me.Txtehtzone & "', '" & _
Me.Txtctrler & "','" & _
Me.TxtCB & "','" & _

[Code] ....

View 1 Replies View Related

Forms :: Input Data Into Multiple Tables Using Single Form - MS Access 2013

Jan 15, 2015

I have 5 tables that I would like to input data in. It can only be done with a single form. The fields I want to input in have the same names in all 5 tables, for example:

Table 1:
Name
Age
DOB

Table 2:
Name
Age
DOB

Table 3:
Name
Age
DOB

Table 4:
Name
Age
DOB

Table 5:
Name
Age
DOB

Is it possible to input data into all of these fields in each table using one textbox for each field?

Preferably without having to use code but if it cannot be done without it then that would be fine.

View 7 Replies View Related

General :: Cannot Change Field Data Type In Database

Mar 18, 2014

In my database i have a field for Tonnage (quantity) ...

I need for example to input 38.60 or 37.89 so my values must have 2 decimal places, ive searched and found changing my field type to double or decimal should solve the 'numbers rounding up/down' but access will not let me change the data type?

View 1 Replies View Related

General :: Data Type Mismatch With Last Cascading Combo Box?

Aug 28, 2013

Some background: I am making a form at work for a coworker with cascading combo boxes where she can select a Customer, then Platform Description, then Period, then Year. I used VBA code for these and they all seem to be working, except the Year.

Code:
Private Sub Form_Load()
On Error Resume Next
CustomerCB.SetFocus

[Code].....

I am pulling a table from Excel into Access (SD0039DA_T2), then I have used a delete and append query to populate a 2nd table (SD0039DA_T). I did this 2nd table because the first table was slowing down all of Access because it's such a large file directly linked to Excel.

The only real difference between the two tables is I added another column to SD0039DA_T called BillingYear. This is the Year in the cascading comboboxes/listboxes I am having trouble with. In the append query, I used ...

Code:
BillingYear: Right([SD0039DA_T2]![Billing Date],4)

...appended to BillingYear. I want just the year (YYYY), not the whole billing date from the original table (MM/DD/YYYY).

So I'm thinking the problem is with the YearCB section of the VBA code or something to do with my tables?

View 3 Replies View Related

General :: Using Hyperlink Data Type And Textbox To Get Path

Jul 24, 2014

Im trying create a new form to add our current database that will password protect excel, word and if possible pdf documents when they are dragged onto it.

For now I only have 2 boxes 1 containing the password to be applied and the other to drag the file onto.

I have it all working so once its dragged on it works out if its a word doc, opens a hidden instance of word which then resaves it with a coded password.

The problem comes when change it so the user enters the password to protect it, when they enter a password or click on the drag box it doesn't allow the drag. it seems once they have entered the record the drag option is not available anymore.

View 1 Replies View Related

General :: Cannot Change Data Type Of Calculated Field

Aug 23, 2012

I got Gross Income Query. But I have employees that have overtime rate as well

So I have to calculate using overtime Payment And Gross Income Separately

So I make query and in query . I write this equation

Ovetime Pay: IIf([Total Hours Worked]>[Normal Hours/week],([Total Hours Worked]-[Normal Hours/week])*[Overtime Payrate],"0")

I successfully calculate it ...

BUT IT JUST GIVE ME THE VALUE LIKE A NUMBER SUCH AS e.g. 50 ,150 but instead of that i want currency data type of that calculate field for e.g. 50 become "$ 50".

Okay so in able to do that i go to properties Sheet of the field of the query and change Format to Currency ..BUT IT DOESN'T CHANGE !!!

DATABASE PAYROLL - Copy.zip

View 2 Replies View Related

General :: Changing Data Type Of Calculated Field In Table

Jul 18, 2013

I am trying to change the data type of a field in a table from calculated to something else. It gives me the error "this data type cannot be changed once the field has been saved"

Is there any work around to this?

View 2 Replies View Related

General :: ELookup With Multiple Criteria - Data Type Mismatch

Apr 17, 2013

I'm trying to use the following expression:

=IIf(ELookUp("EventDate","qsfrmEvents","[EventID] = 8 And [fkClaimID] = ' & [Forms].[frmClaim].[txtClaimID]'")>0,True,False)

But I'm getting a data type mismatch. txtClaimID is numeric, but if I take out the single quotes I get a syntax error.

View 2 Replies View Related

Tables :: Converting Text Data Type To Number Data Type

Nov 3, 2012

I have a table with a field with names set to text data type and i want to change it to number data type but when i do it in design view the data get lost. I want to know if there is a way to convert the data in the field as number type and keep the data in the field.

View 7 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved