Hi all,
I have a file that is called vot.xls, but it is a tab delimited text file.
I would like a button on a form called import to open it up in excel and save it as a worksheet vot.xls file.
How would i go about doing this?
Please help.
Thanks in advance
I've written a function which generates a MailMerge in Word from Access. Works great. However, Id there an easy way to get the SaveAs dialog box to pop up so the user can choose where to save the resulting doc? Thanks.
View 1 Replies View RelatedI am wondering if there is a way to disable the "saveas" in excel from access with vba? I have the following code:
Private Sub cmdReport_Click()
Dim path As String
Dim XL As Object
[Code]....
Which I have used in another excel file. But I can't use that now. The file I am opening from access is a workbook generated from an excel template, and I have yet to find a way on how to transfer this Workbook_BeforeSave sub from the template to the new workbook.
I have some code that opens and populates an Excel spreadsheets then does a save as to a specific directory and also outputs a PDF. This code is working with one small problem, I am leaving the first instance of Excel open and can't figure out where I should put the code for it to quit. Here is my code:
Code:
' This code creates a recordset based on the current reservation in order to gather data on
' a specific reservation, to output to a payment schedule excel spreadsheet which calculates
' Payment dates and amounts for specific reservations
' Declare variables for recordset
Dim rst As DAO.Recordset
Dim db As DAO.Database
[Code] ....
The instance that I need to close is shown in red.
I have a Form opening from Access Options. I would like to close this Form using the Timer. The following is the code I have used but it is not working.
Private Sub Cover_Page_Form_Load()
OpenTimer = Timer
End Sub
Private Sub Cover_Page_Form_Timer()
If (Timer - OpenTime) = 5 Then DoCmd.Close acForm, "Cover_Page_Form", acSaveYes
End Sub
Next question. If I can get this to work can I then use a DoCmd to open new Form within the code above or do I need a new process.
Hi All,
Is there a way that when the user clicks on a database file, the form pops up without opening MS Access window.
Thx,
Jatz
Hi All,
Is there a way that when the user clicks on a database file, the form pops up without opening MS Access window.
Thx,
Jatz
I am very close to completing a DB Program.... How can I create a desktop Icon that will Launch my Program without Loading Microsoft Access along with it???
View 6 Replies View Relatedhi, when opening access how can i get a switch board or a form to automatically open up, instead of viewing the main acess windows
View 1 Replies View RelatedIf I have one access mdb file called "DATA" that contains tables and two access applications as mdb files: "app1" and "app2". Both applications has links to tables in access mdb file "DATA". Is there a way to open access file "DATA" exclusively when I open "app1" and open it shared when I run "app2"?
View 3 Replies View RelatedI have small problem that I can't get access to edit my own database because the are constantly people using it. So is it possible to kick uses off my database so that I get exclusive to edit it?
Cheers
Hello,
I have been working on a database back and forth and home and at work. Today I saved my database from home and onto my computer at work. The database is not opening here at work. It works fine at home. When I attempt to open it, it tells me Access has encountered a problem and needs to close and it closes.
I tried the Compact and Repair.. Access still shuts down on me. I made a new empted database and tried to import the tables and forms into it.. Access still shuts down on me.
It's getting frustrating because I've been trying to get this working for 3 hours now with no success.
Hi,
I have made an application in access 2000. So what I have, 2 text fields and one button. I would like that when I click the button that access visits a site like this:
http://website.com/test.php?ID=5&NUM=23
where 5 and 23 are values from my fields in my form.
Any ideas.
regards
Here's a little problem I have and wondered if anyone knows a way around it.
I currently have many databases that I have created for work and they are quite happy running away doing what they are meant to do on a 2000/NT setup, we will soon be switching to our parent company's network 2003/XP/Citrix which is presenting me with the following problem and we do not have any control over how this is run.
We can no longer create desktop shortcuts to the databases as current, they will place 1 database in the start menu and would like this to be used as the database menu so that all databases are launched from this.
So I am trying to launch access databases from within an access database (Access XP), here's what I have tried so far
Shell - works when I use full MS Access but does not work in Run Time versio n which is what the users will access, shows no error, it just beeps and does nothing.
SendKeys - %fo<FileName>.mdb~ - again works in full access but not in Run Time as RT does not have 'open' in the file menu.
FollowHyperlink - this actually works but I can not get this to open the new database as a full screen window, this requires the user to either run everything maximized (not ideal as some forms are designed to run side by side) or for them to resize the main forms.
Are there any other ways to open a database from within access RT version that will open the access application full screen?
Hello all!
My program was almost finished, and everything was just fine when a fatal error occurred!
I tried to open my access application and my startup page appears, when i introduce the values I need to introduce here (username and password), a microsoft screen appears, saying that the program has encountered an error and needs to be closed.
After 10 times giving me the error (not 10, but quite a lot of times), it work fine...
What's the problem?? Anyone has a solution for that?? It happened two times so far... and i'm afraid of handing this in, and having this problem...
Thanks for your help!
How can I open a particular Adobe Acrobat document from an Access database?
For example, I have a filed called "Doc1.pdf" that I want to open. How can I do this?
frankie13
Is there a way you can set where a from Opens in relation to a button or a piece of text you select.
Basically I have a main form, with some selectable options on the LHS of the screen, rather than use buttons I have text boxes programmed to open a form using the "On-Click" event, I want the new form to open right next to the text box, so it will look like a drop down menu.
Additionally the main form could be moved around the screen, is there a way of locking the 2nd form to be next to the text box ?
Additionally I know I could use a list to but I am trying to design the DB with a certain look.
Many thanks
MattP
Instead of using command buttons to open forms
I would like to open forms displayed in a list box
Is there a way of doing this, so for example the
listbox will show
CustomerForm
SupplierForm
OrdersForm
ProductsForm
When any of the above is clicked the relative
form will open.
Regards
jmeek
I have a form with a bound combo box listing names, [myname] and a multiselect list box that lists all available forms in a database [myselections]. I am really struggling with code that will enable the user to hit a command button that will then open the selected forms to show the data for the selected individual. I have found things related to selecting items in tables etc but not related to opening forms to specific entrys and I am just not experienced enough with SQL to get this working. Can anyone help or direct me to a good example?
View 1 Replies View RelatedI have a combo box with 4 choices and it is limited to the list. Based on the value the user selects I want to open 1 of 4 forms. Tried using the select case but does not work?
any suggestions?
Jon
Hey, just one quick thing.
Whenever i open my database i want my form to open automatically, i'm only using oe form and one table, but the only thing im going to need to use is the form.
Cheers Guys!
I have a drop down with a list of years (2002, 2003 etc) that the user must select from. when they do so and click the GO button a new form will be displayed. I need to use this year to compare against a field in the table that the new form is using. However the field is in a dd-mm-yyyy format that can not be changed.
Is there any way i can do a like search on the value of the drop down against the value in the table to only give the records with a particular year? what i have at the moment is below but obviously this wouldnt work because it is saying, is dd-mm-yyyy like yyyy. How can i turn this like search around so its yyyy like dd-mm-yyyy?
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "Master NCRs"
stLinkCriteria = "[OpenDate] like " & Me![NCRYear]
DoCmd.OpenForm stDocName, , , stLinkCriteria
thanks
Help!!!
I am new to access and data bases
I have a table "Body shop " with fields making up Primary key
Shift can be days,lates or nights
Date Short date
Line integer 1 or 2
Given the 3 fields as strings Strshift, Strdate and StrLine
I cannot open a form at correct record, here is what i have tried
Set recset = db.OpenRecordset("Body Shop")
recset.Index = "PrimaryKey"
recset.Seek "=", Strdate, StrShift, StrLine
DoCmd.OpenForm FormName, , , , acFormEdit, acWindowNormal
recset.Close
db.Close
Set recset = Nothing
Set db = Nothing
Thanks
Hi,
I have created two forms and linked them as subforms to another form(main form). At the moment when I view the main form the two subforms are also shown. I want to make these two subforms invisible, so that users can click on command buttons depending on the form they want to view and then the subform will appear as pop up as a new window/form.
I want the two forms to be linked to the main form
Hi, I want to open my form and have all the areas blank.. right now when I open my form, recent records appear.. I don't want to have to click the 'new' button, i just want to have a new record ready when the form is opened..thx
View 1 Replies View Relatedwhat would be the best way to accomplish this.
when i open up a form (call it the issue form)...i want to ask a question to the user "what is your name" i then want that answer to be put into a record on the form...thus every issue the guy solves his name will already be on the form....