Need A Bit Of Help With The Final Details

Jul 6, 2005

I am almost finished this project. :p There are just a few things left that I would like to do and I need some help.

1. Add an email notification when data on the form has been edited
2. Filter the form for only OPEN orders, status not equal to 6 or 7
3. When an order is closed (status field) I would like to default the "Date Closed" to today, but allow the user to edit the date if need be.
4. Once the status is closed and the date closed is entered, ask the user if they would like to create a followup order.

I have most of #4 done. I added code on the After Update event on the Status field to set the Date Closed to today and then disable the control, then ask if they would like to create the followup order. The users would like to be able to modify the date closed if they don't happen to do the entry until the next day. I have tried adding my code to the After Update of the date (which is updated with a pop up calendar), but once I select the date from the calendar, the focus stays on the date and the user is not prompted to create the followup order.

Any help you can offer would be wonderful

Thanks
Pat

View Replies


ADVERTISEMENT

Default Value For Final User

Jul 19, 2006

Hi I have tried to look, but have not find the solution:confused:

I have a form wich I need in certain fields to have a default value, and this needs to be changed from the final user, I was thinking about taking the data from the previous input, the final user will use the control panel were there is a "push button" to open the form in add mode.
Can I get some help:D

View 4 Replies View Related

Security Falling At The Final Hurdle!

Jun 28, 2005

Hi, I have implemented security using a workgroup file as I have done so in the past and everything seemed to go ok except that I can still access my DB without logging in to it?

Obviously this hints that I have left some permissions on the "Admin" user somewhere but i've poured over it for the best part of an hour now and I can't find where it is. Here is my checklist, can anyone else add anything that I need to try?

All "Users" group permissions are disabled
All "Admins" group permissions are enabled

User "TKnight" belongs to groups "Users" and "Admins"
User "admin" belongs to group "Users"

I have checked all the objects ownerships and they all say "TKnight"

Now here's the bit I don't get. If I log in as user "Admin" with the password I specified using a shortcut pointing to the .mdw file I get the message "You do not have the necessary permissions etc..."
But if I try to open the DB without using the shortcut it lets me in fine and when I check the account it says i'm logged in as "Admin"
Does anyone have any idea why this is happening...

Many thanks,

Tom.

View 8 Replies View Related

Backup And Restore For Final User

Aug 23, 2006

Hi I have had a look on the forum but cannot find what I am looking for!!
I need to back up all the contents of the tables of a database in a certain folder and then restore it. The reason for all this is to be able to update the database with new features so that the final user can receive the update and restore the data.
How can I achieve this???
M

View 4 Replies View Related

Display Problems With Final Access

Aug 26, 2006

I made my Access program and it looks great on my computer.
Why does it look all missed aligned and wacky on other computers ?
These computers are not on a network...
I burned the access program to a cd and then loaded it on their
machines...we all have access 2003

thanks

View 5 Replies View Related

Access 12 Beta1 And 2007 Final

Dec 8, 2006

I have a problem in making reports in access 2007 final.
I can't add related fields into my report.

I found this page here: http://209.85.135.104/search?q=cache:6mrmlLqrTu8J:office.microsoft.com/en-us/access/HA101078151033.aspx+access+2007+report+field+avail able+in+related+tables&hl=en&ct=clnk&cd=1

That says: If you have set the form or report's Record Source property to a saved query, the Field List pane displays only the Fields available for this view section (there is no Show all tables option at the bottom of the Field List pane). To edit the record source, right-click any one of the fields, and then click Edit Record Source.

What does that mean????

Here are my screenshots with the same database:
Office beta 1 report making in design view

http://www.rbstudija.com/access1.png

Office 2007 final report making in design view

http://www.rbstudija.com/access2.png

Note the "fields available in related tables" where is it in final version!!!

View 14 Replies View Related

Queries :: Pulling TOP DISTINCT Rows In Final Query

Jun 7, 2013

I've got two nested queries. One finds the oldest inspections from an import table, the second compares that query to the main table again and pulls all 'expired' inspections for each Service Order in the first.

These queries are trimmed down for the essential elements of my question. I can post the full SQL if necessary.

queryDoTheseFirst:

