Recent content by ryanmc

Thanks f or your help. Atleast that gets me started and gives me soem ideas. Thanks, Ryan.

Well ... What's happening is I am importing data into an Access database from another source. I do this dynamically and not manually. When the import is done, I have tables appearing named 'Paste Errors' and I am unable to open the corresponding reports. This has never happened before, so...

Hello ... I'm importing data into an Access database from an external source and I keep on getting 'Paste Errors'. I've never had problems with this happening before. Does anybody know why this might be happening? Thanks in advance, Ryan.

Hello ... I've written my 'summed' query expression as [Revised Budget] - ([Actual Cost To Period End date] + [Estimate At Completion]) and when I try to run it I get an error message saying "Subqueries cannot be used in the expression ([Revised Budget]-(Actual Cost To Period End Date] +...

Thanks Uncle Jack, But, how do I set it up to export data specifically by date? Ryan.

Hello ... Using MS Word, how do I set it up to auto populate other fields once data has already been entered data in Field 1. Thanks in advance, Ryan

Hello ... I am trying to export data to an Excel spreadsheet based on specific date. Let me explain what I'm thinking of doing ... On my form I have 6 input boxes, with the first one being 'Date'. I have also created a button that says 'Export Data to Excel'. When the user clicks the 'Export...

Braindead2 or anyone esle who might be able to help, Now that I've created my combo box that lists all the tables by month and year (ie:June2001), I want to perform calculations to the table that the user selects. What I want to do is, according to building name within infomation from the...

Braindead2, Thanks you so much! You are amazing and I really, really appreciate your help. Thanks again, Ryan.

Thanks guys, Braindead2, I think what you've suggested sounds like the easiest option. Can you please explain in more detail how I set my combo box source as you suggested. You'll have to excuss me, I'm a junior programmer and I'm really having a lot of problems with this one. Anyone else...

I really need help with this. If anyone could offer some assistance, I would really appreciate it. thanks, Ryan

Hi, I am trying to create a dorp down combo box that lists all the tables in my databse that follows particular criteria (month and year - June2000). I will be adding table to the database at the end of every month, so I want the drop down combo box to automatically add the tabel to the list...

Tyrone, Could you please e-mail me your article on the differences in the change from DAO and ADO. My e-mail address is jratkins54@hotmail.com. Thanks. Also ... if anyone else can give me any information on the differences between MS Office '97, Office 2000, and Office XP, I would really...

Hello ... My company wants to upgrade from MS Access 97'/MS Office '97 to MS Access 2000/MS Office 2000 or MS Office XP, and I was wondering if MS Access 97' is completely compatable for these upgrades -specifically for MS Access because of the storage of database information? Thanks, Ryan

Hello ... I was wondering if anyone knows whether or not or to what degree MS Access '97 is compatable with Access 2000 / XP Office? Do programs need to be rewritten at all or is it completely compatable? Thanks, Ryan.