Search results for query: *

trying to automate some repetitive tasks. I have data driving charts, I also need to display some text in Textbox within the chart. This text changes so i'd like to link it a cell that changes with some fansy-doo concatting. i'll try making a macro to cut/paste the text into the chart, but if...

I'm wondering if there's a clever way within Access or outside access, to compare two tables for any changes. Take "Compress & Repair" scenario.. I did that earlier today and found that one record got lost in the process. For what reason I dont know. There are free 'Excel compare'...

It's a geographic mapping plugin app that comes bundled with Office. I've had it installed, but my installation only came with templates for the Americas and Australia. I need Europe, Asia and Oceania. If you have these templates and would be willing to share or have any other suggestions...

careful though, calendar quarter or fiscal quarter? especially now, with financial reporting being under scrutiny, c/o Mr Sarbanes and Oxley. in my case i had to load the company's fiscal calendar into a separate table and lookup the quarter.

i've considered actually throwing the whole thing out the window and going with Lotus Notes, but at the moment cannot allocate the resources needed to develop a new database, nor do i see the management willing to jump for it. For now, just looking for a temporary solution until we can get...

not very large, the largest of the 3 compacts to about 5mb. the biggest table being about 4000 records. the rest of the tables are lookups, <20 a piece. although, i have to compact regularly, the size is 15-20mb normally.

Hi Mike, we do use Citrix quite a bit. My initial design was based around Citrix, in other words, 1 central dbse and all 30 users hitting the same dbase through Citrix. Good intention, but the thing crashed in 30 minutes. major corruption, i had to scap the idea and go back to 3 databases...

I have 3 front ends where all the data entry takes place. The data is stored in each of the front ends. I tried using linked tables so that the 3 front ends all point the data to a central place, but because the 3 databases are in US, Ireland and Singapore, i get corruption due to network...

So, I created a bunch of reports and queries with these convoluded names like qryDailyRptANC. Without realizing that the name I gave it is going to appear on all headers and exports. Too late to change now b/c these names are hardcoded into buttons and actions. I wonder if there is a way to...

I inherited a set of spreadsheets from some developer the company hired back in 98. Trying to figure out how in hell the spreadsheet works. It's sort of a balance sheet, so there's a lot of cross referencing going on. SUMIFs, VLOOKUPs, etc. The thing that's doing most of the calcing in the...

I have a form with a drop down that lists a few choices for my user. I want to pass the user's selection from that combo box to DoCmd.OpenForm (in acFormDS). In other words, open a form in Datasheet view and filter it based on the criteria the user picked in the drop down menu. I'm totally...