Code:
SELECT TOP 18 ImportTemp.[SO ID], ImportTemp.[Inspection Activity],
[Activity Created]+[AddDays] AS [Due Date]
FROM [Priority List] INNER JOIN (ImportTemp INNER JOIN
queryNeededFirst ON (ImportTemp.[SO ID] = queryNeededFirst.[SO ID])
ON [Priority List].Activity = ImportTemp.[Inspection Activity]

[Code] ....

The refinement I would like to make is, rather than having to pull TOP 18 activities in the final query, just pull TOP 12 [SO ID]s and however many activities come along with them (usually 1 or 2, averages out to about 1.5 so 18 is my compromise). In theory an inspector could have two inspections due on every single property, and would only get 9 unique addresses/[SO ID]s. But I can't figure out how to do that when [SO ID] is no longer unique in the second query.

I suppose I could 'number' the rows in the subquery and add a <=12 criteria on that calculated field, but I'm leery of the processing required (that table contains ~14,000 rows, and most methods of numbering seem to want to use DCount).

View 2 Replies View Related

How To Judge Final Layout In Design And Form View

Nov 2, 2014

How can I see what they will finally look like while I am formatting them? All the views on offer (form/layout/design) are all displays within the the context of the access programing screens, with other windows and menus and ribbons etc. I want to see how it will look full screen. I know I can change a lot of options, change to the form as a default to open with, resave, reopen and then reverse it all but that's not really any good for doing every time you make a minor change.

View 14 Replies View Related

Modules & VBA :: Sorting Out Data To Be Used In Final Table - Runtime Error 3021

Nov 25, 2014

I have managed to sort out the data to be used in the final table. However, I am having trouble transferring the data from each of their own tables into the final table.

Each time I run my code I receive "run-time error 3021: No current record."

It seems that only my timestamp is being added properly, but the error pops up and highlights the first "rstInsert.Edit" of my code. I'm suspecting that my function is running too fast, such that it did not have time to read that the table has already been populated by the timestamp in the AddNew code

Code:
Private Sub Command9_Click()
Dim dbs As DAO.Database
Dim rstTimestamp As DAO.Recordset
Dim rstAcknowledgement As DAO.Recordset
Dim rstAgent As DAO.Recordset

[Code] ....

View 1 Replies View Related

Calculate Final Date Based On Begin Date And Number Of Days

Jun 30, 2015

I need to calculate the final date based on the begin date and the number of days.

The name of the fields are: sdatainicio; diasatribuidos; sdatafim.

View 7 Replies View Related

Order Details

Nov 7, 2005

Hi Folks,

I'm working on an order management database for a small company and have an order details form which I hoped to list each product of the order. As each customer has a different price per product I have a combo (based on a query) to choose the product and display the unit price (working fine) - the quantity and product ID are also input on the form and stored in the order details table (un-tested). My problem is on the first line of the order you choose the product and it and relevant details are shown, however, on line two, three etc when you choose the product - the other lines change to this too. How do I fix this???

Many Thanks in advance for help given!!

Mary

View 6 Replies View Related

SQL Error Details

Oct 8, 2004

I have extensive experience of other SQL databases but, in Access I don't know how to access the SQLCODE (as it would be in other DBMSs) to see if my query worked and if it did then how many rows were updated.

Anyone speak my language?

View 4 Replies View Related

Details And Detail Groups

Nov 16, 2006

Hello!

I have a problem figuring out a solution for following problem.

I have a database of details and their properties.
All the details have been described in one table.
As there is a need to describe groups of details I have found myself in a hard situation that needs to be resolved.
The structure of described detail groups is as follows:

Product

Detail Group1


Detail groupx etc.

Detail4

Detail groupx etc.
Detail groupx etc.




Detail1
Detail2
Detail3

Detail Group2

Detailx
Detailx


Detail groupx etc.


Detail groupx etc.





Is there a way of decribing my products in access so that there are no limits of how many groups does a product have and how many levels of groups the product have.

Thank you

View 1 Replies View Related

Update A Table With Details From Another

Apr 15, 2008

Hi,

I have not used Access for over 10 years! I am using Access 2000 to look at tracking cow weight over time!

There are 2 tables:
- main table
- weight table

I want to set the main table's January weight to a value from the Animal weight table (logical expression):

UPDATE [main table]
SET [main table].Jan07 = [Animal weight].[Kg]
WHERE [main table].[Line no])=[Animal Weight].[Line no] AND
[Animal weight].[weigh date]= 10/01/2007;

