Search results

Hi. I have a db of monthly costs and forecasts. As each month closes, I want to update the actual costs table from a download (csv) from our financial system which includes any prior months that were amended. Due to output format, I have to run a query to parse out the specific fields I need...

Hi there. I have a form with company information and embedded is a subform displaying a list of transactions based on the company selected. The subform does filter the list off the Company selected in a combo box but shows all transactions the company has ever made. The problem I'm having is...

Hi. I have a bunch of data that has a date field in the format yyyymmdd. Is there a way to quickly convert it to mm/dd/yyyy in date format? Currently breaking it down with left/mid/right formulas and then Format(CDate()) but was hoping there might be an easier way. If what I have is it, then...

I'm going to give it a shot. Thanks!

I know I've done this before but I can't seem to figure out how to do it again. I want to be able to open a form/series of forms separate from the main Access window like it's its own application. How do I do that in Access 2003? Thanks!

Thanks for the help. I thought it might have to be something like that. I'm pretty new to VBA and still learning so some of your code was a little beyond my level of comprehension at the moment. Would you mind explaining it a little more? Specifically, what those codes do in Access.

I'm working on a db that tracks actionable items for an office department. I'd like to be able to get to some forms from multiple locations/forms and then be able to automatically return to the previously viewed form without having to create separate forms/buttons/macros that only specify one...