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 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 RelatedI have a table which holds information relating to a fleet of vehicles; each of these vehicles is currently physically checked on a daily basis for a number of items, one of which being to check that the vehicle has valid VED (tax disc).
With the paper disc being abolished now, we have a situation where the individual using the vehicle cannot be certain about its VED status (the chances of one not being taxed is next to nil, but we are talking a fleet of nearly 1000 vehicles here, so anything is possible)
Our current database has most of the vehicle information stored already, so in theory I think I only need to add a couple of fields, which will make the table structure (roughly):
FleetID
RegistrationNumber
CallSign
MobileTelNo
MOTExpiry
VEDExpiry
With the latter two being the added fields.
Now, what I was wondering.....
Is it possible that when a Form (not related to the table, and most likely the main switchboard form) is opened that both the MOTExpiry and VEDExpiry dates are checked, and if either or both of them are due to expire within 7 days or have already expired that a warning appears (vbaOKOnly messagebox would do fine) stating that there are vehicles that require their MOT & VED dates to be checked and updated accordingly)?
Hi all,
I decided to create a switchboard using tools---> DB utilts---> SW manager.
i have managed to get this on the front end, altho the first button the contacts does't work properly. when i click it using that i cannot see any of the data that is in the database? but if i go out the switchboard without pressing anything on it. and goto contacts form the data is there?
Wired? or is it something simple i have missed?
Thanks
Shrew
www.dsltech.co.uk/310506.zip
Have created a form to display/change table info in Datasheet View and added the form to a switchboard.When selected from switchboard, it displays a single record. When executed from the Forms (objects), it displays in Datasheet view.? How can I get it to display in Datasheet View from Switchboard?
Default view = Datasheet
Allow Form View = Yes
Allow Datasheet View = Yes
Hard to see the image but basically, I can't seem to bring the database behind the form to the front to view it when I click on it. I've never encountered this before.
View 5 Replies View RelatedHow can I get a form to open when the database opens?
View 5 Replies View RelatedHow do I minimize/close the Switchboard to view a selected form/report. It shows up behind the Switchboard. Thanks!
View 1 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!
After reading many of the posts here, I decided that one of the problems with the tables in the db I was working on was in the primary keys. I had used the same field name as the primary key in all of my tables. This was RecipID, which was a user entered textbox with an example in a label beside it showing the format to use.
After reading stuff here, I decided this wasn't a good idea. So I changed RecipId to be an autonumber in the parent table (Household_Info) and a long integer foreign key in the children. Also, I added some fields to the parent table to identify the head of household (lastname, firstname)
I already had a continuous form made with a subform and a pop-up form associated with it based on my previous tables. Reran the query underlying the form, and the new fields showed up in the field list box for the form. The fields are all still present in design view, but I get a totally blank form in form view. I checked the forms recordsource and made sure that it was set to the new query.
Can anyone give me an idea about what I'm overlooking? Do I have to recreate the form?
(Sorry if this is a repeat of a question someone has already addressed, but I couldn't turn up any relevant threads after several hours of searching.)
Thanks, Charlotte
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 Form which I have linked correctly to a subform. The Text boxes are showing in the Design view but are not when one switches to the Form View. Labels for Fields are visible in the Form View. Have even created a new subform and that will also not display the Text Boxes.
View 1 Replies View RelatedWhy the ability to view the properties of an object within a form is not available when you double click on it in design view?
I was happily working away double clicking on a command button to edit some code when for some reason the next time I tried to edit it did not open up for me.
I was unable to access it even by right clicking on the object & selecting properties as that also appears to be disabled, not greyed out or anything but just does nothing when selected.
Have I inadvertently changed a setting somewhere that prevents the properties from being displayed?
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.
See title :)
I have seen that in some sample db's rightclicking the mouse showed the menu with an option to check or uncheck the dataview option, unchecked the formview was applied, but when i 'just' import the subform, i cannot find somewhere the possibility to change from dataview to formview.
Maybe someone can help me with this, probably very simple(?), question?
Anybody ever heard of this before? I open a form, and it is empty, just a blank window. I open the same form in Design View, all appears well. :mad:
View 2 Replies View RelatedI 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
This 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 4 tables and around 440 records but can only view up to 417 in the form I have designed. I have been adding new records via form and it has been added to my main table, but when i try to view it in form view - the record is not available to view. What do I need to do to correct this problem?
I have checked that there are no filters, data entry is set to No, Auto deletions, additions and edits are set to yes.
Also to mention it seems that the problem has arisen since I set up some new queries, there is a one to one relationship between the tables!
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