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)
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
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.
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
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?
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)
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.
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.
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?
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?
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
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.
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.
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.
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?
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.
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.
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
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?
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.
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!!
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??
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)
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.
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.
