Trying to do something here on a form. Very simple, but I don't know why it is not working.
Have a form, First input is a Job Number, this field is a primary key. When you tab to the next field it is not coming up with an error on duplication. I'm not sure why. I put in a Docmd.save on "after update, then lost focus..... But apparently it is not saving when you tab off of this field. Simple answer????????
I have have a form with 4 subforms in it, one of the subforms is based on a filtered query . For a reason I can not work out I cannot get it to requery when I add a new record.
To add a new record I select from a combo box and use a command button to save the record
I have tried using this in the buttons on click event
Code:
Forms.trialcatalogueF!TrialCompetitorsSF!competitorsSF.Form.Requery
with no result, however it does kinda work in the combo's after update event, just not until I select another value.
I have a form named CORRES_TYP with 3 text boxes and a list box. I also have a separate table with 3 field from where the information I put in the form was saved.
In my form whenever I put information on the textbox at hit add record button, these information are saved in my table and will reflect on the listbox on my form below the textboxes. Also if I select a record in the Listbox the record I selected will apprear on the corresponding textbox in the same form.
My problem is that I have been trying to create a command button that will save and change the existing record everytime I select an item in the list box and modify the information through the textbox. Here are some infromation about my table and form:
Table name = CORRES_TYP
Field 1 = CODE (Primary key, No Duplicates)
Field 2 = DESCRIPTION
Field 3 = FOLDER
Form name = CORRES_TYP
Textbox 1 = CODE
Textbox 2 = DESCRIPTION
Textbox 3 = FOLDER
Listbox name = LIST14
i'm using a form with an unbound text box to temporarily hold data that i want to use in several other places (all those functions work great). last step is to save the newly created table with a different name (will be used for a mail merge later so must be a separate table or else we'd have to filter thousands of records during each mail merge) and i want to use the data i've temporarily held in my unbound text box within my form as the name in the save as function.
can i specify a variable as a file name within the save as function? is there a better way?
Hi
I am very new to Access and have recently built my first database (using
Acess 2003), the purpose of which is essentially to enter our client firm
records and the details of related contacts within each firm. Firms can have
more than one contact.
I've built the database created the input form (capturing both firm and
contact details) and all is working well but I have run into two small
problems where I believe a quick macro or programming solution is required.
I feel like after much hard work I'm very close but my knowledge of
programming is close to zero and I've run out of time!
The 2 issues are:
1. I have created a one to many relationship between my 2 main tables,
"Firm" and "Contact". The Firm table has a primary key field entitled
"MailingListID" that is simply generated by Autonumber. I have linked this
field to a number field of the same name in the Contact table but when I save
the record (just using a standard save command button), the "MailingListID"
is successfully generated in the Firm table but does not get entered into the
related Contact table as well. Leaving me with an unrelated/connected firm
and contact.
2. In most cases firms will have 2 or more contacts. I belive this is
accomoodated by the tables ("MailingListID" field against each contact
creates a link to a firm, this number can be held against multiple contact
records via the one to many relationship), I just need a form button that
saves the entered contact details, then clears all fields except the
"MailingListID" field ready for a second entry.
Can anyone help me please with the steps or code required to perform these
actions. I've scoured usergroups, manuals and help without any success.
Many thanks for any help you can provide.
Stuck21 :eek:
So I have this relatively simple problem: I need to create a button that once clicked will open the Save As dialog box and allow the user to save a copy of the current database where he wishes. The filename should contain todays date in DDMM format along with some pre-set text e.g. DDMM PresetText.
I am using Access 2010.
I have a few selected reports on an Access 2007 database that users can run. Is there a way for users to view the report, save as a PDF and automatically save a copy to a shared drive by modules/vba coding as an On Click event procedure?
View 4 Replies View RelatedI need code for save dialog file ,and select the file from textbox and save it to the selected location.i have only this code and i dont know what else i can do with this because it just opens the save file dialog !
View 1 Replies View RelatedI am rewriting an old Access 2003 database in Access 2010. When creating new command buttons, the current theme gives them a default appearance. I need to apply this appearance to old command buttons. I know there is a way to select the default button and apply its properties to others quickly. I have done it before but didn't write the process down .
View 2 Replies View RelatedOk I am right now making a simple Vendor/Product database to create a line sheet for some sales folks. I have 3 tables: Vendors, Products, and an associate entity Vendors_Products to relate the two. I have a form currently that draws the Vendor Name (primary key) from the Vendor table and the Product Name from the associate entity. This allows me to create new vendors and select current product types from a drop down box. The problem is that the drop down box is too long and it is tiresome when 1 vendor has 10 product types.
Can anyone tell me how to resolve this? I thought it would be better to have option buttons and display all available products. Then you could just click all of the option buttons that apply to that Vendor and it would create the relationships...is this possible?
I need a simple line of VBA code for Access 2000. I am using Access to open a XML file via Excel 2000 spreadsheet. After opening I want to use SAVEAS to save the file to a different location. In addition I want to specify the file format as Excel. What is the code to specify the file type as Excel?
My current code is :
myWorkBook.SaveAs (myPaths![Path])
So what do I need to add to this line to specify the file type?
Any help appreciated!
Dalien51
I have a combo box that gets its data from a seperate table...In the table I have "Location_ID" and "Location_Name". When I save my form I want the "Location_Name" to save in the "Events" table, but its putting in the "Location_ID". How do I get it to save the "Location_Name" instead of the "Location_ID" from the combo box.
Thanks in advance.
Kacy
Hi,
In VB Code,
Forms event
How can I write save command?
Thanks.
Hey all I have added a yes no button to my save button, so users have the option to save the record or not. so the save yes works fine, but it is the save no I am having probelms with. I would like to click no, and have the changed not saved, clear that out and go back to the first record again kind of like undo. Thanks! Here is my current code:
On Error GoTo Err_savebtn_Click
PIN.SetFocus
'enable buttons
insbtn.Enabled = True
Command31.Enabled = True
Command63.Enabled = True
'Save the current record
Dim Answer As String
Let Answer = MsgBox("Would you like to save your changes?", vbYesNo, "Save record Confirmation")
If Answer = vbYes Then
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
exitedit
Else
exitedit
Call firstbtn_Click
End If
Exit_savebtn_Click:
Exit Sub
Err_savebtn_Click:
MsgBox Err.DESCRIPTION
Resume Exit_savebtn_Click
if i use Date() as default value at my field, can i save it? i mean it not change when next day come for some record. coz i want to use today's date as default date to some record. when next day come, date for that recoerd still at yesterday's date..
or there have any other way to do it?
TQ
I previously posted this in one of the other forums, but now believe this to be of a more general nature, and am still without a satisfactory explanation or any workaround:
I'm working on a new database with Access 2003, using the 2002-2003 file format. While debugging a VBA code module in the VB editor, whenever I get a runtime error something strange happens - I stop the debugger, correct the code and attempt to save my changes, and Access displays the message "Microsoft Office Access can't save design changes or save to a new database object because another user has the file open. To save your design changes or to save to a new object, you must have exclusive access to the file." It then persists in denying me the ability to save ANYTHING until I close the VB editor, close the Access application, and then start over again. In fact, there is no other user - all other machines on the network are turned off, and no other instances of Access or the VB editor are open.
Needless to say, this is slowing my development efforts to a crawl, and I'm totally stumped by it - I never remember running into this problem in years of working with Access 97 (where I can hit errors, stop execution, make any needed corrections to code or other objects, and re-run the application, without having to exit). I'm running this on a P4 3.4 GHz box with 1 GB of RAM. Going into Tools, Options, Advanced and switching the "Default open mode" between Shared and Exclusive makes no difference.
Any suggestions will be greatly appreciated.
This morning when I make changes to reports in design view then I try to save the changes and Access acts like nothing was saved. I then close window and it asks if I want to save changes, I click yes then it dosn't close. If I close and don't save changes it closes then.
I don't get any error messages or anything that looks like a problem and I could save changes yesturday. Not sure what is differant today.
It is on Access 2003 format.
Hi.
I got a problem...
How do i put access to not save automatically. I want it to save only wend i click on the save button i put on the form.
How do i do that?
Thanks.
I have noticed that when i am editing an object within my database, specifically a query and click to close it, it doesn't prompt me to save the changes and does it automatically. There have been cases where i do not want to save the changes and just wanted to know if there was a simple setting to turn off automatic saves?
View 3 Replies View RelatedHi guys, little question.
I really like Access, I can manage well with it. But I have a problem, and I really wonder why this kind of thing happens in such a professional program using a lot of important data.
Actually the program saves automatically, and I don't like it. For example I try a little something, delete some stuff, replace by something else, and when I quit the program, it doesn't say a thing, and when I come back, the unimportant stuff I changed is still there, and what was replaced is lost. Why? Is there any way to force the program to ask if I want to save the changes?... It's really annoying and I really don't feel secure with my data with this system.
Thanks for your clues! :)
I have an AC 2003 db that a customer is running using runtime. There is a report in the db and when the customer tries to run it, a "save as xps" box comes up. The customer is running the db using 6 machines, only 2 of the machines are getting the error. Is this an issue with Vista?
View 6 Replies View Relatedhere's the problem:
I have a table named case and it is connected with a table named categories .the table categories is connected to a table named subcategories.
For every record in the table case the categories and the subcategories are the same.
Is there a way that I can copy all the records of the categories and the subcategories for every record in the table Case or I have to do it only with copy & paste.
Thanks for your time.
i have a table with a date field with default value for new records date()
when i change an other field and im going to save the changes access says that canntot save the changes because of unknown type date()....
Relatively new to databases. I have designed a few using tables, forms. reports etc and have a switchboard open up on start up. When entering details in the switchboard form I need to press enter to save the record.
I noticed that on some databases there is a button which you press to save the record.
Pardon me for being pretty dumb but how do I add this to my forms.
Hi,
I have made 3 forms, details,master, and stocks. They r based on same name tables i.e., details, master and stocks.
Stocks has got a set of pre-loaded records. I want to show data related to stocks on details form, but it should only happen when anyone enters some data in a CODE field on details form. Basically there are 3 fields which are same in details and stocks. CODE (NUM), PONO (TXT), DESC (TXT).
My query is, that when a user enters a record in CODE field it should check if the same code exist in stocks table. If yes then it should fetch the other two fields data and paste in details form. Also advise me how to link these three table together. Please Help
:( here's the problem:
I have a table named case and it is connected with a table named categories .the table categories is connected to a table named subcategories.
For every record in the table case the categories and the subcategories are the same.
Is there a way that I can copy all the records of the categories and the subcategories for every record in the table Case or I have to do it only with copy & paste.
Thanks for your time.