User Profile

Mejmeyster started a topic Trouble with database query

in Access

Jan 25 '07, 08:35 PM
Trouble with database query
Hi Everyone!

I've been desperately trying to prepare a database query from Access to Excel. The problem is, when I ask MS Query to import data from more than one table, no data is importing, only the headings. The SQL is as follows:

Code:

SELECT Expense.Rent, Expense.Utilities, Assets.Cash, FROM `C:\My Documents\Accounts`.Expense Expense, ‘C:\My Documents/Accounts’.Assets Assets WHERE TransactionID =

...
See more | Go to post

Last edited by NeoPa; Jan 27 '07, 12:38 AM. Reason: Tags for Layout
Mejmeyster replied to Unable to change from "text" fieldtype to "memo" fieldtype in a table

in Access

Nov 8 '06, 12:34 PM
Yep, that's what I ended up doing. Thanks so much!...

See more | Go to post
Leave a comment:
Mejmeyster started a topic Unable to change from "text" fieldtype to "memo" fieldtype in a table

in Access

Nov 7 '06, 02:26 PM
Unable to change from "text" fieldtype to "memo" fieldtype in a table

Hi Everyone,

I have a table in which one of the text fields has become too small (since it only holds 255 characters). To remedy that, I'm trying to change the data type of that field to "memo" in design mode. However, when I go to save the new settings of my table, the error message "Record is too large" pops up and won't allow me to save the table. What am I doing wrong? I work with Access 97 in Windows XP....

See more | Go to post
Mejmeyster replied to Limited field sizes in Access form

in Access

Oct 31 '06, 07:38 PM
That worked like a charm. Thanks so much!

See more | Go to post
Leave a comment:
Mejmeyster replied to Limited field sizes in Access form

in Access

Oct 30 '06, 10:02 PM
Access 97

Thanks!

See more | Go to post
Leave a comment:
Mejmeyster started a topic Limited field sizes in Access form

in Access

Oct 30 '06, 09:29 PM
Limited field sizes in Access form

Hi,

I'm trying to modify a pre-existing form so that the text boxes will allow me to store more than 255 characters in them. I've traced back to the table where all the data is stored and tried changing the field type to "memo" instead of "text." When I go to save the table, however, I get the error message saying "Record is too large." What should I do?

Thanks for all your help.

See more | Go to post

No activity results to display

Profile Sidebar

Trouble with database query

Leave a comment:

Unable to change from "text" fieldtype to "memo" fieldtype in a table

Leave a comment:

Leave a comment:

Limited field sizes in Access form