Automate Changes Of Fieldnames In Tables/queries

Jan 31, 2008

I have a reasonable large dbase with some 12 tables and some 40 Queries.
In three of the tables, there are fields with dubious names like AA1, CD-3, 227, etc.
I want to change these field names to some more appropriate names like : Testblok , Cspeler, Jaarnummer, etc, etc.

In doing so, I will have to go thru each and every Query ( and at a later stage forms/reports) to change the fieldnames in that query corresponding to the changes I made in the initial table field name.

Would there be another way of doing this, i.e. is there a routine for changes made in the fieldnames, being “automatically updated in the table bound query.

View Replies


ADVERTISEMENT

Union Queries And Selecting Fieldnames With Criteria

Oct 18, 2006

I am trying to combine fields (different columns) into one field. However I am trying to have a criteria for the fieldname. For example I wish only to combine the columns that contain the text 2003 (ie [Value 2003],[Price 2003]). I have tried to use wildcards in SQl ie select * from [query] where * = %2003. I must be missing something because I can't seem to work it out. It must be simple. I have also tried several ways through the design grid with wildcards in expressions. I also don't want to union the columns by using the exact names ie [Value 2003]& [Price 2003] because additional columns may be added.

Any help, extremely appreciated, I have wasted a whole day with this.

Deesy.

View 4 Replies View Related

Tables :: Automate Record Input Across Tables

Jan 13, 2015

Trying to get a record entered into a field on table (a) to automatically enter into same field on table (b).Example: Plant database table, input record in plant name field. Have same record appear in propagation table in the plant name field.Played around with relationships a bit, don't know if there is where u do this.Plant name is primary in both tables.

View 1 Replies View Related

Automate An Export Of Data To Access Tables.

Jul 28, 2006

Hi,

Would it be possible for me to build an interface for a customer to use for importing data. So that they customer could choose from a drop down list, or input into a text box where they want to export from, and where they would like the export to be imported?

View 1 Replies View Related

If FieldName(s) (multiple) = Multiple FieldNames From 2 Tables Then "Error"

Apr 18, 2006

Ok, I have a form where new clients are entered into the system. We would like to have an automated check that could be run which would check several different fields and compare them to several different existing fields in two different tables to see if the same name shows up. What is the easiest way to go about doing something like this?

Thanks.

View 1 Replies View Related

Queries :: Automate A Harder Date Field

Mar 12, 2014

I run a report based on dates I enter (see below)

>=[Date you wish to view DD/MM/YY] And <=[Enter the Date after DD/MM/YY]

I would like to automate this if possible, the dates are enter are always a set pattern

If its Monday I enter the previous Thursday and Sunday
If Its Tuesday I enter the previous Sunday and Monday
If Its Wednesday I enter the previous Monday and Tuesday
If Its Thursday I enter the previous Tuesday and Wednesday
If Its Friday I enter the previous Wednesday and Thursday
I dont run rthe report on weekends

View 7 Replies View Related

Queries :: Automate Show / Hide Of A Column Not In Use

Dec 18, 2014

I want to automate a query so when the user views it they see only the columns that have data. Columns that do not have data are not there.I am using MS 2007

My Access tool is setup to import data into tables and then the user views the data imported. However, if their's no data (and no column to import) I want the query report to not include the column.

View 8 Replies View Related

Queries :: Way To Automate / Improve Update Of Query

Apr 13, 2013

I have 2 queries to check if there is any "double quote" character in any of 12 month columns in a month table of 125K records. I use 2 queries since the maximun criteria in a query is only 8. So I use 8 criteria in the 1st query then use 4 criteria to check the remaining months in the 2nd query. The month table is refreshed and created every month. The 12 month columns are changing from month to month since they are -13 month to -1 month when the month table is created. For example, if the month table is refreshed and created in May 2013, then the 12 month columns are "May 2012", "Jun 2012" .... and "Apr 2013". If the month table is created in Jun 2013, then the 12-month columns are "Jun 2012", "Aug 2012" .... and "May 2013". The end user has little knowledge of Access Databse so he seems confusing how to update the 2 queries on new month table.I am trying to see if there is a way to use 12 criteria in just one query so the end user only deals with one query's update.If there is a way to automate/improve the update of the queries/query, then it would be the best.

