General :: Previewing Forms Full Frame While Designing?
Oct 17, 2014Is there a way to preview a form you are designing to see how it will look when it's full frame?
View Replies
ADVERTISEMENT
General :: Dynamically Adding Option Controls To A Frame On A Form
Aug 20, 2012In Excel, I can dynamically add option controls to a frame on a form using the Control.Add method. Is there an Access Equivalent? I can only find Count & Item as Control. items.
It might have something to do with design view i guess.
General :: Designing Database Using Existing Data
Oct 25, 2014I have to design 2 databases base on some data that was given by my instructor but I feel like I'm missing something on both specially the 2nd database. I have attached my work so far as well as the instructions and the existing data..
View 2 Replies View RelatedForms :: How To Display Picture In Object Frame
Mar 25, 2014I want to know how to display picture in object frame in a form ?
I would like to select the data from a table ...
Forms :: Unbound Object Frame Inside Tab Control
May 24, 2013On a Tab Control inside a from, I've created an Unbound Object Frame, referring to an MS Excel Work Sheet. The goal here is to link that Unbound Object Frame residing on the Tab Control and save the form/link.
Now, when I execute the code, the Object Frame is linked and updated, but when I close the form, the link inside the Object Frame is not saved! However, when I do the exact same thing without placing the Object Frame on one of the pages of the tab, so as regular control inside the form, all works fine.
The code is as follows (performed when I click the button);"OLETest" refers to the UnBound Object Frame placed inside the first page of a Tab Control inside the form.
With OLETest
.Enabled = True
.Locked = False
.Class = "Excel.Sheet.12"
[code]...
Forms :: Unbound Object Frame Takes Forever To Load
May 6, 2015I'm experimenting with unbound object frames to embed an excel sheet in Access.If I have an excel application already open and busy, and then open my form, access freeze completely and won't do anything. My users will probably be running excel vba programs when they attempt to view this form, if there is no work around I'll have to drop the idea of embedding excel in access.
whenever an "external" thing wants to use excel (opening a file in explorer, etc), it uses the very 1st excel application open on the computer at this moment, instead of creating its own instance, or at least scanning for how busy the open application is. Because of that, I think that even loading the preview in the access form will try to use the current excel process even though it's completely busy.
Designing Forms For Different Display Sizes
Aug 25, 2005I have written a database application in Access 2003 for my company. I am going to deploy it with Terminal services on a Windows 2000 Server. I went to my server room to logon and test and found that 90% of the screens I designed had print and close command buttons that were off the screen. I developed the application on a 19" plat panel display with 1280 X 1024 res. The server room has a 17" Non-flat panel with 1024 X 768 res. I am assuming this is the culprit. Is there a way to make the application a "ONE SIZE FITS ALL" solution. Im sure writing a different version for every possible resolution is not how it is done. Any ideas would be deeply appreciated
Thanks
Forms :: Make Frame Automatically Adjust To Image Width And Height
Aug 7, 2013Is it possible to make it so that whatever the dimensions of the image i paste the OLE object's frame will also be the same? I'm having a problem, not necessarily a problem more like a preference, I'm inserting pictures of each individual inside a database and whomever last took these pictures didn't make sure there was a standard size So all the images are different sizes and when they're put inside the OLE frame you can see the image inside it but the frame itself also shows its white background because the image isn't the full dimensions of the frame. I was thinking if it's possible to make the frame automatically adjust to the image's width & height.
View 3 Replies View RelatedDifficulties In Designing Functional Forms And Tables...
Nov 14, 2004Hi,
I am a newbie at Access and am basically designing my first database. This database is for a short term project and is designed to track the attendance of employees at acompany. Here is a brief description of the tables and forms in question.
EmployeeInformation - this table stores records of each employee, their ID, DOB and SIN.
AttendanceProfile- this table stores records of prolonged absence periods for each employee. A given employee can have many attendance profiles, meaning that this table is linked to the EmployeeInformation table via a one-many relationship. This table will provide detailed information about the status and history of each Profile. So for example if an employee misses work for 12 days due to an appendicitis operation, the exact nature and dates of this absence would be listed as a new profile. The primary key for this table is an autonumber field called ProfileID
ActionLog - this table stores the actions taken by company employees (if any) in response to each AttendanceProfile. It is connected to the profiles table via a one-one relationship with ProfileID being the foreign key in this table. Another main field is the ProcedureNum field which will list the number of each procedure taken for a given ActionLog record. This table is needed to track what the company has done/is doing to track an employees prolonged absence.
Allow me to illustrate with an example. An employee, John Doe misses 15 days in June 2001 due to an illness in the family. An AttendanceProfile record is then made for this period illustrating the exact nature of Mr. Doe's absence as well as tracking what official documents he has submitted (eg medical note, official company documents). Another matching record containing the same ProfileID is also made in the ActionLog table describing what the company has done so far to track this absence. So if an HR employee calls Mr Doe's physician to verify this illness or sends a letter requiring further documentation, each of these steps is listed in this log for this absence profile.
Sorry for the long-winded explanation, but better now than to have to clarify myself later. Here is where I'm stuck. I would like to set up two data entry forms, to create new AttendanceProfile records and related ActionLog records. Obviously, these corresponding records are linked directly by the ProfileID field. After completing the AttendanceProfile form, I would like the user to be able to click a command button to open another form (I am avoiding a subform in this case because my attendanceProfile form is huge and I cannot conveniantly fit a subform on it) to open a new form where they can enter Procedure descriptions and dates on the ACtion log. For each new procedure the user enters, an autonumber fields automatically increments the procedureNumber for that specific ProfileID.
Finally, my question to any of you is, assuming that I have already designed the AttendanceProfile table and form, how shall I design the ActionLog table AND forms to accomplish this exact task.
Once again, sorry for the excessive detail. Your assistance is greatlys appreciated.
Regards,
Mike J.
General :: Creating A Database Full Of Contacts
Jan 2, 2014I'm creating a database full of contacts. I have a contacts table with detailed info on each contact and I also have a company table with details on each company - all companies attached to a contact are in the company table plus a few others. I'd like to be able to pull up a company profile and see all the contacts we have associated with that company displayed in a list.
View 1 Replies View RelatedGeneral :: Lock / Unlock Full Menu Based On A Password
Sep 28, 2014I want to lock down and unlock the full menu based on a password..
For instance upon load of the database I would like it stripped down when a general user logs in... but if a admin logins in then they get all menus...
so based on the user type will dictate the menus visible.. cane this be achieved'''''''''''';
Forms :: Subform Full Of Check Boxes
Jun 20, 2013I need to make a form that lists 120 checkboxes and then adds an associated value to get a total.I have a table with Description field (i.e. aspirin) and a Points field (i.e.2). I need to make a subform that shows 120 checkboxes and when the user checks the boxes the associated points are totaled.
I have tried using a default value for each checkbox which works except I can't get the subform to add a new record when I move to the next mainform record.how to make a form where I can see all 120 items and give the use a choice to check 1 or all of them and get a total?
Getting All Forms/queries/tables To Show Up Full Screen
Jul 5, 2007Is there a place I can insert a snippet of code to have all the forms come up full screen. Some users think it is annoying that they dont always come up maximized. Any help would be greatly appreciated!
View 12 Replies View RelatedForms :: Full Path To Images Are Stored As JPG In ClientTable Not As OLE
Sep 27, 2013I have several text boxes which I can populate using the DLookup.I have images I want to display for individual records.I use a search (textbox) to input client name and this populates all other textboxes. I am trying to get the relevant image to display also using this search box. I have also disabled record selectors just tidy up the form. I have tried coding the image control on the AfterUpdate event of the search box. Full path to images are stored as JPG in my ClientTable not as OLE.
View 2 Replies View RelatedForms :: Application Running In Full Version But Not In Runtime?
Apr 11, 2014I have a small database application which is split in fe and be. Its running fine and i have been making changes to the front end regularly and replacing the file on server successfully with no problems, But today i edited some forms and reports and afterwards i ran it on a client in access runtime produced the on click event error ( which is on log in form which is a startup form ). Its working fine in full version of access even on the server but couldn't log in because the clicking on login button display the error. See attached image.
View 6 Replies View RelatedForms :: How To Make A Form Show NOT Full Screen
Jan 7, 2014See my 2 attachments. I put the Pop-Up property on the form. that worked but still not what I want.
On the HATT attachment do you see how it opens in the middle of the screen? And the other opens at the top right, (and has that tab at the top right that says frmMain)?
how do i made the airwatch open in the middle? like the other screenshot?
Forms :: Full Info For All Property Options Of Any Form Control
Jun 26, 2015How to set all controls in the form I would like to get complete information about all property options.
View 6 Replies View RelatedForms :: Field Doesn't Show Full Length Of Record
Dec 4, 2013My form which is based on a table carrying same name doesn't append the full length of the text to one of the fields.
I don't know where the mistake is occurring or indeed I don't know if the error is in the table or in the form.
The form is showing full length of the text but when I look it in the table, it has just one or two bits of the full length.
Forms :: Open Form To Show Full Details When Double Click On Subform
Jun 16, 2015I have a subform 2SiteList (Datasheet View) with the field SiteName... i also have another form SiteDetails.
if possible i would like to be able to double click on a SiteName on the subform and have the SiteDetails form to open to show the full details.
Frame Issue
Nov 1, 2005Issue
I am using frame for presentation purpose in the form. The frame is in the background and all the text boxes and labels are populated on top of it. When ever I click on the empty portion of the frame, all labels disappears. All I see is values in the text boxes.
I think I need to disable on click property of the frame. Just don’t know how to do it.
Please do comment.
Thanks in advance
Deleting Similar Records Within 1 Second Time Frame!!
Apr 22, 2006Hi guys,
need your help again with the following problem i'm having. I'll give an example to make the problem clear.
I have a table, eg table 1 with the following records:
Tag________Desc________Msgno____DateTime
016GB001___Alarm OFF___1403______21/4/06 11:02:02
016GB001___Alarm OFF___1605______21/4/06 11:02:02
034GB005___Alarm ON____1403______21/4/06 11:02:04
016GB001___Alarm ON____1403______21/4/06 11:02:07
016GB001___Alarm ON____1605______21/4/06 11:02:07
048GB001___Alarm OFF___1403______21/4/06 11:05:31
048GB001___Alarm OFF___1605______21/4/06 11:05:32
048GB001___Alarm ON____1403______21/4/06 11:06:51
048GB001___Alarm ON____1605______21/4/06 11:06:52
I need a query that looks at records with similar Tag fields that occur with a 1 second difference between them and deletes those with "1403" in the Msgno field. I'm a newbie and i've got no idea where to start. The query should return the following records:
I have a table, eg table 1 with the following records:
Tag________Desc________Msgno____DateTime
016GB001___Alarm OFF___1605______21/4/06 11:02:02
034GB005___Alarm ON____1403______21/4/06 11:02:04
016GB001___Alarm ON____1605______21/4/06 11:02:07
048GB001___Alarm OFF___1605______21/4/06 11:05:32
048GB001___Alarm ON____1605______21/4/06 11:06:52
I hope the problem is clear. I know this is going to be one heck of a challenge, and i'm not sure whether this can actually be done in access!! Anyhelp from anybody would be enormously appreciated. Hope to see a solution soon!!
Kind regards,
Monty
Display Remaining Units Within Time Frame
Jan 4, 2013I have a database being used to track and bill therapy units. I have a table that stores the pre-authorizations that tells me within a [start date] and [end date] I am limited with X amount of units (that is all the client's insurance and/or funding source will pay for within the time period). I also have about 4 different codes I can be authorized for which is also stored in this table - each code a separate pre-auth record.
Another table is where I enter in the type of therapy (service code) I've completed with the client. I put in the Service date, start time and end time and it will automatically give me the amount of units to bill (1 hour=1 unit). If I happen to choose a code or enter in a service date that does not match up with a client's pre-auth (Service date is between start date and end date and matches code from pre-auth table) I have a simple text box that says "No auth for this code or service date" due to an IIF statement in a query. I'd like to take this a step further and give me the remaining units for the pre-authorization left when it does find a match.
What is happening is when it finds the authorization, it's not taking into consideration all the services I've done for that time frame. For example: I have a pre-auth from 12/1/12 to 1/31/13 for code 90806 for 12 units. I served the client for that code a total of 10 units thus far. I can't figure out how to link my 4 service records dated 12/3/12 (2 units), 12/16/12 (4 units), 12/27/12 (2 units), and 1/3/13 (2 units) to add together and then subtract from my auth for 12 units. I know the dates are the key but I'm lost.
Designing A Database
Aug 19, 2005Could someone please give me some help with designing a database in access.
I know excel really well, and took a class on access, and have tried a few times to get started with access but always to no avail.
I have a company that installs real estate signs
1. we have about 200-300 agents (which represent about 10-15 offices)
2. 3 things can happen to 1 sign -
-1. installed the first time (charge)
-2. have a sold sign, for sale sign, or flyer box put on(charge)
-3. Finally removed(free, no charge)
-4. the date would have to be tracked on all of these occurences
3. We have about 10 products or things that can be put or hung on a sign.
I can set up the offices and the agents, and link them just fine. I can set up the products and do the work detail. The problem I have and cannot figure out is trying to bill or invoice this. Some agents are billed individually and some agents don't get billed, there office gets billed as a whole. Could someone please offer some insight on how maybe to go about this from the beginning.
Thanks for any help
Josh
Designing A GUI For A Database
Jul 17, 2007Hi
I've been asked by someone at work to design a "no brainer" gui for an access database but I am a complete newbie with regards to this - sure I can do simple queries to filter the information I what in design view but this is something else.
How can I design a gui that can be clicked on or is executed when the mdb icon is clicked that will allow people to access from a drop down box the area they need information about and then have to option to either have the information exported to excell or in a summary report to be printed off. Should I use the form wizard or the report wizard - though none of them seem to do what I want.
I've set up the database from the excell spreadsheets they gave me containing activity figures per operational region. The regions are listed in the first column and I wanted a drop down box to list them.
We have 6,000 entries on the database. These cover 8 regions with some regions containing maybe 500+ entries. As mentioned the regions are listed in column one of the database.
When I select the regions column in a drop down box instead of getting just one entry per region, I get every single entry for example 500 for region 1, 200 for region 2 etc. In other words it is reading the rows not grouping them according to region which is what I want
How do I group them so Access only includes one entry per region on the drop down box and what is the best way to design the gui to give the results I am after?
Thanks
Andrew
Please Help In Designing Tables
Nov 29, 2006Hi all,
Excuse me for being new here...but i need some advice on a database im working on. Im currently in a school trying to develop a database that records my students' participation in some arts activities.
What we need is a database that could capture the number of participants that actually went for a particular event (sounds easy rite? - :rolleyes: ).
To break it down:
1. The EVENTS are broke up into 3 categories : Exposure, Experience & Excursion.
2. Each EVENT consists of the number of PARTICIPANTS that is divided into Students, Teachers, Parents and Alumni.
3. Lastly, the PARTICIPANTS are further seperated into different interest groups such as Band, Choir, Drama Club etc....
It is quite overwhelming for me as im not that experienced in using Access..so i'll be glad if someone could help to advice me on how i should design the tables and their relationships.
Thank you.
Cheers! :D
Designing Tables
Jul 29, 2007want to create a database for our college examination cell. I wanted to know hwo I can create such a table:
RollNo. |------Subject1------|-----Subject 2-------| .....
-------| Theory |Viva| Total |Theory |Viva | Total |.....
There are around 6 subjects.
I want it soemthing like subject1.theory, subject1.viva etc
I know that is not exactly possible in MS Access, so could anyone tell me the best way to do it. I somehow wanted the subcolumns to appear as part of the subjects. (as we can do in excel)
I thought of naming them as sub1_theory, sub1_viva....... but not too happy with it.
any help would be appreciated.