Copying Numerous Forms/queries/reports
Jan 10, 2005
I have a problem that is very tedious. I have 9 separate copies of the same databse (there is a copy of each database for every branch of my company. Each database has small custom features that show what company it belongs to) i was told to make a new feature, and in the making, i had to make 40 new queries, 12 new forms 8 new macros, 12 new macros and 6 new forms. this feature needs to go into all of the databases. As far as i know, im going to need to copy and paste each individual query,form, macro and form. Thats 72 different things i will have to copy and paste into 9 separate databases. Does access provide an easier way to go about this?
any help?
View Replies
ADVERTISEMENT
Sep 18, 2013
I have a form where i select via a combo box if a product has been inspected, if it has, additional controls are then made visible.
If Me.Inspection_Completed = "Yes" Then
Me.Date_Inspection_Comp.Visible = True
Me.Date_Inspection_Comp = Me.Dateinsp
Me.Inspector.Visible = True
Me.Qty_Inspected.Visible = True
Me.OK.Visible = True
[Code] ....
I tried to put this in a function so i could call it on load, or on current etc, but cant seem to get it to work, apparently you cannot use the me. in a function.
View 4 Replies
View Related
Apr 21, 2014
I have a database of high-school football players, and I am looking to print out single page reports (or forms) that will show detail from several tables and queries. This will act as their resume when they visit schools on recruiting visits. The reason for needing query items, is that I have developed queries that return the most up to date height, weight, 40 time etc., and that single most up to date number is what should print, not the entire table. When I try to build a report it will let me bring in multiple tables, but not queries.
View 2 Replies
View Related
Mar 16, 2012
I am creating a database from an Excel Workbook. Many of the calculated cells are dependent on the values of other calculated cells.There are more than 255 cells for the one sheet so I can't use one table.I was forced to use multiple tables and place the calculation fields in their own tables for the use of their fields in a calculating query, although they won't be seen on any form or report.
What is the best way to relate these tables even though they should really be all part of one table? Should I just use a Cross Join? Will a cross join allow me to properly calculate with a field from an unrelated table? What about an Outer Join?I need to reinforce integrity so that if one set of table data is deleted, so are all the others.I have already tried to place a "Report Number" autonumber field on each table, but it doesn't seem to allow me to reinforce the integrity and gives me, "invalid field name of definition of index or relationship".
View 4 Replies
View Related
Nov 15, 2006
We have a billing scheme in which we partial-bill ceratain customers based on certain events: 30% when they sign the contract, 30% a number of days later, 30% when we ship the goods and the last 10% upon installation. This is a common process, known in many indistries as 'progress billing.'
What I am trying to do is compare the collection performance on the invoices based upon which trigger sent them. For example, I'd like to find the average and standard deviation (plus some percentiles) of the time it takes to collect invoices that are sent... when we ship, let's say.
I have a table that shows order number, invoice number, invoice date, amount and payment date. So, I can have the order number show up to 4 times with a chronology of invoice dates.
My question is this: How do I group for analysis all the FIRST invoices, the SECOND ones, etc...?
Thanks for any help! I can do this in excel... but I was given this extract of 100000+ lines, and hope to do it all in Access. Thanks again.
View 2 Replies
View Related
Jun 1, 2005
Put simply - when I do a find it displays the first account that matches it, then, when you leave the find screen and hit the "next record" key it simply displays the next account (i.e it no longer matches the search criteria).
So my question is,
How do I search records, then skip through ALL accounts that match the criteria.
example:
100 accounts in a database. 50 accounts are assigned "Mr A" and 50 "Mr B".
Mr A and Mr B sit down to work - hit find, and type in their name.
The form shows 1 account, and when mr A hits next fifty times it should not move on to mr Bs (possibly a "no more matches/records" message?).
I hope this is clear enough - and thanks in advance.
ps - I heard something about one form to search - and a subform to display results - the search criteria is static in form one, where as the subform can be skipped ("next record" pressed). But trust me - Im inexperianced :p and would need a nice newbie friendly description of such technological witchcraft.
View 1 Replies
View Related
May 18, 2005
I have nearly 100 queries in an Access database which links to a SQL Server database. The queries are working just fine.
I have created a new Access database, linking to a different SQL Server database which has the same table layouts as the first. Is there a way to automatically copy the queries from the first Access database to the second?
View 2 Replies
View Related
Feb 2, 2015
I am using .FormFields to fill a quotation template in Word, but the subform I am retrieving the data from has rows of records under each column and I need to send more than just the first row to fill the required bookmarks in Word.
The code I'm using is
Set doc = appWord.Documents.Open("S:TemplatesQuotation Template - Test.doc", , True)
With doc
.FormFields("FirstName").Result = Me!FirstName
.FormFields("FirstName2").Result = Me!FirstName
.FormFields("LastName").Result = Me!LastName
.FormFields("LastName2").Result = Me!LastName
[Code] ......
View 4 Replies
View Related
Sep 7, 2013
I'm using Access 2007.I have 2 tables that are identical in structure.The tables are called [Workorder Parts] and [Workorder Parts Temp]. They both have the same structure:
WorkOrderPartID (Autonumber)
WorkorderID(Number)
PartID(Number)
Quantity(Number)
UnitPrice(Currency)
Notes(Memo)
KitID(Number).
[Workorder Parts] has 128 records in in and [Workorder Parts Temp] has 28 records in it that are a small subset of [Workorder Parts] therefore, the contents of the key field column in [Workorder Parts Temp] is the same as in [Workorder Parts].I tried the following SQL but get an error message saying "Cannot Update "WorkOrderPartID" Field not updateable":
DoCmd.RunSQL "INSERT INTO [WorkOrder Parts] SELECT * FROM [Workorder Parts Temp]"
My aim is that I want all of the records from [Workorder Parts Temp]to be copied to [Workorder Parts] and have their "WorkOrderPartID" fields correctly updated with a new value...
View 14 Replies
View Related
Dec 15, 2014
I've got a listbox on one of my forms (with multi select enabled). Essentially its a list of products, the idea is for the user to select as many products as he or she likes, then they click a button and the selected products show up in an append query, which will add records to a table.
How to copy the data from a list box to an append query (nothing that each selection should have its own row)...
i also wanna look into "Select All" and "Select None" buttons, is this possible?
View 4 Replies
View Related
Jul 28, 2014
I have a MS Access table containing Dependent social security numbers but some of the dependents social security numbers are blank.
I have a MS Sql Database that contains a table with most of the missing MS Access table dependents Social Security numbers.
How can I take the Dependents social security number from MS Sql Database and copy/update the MS Access table.
I tried the sql code below created from MS Access and it matches 453 records out of 460 dependent social security numbers but how do I update qryGHIAccuracyFile_MissingDepSSN.SSN with the social security number from dbo_depfile1.dep_depend_ssn
Code:
SELECT dbo_depfile1.dep_depend_ssn, qryGHIAccuracyFile_MissingDepSSN.SSN
FROM qryGHIAccuracyFile_MissingDepSSN LEFT JOIN dbo_depfile1 ON qryGHIAccuracyFile_MissingDepSSN.MemberSSN = dbo_depfile1.dep_ss_nbr
WHERE (((dbo_depfile1.dep_first)=[FirstName]) AND ((dbo_depfile1.dep_last)=[LastName]));
Updating MS Access table dependent blank SSNs with SSN in MS Sql Database.
View 2 Replies
View Related
Dec 14, 2006
This is surely just going to be a simple dim statement or code.I have 2 forms, one is plancontrol and the other is contacts. The plancontrolform holds a record of contacts for different forms - the contacts form is merely a seperate form to choose which contacts you want to add. (it was to messy keeping it all on one)The contacts form uses cascading combo boxes to choose a contacts. This all works fine but after a contact has been chosen, i want to (through a command button) add it to a viewable list. Once the user has selected all the contacts they want they can close the contacts form. The names will be automatically entered into the plancontrol form. This is not my normal type of database as it is linked to Otulook, therefore some of the rules i abide by i cannot!!Any ideas? Should i (and how do i) keep adding the names to plancontrol as i go along, or just do it all in one go at the end? p.s. plan control is a continous form.thanksKev
View 2 Replies
View Related
Oct 25, 2014
I am currently creating a database which stores customer details and booking details.
I have the following tables: Customers and Reservations, both of which are linked by the CustomerID field.
The customer form automatically assigns a CustomerID when you enter data, however I then want the CustomerID to be copied on to the reservations form aswell. Also, the reservations form is a new form and not a subform.
View 1 Replies
View Related
Sep 8, 2004
I KNOW I'm making this harder than it needs to be.... I have a union query that pulls from two sales tables. I'm setting up a report where a person can select a manager name, start date, and end date for those union'd sales. I can do all this no problem in the query, but I want to be able to have this information selected on a form, instead of through popups, to bring up the report. How do I link the form information to the query? I can't get the report to show information it "read" from the form. Does that make sense?
Please help!
View 1 Replies
View Related
Jul 16, 2007
HI folks
I have a db. I have created a search form which when you click the search button executes a query to find the required records.
The query is currently outputting to printpreview of the query.
What i want to be able to do is have the option to select the correct record and then print it. The search can either be exact and return 1 record or use a wildcard and return a few records.
I have the report setup and working I just can't for the life of me figure out how to link everything.
Maybe I've missed something I don't know.
View 3 Replies
View Related
Oct 24, 2005
I am in the process of trying to build a template in forms for my boss to quickly enter information and construct a PowerPoint presentation from this information.
Basically, I have a form that he can enter information, but it needs to look professional (not datasheet view). Is there a way that I can make a subform and frame it, so that I can copy the entire form (not just the data) and paste it onto powerpoint? I need the formatting to be consistent and appealing!
View 2 Replies
View Related
May 31, 2013
I have a form Based on a tables called:-
TBLInvoice which contains to fields relative to the question
UseDefaultDescOfServices = Yes/No Type
DescriptionOfServices = Long Text Type with Rich Text Enabled
And second table called TBLCustomerPOs which contains a field
DefaultDescriptionOfServices = Long Text Type with Rich Text Enabled
What I am trying to do is if the UseDefaultDescOfServices = Yes then copy the data in DefaultDescriptionOfServices to DescriptionOfServices and make the field read only and turn off the boarder on the field. If it set to no then the user can enter his own data, turn on boarder and make the field editable.
However I am failing at the first hurdle, i.e. I cannot copy the data. Below is what I have tried to do but it doesn’t do anything.
If [TBLInvoice]![UseDefaultDescOfServices] = -1 Then
[TALInvoice]![DescriptionOfServices] = [TBLCustomerPOs]![DefaultDescriptionOfServices]
End If
View 6 Replies
View Related
Feb 15, 2006
Hi All,
I’m completely stumped … could be because its so late or my brain has just decided to give up on me!
Short of not going into too much detail, could someone advise … does one HAVE to create a query in order to create a report based on a form OR can one create a report based solely on a form?
Is there a right way and a wrong way ... ?!?!
Hope someone can help me ... thanks in advance.
View 2 Replies
View Related
Mar 30, 2005
Ok, so now this is where it's getting more complicated... (though I guess this is where you guys usually start)
When you have a query, and you type in your inputbox thingy like so:
http://reenen.fateback.com/image.jpg
PeriodEnd: [Enter period end date dd/mm/yyyy: ]
And you can have multiple, then it will prompt you for several of them.
Now this is not very tidy, so I'd rather do it on a form. How can I display the form as the query/report runs, and insert the values entered into the form as the inputs into my variables? (This case PeriodEnd)
-Canderel
Grrr... I can't get the image to display.
View 11 Replies
View Related
Jan 30, 2015
I currently have a form with the below fields (example names)
FRMFormName001
Field001
Field002
Field003
Field004
RPTReportName001
Once the info is filled out we click a button that converts it into a report and once the information is confirmed correct you have to click another button Email it off, this is currently done by a macro creating the report as a attachment PDF File.
The system has now changed and they now want the details in the body of an Email, is it possible to make the details be copied straight into an Email body by a simple macro button click or similar?
View 5 Replies
View Related
Jan 26, 2014
I would like the text from the previous field Invoice_Contact copied into the field Invoice_Contact of each new record created. I think I can use CTRL ' - but would like it done automatically if possible.
Field location:
Form = PatientUpdate - Subform = F_Invoice - Field = Invoice_Contact
The form and subform are linked through: Pat_ID
The subform is based on the table called Invoice with Invoice_ID as the primary key.I tried several variations of this DLookup from examples I found on the web but the field comes out with "error" in it and its flashing!
View 14 Replies
View Related
Apr 9, 2013
I'm trying to make a template form for a helpdesk, at the bottom would be a "Copy to Cliboard" button that when pressed will copy to clipboard in the format of:
label1 textbox1
label2 textbox2
label3 etc...
I got the jist of it, but got lost somewhere along the way, this is what I have so far:
Code:
Option Compare Database
Option Explicit
Private Function fcopyfields() As String
Dim strapp As String
Dim strapplabel As String
[Code] ....
It's falling apart at the button click.
View 2 Replies
View Related
Sep 8, 2011
I have a psychology project where we soon use a questionnaire on a daily basis (maybe 80 variables per day per subject). Currently, there is no data in the database.
I've managed to create a table called day1 (with 80 day1 variables) and a form that looks like the questionnaire we want to use (and linked apropriately to the variables in the table for day1).
What is an easy way of duplicating the table and form for successive days? That is, i want the structure of the day1 table copied to another table (call it day2). It has exactly the same variables except they are slightly different to differentiate them from day1. I would like the form for day2 to have exactly the same layout as the form for day1, but link to the variables in table 2.
I know i could just couple the day1 table, change the variable names slightly, and then copy the form for day1 and change the links to point to table2, but there are many assessments (18 days).
View 3 Replies
View Related
May 24, 2006
Good morning All.
I have a database which updates via a Function in a module every morning (i.e imports and exports data).
Yesterday the DB crashed and incurred a problem. The DB was closed down and re-opened.
When it was re-opened all the Tables, Queries, Forms, Reports and Modules were no longer showing in the DB window.
When I selected the Tables tab the following message appeared:
Operation Invalid Without Current Index
this was then followed by another message:
"Isn't an index in this table. Look in the indexes collection of the TableDef object to determine the valid index names
This also appears if I try selecting the other tabs i.e. Queries, Modules etc.
The strange thing is the DB still updates at its stipulated time, and still imports and exports data. I am running Access 97.
Does anybody have any idea of how I can sort this out?
Regards
Chathag :confused:
View 1 Replies
View Related
Sep 5, 2013
It basically is used to create, manage and track Customers, Parts, Work Orders and Suppliers, payments and employees.You simply create a Customer and then create a Work order that contains a list of parts and labour items.
What I want to do is to create a "Kit" of parts so that the user does not have to select each part individually when they create a Work Order. For example, if I use a mechanics workshop as an example, the mechanic may sell his "Signature 1916cc Engine" that consists of 40 different parts and some other items such as labour and other services. In this scenario, instead of the user individually selecting 40 different parts, all he needs to do is select the Kit called "Signature 1916 cc Engine" from a drop down list and all of the 40 parts and other items would automatically populate the correct Work Order Parts/Labour tables.
I would also like the user to be able to select another "kit" that would either replace all parts and labour records or append to what is already there.
I have changed the form called "Workorders" to have 2 buttons. One called "Load Kit" the other called "Save Kit".If the user presses "load Kit" a form will be displayed that enables them to select a "kit" from a list and whether they want to replace all of the existing parts and labour records or if they want to append to the existing records.
In order to create a new kit, the user can simply manually create a new work order by individually selecting each part and labour item and then pressing the "Save Kit" button. The user will then be asked to provide the short name of the Kit and the long description (I have created table called tKit). The new kit will then be saved.
It appears that the "Entered by" field that is linked to the Employee table must not be blank other wise the Workbook is NOT saved....I have tried to figure out why this is happening but can't!
The Work Order Parts are stored in "Work Order Parts" and the Work Order Labor is stored in a table called "Work Order Labor". I have created 2 extra tables called "tKitWorkOrderParts" and "tKitWorkOrderLabor" that I assume will contain the items that make up the kits..
View 14 Replies
View Related
Jan 21, 2014
I'm trying to secure my database so users can't edit tables, forms, reports, queries, etc.I'm splitting the database, making an ACCDE for users:
1. I inserted code to disable the bypass key.
2. I inserted code to hide the Quick Access Toolbar (QAT) in the On_Load sub of the form that opens with the DB.
3. Deselect Navigation Pane, Allow Full Menus and Allow Default Shortcut Menus are deselected
4. Then, I use the immediate window to show the QAT, I then create an ACCDE.
How do I link this ACCDE with the original ACCDB? Am I supposed to delete tables from the front end and link the forms/reports to the back end DB?
View 7 Replies
View Related
