Relationships Are Not Being Saved!!!
Mar 10, 2006
Hi guys, I have included 2 screen-shots. Basically, my relationships are not getting saved. The relationships still function fine, like my Lookup fields are working normally etc. Its just they are not visually being saved in access, take a look...
This is me saving a simple relationship between 2 tables:
This is me opening up the relationships window again, only to find that there is nothing there:
PLEASE HELP - this is time-critical (as updating any remote database is)
View Replies
ADVERTISEMENT
Oct 30, 2005
When the user press 'tab' key the record is being saved. I would like to prevent it and enble record saving only when 'save' button is presed
View 4 Replies
View Related
Oct 30, 2006
I am a school nurse. I have started to keep a record of office visits of all the kids that come to my office in a MS Access database. I have a table that I use for logging in each student, time, date, reason for visit, action taken, etc. along with a lot of other info on other tables and queries. I'm wondering how to keep the data entered on the health office log from being altered once entered. Is there a way to do this in Access? Thanks
View 7 Replies
View Related
Aug 29, 2006
I have just had a very frustrating morning. Recently upgraded to MS Access 2003. started having a strange problem, MS Access kept notifying me a another user was using the access database I was in. I switched off and rebooted, still the same..... ?
Read a bit on the Internet, checked my settings, made sure I was exclusive user, made sure user was set to owner, Rebooted, still the same.
I noticed that occasionally the *.ldb file would suddenly appear when I've tried to move or copy a database in explorer from one folder to another? Something was shadowing me, something was recording when I was using an MS Access database.
I checked to see if I had inadvertently added any strange Add-in's, none Listed. I checked visual source safe, I haven't set that up yet it's not doing anything.
Then I remembered! I had installed MS Access crawler which works with Google desktop to record where your MS Access files are. I uninstalled access crawler and I have not had any problems since.
View 1 Replies
View Related
Mar 20, 2008
Hi there.
I downloaded a demo database (attached, Expiry 200 ) witch allows me to distribute my databases in demo mode with the option of registering a full copy.
this works a treat so far. :)
but now i want to modify the code but i cant work out were the values in the frmsetexpiry are saved to (the registry maybe?) IE: max number of times, company name etc.
any help will be much appreciated with this
thanks
rob
View 12 Replies
View Related
Jun 8, 2005
Hi
Can anybody tell me how do I delete saved queries from vb code.
Thanks
Amar
View 1 Replies
View Related
Sep 8, 2005
Hi all,
I've got a subform, fed by a query which contains a lot of calculated fields. All the calculations use the contents of a field on the main form.
What i want to do is have a live update, so that if i change the value of the field on the main form, the subform is requeried and the fields recalculated using the new value.
I've put a subform requery on the On Change event, but the requeried fields are coming out the same, presumably because the new value i have put in is not saved until i change record.
I'm using the control name in my calculations, and yet it's still picking up the old (saved) value from the underlying table - is there no way to tell Access to look at what resides in the control right now?
El.
View 4 Replies
View Related
Oct 21, 2005
Gurus,
I seriously need some help with the following.
What I need to do is when I enter the data in the form and before I go to the next record I want to save this row in the table and then insert two more rows with the same values (that I just entered and saved in the table) while incrementing the index field. I also want to programatically manipulate a field value in the second and third rows that I will insert before commiting.
For Example:
Tbl-A
Reg_Num Number (Index)
Name Text (30)
Reg_Type Text (1)
Category Text (10)
Sub_Category Text (10)
Short_Desc Text (10)
Long_Desc Text (50)
1st row:
10001, "PSUS", "A","CREDIT CARD", "FEE", "CCF", "CREDIT CARD FEE"
After I enter these values I click on "SAVE" button. When I click on save, I want to insert the same row twice (notice Reg_Num and Reg_Type values) in the table and increment Reg_Num and change the value of Reg_Type.
2nd row:
40001, "PSUS", "W","CREDIT CARD", "FEE", "CCF", "CREDIT CARD FEE"
3rd row:
60001, "PSUS", "X","CREDIT CARD", "FEE", "CCF", "CREDIT CARD FEE"
As you see, I am incrementing the index field value by 30,000 if Reg_Type is "W" and by 50,000 if the Reg_Type is "X". What it means is copy the row that I just entered, insert it in the table, change the Reg_Type value and increment Reg_Num based on the business rule. COMMIT. Do the same for the next row.
I have about 20 Fields in the table. I do not want the user to type 10 times the same values and make mistakes. This is just an example. I have about 8 different Reg_Types that needs to be stored in the table everytime a new Reg_Num is entered with Type "A". User can enter any Reg_Type but to make my life easier I'm restricting to start from Reg_Type "A". For each Reg_Type the Reg_Num needs to be computed because it is extreamly important in our application.
Hope I explained it right.
Thanks a million in advance.
PS
View 3 Replies
View Related
Feb 25, 2006
Hi can anyone help please!
I'm writing a course registration Db. I have a have 3 tables at the moment tblContacts [ContactID], [FName], [SName], [Etc..] tblCourseRegistration[RegID] [ContactID][CourseID] and
tblCourses[CourseID] [CourseName] [Etc...]
These are all linked on a tabbed form. I have found that the same Contact can sign up for the same course twice. I need to stop this happening. Is there an easy way to prevent this or do I have to write a query that runs before the save command to prevent this?
Thanks in advance person with sore head!
View 7 Replies
View Related
Jul 28, 2004
I need to know how to send an email to myself when someone adds a new record
to my database. If someone can help me it would be greatly appreciated.
Amanda
View 8 Replies
View Related
Feb 11, 2014
I'm trying to set up a saved import, but keep getting the following error message: "You cannot record your changes because a value entered violates the settings defined for this table or list (for example, a value is less than the minimum or greater than the maximum). Correct the error and try again"
There are a couple hundred fields, and they are all set to text. Is there a way to figure out where the problem is occurring without going through all fields?
View 5 Replies
View Related
Jan 20, 2006
I have a split database (A2000) on a server; many people use the database at many different terminals. I would like to save the computers identification to the record being created. Any ideas on how to accomplish this?
Thanks
gMAC
View 2 Replies
View Related
Aug 4, 2006
I am new to MS Access, when I am making any calculation using some expression, then I have to save the result to table, it is not saved. Please anyone suggest the solution for my problem..... and mail at rupedhiman@gmail.com.
Rupinder
View 1 Replies
View Related
Sep 4, 2006
What i want to do is if a user forgets to put lets say Address or Zip
Will not allow user to save record but instead will highlight the text boxs
that are required. Once data is put in will allow user to save record.
Any ideas
View 1 Replies
View Related
May 21, 2013
Is there any way to view a Saved Import to see what it is doing?
I just inherited a database from someone that has several saved imports. I need to be able to see where the data is coming from and where it is going to so that I can recreate it using VBA.
View 3 Replies
View Related
Oct 8, 2014
The user wants to be able to click a product desription in an access table, and a picture of the product pops up. is this possible and if not, what is best way to implement this functionality?
View 2 Replies
View Related
Jul 15, 2014
I have a Multi user Access Database which has been split into a Front and Back end. What I am noticing is sometimes when the user enters data into the Front end form, it is not being saved in the Backend tables....
How to confirm when the user clicks save that the data is actually being saved in the backend tables.
View 10 Replies
View Related
Sep 19, 2013
When using Access 2007, I have a new record button, but that record is only written to the db once you navigate away from it. How do I write immediately to the DB, so that record is saved without navigating away from it. I believe I can use ADO or DAO but I'm having difficulties.
Private Sub Command71_Click()
DoCmd.GoToRecord , , acNewRec
MaxValue = DMax("[Record Num]", "Joblog")
Text64.Value = MaxValue + 1
View 9 Replies
View Related
Aug 24, 2014
I have 2 Linked forms :
frmINVOICE
frmINSURANCE
Several of the fields in frmINVOICE are supposed to be repeated in frmINSURANCE, example Field name such as [Invoice No], [Invoice Date], [Description] etc. are identical in both forms.
My problem : After update of the fields frmINVOICE, the linked record will not update in frmINSURANCE.
I have manipulated by adding the below controls/commands to the field event and/or current form of both forms but nothing works :
- DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70
- Refresh macro
- Requery
- Me.Dirty = False
Nonetheless, I noticed following outcomes :
1) if I tap between the forms twice, the field record from frmINVOICE will be updated automatically in frmINSURANCE
2) when I close and open frmINSURANCE, no change occurs
3) after I manually save frmINVOICE, then the field record from frmINVOICE will be updated in frmINSURANCE
What should I do now ?
View 4 Replies
View Related
Sep 21, 2005
I have a multi-select list box that runs a "For intCounter" and builds a sting into a text box. That works fine the text box will populate as designed <"Closed" OR "On-Going">.
(I know that I should be dynamically creating the query in the first place ... normally I would ... but this is a quick fix that I want to get it into an existing application, while the redesign requirements are being written.)
Now I want to pass that string to a pre-existing query, but I'm not sure what to write in the criteria section.
I've tried...
Like "*" & [Forms]![ViewReports]![TextPickList] & "*"
IIf([Forms]![ViewReports]![TextPickList]="","",[Forms]![ViewReports]![TextPickList])
and just plain old ...
[Forms]![ViewReports]![TextPickList]
but my query is coming up blank. What do I need to write into the criteria section of this saved query?
thanks in advance!
View 2 Replies
View Related
Jul 26, 2005
Hi Experts,
I am beginner to Ms-access database. I want save value of A(5) - B(3) into C but, when i check the field C, i find 0 instead 2. Please advice me what i need to do to achive the exact value in field C.
Regards,
Saied
View 3 Replies
View Related
Apr 21, 2005
I have one more problem about the version 2000 since it was not happen in version 97. I have changed several report formats margin lots of times (for example .25" for left and right margin to fit on one page) and when I open the reports next time or other users access them from the server (since the application residing on the Novel server) the format keep changing back to the default (1" for all margins: top, bottom, left, right)!!
Please let me know if it is a "bug" in Access 2000 and HOW to fix it!!
Thanks much,
View 1 Replies
View Related
Sep 8, 2005
I am having problem to keep the desired format for reports' margin (left, right, top, bottom) and paper size (letter, legal), and orientation (portrait, landscape) stay!!
Currently, I have one MS Access 2000 database application resides on Novel Netware server version 6.0, [B]although I open the Access database exclusively to change all my reports design to the way I like, and SAVED them properly; however, later when I and other users view those reports, the formats change back to default view, which are "letter size, portrait and all margin set to 1")??
It is very STRANGE and FRUSTRATING and incovenient since all users have to manually go to "Page Setup" of the report's design everytime to change margins to make the data display nicely on one page!! It has never happened like this in version '97!
Plllease let me know if ANYBODY has any SOLUTIONS to this bug of version 2000 of Access?? Or any UPDATE file released to help get rid of it??
Thanks so much,
View 1 Replies
View Related
Jun 26, 2013
I am using MS Access 2010 to export data into MS Excel 2010 spreadsheets.
I am just wondering: Is there a way to set the Parameter value for the query via VBA?
For example: There are 10 regional managers. When I click a button on a form, 10 sets of data per manager are going to be exported into Excel spreadsheets.
I have created a saved query named [For exporting] with a parameter [Manager Name] for the field [Master Table].[Manager].
The VBA for the button has 2 subs:
1) Sub 1 for the loop for 10 managers
Code:
...
strQuery = "SELECT DISTINCT [Master Table].[Manager] FROM [Master Table] WHERE ((([Master Table].[Manager]) Is Not Null));"
Set rstStores = CurrentDb.OpenRecordset(strQuery)
[Code].....
View 10 Replies
View Related
Dec 8, 2012
i want to have a button where the operator can cancel when on a current record. i want an if. if form has changes made but not saved then undo else close.
is the record state 'dirty'?
View 2 Replies
View Related
Aug 8, 2013
I'm working on a "Product Details" form somewhat similar to form in northwind, which the record source in "Products" table. what i'm trying to do is after clicking "save and new" command button to go to new record in form, i would like all text boxes to automatically retrieve the value from last saved record set as default value.
after google searching this subject i found the LastModified Syntax but i just don't understand whether i use it in VB or marco, or even how to implicate this. Should I make macro on each txtbox or should i create module? if i have to create either macro or module.
View 5 Replies
View Related
