I have done this before and can't remember how I did it and I can't fogure out how to do it. I have a form with textboxes that are for displaying info to the users. I want to lock them so that users can not click on them or high light the fields. So basically the user can only click on fields I want them to.
View RepliesI have a Inventory DB and i want to integrate scanning. So far i have a table called StockInfo, this table holds information about bar codes (device type, make, model). I have a form called Scan_Barcode, on this form I want to be able to scan a bar code into a text box (text0) and use a afterupdate and requery function to display the results onto a form called EnterInventory.
Not only just the results but I want certain columns from the query to display in certain text boxes on this form. I have a query called FindProduct. that filters the criteria by whats entered on the Scan_Barcode text box (text0). So when i scan a certain bar code i can get the query to display certain product information for the bar code. I just cant get the results onto the HarwareStock form.
I working with Access 2010 and a form with criteria controls, a requery button and a subform that displays the query. I wanted to add a text box that would display some aggregate information about the query results. Like how many results were returned or what the average is in a column of numbers stuff like that.
If at all possible I was hoping to have the text box display aggregate information of the whole query but when a specific entry in the table is clicked I was hoping to have it show aggregate detailed information about that entry opposed to the whole table. So I am not sure if that changes the solution but I wanted to put it out there.In my searches it looks like Dlookup is the way to go but I have seen a lot of people use Dlookup in very different ways so I might be wrong.
Ok, nobody chew me out... I know there's over 500 posts regarding calendars on here because I've read just about every single one and haven't found any answers yet. All of the posts that vaguely resembled what I'm looking for had no replies.
Here's what I'm trying to do:
First I've got 4 tables, each has different data including a start date, start time, end date, end time and description. Each table pertains to a completely different subject. The tables are already populated (imported from excel).
I've got a form with a calendar control (Ms Cal 7) in it... and that's about has far as I have gotten.
I would like to be able to open the form and have the calendar show all events for the current date (i found how to make the calendar show the current date, it's just populating the text boxes that I'm having a problem with).
So, here's how I would like it to work...
When the form is opened, you can click on a specific date (or don't click anything and it shows the current date). Then the textboxes show the info for that date.
Example:
Calendar = 4/20/2005 (Calendar control here)
Textbox1 = select from table A where subject="codereds" and start date = calendar control date
Textbox2 = select from table B where subject ="codeblues" and start date = calendar control date
Textbox3 = select from table C where subject="codegreens" and start date = calendar control date
Ok, anybody got a clue on how I can do this because I've had no luck finding it anywhere.
Thanks ;)
I am trying to create a form where I store the literacy and numeracy results of a group of students. So far I have designed a form which gives me a tick box as to whether the test they took was literacy or numeracy, then a box where I enter the score. Literacy tests are scored out of 72 and numeracy out of 50.
what I would like to do is write something that shows the literacy numeracy levels of each student after each test. So for literacy, the score ranges are as follows:
0 - 13 Below Entry 1
14 - 32 Entry 1
33 - 52 Entry 2
53 - 65 Entry 3
66 - 7 Level 1
What I would like to be able to do is tick whether or not they sat a literacy or numeracy test, enter the score and the db to come up with their level and display it on the form.
I have several combo boxes and textboxes showing quanity,productname,
size, and price. How can I pass all of this info in a single row that also calculates
the quanity and price. Also, multiple selections can be added, so several items can
can added in other rows. THe ability to cancel each row would be required as well.
Thanks
I have strange issue when creating auto populated text boxes which displays rows from combo boxes.
In one database auto populates works with simple text box Control Source edit "=[ComboName].[Column](NumberOfColumn)".
Somehow same method doesn't wotk in different database: here one time I have to insert VBA code at On change Event:
Me.TextBoxName = Me.ComboName.Column(NumberOfColumn)
And other time it wont work with On change but only with After Update Event (code is same).
Another thing this morning happens was that when I tried to add new record trough form where combo box and tex boxes are located, MS Office suddenly stopped working after selecting combo box selection (with message Microsoft Office has Stopped Working). It is 2013 version.
I got it work after deleting and re-inserting VBA code to autopopulate text box at After Update Event.
I am trying to obtain totals from two columns in the list box into text boxes on the main form, but my third argument is not working as expected.The source of one of the tex boxes is:
Code:
=DSum("Airtickets","T_Training_Participants.ProgrammeID=Me.lstParticipants")
I want to sum only amounts of the records that equal or belong to a selected programme (ProgrammeID) in the bigger list box above.
I have a form that is displaying a subform (of which source is a query). I have got the data from one of the columns in the subform going into a text box (entered in the control source) however when the field is empty it comes with a #Error in the textbox.I want the textbox is display some text is the subform value is null.
View 11 Replies View RelatedI have a table called Client Info which stores the clients name and their requirements (Gas safe etc). And I have a table "Job List" where i select from a drop down menu the clients and it auto fills all the requirement check boxes based on what is stored in the Client Info table. However I can't get the code to work.
Private Sub Client_Click()
[job_list].[Gas_Safe].Value = [client_info].[Gas_Safe].Value
End Sub
I am currently developing a database to provide a friend with an auction tracking and ordering system.
I will have a number of questions the first is related to the Home Page/Dashboard/Summary form I am creating. I basically have a few sections, one of which is a combo box offering the user to select an auction to view in the summary section. This summary section contains the list of lots but I also hope to to expand on this and create multiple text boxes, each containing the answer to a number of queries (totals etc).
I have written all the queries and can see the results however as the form does not have a record source I would like to know how to make each text box populate with the result of different queries (ideally in vb - I am using ms access 2010)?
I have tried a few things, control source doesn't apply as I have no record source (i guess). I investigated Dlookup/Dcount but am unsure if these apply for the same reason. I understand I am likely to need a recordset etc in vb and have already tried a few things but unfortunately none of them work.
I'm trying to build an database for aircraft operators. I've got the basic tables structure and relationships but I'm stuck on building an search form to filter records by user input.I've got following controls on my form (unbound):
1. AircraftType (combo box) from tblAircrafts
2. CompanyName (combo box) from tblListOfAircraftsOperators
3. TeailNumber (text box) from tblAircraftOperators
4. AirportNameSearch (combo box) from tblAirports
5. PassengersNumber (text box) from tblAircraftOperators
6. ManufactureYear (text box) from tblAircraftOperators
7. SourceSearch (combo box) from tblInfoSource
8. CountrySearch (combo box) from tblCountry
9. CategorySearch (combo box) from tblAircraftCategory
10. EamilToOperator (text box) from tblAircraftOperators
11. InteriorPhoto (Bound object frame) from tblAircraftOperators
12. ExteriorPhot (bound object frame) from AircraftOperators
I need to enable users to search for aircrafts based on those criteria. As I mentioned I'm new to Access and I don't have any advanced coding skills. I have a query build to perform the search and this is the code I've managed to write so far:
SELECT AircraftOperators.RegistrationNumber, AircraftOperators.PassengersNumber, AircraftOperators.ManufactureYear, AircraftOperators.EmailToOperator, AircraftOperators.ExteriorPhoto, AircraftOperators.InteriorPhoto, tblListOfAircraftOperators.OpratorName, tblAircrafts.AircraftType
FROM tblAircrafts INNER JOIN (tblAirports INNER JOIN (AircraftOperators INNER JOIN tblListOfAircraftOperators ON AircraftOperators.CompanyName =
[code]....
I'm wondering is it possible to create a multiple parameter query which will return results even if you leave some of the parameters blank ?. I'm trying to set up a Form which will allow users to select parameters using combo boxes but at the moment you need to fill them all in or you'll get no results...
View 10 Replies View RelatedI have a form with text boxes and after I click on the text box, the field gets grayed out. I can still read my text but I would rather it have it stay white.
MS Access 2010
I have 3 tables.
One is a list of fishermen with all their info. I used a Code as the primary key.
The 2nd is a fish ticket sheet with fish tickets entered and the code in there as a foreign key in the relationship between the two.
I create a report listing the fish tickets and prices perfectly for the 4 fishermen I have entered fish tickets for. (I have 140 fishermen in the main table)
I added a 3rd table for payments made to the fishermen. There are two payments for 2 of the fishermen.
then, I go into report design view and drag in two of the cells from that 3rd table into my report.
The problem is the report then prints JUST the fish tickets and payments for the two fishermen that have payments...not the info for all 4 fishermen. I need to print out settlements for all the fishermen whether they have payments or not?
I am trying to search on EmployeeID field and populate corresponding data like EmployeeName, EmployeePay in other text boxes in the same box .
In my Unbound Form I have three unbound Text Boxes and one Command button:
txtEmpID
txtEmpName
txtEmpPay
cmdFind
In my table EMPLOYEE i have three fields
EmpID -- Autonumber
EmpName -- Text
EmpPay -- Text
I have an access database and I plan on splitting it so the FE will be on each users workstation and the backend will be in a folder on the server. But is there anything else I need to do to allow for the possibility of multiple users using the database and changing info at the same time?
View 4 Replies View RelatedHi
I am pulling my hair out with what I am sure is a simple task, creating a search form that, when criteria are entered, finds a record and displays related data/results from 3 tables. I have tried every forum and web post I can find but I think there must be something fundamental I'm neglecting to grasp.
Quick background:
My database has 4 tables, Firm, Contacts, Mailout and FileNote
The database is contact-centric (ie, everything is linked to a contact record, multiple contacts are held against firms, mutiple file notes are held against a contact, contacts can be attached to multiple mailouts)
I need to search for a contact record based on multiple criteria (keeping it simple, lets say a combination of first_name & last_name OR first-name & firm_name OR their specific contact ID)
I need a 'results form' (not just a datasheet view) that displays all information related to that contact (i.e. all files notes + ability to create new ones, firm contact information, and mailout history)
I've created a Main form with Firm, Mailout, Contact & Filenote subforms embedded that enables me to scroll through every contact and view all related detail (as above) and add file notes & modify data very nicely. My problem is I can't search, I can only move through each record sequentially. Very handy when we have 4000 contacts!
I realise I'm probably a complete wally but could someone please explain to me the vital steps I'm missing? I've tried unbound fields, I've built SQL queries & command buttons (but results are dumped into a datasheet)....I'm lost.
Many many thanks.
I have a table which has a yes/no field, in the table everything displays as either Yes or No, unless you click on it to edit it, whereby No become 0 and Yes becomes -1.This isn't a big problem as users can only access forms. On the input form this is a check box, checked for Yes and unchecked for No. This used to be a drop down selection box of Yes and No and the same problem was occuring, so I know the problem doesn't relate to the check box.
I have a second reporting form which has multiple combo boxes to filter down results in a subform. In the subform the field correctly displays as Yes and No, however, the filtering combobox for this field has the options 0 and -1.
The combobox is set up as Yes/No, the table is Yes/No and the results are Yes/No. There is no other formatting or input options that can be changed to tell the database this is a Yes/No field.How can I get this combobox to display as Yes/No? It's causing a lot of confusion with users as they are having to select 0 or -1.As a note, I've already tried the following:
-Deleting the combobox and starting again.
-Deleting the table and combo box and starting again.
-Deleting all tables, queries and forms which use this field and starting again.
None have worked, this seems to be something Access is doing rather than an error in what I've done.The filter form uses this code, which may be the cause:
Code:
Option Compare Database
Option Explicit
Private m_colCombos As Collection
Private m_strFilter As String
[code]....
I have a report and at the footer i want to show how many of the txt boxes i have are >0
i tried
=Count([txtbox]>0)
I know that this is quite simple but i just cant get it.
I a a new user to Access having only every ceate a couple of small databases using the wizards. I have just started a database where I have created my tables and I am now creating a form to display information. The problem that I am having is that when in Design mode I can see all the information and fields that I have used to create the form, however when i save the form then opening in display mode I do not see any of the fields, revert back to design mode and hey are all there.
View 14 Replies View Relatedhow to have users drag and drop a document into a text box within a form and have it create a hyperlink. What I need to know now, is if there is a way that when a file is dropped into the text box, it only shows the icon associated with that file, or at the very least, edit the hyperlink to only show a certain text. The files I need to see are all in a networked drive, so the hyperlink addresses can be quite long, and ultimately I'd just like the hyperlink to say "letter". Showing the icon would be a plus.
View 3 Replies View RelatedI have one table (500 Club) with two fields (ID) (Name) i would like to randomly pick a record from the table and display the results in two seperate text boxes on a form one for (ID) and one for (Name). I intend to use this for a monthly draw at my workplace.
View 6 Replies View RelatedI wanted to send a message to the person who created this sample database with a modification query but I don't have enough posts to do this, so my message would not send.
The below sample database called
Sample - Use Hidden Form to Log Users ,URL...
I would like to add to my database. Any way to modify the form/code so that I can log more than one form? I have 5 forms that I would like to log user in and out of but I dont know how to adapt this to do that?
I was wondering if it was possible to be able to make changes to a form whilst others are accessing different forms.
At the moment, if i am editing the database any user trying to access the database gets a error warning them, they the database is in admin.
But if another user is in the database while i am trying to change a form / report, i am unable to save.
I no the simple way to do this would be to do changes whilst no-one is in. Its just some minor tweeks need doing during the day.
I've attached a link below:
Basically, its a database for an entertainments agency, I've got a form for 'Artists' which shows the performers on the agencies books. I've tabbed the form so one screen shows the artist details and I want the second screen to show the bookings that the specific artist has.
I've linked to the 'bookings' table on the subform successfully, but I can't figure out how to filter it so it just shows the bookings that the specific artist showed has.
i.e.: I want it so that The Deltatones booking tab ONLY shows the deltatones bookings.
Here's the dropbox link : [URL] .....