Search results for query: *

Hello, I have a project coming up in which they want me to be able to pull table data from Microsoft Access into Microsoft Project and most likely, vice versa. I've been trying to find a straight forward resource on the web about the subject, but have just come up with more questions. Does...

I have a project database that managers used to keep track of their projects. One aspect of each projects record is the resource (people) who works on the project. I'm trying to pull up a list of all the projects that do not have anything listed in their 'Resource' field. The table is called...

Hello, Like a lot of people here, I need to have my Access 2000 reports exported to another file format for emailing. However, all the nice formatting is gone from the .rtf file that gets created. I've been reading in certain forums here that it's possible to export reports to Adobe Acrobat...

I need to change my D drive to a G drive ... is that possible? And if so, how would I go about doing it? Thnx! (^_^) -Jedi420 A man who has risked his life knows that careers are worthless, and a man who will not risk his career has a worthless life.

Hello, I am just curious if I am able to work on an Access 2000 file in Access XP and still be able to work on that same file later on in Access 2000? I know that you could not do that with Access 97 and Access 2000. I just wonder if the same issue exists. Any help would be greatly...

I have a split Access 2000 database with the backend on our network drive and the front end on everyones computer. Since we're all in the same office, everything runs fairly fast and well. Now, however, there are 2 more additional users who are at a remote site and they're complaining that the...

I figured this'd be the most appropriate place to ask this: Is there a way I can run a program from a batch file and not have the batch file hang until the program it called has finished executing? I just want that batch window to go away as soon as possible and it never does until the program...

In trying to re-link my tables after I moved my backend, I get an error message saying "Not Enough Space on Disk". I dont understand, there are GIG's of space left. This is the final step before we put this thing into production and I have no clue why this is happening. Any help...

I had a secured Access database (secured properly!) that I recently began working on again. To facilitate multi-user access, I split the database. I noticed, however, that the security did NOT extend to my backend DB ... only the front-end mde file. That means that anyone can just open...

In Access 2000, how would one go about (through code) finding out that the record they are on is currently locked so that I can show my user some kind of msg box to let them know that trying to edit the form is useless at the current moment?? And also, how (throug code) would I find out that...

Hello, I have a split multi-user DB in Access 2000. I'm usind edited record-locking and as far as I understand it, if two people are editing the same record, it will save the changes of whoever does so first and the second person who tries to change will get a write conflict error with the...

I was recently reading foolio12's security FAQ (faq181-3893) and I am quite satisfied with the level of security that my DB has, except for one thing. You can open a new DB and just import all my tables and queries and since my tables are linked, whomever would do this could alter/delete...

Hello, Im running an UPDATE query and an INSERT INTO query where I'm experiencing this problem. When I run either query, if ANY of the values that are being updated or inserted are NULL or an empty string (""), they do not work. I recieve no message or error. I just check the data...

Hello, In my database, I sometimes import excel data to use as records. However, whenever I use the DoCmd.TransferSpreadsheet function to import my data, I get tons (about 136) of blank records in the destination table. I check the spreadsheet and nothing seems out of the ordinary...

I'm using Access 2000 and was wondering if someone would be so kind enough to tell me how I can reference the various dialog box's (mainly the common dialog windox) through Access 2000. Doing it the VB way (by right-clicking on the toolbox and selecting it there) is unavailable. Thank you very...

I've currently been assigned with the task of maiking our DB be able to export a table to a spreadsheet, whereupon people would then be able to update records at home. They would ideally then return to work, and be able to import the spreadsheet to be appended to the table that it originated...

I recently view someones Access database at work and I noticed that when I right-clicked on their form, the properties selection had been disabled. However, when you entered Design-Mode, it was available again. He doesn't work here anymore so I can't just ask him how he did that. Does anyone...

Hi, I am curious ... is there a way to auto-center reports?? Whenever I open my reports (manually or from code), they're always off center and usually focused on the bottom-right corner of the report. Any ideas or suggestions? Thnx! (^_^) -Jedi420

Hello, I have a similar problem in that I have a Main report that displays all projects. Projects may or may not have status updates. I have a subreport in the main report that shows the updates (if any) per project. The sub-report shows the updateDate and the statusUpdate and is based off a...

Is there a way to open a report from criteria based on its sub-report? I have a report that displays projects (from tblProjects) and a sub-report(from tblProject_Updates) in that report that lists all the updates (if any) for each project. The two tables are linked via the projectID (and so are...