Search results

hi all, i'm tryin to use acc 2007 and i see that all has been hidden very well... ok - i want to be able to import a spreadsheet via a button. i imported a spreadsheet and saved the steps, but i see no code anywhere where this has been saved (?) i wanted to create a button and add the code...

cool thanks for that i wil slap them first... THEN ask questions :)

that makes sense cheers for that! :)

would having a db with several tables and NOT setting any relationships up in the relationships window affect the db in any way? i have such a db, which originally had all the relationships set etc. however, as i encountered errors and had to replace tables and delete entries, i must have at...

I have a small access db in a network which has started to crap out far too often lately. The main table records job entries and inserts a date stamp. Every now and then, an entry has a ridicuous ID (auto inc field) and/or a bad date stamp and i can't delete the record (instead i have to output...

please delete this thread sorry all

thanks for that - you're a star!!!!!

Hi all, I have a single spreadsheet with multiple tabs, and I need to change that to multiple spreadsheets with a single worksheet each. I'm wondering if any of you have come across a little script or app that might do this?

Can I create a table 'on the fly' to host an xl import? I'm using... DoCmd.TransferSpreadsheet acImport, 8, "tbl_Import", sPathOfFileToImport, True ...at the moment, and it would be neat if I could tie it into that statement The issue is that I need to import an xl spreadsheet whose...

thanks BETWEEN works great!!! Thanks for your help ;)

Hi all, I'm having trouble with my syntax in an SQL statement that passes variables I'm trying to do this: SELECT * FROM MyTable WHERE ID >= var1 AND < var2 I'm having probs with the single & double quotation marks that separate the vars from the statement proper I got something like this...

thank you all Thank you all for your help!! Date_Diff confused me a little, so I used Between -> it does what I need Thanks again for your time Jose :)

nearly! that also displays tomorrow's record - which is Phil, 10th of Nov 05 ======================== Name, Date (Day/Month/Year) John, 09/09/2005 Phil, 10/09/2005 Xena, 03/11/2004 ======================== Thanks so far

Don't display records older than x days - problem with syntax Hi all, I have a table with some records: Name, Date (Day/Month/Year) John, 09/09/2005 Phil, 10/09/2005 Xena, 03/11/2004 I want my query to display all records with today's date, or those that are 100 days older than today's date...

Top That's great!!! It works great - I just need one more bit of knowledge, if you would spare me :) * The reason I replace data is simply that it is a small app that imports csv data into a table, modifies it, then exports it into XL. Each import replaces the last. Basically, I'm storing the...

Hi all, I want to retrieve a set number of records from a table, using a query. I'm not sure of how to do this. I can't use the ID, because the table gets its data replaced contantly by imports (so the ID doesn;t start at 1...) I want to be able to retrieve, say, the first 25 records on that...

last thing thanks for the link - i did spend time searching for it - obviously not enough. :)

Using FileDialog(msoFileDialogOpen), how do I get the name of the selected file? I've worked my way down the properties (e.g: Debug.Print Application.FileDialog(msoFileDialogOpen).SelectedItems .Item .Title etc... Thanks in advance

thanks thank you! that works great!

cool thanks for that!!!