I have tried several times to get this working, but it tends to prompt for the weight to be given as an input.

Any ideas?

many thanks

Lactaman

View 4 Replies View Related

Handling Address Details

Apr 25, 2006

Hi All,
I am rather new to this and I must admit I am getting everything completely wrapped around my head!

I am developing a database that stores technical support requests received and their solutions. I have three main tables :

Problem - stores all the details of the problems received

Client - stores the address details of the client which is then associated with the 'Problem' table

Company - stores the name of the company which is then associated with the 'Client' table. This is a separate table as different clients can work for the same company.

At present, I have a 'problem data entry' form in which I enter all the details of the problem. At the top there is a section where I can do a search for a particular client and company and the details appear in the respective text boxs on the 'problem data entry' form. If the client does not exist, I have a button that I use to open another form which allows the entry of the new client's details ('New Client'). The user can choose which company this client works for by using a combobox. If the company is not already in the database, I have another button for opening a 'New Company' form!

Its all a little convoluted and it does not work particularly well to be honest. When I add a new company, I need to move forward a record and then back in the 'New Company' form in order that the new company information is saved correctly.

The company selection combobox in the form 'New Client' is then updated with the new company name BUT I need to actually open the combobox and select the company name myself for it to work properly! Once again I also need to move forward one record and then back again in order to properly save all the information before I can close the form.

What would be nice is to do a search for the the company in the combobox on the 'New Client' form, if the company is not found, it automatically adds the company to the database whilst updating all the necessary links. Hence getting rid of the 'New Company' form. I would also like to get rid of the problem of having to move forwards a record and then back again.

Any ideas? I find my method to be rather poor, there must be a simpler way of doing this!

Many Thanks,
Lee

View 1 Replies View Related

Multiple Details Sections?

Jan 29, 2007

Hello,

I have not used access that much, but what I am looking to do is basically have 2 details sections within a report that will have different records in them.

I first used a subreport but that really did not work as intended. It left large gaps in between the records and just plain didnt work.

Here is a image of what I am trying to achieve:
hxxp://img379.imageshack.us/img379/9471/accesshelpnx9.gif

As you can see theres two different sections. One is for regular campaigns and one is for extended campains. There is a field in the table that has the extended date. For the compaigns that field should be blank or null and for the extended campaigns it is not blank or null.

Is there anyway to achieve this in Access 2003, if so can you tell me or describe me the steps?

Thank you!

View 1 Replies View Related

Details About The Girl Scout Database

Nov 22, 2005

Basically, our goal is to create a database that contains the information of previous girl scout info, just in case they decide to return, and also to have drop-down boxes in the form so when you select a returning girl scout, their info is already in the system and all the fields will be automatically filled with the info. i have thge link to the database once again

https://s38.yousendit.com/d.aspx?id=0TV74WKE03KN8194HDI0C7V2Z6

View 3 Replies View Related

Viewing A New Form With More Details Of A Record

Nov 27, 2006

I have got a form with summarised data (of records) on view for people to look at. (this is a continuous form). For each record I would like to have a button that displayed another form with more details on it. So by pressing the button opposite a particular record it would take the Id value of the record and open another form (with more details) at that particular record.

I would be very interested in seeing this done with a macro if possible but beggers can't be choosers!

View 4 Replies View Related

Button Captions And Details From Table

Sep 18, 2007

Hi There

I am wandering if anyone has a solution to this problem i has basically have 2 tables 1 called departments, with the fields: Dep No, Dep Name, then i have another table called Items, with the fields: Item No. Item Name, Item Price, Department.

What i want to do is create say 10 command buttons and create an array of them i know sort of how to do it in visual basic and all the 10 command buttons name is the same and an aray is created but i dont know how to do it in access i know that it doesnt let you create an array but i have seen it done somehow in a project that i came across.

so basically what i would want to have done is on the form load the 10 department buttons captions are loaded from the table departments and when a department button is clicked its is linked to items where i ahve created say 20 command buttons called items.

