hardcoded parameters in querys--can I find all?


We have a tbldepartments. At this point (has been a few years)...many dept. have merged or changed names. We want to 'change' the names of some and delete or add others.

Ok on the delete/add.

However, in many of our queries, we have the dept. name/number hardcoded in. And trust me, there are tons and tons of them...this is a big database.

Short of going through each query, is there a way to 'search/replace' either in each query or in all To update these easily

suggestions
Posted On: Monday 22nd of October 2012 05:51:14 AM Total Views:  392
View Complete with Replies

RELATED TOPICS OF Microsoft Access PROGRAMMING LANGUAGE




Access 2010 - Macro or VB to activate/find a particular record

Good day, I've got a order form that the user populates with the materials they need, each item on the sheet becomes an individual record but through a query, the form appears to be a single form with multiple parts (if in fact the user needed more than one part). A manager then has to approve all the records/parts they requested. I made this process where all the manager has to do is pull up the first record and he sees the full list of parts/material but ends up only approving record one. It sounds complicated - live and learn for me. I've got a submit button for the user when they have listed all their parts, but if they finished with item 10 then record 10 is really the one they are submitting. I already have the code written to automatically mark a submit check box with True. I need the submit button to call up record one so that's the record that gets submitted - when the Manger and user go to review the parts, they see record one but also sees all the rest of the parts through a subform. What would the code look like to make the submit button auto check record number one Fields possibly involved in the code: [PRItemNum] represents the number of each record and the number of each part (1, 2, 3, ...) "frmPMRandQualityChecklistNewRecord2" is the name of the form
VIEWS ON THIS POST

235

Posted on:

Wednesday 10th October 2012
View Replies!

Trying to find a low-cost program for Data migration and ETL

Im building a database for my company. We are a rather small size book company with a lot of references and still growing. We have a Mysql database here and are trying to find some good tools to use it at its best. Basically we are just starting up the database after dealing with Excel: we had a size problem So im trying to find a program that will allow us to do two different things: the migration of our data from the old system to the new one and a specialized software to perform ETL (Extract, transform and load) on our database. About the price of the tools, if we were one year ago, the accounting department would have been pretty relaxed about this. But today, we have some budget restrictions and therefore need a low cost tool. So could you give me some advice on a good data migration and etl tool for a low cost
VIEWS ON THIS POST

138

Posted on:

Wednesday 17th October 2012
View Replies!

Compile error: Can't find project or library

There I try to use the function chr() and left() in Access2000. but it got "Complile error: Can't find project or library". Appreciate someone can help me.
VIEWS ON THIS POST

173

Posted on:

Thursday 18th October 2012
View Replies!

trying to find a field

When opening a form i get asked for a parameter value for a field that has been deleted. it obvioulsy still exists somewhere but I cannot find it. i have analysed performance, all tables, forms and queries but it doesn't come up with this filed anywhere. the field name has even been spelt wrong so i thought it would be easy to track! Help - what else can i do to find where this parameter is being called from\t
VIEWS ON THIS POST

118

Posted on:

Thursday 18th October 2012
View Replies!

Access how to find members who have not paid in a query

anybody help please I have list of member in the member table, every month each member makes a payment (monthly fee) as they do they get entered into the fee table how do I find out the members who have not been entered into the fee table (which will show they have not paid )
VIEWS ON THIS POST

159

Posted on:

Thursday 18th October 2012
View Replies!