Search results for query: *

I'm hoping that someone can help me with this. My company wants to create a query that will export the records to a table. This in itself is easy enough to do but the trick is they want it to be fully automated with no user interface. They want the export to happen at a specific time each night...

Does anyone know how to format an integer data type in a table so that leading zeros won't be dropped? Any assistance would be appreciated. Thanks.

I just downloaded Microsoft's HTML Help Workshop to add to an Access database. I'm finding it confusing to work with but figuring it out somewhat. I tried testing the help file I made in the database by going to the main form's properties and entering the path the the help file in the "Help...

I hope someone can help me with this. I currently have a function that applies a filter to a form based on a user's login. I'm using a DLookup function in VBA, which looks at a table that contains the user's login and department, which is used as the filter. It looks similiar to below. Dim...

Does anyone know how I can create a procedure to deselect selected items in a list box when the users hits the command button? I know how to write code that will remove the entries from the list box but I don't want to remove them just deselect them. If anyone knows and you can let me know, I'd...

I just imported some data from the spreadsheet and it's in pretty bad condition. The biggest problem being that theres a lot of blank spaces. For example if I try to concatenate the first name and last name together it will come out looking something like this "John Smith" Does...

I need help with this one guys. The user wants to track operating hours of different business and be able to locate business by hours of operation. The catch is that it won't always be a straight shot like M-F 08:00 am to 05:00 pm, some days the operating hours may be different. Does anyone...

Does anyone know how to only undo the previous action? The undo event in VBA undos all the changes that you've made during the current session but I just want to undo the most recent change on a single field. Is there a way I can do this? Thanks.

Does anyone know how I can automate Access to do a Word merge for mailing labels to Word? I want to merge it so that when Word opens up it automatically merges the information and then close the merge document template so all the user is left with is the merged information. Any assistance would...

Does anyone know how to create a print dialog box for a report? I don't want to open the reports in preview, I want them to print when the user clicks on the button but first I want a print dialog box to appear so they can select which printer and tray to use. Thanks.

I'm creating a database that's a little different in the fact that I can't define one single field as a primary key, I have to assign several. I have 3 tables, 1 is used as a primary table and has a primary key set to to fields (Field1 and Field2), Another one is also used as a primary table...

I just imported a bunch of data that into a table and I need to get rid of the duplicate records. I'm basing unique records on 4 separate fields. I can run a find duplicates query but all that's going to show me is which records are duplicates and I'd have to manually go into the table and...

Does anyone know any easy way to set user's print properties instead of going to each user's machine and setting them manually? For example, I have departments that all want their print settings the same. If there is a way that I can just select group of people and set all their properties the...

I'm trying to create a new field in an existing table for a crosstab query. For example, I have 2 fields in the table (field1), (field2) and I want to be able to add a (field3) and subsequent fields when I run the code. Is there a way to do this? Any help would be appreciated.

I posted a message in here about a week ago about having problems with Novell and Access and someone gave me some advice that got it working. The problem is that in order to get it to work, Novell has to allow users delete persmissions, which means that they can delete the entire file. The...

I'm trying to do something, which sounds pretty easy to do but for the life of me can't figure it out. I'm trying to create a field with an e-mail format but can't figure it out. Does anyone know how to do this? I don't care if it's done in the table, it can be done in the form for all I care...

I just added a gif animation active-x control, which isn't part of the standard Access active-x objects and I'll be placing the database on the network in a multi-user environment where everyone will be using the same front-end. My question is since this isn't a standard active-x control, will I...

I'm trying to do a dlookup function for a table that's located in another database. Does anyone know if this is possible and if so, how to do it?

I'm trying to perform a copy paste function for screenshots. I have a field in the table set to "ole" and I know you can copy and paste screenshots into it by using the keyboard but I was wondering is there anyway that you can set it up so when the user gets the screen capture, they...

I'm working in a Novell environment and the Microsoft Access Database that is on the network is only allowing 1 user to access the database at one time. I checked everything in the database and it's set to allow multiple users and the network guys are telling me that it has nothing to do with...