View 9 Replies View Related

Queries :: Design View - Automate Date Field

Mar 12, 2014

I run a query daily and have to alter the date in the design view (as below).

>=#01/04/2013# And <#11/03/2014#

All I want is for the query to run 2 days behind, so for example today is the 12/03/2014, I use the above, and then daily change this every day.

View 1 Replies View Related

Print Out With Fieldnames

Feb 11, 2005

Is there an easy way to printout a form in disignview so the fieldnames appear in the inputboxes? I've a form with 11 tabs and on each tab at least 10 input boxes (10x11 = 110 boxes :eek: ) Writing down the names on a printout is NOT effective

Thnx

View 2 Replies View Related

Queries :: Automate Outlook Task To Export Common Query Every Day

Jun 29, 2013

I've created an outlook task to export a common query I do every day, is there a way to automate it so it will happen automatically without me pressing Run?

I use office 2007 on a company laptop with tight network restrictions (so no Windows Task Scheduler)..

View 1 Replies View Related

Modules & VBA :: Automate Access 2007 Queries With Form For Users?

Oct 18, 2013

I've been using Access 2007 to run queries on a database where we eventually export results as separate Excel spreadsheets for individual clients. The process is quite involved, using queries to change fields from code letters to words and splitting the database up into different client tables, saving the tables under date order and with different client codes.

I now need to pass this role on to colleagues, so need to make everything as straightforward as possible.

I had thought to use a Form as the user interface, with a minimum number of buttons, however I need either the system or the user to amend the date for the initial table, then to use this new table and run a series of standard queries on it, then produce the separate tables.

I don't think I can just use macros behind the buttons, because the database name is changing each time.

I assume some parts will be too tricky to automate - it will be necessary for colleagues to follow instructions instead.....

View 2 Replies View Related

Create FieldNames Using Field Value

Aug 20, 2004

I have a table in an Access 2000 database: [SAP_Survey_Answers] that contains FieldNames: CO_ID, ES_ID,
PKey, QFieldName, QAnswer. The *_ID are ID#, QFieldName lists the questions in a survey, & QAnswer corresponds to the QFieldName and gives the answer given by the customer. Here's the dilema: I need to create a new table with CO_ID, ES_ID as Field Names BUT I also need each question as a new field name. How can this be done? Query? SQL statement? I've been racking my brain on this one. Any help would be greatly appreciated!

View 3 Replies View Related

FieldNames In Subject Line Of SendObject Action In Macro

Aug 6, 2004

I have a Macro setup and SendObject is one of the Actions. It is setup to send an existing report. Is there a way to insert a fieldname from that report into the Subject line of the e-mail that is sent? That would be great, instead of having the same subject line for every e-mail, using the date or something like that. Please let me know. Thanks.

View 3 Replies View Related

Automate XML Export

Jul 11, 2006

Hi:
I want to automate the XML export function of Access and not sure if it is possible or how to do it. In going through the menu bar (File ->Export) interface, I must choose the root table, and then subsequent tabbed windows allow one to select what tables to be exported, if I want the schema to be generated, the target filename, etc.
Instead of having to go through this large selection process, I'd like to write a script that I can run consistently over the same tables, produce the same file name, etc. Can anybody provide a suggestion/code/pointer on how to accomplish this? Thanks in advance.
John

View 1 Replies View Related

Automate Hyperlinks?

Sep 20, 2006

I have a database of chemicals and one of the entries is the MSDS number. I would like a hyperlink, pointing to the .pdf of the chemical, created when I enter the MSDS number. If the MSDS number is 1111 the .pdf file will be something like (\servernamefolder1111.pdf). Is there a way to store \serverfolder in a string, append the MSDS number, and .pdf then store that in a hyperlink field. Any suggestions?

View 3 Replies View Related

Trying To Automate A Report

Jun 27, 2007