I dont know it it makes sense what i have written but any help on this matter would be very apreciated it pr if anyone knows of any examples as i have been stuck on it a while

Many Thanks

View 6 Replies View Related

Update Contact Details Automatically

Nov 20, 2007

Dear all, please excuse the fact that this is not an explicit problem I have, but more of a general query.

I have an Access database (2003) with a load of contact details in it. Including various fields for each contact, such as their email, services they offer, where they are, main contact name etc.

Some of these contact details will be out of date and I want to make sure that all the contact details are up-to-date.

I am in the process of setting up a mail merge with a Word document which will output to Word their relevant details, and this can then be e-mailed to each of the contacts with them to update and e-mail back again. Someone would then manually update each of the contact details.

This is quite a time intensive way of doing it, and I wondered is there a way of automating the process? I don't have the time to put the whole of their details on a website so they can update it over the web, but is there a way that access could possibly read the return Word document to automate updating their details? Or is there another easier way of doing it, without using word and using something else such as Excel or something.

If anyone has any experience in doing this kind of thing I would be really glad of some tips.

Many thanks

View 9 Replies View Related

Use Previous Fields Record Details

Jan 7, 2008

Dear Guru's,
Happy New Year 2008.

:confused:

I have a task of implementing a fleet fuel consumption. I have made a form where user logs in previous odometer and current odometer reading. I have been challenged to make the system to automatically use previous odometer reading next refuelling. Please assist.

Joseph Njoroge

View 6 Replies View Related

How To Show Only The Current Forms Details!!

Jun 9, 2007

Hi i hope someone can help. :)

I have created a databse with three tables that are linked (customers, quotes and invoices). I have my main form (customers) with two sub forms (quotes and invoices).

Is it possible to create a query to show the data just from the current form that i am viewing?

I would appreciate if you could help.

View 2 Replies View Related

How Do I Use Submit Button To Add Details To A Table?

Jan 10, 2006

Hi everyone, I am new to this so bear with me.

I currently have a form with textboxes and 2 combo boxes. I have a submit button at the bottom of the page and would like this to take all the infomation from the form and add to a master table.

I was hoping to be able to create a pop up message to say "This item has been added to the database"

Can anyone help point me in the right direction?

Many Thanks!

View 1 Replies View Related

How Do I Use Submit Button To Add Details To A Table?

Jan 10, 2006

Hi everyone, I am new to this so bear with me.

I currently have a form with textboxes and 2 combo boxes. I have a submit button at the bottom of the page and would like this to take all the infomation from the form and add to a master table.

I was hoping to be able to create a pop up message to say "This item has been added to the database"

Can anyone help point me in the right direction?

Many Thanks!

View 6 Replies View Related

Including Details From Query Calculation

Aug 1, 2006

Part of a database I'm developing stores details of events. Each event is funded from a variety of different sources.

There are three tables involved in making this work:
tblEvents - which stores the main event details
tblFundingOptions - which stores all the possible funding sources
tblEventFunding - which links the two together.

I have created a form to access all of this, with the information from tblEvents at the top and the Funding details on a subform.

I have created a query based on tblEventFunding which adds up the total amount of funding allocated to each event. I want to display this total on the form I've developed.

Can I do this without creating a second subform to pull the details in from the Query? I've tried creating a text box and linking it to the appropriate query, but it just displays #Name! - presumably because it doesn't know which record from the Query it should display, and I don't know how to tell it!!

Is what I'm trying to do possible, or do I need another subform?

Many thank in advance,

Gary

View 1 Replies View Related

Invoice Details Complex Issue I Think

Dec 7, 2006

Hello,

I have an invoice form where ofcourse I have a invoice detail subform, I got everything working fine so far, but now I need to do an update to this form and I dont know how to do this.

I have the following tables on my DB:

Clients
Products
Departments
Invoices
Invoice_Detail

Now each product will belong to a department, let say 1" PVC Tube belongs to the Department Pluming.

This is what I need to do, I open the invoice form enter all the invoice information, than I goto the invoice details, there is the tricky part, I want to select from a combo box the department of the product I will sell, once I selelct the department I want to selelct the product... The problems is that I only want to be able to see the products that belong to that department I picked.

How can I do that?


thanks if there is any example db will be great...

Daniboy

View 8 Replies View Related







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