I've been trying to modify a database I downloaded from the Microsoft site
entitled
'Inventory management database.mdb'. Using Macros developed by microsoft for their example database (which I've
modified) a macro opens up a list of reports - which can be individually opened up by
clicking on them. However, when I try to open up one of my reports which
appears on the list, I get the following error message:
"An expression you entered is the wrong data type for one of the arguments
You tried to run a macro or use a method to carry out am action, but an
expression
evaluated the wrong data type."
I guessed this meant I had perhaps specified the wrong datatype in my table,
rom where I had written my list of reports, but this all seemed okay when I
checked and compared it with the working original. I had specified text (and
autonumber for the report ID number)
Can anyone point me in the right direction with this?
I have a macro run from an autokey (F12) that uses SendTo to send the current report that's on screen to an email as an attachment. This has been working perfectly for years and all of a sudden when I hit the F12 key I get: The Object Type argument for the action or method is blank or invalid. It's fine to just right click the report and use Send To but this is a pain for my users who just want to hit F12 as before.
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.
I have 2 excel sheets that I have imported as external data. I created a relationship between the 2 tables on part# field that is common to both. The relationship is to take all info from A table and only those from B table that match. The part# field is set to text in both tables. When I run a report that merges the 2 together a significant # of parts in my field change to a negative number. For instance the part# in both tables are 12345678 it is changed to a random -3452345 number..
I am not sure how this query I made is pulling up wrong data. Everything else is fine, except for 1 row of data. It is supposed to pull how many demonstations were scheduled for that day and how many were executed. It comes up with 4 demos and 8 executed. That can't be right. I checked it with the actual data and there are 6 demos total and 4 executed. Anyone know what could be going on there? For the other 30 something records it works just fine.
SQL: SELECT [Promo count].PromoNo, [Promo count].[# of Demos], Count(DemoOrder.Status) AS CountOfStatus, CountOfStatus/[# of Demos] AS Percentage FROM [Promo count] INNER JOIN DemoOrder ON [Promo count].PromoNo = DemoOrder.PromoNo WHERE (((DemoOrder.Status)="E")) GROUP BY [Promo count].PromoNo, [Promo count].[# of Demos];
I have a couple of subforms on one particular PC where the data is showing in some strange font, WingDings or something like that. On my PC the data shows correctly.
Please see screenshot here: http://www.confetti.ie/screenshot1.jpg
I tried changing the Font Name for all the controls in the subform to common fonts Arial, Times etc but it still shows as WingDings.
I also tried changing the default font under Edit > Options to common fonts with no change. In the Options I tried changing font options on the Datasheet and Tables/Queries tab.
I am using the following control source for a text box on a report: =nz([Raw_Turb], "---")When I do, it pulls data from a different field from the data source. I am pulling the data directly from the data table. I have tried creating a query and get similar results only from a different data field!I have tried the same control source on a different report and it works correctly! Why does it not work on the current report?
I am writing the following query to insert data in tblpostroom from another table. Both the tables have same field names like Date1,582,1810.Now If I run the following query then in the fields 582,1810 of tblpostroom , the data gets stored 582,1810 respectively for all the records. But in actual fields 582 and 1810 store different data.
Code: INSERT INTO tblpostroom ( Date1, 582, 1810 ) SELECT Date1, 582, 1810 FROM Sheet1;
I have a field in a table that is comprised of mostly numerical data but some records are text.
I want to convert this field to numerical only and make a new field to put the textual data in.
However converting the field will delete the textual data. What is the easiest way to convert the field but save the textual data AND append the textual data to the SAME record that they were in originally in the new field?
I’m not an expert in Access and hope that someone can help me with my problem. I have about 20 fields of Yes/No data type.
E.g. StudentID- Tex Science – Yes/No Math – Yes/No Biology – Yes/No Chemistry – Yes/No Economics – Yes/No ...
I would like to create a parameter query (without using form combo box) where when I run the query, it would prompt me for the subject name. Let say I keyed in Science, it would list out all the StudentsID who took up Science only (with a Yes) and the other subjects.
I want to input data number such as 0.5 in my table, but it doesn't work. I already fill field size : integer with format : Standard with Decimal : 2, but the result is always 0.00 not 0.50 as my expectation. How to define that in my table?
When exporting a table to excel is there anyway to presever the data structure - ie a text field of length 30 will only take text length 30, Interger would only take integer and date would only take date etc, etc ,etc.
Hi, Trying to get back into Access after a long time, just need some refreshing :) tips.
I have 2 tables, one of the tables stores titles (mr, mrs, etc). I tried using the 'lookup' data type to link the data from the other table. This however stores the field as a number and causes problems on my form as only a number is shown rather that the text.
I have a rich text editor that I want to use to post HTML to an access database field. The average post will probably be four hundred or more characters. What is the best Data Type to use for this. I am looking at going with Memo but I want to be sure.
How can format proper display for percentage values. What happens is I chose a field as percent, but if I put in 9 meaning 9 % I get 900% as the value is multiplied by 100, but if I put in 0.09 I get 0%. I just want to put in day 9 and be saved as 9%.
hello people, i wanted to add a string at the end of a long column of Currency. Is there any to to change only the last field to a string or do i have to change the whole column just for the last field?
I'm using Access 2002 and need to increase some field sizes, some by increasing the maximum number of characters and others by changing from Text to Memo. When I try to do this I get the message "Microsoft Access cannot change the data type. There isn't enough disk space or memory"
I have two 320GB hard drives and 4GB of RAM and the Access file is a mere 280MB. Can anyone please explain the problem and tell me how to achieve my objective?
I have a DB that was given to me with a SSN field that has the Number Data Type. Therefore, if the SSN has a zero as the first number, it is not coming up. Other than changing data type to Text, is there a property that would keep the initial zero? Thank you for your assistance.
I have inherited a table where the data type is binary in some cases and I want to change these to Numerical. When I do this in design, I get a message which says I can't do that. I have something like 200,000 records.
If I try to export as Text file I get Invalid Argument message coming up. Can anyone help?
i am creating a database that will include four (4) tables that need to have an autonumber as a primary key, but i need that autonumber to be preceded by a letter (one letter for each table). i am creating forms for the users to based on these tables for users to enter data. please help...i'm running short on time. thanx!
the database i'm creating will be used to store city issued permits. there a 4 different types of permits that can be issued, some w/the same info (i.e. contractor, owner) and others with different data (certain permits are only issued for a specific # of days, others require a tap or meter size, etc.). i have separate tables for the contractors, owenrs, and payments, but each payment needs to be associated with a particular permit #. for example: check #3 from john doe contracting is associated with permit # m123, or h123, etc. that's why i decided to have a separate table for each permit type. i was attempting to avoid data redundancy. i also need separate forms for the users to enter data into as per their request. i'm open to suggestion if you have some other ideas. thanx in advance. :confused:
I have a table that i need to be able to store text that may be over 255 characters long. I have changed the fields datatype setting to memo as I thought this was able to show Up to 65,535 characters. But the data is still being trimmed to 255 characters. I have looked in Access help at data types and it states that the memo field length is 65,535 characters
"if manipulated through DAO and only text and numbers [not binary data] will be stored in it, then the size of the Memo field is limited by the size of the database."
My question is?
How do I know if it is manipulated by DAO
If it is not manipulated by DAO how can I change it (if possible) as I really need to full data to be retained
