When one user opens his ACCESS file, it opens in Notepad. He uses ACCESS 2003.
Now he has to right click on that file (on windows explorer) and select open with 'MS Access' to make it to work.
Any one knows how this setting can be changed to open with MS ACCESS?
I am importing data that has been put onto Notepad into an Access table - this works fine except the date in notepad comes across as a date and a time. When I put the table into a query and ask for the date to be Between [Specify date 1] and [Specify date 2] - does the user have to then put 7/02/2005 00:00:00 AM and xxx. I have tried this but it doesn't return all values. I have also tried just the dates but this doesn't return all values either - any ideas?
View 6 Replies View RelatedHas anyone had the experience using a digital notepad, such as this one, http://www.newegg.com/Product/Product.asp?Item=N82E16883101001, can this device allow an user to enter free text from handwriting to a field on a form in real time?
View 1 Replies View RelatedHow can I get a form to open when the database opens?
View 5 Replies View Relatedis it possible to automatically output the results of a query to notepad?
View 2 Replies View RelatedI have a pesudo forum running on a server which sends emails automatically to a group to indicate that there is a new posting - much like any forum...
I would like to include a link in the email (automatically) that will open the Access Forum and point directly to the relevant post...
I searched the forum but was surprised to find that this question hasn't been raised before... so I'm worried? :p
I know I will get a hundred links from the Mighty Moderators now saying I didn't look properly - as my old mother used to say :rolleyes:
Dave Eyley
I have a couple charts that I would like to show on my switchboard. Right now I only have one that is up everytime I open my database. Is there anyway to have it do a random Sub form show up everytime you open the database up? Thank you for your help. Without this forum I would have shot myself a long time ago!
View 1 Replies View RelatedHello Ladies & Gentlemen,
I was trying to access this particular MS-ACCESS file which serves as a DB for a software. But the file opens and closes in a split of a second and was impossible to view its structure. :mad:
I beleive it's made to respond so by the programmers in order to hide the content. Can anyone please help me open this file? PLEASE...
Teddo
A form that used to automatically open when the db was launched has been deleted. However, the instruction to load the form is still in the db. I would like to remove that instruction, but I can't seem to find where to look for that code. In Access 2007, I went on DB to the Database tool menu, but its not in the switchboard manager.
View 3 Replies View RelatedI am having a problem running Access 2007 runtime on a workstation. I have set up the 2007 database (.accdb) on our server and am able to connect to it and open it from the pc that has Access 2007 full version installed and it works fine.
I also installed Access 2007 runtime on another PC and was able to open the database using the runtime version just fine.
However, on this other PC, I installed the runtime version, and when I use the command line (msaccess.exe /runtime \serverdirectorydatabase.accdb) to open the database in runtime mode, Access opens for a split second and then closes immediately.
When I just run msaccess.exe, it opens the runtime version and says that I have not specified a database, as expected. So, I am wondering why it is not opening the database when i DO specifiy the database.
If i specify an incorrect directory for the database, it opens the runtime version and a dialog appears telling me that a database was not found, and upon clicking OK, the program closes.
I can say, that when I run it off the computer that works through the runtime version, I get a security warning telling me that there are potentially unsafe elements in the database, but i just have to click OPEN and it still opens it fine.
Perhaps the non-working PC is denying it access due to these security issues?
I can't seem to figure this out, and any help is appreciated.
Using Access 2010.I purposely disabled the Access Objects to open when the database opens of fear of someone messing with my data. This works. The problem I'm having is when I use the print button (access macro) on one of my forms, as soon as i click the button, the "all access objects" window opens on the left side navigation.Is there a setting that will permanately stop this from opening?
View 3 Replies View RelatedHi,
I've been given an existing database to modify, and I'm struggling somewhat to see how the author has implemented certain functions.
On a main menu form (autoexecs on starting the database), there are various "Search By" option buttons to generate a report, ordered in various ways. The "On Click" field for each of them refers to a macro, called Buttons, and a line in that macro dependant on the type of search (e.g. OnClick = Buttons.byPerson).
The Buttons macro runs an OpenReport command, the report corresponding to the search type (e.g. Buttons.byPerson has an OpenReport command for the "Report by Person" report).
However, when I click the search buttons (or indeed run the corresponding reports) I instead get another form which allows the search criteria to be specified - this then generates the report (I would assume based on the relevant query - e.g. Person Query), but I cannot understand how this works.
Google searches have not helped much as I can't seem to find an adequate search phrase to use, and I've been staring at the thing for some hours now. Any help getting me off in the right direction would be much appreciated!
It has been ages since I visited the forum, feb 23 to be more exact...
Life has been hell and am crammed for time... This time I have run into something I cannot get a handle on...
On just about any PC this db I build works perfectly, but on one I having some trouble (see attached). I have never experience this.
If I (or the customer) opens the database either by double clicking on the database on the network, double clicking the shortcut it looks like [see attachments OnOpen]
This is not very nice offcourse but is simply solved by clicking the maximize button. After which we see this... [see attachments AfterMax]
From this I can maximize the database screen, but not the form. It stays like that, unless I click design and then Form view. After which the database works normal.
Does anyone have any clue?
Greetings all.
I've got a minor housekeeping issue with my db that I can't seem to crack.
The db opens to the main form, which has a boat-load of control buttons that open a variety of forms and reports and 1 query.
The problem is that when you select the button that opens the simple query, the query opens in maximized view and then when folks want to close it, they often end up closing the whole db, instead of just the query. (Using the right corner X.)
I'd like to open it about half screen or so, to avoid the accidental closing of the whole database.
I can open the query directly or from the macro and in both instances it opens up the correct window size. But when I use the button it opens maximized.
I've searched the code, can't find any reference to maximize.
Can't find anything in the button properties that would cause it.
Any idea why this is happening or how to get around it? It's probably something simple, but then, so am I. (hehehehe)
Thanks,
BeckieO
Hi,
Is it possible to have a query that shows only records for the current date and when you click on a specific record it opens in a form ready for editing?
The query would serve as an index of transactions for the current date.
Please help.
Piet
Hi
I am trying to get access to close all open forms and open the selected form when a button is pressed.
I tried this in a macro like so:
open switchboard
open new.client
close (forms)
The switchboard is used as a back drop to the database.
the new client form will open over this (pop up is set to YES)
Any other forms will be closed at this point.
I can only get it to close one form at a time which means I have lots of close commands in each macro.
The problem is, if I add a new form then I have to go through each macro to reset it to take that form into consideration.
There must be an easy way to do this.
Alan
I would like my form to open and automatically go to the end of the records, so I don't have to navigate to the end before I start entering data.
I have seen a form do this but can't find out how.
Thanks
I have a FE DB that I have been opening and closing at various times without incident. Now all of a sudden it only opens as READ ONLY. I can't find anyone with a BE open that might be causing this. What will cause this? If I save a copy and then replace the original will I lose my data?
View 6 Replies View RelatedI have a database which seems to open many copies when it is accessed over the internet (via ASP) but If I open it on my compter over my LAN then it seems to open 'exclusive' and those on the Internet get the error message that 'file is already in use'.
Is there a way of opening the database over the LAN and allowing the Internet to see it?
I am sure this has come up a thousand times and I searched but could find nothing about this. I have a database with one main form and many queries. When the database is opened by users I would like for only the form to show. I do have queries in a dropdown list on the form to run. Basically, I only want the form to show when the database is open but I want to be able to get to the menu's etc when I need to.
Please help.
What is the best way to have all controls in a subform empty when form opens? The form and subform are bound.
The following:
Private Sub Form_Open(Cancel As Integer)
Me.textDate = Null
End Sub
Produced error - "cant assign a value to object"
thanks in advance
I have a form based on a query. The query sorts records by ID number. When I open the form, it opens to a record that is not the lowest ID number. It's the same record each time that it opens to, but it's not the correct record There is no filter or sort order on the form, and it seems like starting with record 2 it is sorting correctly. any ideas? thanks.
View 1 Replies View RelatedThis is the first time I've used this forum so, hello everyone
My first question is about filtering a form
When a user is in the menu screen and selects a command button to view details, the next form that loads shows every record within the main table. So the user can use the navigarion buttons to go through each record.
There's search criteria on this form so the user can select which ever record they like.
Because of speed issues, I'd rather the form filtered a record (whichever one) as soon as they pressed the command button.
I've thought about how i'd do this and can't really come up with much; looked at openargs but my VBA isn't that hot yet
Does anyone have any ideas?
Thanks in advance
I have a form that I built with the intention of creating new records. I want to convert it to use with existing records too. I can't seem to get it to look at anything but new records. I imagine it is a property setting and something very minor to a seasoned Access programmer.
View 14 Replies View RelatedWhenever I open this form I get this message. Form opens a web page.If I open that web page with browser I don't get this message.
View 2 Replies View RelatedI have a form with a combobox. From this combobox I would like to trigger the opened of a different form with the name and surname of the patients selected into the combobox.
I used this vba code
Private Sub Find_Click()
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "ID Patient"
stLinkCriteria = "[PTS]=" & Me.Identification
[Code] ....
The problem is that when the form Id patient is already opened every thing works fine but when the Id patient form is not opened it looks like if the combobox was not able to trigger the form with the name and surname of the patients!