Recent content by AccessHawaii

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...

Thanks. Got it working now. Another question for you. I've never ran into this before with Access but I am now. It keeps doing an auto-correct. For example if the user types in "CNA", it changes it to "Can". Anyone know how to fix this.

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.

Thanks, Randy. I just sent you an e-mail. Your way sounds a lot easier than all the steps I'd have to go through with the Help Editor.

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...

Andy, Thanks. Worked like a charm. It does exactly what I was looking for and I'm even able to get rid of some of the other routines I have and replace it with this. Thanks again.

Thanks Andy. This sounds like what I need. I'm gonna try it out and I'll let you know how it goes.

Thanks Andy. I'm not sure how I'd be able to throw this into a filter though. In the main table, the department is in a single field with a drop down. What basically happens is the record is sent to one of the 10 or so departments for resolution and people may be assigned to different...

Yes, there is. I have a similar setup on one of my databases. Basically I have a table with 2 fields. One for the user's login and one with a yes/no field. When the user logs into the database a hidden form opens up with the user table as its record source and filters on the current user's login...

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...

Thanks, worked great.

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...

Thanks for the help. I got it working.

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...