I am trying to automate a report to run at night. I have created a batch file that will run a macro each night. But, when Access starts and loads my database I get a Security Warning [ This file may not be safe if it contains code that was intended to harm your computer]
I have tried to use a Sendkeys command to send an 'O' to go ahead and open the database but it doesnt work.
Also, my report goes to a pdf converter and it asks for a file name. I just want the macro to accept the default and continue.

How do I do this?

Thanks in advance
KD

View 1 Replies View Related

HELP HELP! Automate Import Of A .csv File

Nov 8, 2005

I was working on project that involved writing the data into Access database using a C program. The insert query execution was taking very long, so I decided to write to a .csv file and then import it to one of the desired tables. This worked very fast as compared to directly writing to the DB. Now I want to automate this process. The user should specify the file name at the command prompt and I want to call a script so that the script automatically imports the contents of the .csv file into the access DB. I already have connection established to the DB. All I am looking for is the script that can automatically import the .csv file into access DB. Please help me out. :confused:

View 2 Replies View Related

Automate Holiday Periods

Jan 25, 2006

I have read more post than i care to think about but I can't stil get my head round the following problem.
I have created a database (with this forums help) but I am stuck on the following query/form/vba etc....

Our staff holidays run from 01/05/05 until 30/04/06 and i have a query that calculates what holiday entitlement staff are due from 01/05/05 on a daily basis up to 23 days worth of hols ending on 30/04/06, but I can't work out how to set next years holiday period 01/05/06 - 30/04/07 without changing the form manually, is there a way for it to auto update??

View 2 Replies View Related

Automate Mouse Click

Aug 10, 2006

I want to be able to automaticallly send a mouse click in response to a message using a Macro or VBA code. Is this possible, Any suggestions appreciated

thanks

View 2 Replies View Related

Automate Sending To Winfax

Sep 16, 2006

Anybody got a working example / sample of faxing through Winfax10

Wish list
1.Use the FaxNo. On form
2.Send a Report

Looked through the threads but no conclusion reached

Cheers in advance

View 1 Replies View Related

Is It Possible To Automate The Following Data Input?

Nov 8, 2006

Can anyone please advise how I may be able to achieve the following?

The database in question is used to store info about members of a radio control model flying club.

I have a table (members) containing member’s personal details – names, addresses etc and a second table (club_membership) containing membership info in the Fields – year, membership_cat, insurance_cat. Each member has a record in the second table for each year they have been a member.

To simplify the renewal process (typically most members renew at the same time at our AGM) I would like to use a form which lists all members names with a check box (renew) which is checked if the member renews his/her membership. For every member checked I would like to automatically create a new record in the club_membership table for the next membership year (2007) by copying over values for the fields membership_cat and insurance_cat from their record for the previous year.

Many thanks

Russell

View 1 Replies View Related

How To Automate An Update Query?

Dec 29, 2004

Is it possible to automate a update query to run whenever a table has a new record added? If so, how is it done?

Thank you.

View 2 Replies View Related

Automate Emailing Report

Aug 24, 2006

Hi all,

Access 2000
Wondering if there is anyway to setup a report to automatically run and e-mail out at a certain time each day? I currently have a button on a form, based on a macro, that when clicked, will e-mail the report to a certain user. Just wondering if there is anyway to set it to send at a certain time, without having to open the database and manually run it.

Thanks in advance.

J

View 1 Replies View Related

Automate Mail Merge From Access

Oct 11, 2006

Hi,

I have created a mail merge from a query in Access and it works fine if you run it from word but I would like to know how to automate the mail merge from Access using the Command button. Please can someone advise.

Thanks

Alex

View 5 Replies View Related

Automate The Running Of A Parameter Query

Jun 12, 2006

Automate the run of a parameter query

I have a parameter query in ACCESS that generates an ACCESS report for 250 facilities. (Each facility has their own ID of course.) Every other month I need to run this report on all 250 different facilities. Then I give each facility their report by dropping it into an electronic folder.

This is a lot of work. Is there a way that I can automate the generation of these reports? Perhaps somehow pass the ID numbers?

I need each report to continue to be generated as a separate file.

View 7 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved