Access Continues Forms
Jul 26, 2005
Hello from Greece.
I have a little problem. Let's say I have a Tubular (Continues) Form with these Textboxes (assigned to fields in a Table Customers) :
SerialNo Name Date_Of_Birth Value
1 Theodore 9/12/76 5
2 Theodore 9/5/70 6
3 John 4/4/90 3
4 Maria 7/4/90 2
5 Anna 12/5/05 3
Then I apply filters (By right clicking and filter by selection). Let's say multiple filters for Name and Date_Of_Birth.
Is there any possible way, after the filtering, to have the Sum of the Value of each record (filtered Continues form) in a seperate textbox?
Thank a lot ...
View Replies
ADVERTISEMENT
Jul 29, 2013
Form info
1st Form Name: Mainform
Text to enter employee ID : empid
Sub form within Mainform: SFTimesheet (continues form)
text to enter: Timein, Break, Timeout
SFTimesheet shows and accept entries for each employee called using the text empid, on the mainform
I wanted the subform to show 7 days /lines starting from Sunday to Saturday of current week and dating the text "Timein" accordingly. When employee enteres an entry on the 7th Line, it should give them a new 7 lines for the new week to begin.
View 5 Replies
View Related
Nov 9, 2005
My table has been corrupting every week and there is only 2-3 people using it on a consistent basis. It will work fine to add new records for a couple of days then they will receive the "duplicate record" error message and it is trying to assign an autonumber that is already being used in the table.
It seems to be picking a random record to restart the autonumber with. I tested it by trying to add a record-it would assign id# 1068 (which is already used) I would get the error, get out, go back into the table and add another record and it would try to assign it #1069 and so on. When it got to a number that wasn't in the table #1071, it would allow the record then. It continues to go through this process, error-ing on id#1072. The record it starts with doesn't seem to have any bad data.
Does anyone know what would cause this to keep happening? I do have another table that ties the id #'s to this first table. When I move records from the first table into another one, or delete them completely, I haven't been removing the data from the second table. Could this cause a problem?
I would appreciate any help with this. I'm am currently working to get a SQL backend done in hopes this will solve these corruption issues.
Thanks,
Toni
View 3 Replies
View Related
Aug 15, 2014
I had to put a breakpoint into my VBA code in one of my apps to debug a problem I was having and inspect the variable values. All was well until I finished the debugging process and tried to eliminate my breakpoints. However, the next time I ran the application, the code stopped as if one of the breakpoints was still active. I closed the application and reopened it (even rebooted the computer) and the code continues to stop in the same spot in the program. The only thing I can think of to do is to create a new empty Access database and import all the objects from the old one. I'm thinking the database must be corrupt and this is all I know to try.
View 3 Replies
View Related
Sep 22, 2004
PROCESS AS DESIGNED: The user logs in and is given a form displaying existing records that are coded (by userid) for that user to update. From that list, the user selects a record and continues to a second form (the first form closes) which displays all the fields of the selected record which should/can be edited by the user (plus a few non-editable key fields). There is nothing tricky to how the records are selected for display. A simple query behind the first form selects data records using the userID number. The second form does a simple record select using the active record ID number on the first form. Nothing tricky -- no modules just queries, tables, forms and simple macros to string it all together.
The user can open/close these two forms as often as necessary and the record will continue to show up until a value is entered into a "completion date" field. When that field is no longer blank, the record will no longer be displayed for use.
PROBLEM: About 90% of the time, things work as expected. But 10-15% of the time, somewhere between opening the record in the second form and closing the second form, the edited record totally disappears (as if it were never opened, it isn't even system date stamped) and the input information is inserted instead into a brand new record.
Users can sometimes tell when the edit record is dropped during processing, because key fields displaying previously entered data go blank and the displayed recordID (autonumber) is changed. p>
ERROR PATTERN: NONE! It can happen as the edit record is first opening, in the middle of editing the form, or at the end when closing the form. It will happen on a specific PC 2 times in a row and the third time be fine. It has happened at multiple locations but not for all people and not consistently for the same person/same pc. The same record that failed can be re-selected and work just fine the next time.
I cannot reproduce the error myself. I have tested everything I can think of without causing the error. I can lose changes and avoid a system date stamp if I abort my Access sesssion, but that doesn't create/insert a new record with my new input. It just loses everything.
I have wondered if a momentary break in the network/communications could break the connection to the application to just enough that the form remains on the screen, but selected record is discarded. Input into the empty form would/does insert a new record.
I have asked the IT Operations group to investigate if a network/communication problem could be the culprit, but they haven't gotten far on this. I have never seen this happen before and am totally stumped but am desperate to resolve it before user confidence is damaged.
View 1 Replies
View Related
Dec 29, 2014
I have a table and a form. I need to input data in the form and click on a button to add this data into the existing table.
This is part of a bigger application which will be compiled and given away for use.
tblProduct
id = autonumber
name = text
InHand = integer
Price = float
frmNew
txtname = textbox
txtInhand = textbox
txtPrice = textbox.
I need to coy frmNew.txtname into tblProduct.name and so forth.
View 9 Replies
View Related
Oct 24, 2013
I've been using the following code successfully in Access 2003 & now I need to migrate to Access 2010. The purpose of the code is to use the items that the user selects in the list box to build the criteria of a query. Access 2010 keeps giving me a syntax error when I try to run the query & I don't know why:
My code is:
On Error GoTo Err_Command151_Click
' Declare variables
Dim db As DAO.Database
Dim qdf As DAO.QueryDef
Dim varItem As Variant
Dim strCriteria As String
Dim strSQL As String
[Code] .....
The syntax error I get in Access 2010 is:
Syntax Error in query expression 'SELECT * FROM
qryContractListSummarybyDateContract3TYPEBREAK WHERE
qryContractListSummarybyDateContract3TYPEBREAK.Rep ortableName IN('Adbri
Masonry NSW');'
View 12 Replies
View Related
Jul 23, 2014
Can I for instance while my db is open, open it in design mode from my form via code?
View 3 Replies
View Related
Sep 5, 2014
Where can I find the Hex or RGB value for the blue colour that Access 2010 uses by default for buttons on forms? I need to change some buttons to yellow (I know the code for that) but later change them back to the previous shade of blue, which is shown in the Properties pane "Accent 1, Lighter 40%".
By clicking in the standard colors area at the bottom of the colour chooser I can find a very similar blue #D6DFEC but it doesn't look quite right. And the "accent" colour does not give me a Hex value.Is that "usual" blue even one colour? How can I reset a button to that style having changed it?
View 14 Replies
View Related
Dec 26, 2014
I am creating a simple data entry form wherein the user will enter the product id and on change the product description and retail price must be displayed.
When the order quantity is entered, the total cost need to be calculated. I am able to do this using DLookUp and simple multiplication.
However, after doing the above, I need another row to appear so that I can accomplish the same for another product.
View 2 Replies
View Related
Dec 8, 2014
I am developing a small database for use in a multi-user environment: I have split the tables off and am testing with two copies of the front-end on different machines. All seems to work well except on one form.
On this form, the value of a bound control (exposed as a number of radio buttons) is used to make related controls on the form visible or invisible. I use the AfterUpdate event to trigger appropriate VBA code to accomplish this; it works well.
However if two users have the same form open at the same record (unlikely, but not impossible), and User A changes the value of the control via the radio buttons, Access will eventually propagate the change to User B's copy of the form but the AfterUpdate event will not be triggered and the form becomes inconsistent. I understand that events are only triggered when a user makes a change to a control; how can I be alerted when Access makes a change?
View 4 Replies
View Related
Nov 26, 2013
Two forms have matching fields (ContractID), and each form has different data displayed from different tables (SQL views, actually).
I want Access 2007 to stay on the same ContractID when the user switches to a different form.
View 4 Replies
View Related
Apr 13, 2013
I have an access form with tab control pages each with embedded forms.In one page I have a list of records as a datasheet form with the record identifier field configured as a hyperlink. When I click on this it passes its value to a form field in the form in the following tab page (works without the hyperlink but its a useful way of highlighting which field to click) which is a display/edit form of the details of the individual record. The Subroutine which does this sets the focus on this field it is passing the value to on the other form and the 'On Got Focus' event in that triggers the query that fills the editor form.
When I click back on the following tab to select another record to view/edit, the identifier value of the other record is passed to the other form but the data displayed in the rest form doesn't change. I understand this is because the field with the 'On Got Focus' never lost focus and so the query function was not called. To correct this I tried adding the same function call to the 'On Change' event however this does not work (the field is a text box set to 'locked' if that is relevant).I can get the form to do a new query properly if I click on a different field in the form before going back to the list tab or (as this is removing the focus allowing the On Got Focus to work again) if I click on a button to select a different record (which just takes me back to the list form).
Is there any way I can get this to work without having to manually remove the focus from the problem field? I have tried setting its On Got Focus event to move the focus to another field after the query function call however this prevents the Setfocus line in the code in the previous form from working. Here is a snippet of my code below.This code is for the list form and passes a value to the editing form:
Private Sub SalesID_Click()
Forms!Mainform.Requery
Forms!Mainform!Sales_Admin_Form!Sales_Admin_SalesI D.Value = SalesID.Value
Forms!Mainform!Sales_Admin_Form.SetFocus
Forms!Mainform!Sales_Admin_Form!Sales_Admin_SalesI D.SetFocus
[code]....
View 1 Replies
View Related
Dec 11, 2013
Is there a way to auto number a report form.
I have attached my database for a better understanding of what I am trying to do.
View 2 Replies
View Related
Sep 5, 2014
Is there any way to list a combo box with all the forms of an Access Database?
View 5 Replies
View Related
Jul 19, 2015
I am doing an assignment and I am stuck at this validation rule. So in my database I 've got one table named horse and the rules I am supposed to set are these two：
1：A horse cannot be added that does not already have a Dam and Sire existing in the database unless either or both are not known.
2：A horse must not be deleted if it is the Sire or Dam of an existing horse.
I guess I am supposed to create a data entry form for table horse and apply these two rules in the form, but what should I do to achieve that? Seems a bit complicated cause the entering need to check some other fields (sire and dam) in the table..
My table looks like this
Horse_id Name Colour Sire Dam Born Died Gender
101 Flash white 201 301 2001 0 S
102 Star brown 201 302 2002 0 M
201 boxer grey 401 501 1991 0 S
301 Daisy white 401 502 1992 0 M
I know it might seem too simple to you but I am a full-time worker doing this online course. The consulting resouce for me and the time are both quite limited.
View 2 Replies
View Related
Nov 20, 2014
I have a Main (Home) form that has a sub navigation form (frmNavigationSubform).Need to access 3 forms. Forms 1,2 and 3. Also, have 1 options form.
Subform has 2 Navigation buttons. NavigationButton2 and NavigationButton3.
NavigationButton 2 Navigation Target Name = 1 (frm #1).
NavigationButton 3 has no Navigation Target Name. This is passed on when user picks Option1 or Option2 form options pop screen.
Now I can pass the name to the Navigation Buttons2 but the subform does not show it. I have to click on the Navigation Buttons2 again for it to show. What I want is when the user makes the choice in the options screen the name is passed and form 2 or 3 should load/show.
View 1 Replies
View Related
Aug 17, 2005
I use a MS Access database in a medical/diagnostic type business. I would like to give our clients access (password locked or something to prevent people from viewing others' info) web access.
The problem is I dont know ANYTHING about doing this.
Can someone please point me in the right direction, even a list of articles or something on how to get started?
Many, many thanks for any help
mfpoore
View 1 Replies
View Related
Jul 23, 2006
im creating a database for a team that run courses. someone else started the database but never finished it. I have 2 tables which i will refer to as Contacts & Training Courses. I also have a form that displays the information from the Contacts Table. All the information that is being displayed on the form is showing up in text boxes. I want to now add a drop down list box in the form so when its on a particular record showing the information about that contact it will also show me a list of what training courses they run. Both the contacts table and the training table have a Company ID field and the numbers for them are the same in both table.
I have tried using a query but its not working and all i get so far is the contacts showing up and the courses ID repeated several times.
I hope someone can help me
phill
View 1 Replies
View Related
Feb 22, 2007
I have created some forms on a 15" wide screen monitor. When I look at these forms on a 19" monitor the forms are out of position.
How do I solve this
View 2 Replies
View Related
Sep 6, 2005
Hello!
I would like to convert existing MS Access forms to an internal Delphi application.
Any information about the fomat of representing forms in the Access database and the method of reading/parsing the forms would be appreciated.
Also, I wonder if it's possible to read the forms without using Window's technologies (ADO, etc)?
Thanks in advance!
View 4 Replies
View Related
Jan 2, 2006
Hi,
I was given a set of mdb files where the access forms were linked to SQL server tables. How do I find out the name of the SQL database the forms are linked to?
thanks
View 6 Replies
View Related
Jun 19, 2006
Please help!!
I am creating a program that will allow the user to select a sale and pull up only those product items associated to that sale in the details. Any help would be appreciated. Then with in the details section the user will/should be able to enter in the Quantity needed to order. Any suggestions on how to do this. My tblSale does provide the data needed so how do I get the data to go to the form?
I am new to this forum so if I have not asked properly I apologise now.
The Database is attached. Form Orders is the form that I am using to accomplish my task. The getproducts4Sale Query is the information needed.
View 2 Replies
View Related
Aug 16, 2006
hello all ! here is a new challenge.
I have an application in access 2k, where i am hidden access environment using code. Because i am hidding access environment the popup and mode properties are in YES.
Situation:
i have a form with a combo list, where i can select a report, 1 button to view the report , another button to print the report and another button to close the form.
Once the user has selected the report and pressed the view button the following code runs:
DoCmd.OpenReport "reportname", acViewPreview, acWindowNormal
if the user pressed print the following code runs:
DoCmd.OpenReport "reportname", acNormal
Problem:
When a user wants to view a report nothing happens. the report is not open.
do any of you have an idea?
i am attaching 2 db. One where you can see the problem with hidding environment (wine_NOcode). The second db without hidding it (wine_code).
the pwd is 1.
thx very much, Max.
View 2 Replies
View Related
Aug 23, 2006
I have impletemented a user system for my database with different access levels relating to entering and editing data.
I would like to make certain forms only accessible to a specific group of users. Is this possible and how?
Thanks,
Gary
View 1 Replies
View Related
Jan 5, 2005
Was wondering is there a way I could have a button that would give me direct access to a specific form. example. I have design a form for my Ranch and was wondering instead of me clicking on form than add cattle. Is there was a way i could have a button on my database that would when i first open it to automaticly take me to that form.
thanks
Roger
View 4 Replies
View Related
