Search results

Thank you Paul. Your suggestion makes perfect sense. I had a play and came up with a suitable combination (if anyone else reads this): Field size double Format Fixed Decimal places 1

Good morning I have a glitch with a query I think. I'm a user not programmer so I'm hoping for some advice. I use transferspreadsheet to upload a report into a temp table, then a series of queries to move relevant information to appropriate tables, and a final query to empty the temp table...

Resolved. From what I understand I needed to compile the database prior to trying to make the mde. It was very easy to resolve once I knew what to do. I followed help from this thread: http://www.access-programmers.co.uk/forums/showthread.php?t=38174 boblarson and Pat Hartman to the rescue...

Thank you for your reply Pat. From your description it sounds like upgrading is beyond me. I don't have any programming experience - I'm only on this because I'm the most experienced user we have here. Perhaps I can track down the source of the corruption and address it at the source. Is...

Good afternoon When I click the Create MDE button I get the error message You cannot add or change a record because a related record is required in table 'MySysAccessStorage'. I am a user who has been making some improvements to our database. I have been pretty successful with the help of...

Thank you fellas. ajvol I ammended the range of cells I'm inporting to exclude some unnecessary rows at the top of the spreadsheet. Cell A19 had about 400 characters so I started the command there, and now all of the text is being imported. I am so grateful to you programmers who provide...

I don't think that's it either. It's .xlsx. But the access version is an older version, maybe 2003. Could that be the root of the problem?

Yes. The Excel spreadsheet has complete text in each cell. I have worked backwards from the final (ultimate destination) table where I noticed the incomplete text. Then I prevented the delete query from erasing the temp table after all of the append and update queries (put an ' before the...

Hello Mr Larson; thank you for replying. The Excel cells might contain up to 1000 keystrokes (guessing) which are comments from companies about their activities. I had previously run into this incomplete text capture problem when copying from the temp table to final tables, so I have...

Maybe if I ask the question more directly? transferspreadsheet only imports a limited number of characters from each cell in the source spreadsheet to my temp table. Can I alter the code to capture all text in the target cells?

Hello I'm a user not a programmer and I'm hoping for a bit more help following up on assistance from John Big Booty a few months back. I used some code from John Big Booty to import a spreadsheet into a temp table and then run a series of queries to move the data to their final tables...

You did it! Thank you so much JBB. For being willing to share your knowledge, and for being patient enough to help me eventually ask the right question! Now I think I can base a series of other queries on this SQL to extract the rest of the information from my temp table.

Yes that was the error message. But in future the application_id will exist in tbl_opr and additional fields will be added to the record as time passes. Should I be using an update query instead of an append query? Also, the sql you posted points at the question in tbl_opr_temp, not the...

Hi again JBB. I'm sorry to say that it didn't work. It broke at ...it didn't add 1 record to the table due to key violations... If you can bear with me, open tbl_opr_temp. F1 of record 100 contains the text If you were unable to recruit*. F1 of record 104 contains the text entered in...

Sorry about that. The developer who put it together in the first place built in a lot of structure. It's been painful to get as far as I have. But that's my query! f30 in tbl_opr_temp holds the application_id, which is the primary key for the destination table: tbl_opr. tbl_opr_temp was a...

I didn't move the opr tables to the back end yet so you should have everything you need in one place.

Here you go JBB - I hope you can make sense of it. The query I've been wrestling with is q80_find_recruitment_story_6

Maybe I can't attach a copy of the .mdb because I haven't been a member for long enough?

I think so JBB. It is split into a front and back, so if I post the front, users won't be able to access the data right? Privacy and all that stuff...

"I haven't been able to get put field I want to extract into its destination record." Sorry about this rubbish. I haven't been able to put the field extracted from the temp table into its destination record.