Search results

OK, great! Can you give me an idea of the kind of query I would need to delete all the records in a given table?

Is there a way to select several rows of records in a datasheet view of a table and delete all of the selected records? Every time I try to delete more than one record at a time, I get the following message: "The Micorsoft Jet database engine stopped the process because you and another user are...

Hi everyone, Is there a way to automatically shut down Access after a given amount of time? I have an Access application that runs across a network. Access is the front end of a SQL Server 2000 database. Some of the users forget to close their application at night when they leave for the day...

Yes, the data in my database is extremely sensitive. So I will take parts of it and include it into a demo of what I am doing and paste it here once I have done that.

I am attempting to export a table as a tilde (~) delimited txt file, but when I right click on the table, click on Export, the window pops up, I go into Advanced and select the tilde, and then say OK, I get the pop-up saying, "The Micorsoft Jet database engine could not find the object." Can...

What exactly do you want me to paste? The form's code, or the db fields?

I have a form that no longer saves data in some fields, but does save data in others. Nothing has changed, except that it no longer saves the new data which it did save at one time. I looked at the code behind the form, and the requery statement is still there. Any suggestions?

I can see where the comboboxes send the data, but I want to see and pring out the list within the combobox that a user has to pick from when they are filling out a form? Thanks again for your help.

I have a new job at a company that had someone else develop their Access application. My boss has asked me to print out all of the options in several comboboxes so he can have me either add to or delete some of the items in the list. Is there a way I can copy all of the items in the list of a...

I have clients that send text files to me to be imported to a database that I keep for them. I have imported several of these files in the past, but all of a sudden I am getting a strange error message. Here is the scenario: I open my database and right click in the empty area of the Tables...

I have a report that needs to be printed on legal paper (8.5 X 14). How do I force Access to print to a piece of paper 8.5 X 14? Thanks in advance for your help. David

How can I filter records and have all records show up as a list if a perticular check box is not checked on the form? Here is the scenario... I have a sub form on a main form. In the sub form, the user will input the current ToDo list of the clients account, notes, etc. If the ToDo is complete...

Please forgive me if this question seems too simple for some/most of you. I have two fields on a page that I want to show the current time on the computer, and the current date. How do I do this? I also want the current time display to display the seconds ticking off. Please give me very...

OS compatability Thanks for your reply. So how do I fix this problem? The company I am doing this for has numerous operating systems. So I need a fix that will work across anything from Windows 95 all the way up to Windows XP Professioanl. Thanks again, David Greene admin@mindinthesky.com

I am in some of the final stages of writing an Order Management application in Access 2000. To get started, I used the Order Entry template that comes with Access. When I first started this development, I was writing it in a Windows XP Home Edition OS. But, when I tried to open the application...

Thanks for your quick reply, and for the advice you have offered. But while I have an idea of what you're talking about, I have no idea what the methods are for doing it. Is there a place I can go to and read how to enter this code, and how to get it to work? As I said, I am a novice at VBA...

Thanks for your advice! But, sadly these people are so darned lazy so that they don't want to have to click a button. Is there a way so that as the last field in the End Date/Rights field looses focus, that the query is automatically run? If the query finds an equal order, sometime within the...

I am a little bit of a novice when it comes to using VBA with Microsoft Access. I am building a form called "orders" with a db called "orders1". There is the ability to have 10 orders displayed per form with 5 fields per order that display important information to consider when filling out an...

I am a little bit of a novice when it comes to using VBA with Microsoft Access. I am building a form called "orders" with a db called "orders1". There is the ability to have 10 orders displayed per form with 5 fields per order that display important information to consider when filling out an...