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
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 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.
Can't figure it out. Here is the code:
Private Sub Button_OpenQuest_Click()
On Error GoTo Err_Button_OpenQuest_Click
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "Ques_Physician"
stLinkCriteria = "[sbjID]=" & "'" & Me![sbjID] & "'"
DoCmd.OpenForm stDocName, , , stLinkCriteria
Me.Visible = False
Exit_Button_OpenQuest_Click:
Exit Sub
Err_Button_OpenQuest_Click:
MsgBox Err.Description
Resume Exit_Button_OpenQuest_Click
End Sub
__________________________________________________ __
I get the message "The command or action 'SaveRecord' isn't available now"
Why won't the form save - it's telling me the command or action Save Record isn't available just now. I've got it on a After Update event of a combo box where it saves the record then it previews a report. If I don't save before opening the report half the data is missing.
If Me.Dirty Then
If MsgBox("Record has not been saved. " & Chr(13) & _
"Do you want to save it?", vbInformation + vbOKCancel) = vbOK Then
DoCmd.RunCommand acCmdSaveRecord
Else
Exit Sub
End If
End If
I have a form with 4 combo boxes. Box 1 is linked to a unique indexed field of my main table and does not allow duplicates.
Is there a way I can enter selections in the other 3 boxes and save only those 3? (these do not add data, but edit an existing row in the main table)
Experimenting, I found that if I didn't make a selection in Box 1, I could still make selections in the other 3, close (save) the form, and it would make those 3 edits in the table row belonging to the value that was in Box 1.
This is kind of what I want, except that there are many selections in Box 1, and if I select one of them and close (save) the form, I get an error message that a duplicate entry will be made?
Would a possible solution be to have Box 1 on a main form and the other 3 on a subform? If so, how do I set this up? Or is there another way to relate the other 3 boxes to Box 1, and only save the 3.
Hi all,
I am wondering if there is a way to save a record in this manner.
When the user opens the form wait 1 second and then save.
But I would like it to do this only once. I have tried the “on timer” but it keeps saving the record every second.
Thanks in advance
Jon
guys, here is my problem.
I created a tool to manage changes. As part of the process a support can edit a change to change the status and the requester can validate that the change is done properly. Both processes work in the same way, the diference is that the can modify different fields in the form. But here is the procedure.
Edit a task (support role): From a task management menu press the button to open a form with a list of changes to be done. Double clicking in a specific change number a new form with the change detail is opened. When the support finishs press the save button and insert the changes in a history table (to track the changes) and update the change table to update the record. Until this point everything is great.
Validate a task: (requester role): from the task management menu press a button to open a form with a list of changes to be validated. Double clicking in a specific change number a new form with the change detail is opened. When the requester finishs press the save button and save the changes in a history table (to track the changes) and the change table to update the record.
The problem is that the validate task form doesnt update the change table and doesnt insert all the fields in the history table, only some of them.
Here is the error msg:
" ILI index tool can't update all the records in the update query.
ILI index tool did not update 0 fields due to a type conversion failure, 0 records due to the key violations,1 records due to the lock violations, and 0 records due to the violation rule violations.
Do you want to continue running this type of action query anyway?
to ignore the errors and run the query, click yes.
for an explanation of the causes of the violations, click help"
Here are the sql to update and insert once the save button is pressed:
Public Sub grabarstatus()
'DoCmd.SetWarnings False
MsgBox "entered"
DoCmd.RunSQL "insert into [history] (change_id,before,after,user,modify,action) values (" & Me.Task_Num.Value & ",'" & vstatus & "','" & Me.status.Value & "','" & Forms!Login!username1 & "','" & Now() & "','Validate status');"
DoCmd.RunSQL "update [newchange] set status='" & Me.status.Value & "' where change_id=" & Me.Task_Num.Value & ";"
DoCmd.SetWarnings True
End Sub
thx very much
I have a combo box(based on a table) on a form which autofills 12 textboxes. The problem is when i switch to the next record on the form the auto filled textboxes stay the same as the first record. when a new item is selected from the combo box all the records are changed once again. I dont know if this is explained well enough but any help would be great
View 3 Replies View RelatedI have an unbound form that I load with one record. The record is selected based on a selection made in a list box on a previous form.
Then changes can be made to the data.
Then I want to click the save button which runs a stored procedure to update the table with the new data. I DON'T want Access to automatically post the record for me.
But when I hit save it tries to update twice and gives me a warning - it saves through the stored procedure and then tries to save again as the form closes. (I'm assuming. - I get a warning that says another user has changed the record and do I want to overwrite the changes.) I think it's because right now I load it with fields from a view.
Here is the code that opens the form and gives it the recordsource....