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.
How can I get a form to open when the database opens?
View 5 Replies View RelatedI've recently decided to move a database that had all its information on 1 table and divided it into multiple tables.
Attached is the relationship as well as the form.
The issue I have is that when I click the form, it only shows a blank record with none of previous records.
Data entry is already set to NO. I'm wondering if it's an issue with my relationships, tblStudioDescription is the parent table and the others are child tables so I linked them with the ID and set referential integrity.
Hi,
When the user clicks on the file name, I want the form to load automatically & also at the same time minimize the database window (i.e. the window where all the tables, queries etc are listed). Any suggestions?
Thx in advance,
Jatz
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 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!
I 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?
We have a database on a PC located on our network. The database is located in this computer's shared folder. Another database grabs data from this database occasionally. We're running into a problem where we cannot open the DB located in the shared folder (permissions granted) without it being a read only instance even with no users accessing the DB.
View 6 Replies View RelatedI 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 code for a button click event. Essentially I have a main table form that I use to enter customer data and info. I also have a button that I use to add that customer to a separate table that I use for special Customers. My code copies all the data I need copied to my other table, so I wont waste space here typing my code that actually copies the data to the new table. What I will list are the two commands I am using after that code, to close the current form (the one with the button) and open the form for entering special customer information (the form to edit data on my other table). It works flawlessly, but when it opens the other form, it opens to the first record. I want to know how to make it open to the record which I was viewing when I clicked the button to copy the data.
DoCmd.OpenForm "Special Customer Data Entry", , , Number = Me.Number
DoCmd.Close acForm, "Customer Data"
I'm working on a project that has two tables. "Calls" and "Customers". The Customers form has a subform, "Calls Subform" in it. When you click on the (New) Hyperlink a new form opens, "Call Details". I would like to pull information off of the "Customers" Form and insert it into the newly opened "Call Details" form.
Problem #1) Home Phone (named "Phone" and Text223 (named "CID"): are both bound controls so I have to do this in an OpenArgs type process.
Further details:
On "Customers" the following is true:
"25" is the "ID" for that customer on the "customers" table
"Home Phone" is the home phone number on the "Customers" table
On Call Details the following is true:
Home Phone is Bound to a table "Calls" and needs to pull it's data from Customers Form..Text223 is CID and bound to the table "Calls" and needs to pull it's data from "Customers" form.
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!
I have designed a form which I want the users to see in Datasheet form.
In the properties, "Default view" is "datasheet" and "Views Allowed" is "datasheet"
When I open it directly, it opens as a datasheet.
But when the Switchboard opens it, it comes up as a Single Form. Infuriating !
What to do ?
NoVoiceLeft
I have a User Main Menu as seen below with the command buttons for New Work Log Entry and Edit Work Log Entry. The New Work Log entry opens a blank Work Log as shown below. The Work Log form's record source is tblWorkLog. The user will fill out all the fields except the End Page and Total Worked Pages. The user will then exit out of the database. When ready to enter the total worked pages the user log back in to the db and will click on the Edit Work Log Entry.
This is supposed to open up the last entry the current user was working on so that he or she can enter the End Page and Total Worked Pages
Currently it is opening up the last entry of the table even if it was a different user's.
How can I change this? I need it where it opens up the last record for that person. There are going to be 50 users so I can't have it open up to the last record of the table.
Any help will be apppreciated.
http://img.photobucket.com/albums/v332/youmnac/UserMenu.jpg
http://img.photobucket.com/albums/v332/youmnac/WorkLog.jpg
Help! What seems like a simple problem is driving me crazy.
I have a form (one of 2 that are nearly identical) that appears to be opened “filtered”.
When the form opens, none of the controls react to clicks, it does not allow edits. It has a feel as if a master lock is on the form. Finally, a right click to a shortcut menu saw some progress. If I select “Filter By Form” (the current record fields become blank) and then select “Apply Filter/Sort”, the form becomes “normal”, i.e. all fields and controls behave normally.
I have gone over the code of this form and its near-twin and cannot see any differences relating to this problem.
Assuming there is some type of stealth filter at play, Access Help yielded:
Use this procedure to delete any type of filter, regardless of what method you used to create it.
1. Click in the form, subform, datasheet, or subdatasheet whose filter you want to delete.
2. Switch to the Advanced Filter/Sort window (Advanced Filter/Sort window: A window in which you can create a filter from scratch. You enter criteria expressions in the filter design grid to restrict the records in the open form or datasheet to a subset of records that meet the criteria.).
3. On the Edit menu, click Clear Grid.
4. Click Apply Filter on the toolbar. I can not find the “Advanced Filter/Sort” window they talk about. I am assuming that this is a filter issue.
Does anyone have any insight on why this form opens “locked” and what the related filter issue may be?
I have also tried the VBA code:
Me.Filter = ""
Me.FilterOn = False
To no avail.
Any help is certainly appreciated.
Thanks,
JQ
how can i insert 'thisvalue' into 'thisfield' as soon as the form is opened??
View 5 Replies View RelatedI'm trying to add data about a form to a table when the On_Current event fires. The data I want to add is:
windows login username
date and time the On_Current event occurred
name of the form that was opened
that the form was opened
the number of the record (ID) in the table the form is based on
I have the following code
Private Sub Form_Current()
If Me.NewRecord Then
Call FlimOpen("OR IR No", "OPENED")
Else
Call FlimOpen("OR IR No", "OPENED")
[Code] ....
Excuse the use of 'FlimOpen' but I needed a unique word that I would remember (inspired by FlimFlam the cat on the children's channel CBeebies here in the UK)
I try to compile and I get an error about the wrong number of arguments or invalid property assignment. However, the event does fire correctly when I open the form or move from one record to another so something's working!
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 RelatedIs it possible to open multiple forms when the database opens? Currently only one form opens. I am using Access 2010.
View 5 Replies View RelatedI need to hide my subform on load or open of the main form but am experiencing some weird results. I have tried putting Me.SubForm.Form.Visible = False in both the on open and the on load of the main form and it works only if the tables on which the subform have records in them. If the tables for the subforms are empty I get an error 2467 telling me that "The expression you entered refers to an object that is closed or doesn't exist." I find this strange because from all I can find the subform loads first.
How can I hide the subform when the main form opens no matter what records exist or don't?
I have a Form with a control button that opens a Table using VBA code.
I have made quite a few similar databases before and usually when the Table opens it opens "above' or in front of the Form.
This time the Table opens but behind the Form.
I would like the Table to open and appear in front of the Form.
Is there a setting or something to control which displays on top?