General :: Parking Slot Warehouse Database - Altering Available Options In Combo Box
Mar 1, 2014
I am new to MS Access. So I am making a database for an automobile warehouse. When a new car arrives at the warehouse, it is allocated a specific parking slot (using a combo box available on the 'New Arriving Car' form).
However, once a specific slot has been allotted, the end-user should not be able to allot the same parking slot to other arriving cars, until the original car has left the warehouse so that the parking slot becomes available once again. Currently, the parking slot combo box shows all parking slots whereas it is supposed to display only unoccupied parking slots. How can I enforce this? (Note that there is a separate form called 'Exiting Car', which is filled when a car is leaving the warehouse).
Fyi, each car is referred to by a unique 17 digit code - so this is the primary key. Also, there are 120 parking slots available in all, with the slot identifiers ranging from A1, A2...A12 to J1, J2..J12 (10 x 12 = 120).
View Replies
ADVERTISEMENT
Jul 6, 2013
What I am trying to do is create a master table which references the every other table.But the primary key references another primary key.I can get the combo box to display all the options, buy shows options already selected for other records.in other words...
I have 4 reference IDs from table A.
(ID1, ID2, ID3, ID4)
Master_Table has a combobox to select between the IDs.
if record 1 has ID_1
Record 2's combobox will show all 4 IDs
If I only have 1 ID that can be put into record 4, it's combobox still
displays all 4 IDs.
What I want is: If ID3 is selected for record 1, it wont be displayed in the comboboxes for the other records.
View 2 Replies
View Related
Apr 30, 2015
I am working with Access 2007. I have a pretty good working knowledge of access. Here is my problem. I have a warehouse which supports four departments. The warehouse floor area is segragated into four areas. Area 1 department 1, area 2 department 2, and so on. Each department uses the same commodity, so I will have four of each item, belonging to each department. The storage locations will be unique and not repeated anywhere in any department. I receive and issue items for all departments.
The problem is how do I structure the tables and queries to receive an item for department 1 adding it to department 1 only and not have the item added to another department with the same item. Also to issue the item from a department 1 without effecting the on hand balance of any other department. I am too the point of creating 4 separate databases one for each department.
View 8 Replies
View Related
Oct 7, 2005
Hi there,
I'm working on my A2 IT Access project atm, and my aim is to produce a fully functional db for use by a golf course, incorporating membership information and tee-time reservation system.
I've got the membership side pretty much sorted, so now I need to start work on the reservation system.
But where to start?
Basically, the user needs to be able to view slot availablity on a specific day, and make/change/delete bookings quickly and easily. The booking also needs to contain the party size. The bookings themselves should relate back to the specific member that made it via the MemberID field.
The user should be able to make bookings upto 6months in the future.
Block bookings should also be possible, so that the admin can block an entire day out for a tournament therefore preventing member bookings.
The first available and last available slots also need to be editable by the system admin to take into account time of year, light conditions etc.
Right, so i know there's quite a lot there, and i'm sure i'll come up with more features that would make it better.
But as it stands, that's something to get me started.
I'm not asking for someone to do the project, just to point me in the right direction as to suitable table structure, how to "make" the slots, how to store the bookings in the table, etc.
So, any input and ideas are greatly appreicated.
Cheers
Gavin W
View 8 Replies
View Related
Oct 9, 2006
I am having an issue with a combo box on a form with the following query. It works exactly as it should, but unfortunatly, I need a little more.
cboASC is off a table, cboQCode is from values, If I don't fill 1 of the combo boxes I get a blank record (just fields).
What I need is an option to choose all Primary Locators and/or all Qcodes for a general report instead of a local report.
SELECT CallsEntered.[Work Order Nbr], CallsEntered.[Date Entered], CallsEntered.[Time Entered], CallsEntered.[Primary Locator Code] AS [ASC], CallsEntered.Headend, CallsEntered.Node, CallsEntered.[Grid Id], CallsEntered.[Q Code], CallsEntered.[Problem Code 01], CallsEntered.[Primary Finding Code], CallsEntered.[Primary Solution Code], CallsEntered.[Cancel Code], CallsEntered.[Scheduled Date], CallsEntered.[Wo Status], CallsEntered.[Date CheckIn], CallsEntered.[Assigned Installer], Calendar.Week, Calendar.Year
FROM Calendar INNER JOIN CallsEntered ON Calendar.Date = CallsEntered.[Date Entered]
WHERE (((CallsEntered.[Date Entered]) Between [Forms]![frmServiceCalls]![txtStartDate] And [Forms]![frmServiceCalls]![txtEndDate]) AND ((CallsEntered.[Primary Locator Code])=[Forms]![frmServiceCalls]![cboASC]) AND ((CallsEntered.[Q Code])=[Forms]![frmServiceCalls]![cboQCode]));
Your time and help is appreciated.
View 2 Replies
View Related
Jan 4, 2006
I just added a column to my table upon which a cascading combo box is built. When a name is selected from the combo box, 2 related fields populate. I want it now to populate a 3rd field. So I added the column to the table to input the data into that 3rd field, and adjusted the column widths and count in the combo box. However, when I indicate the control source of the 3rd field as the corresponding new column from the combo box, nothing populates in my 3rd field. I've tested it by designating one of the previuosly exisiting combo box columns and it will populate the data, but it seems to not be recognising my new column. I've also verified the properties of the new field to ensure that it is visible. What went wrong?
View 3 Replies
View Related
Aug 1, 2006
I have a form with two cascading combo boxes. The options available in the second box depend on what is selected from the first.
Some of the selections which can be made in the first box do not have any options to be selected in the second box and so it currently just pops down empty.
Is there a way that I can make the second box "greyed out" if there are no options for it?
Thanks,
Gary
View 13 Replies
View Related
May 20, 2014
I have two combo boxes in my form. The first one has the option of selecting a or b. If the user selects a, the second combo box will have the options of c and d, if b is selected the options in the second one will be e and f. How can i do this?
View 2 Replies
View Related
Mar 26, 2014
See the Main form of attached file, I would like to see contacts list box is made from drop-down list Customers. dependent
In the main form needs to select one customer (for example: Klant1), only the contacts 'de Vries' and 'Van der Linden' can be selected in the combo box of contact (in the main form) .. I do not succeed despite several attempts with macros to achieve this.
View 2 Replies
View Related
Jul 10, 2013
I just learned about Access 2007 since two days ago. I was assigned to do a database on the competency test records for my company.
I currently have 2 tables: tblCompetencyRecord and tblSections.
In tblSections, I have sectionname and sectionhead. PK is the sectionname.
I created a form from tblCompetencyRecord.
I have employee name, employee number, position, section, section head, test period, status and remarks on my form (like wise in my tblCR).
Now, I want to get Section field (combo box) to auto fill the Section Head field. I've searched high n low (i think), but i just couldn't figure it out.
View 3 Replies
View Related
May 9, 2006
I am a relatively inexperienced user of Microsoft Access, but my current problem has even the experts at my company stumped. I am hoping that someone here can help.
My company has an Oracle-based data warehouse. I can access its data just fine through TOAD and other applications.
However, when trying to link to the tables through Microsoft Access, it takes an extraordinarily long amount of time. My computer makes a noise as if it is searching for a file and not finding it, and Access goes into "Not responding" mode for five minutes or more. But--given enough time--the data WILL come up.
My Access can retrieve data from its own database, and other networked Access databases, just fine.
Does anyone know what might be causing this problem specifically between Access and Oracle?
Thanks in advance.
View 7 Replies
View Related
Sep 3, 2007
Hi all. I am considering developing a purchase order and warehouse management database, to be manage a cold store in my workplace.
What i have in mind is a system where the details of each pallet coming in is recorded (weight, quantity, location of pallet in warehouse etc.) is recorded, marked off against the corresponding purchase order number and then a label is printed with a barcode to quickly identify that pallet.
Handheld barcode scanners would be used to record when a pallet leaves the warhouse, and where its going to(despatch, production etc.). Ideally the scanners could be used to give forklift drivers order picking info aswell.
I'm fairly confident i can design the database, however, i have never done anything with barcodes, scanners or handheld devices. Is this even feasible with access? How do i go about doing it, any advice, example databases etc. greatly appreciated.
View 1 Replies
View Related
Feb 13, 2007
I would like to put my database that I have created online so I can update it from anywhere, and was wondering what are my options - does access have a feature to do this? Or will it involve using dynamic coding to update the tables? I would like to use the forms that I have already created etc ... but is this possible?
I have my own server if this helps?!
thanks
d
View 3 Replies
View Related
Jul 28, 2006
Hello,
I have a database with certain startup options for the end user. What I
would like is for the database to prompt for a password ONLY IF the shift key
is used to try and bypass the startup options, so that only an authorized
person with the password can see the background of the database. If I simply
set a database password from the Tools menu, it asks for that password with
the startup options as well, and I actually locked myself out of a database
that way! So there needs to be some kind of check for whether or not the user
attempted to bypass the startup options, and based on that, ask for a
password or not. I am not sure if I can do this through Access options
directly, or I will require some coding, but either method is fine.
Please help!
Thank you,
Kriti
View 4 Replies
View Related
Sep 17, 2015
I have set my options to protect my Db. I have unchecked "display navigation bar", "allow full menus", "allow default shortcut menus" and "allow built-in tool bars". After restarting , everything else is missing but the nav bar just wont go away. I have retried many times but, no go. I have even tried to change user levels on my login but it does not have any effect either.
Also, On my split Db FE, i created a new table 'USysRibbon' to set a default ribbon without the "options" function, but I can not see the new table on the tables nav bar. I remade the table, but it says it already exists. Why can't I see it. All the tables in my FE have the blue arrow next to them to show the redirect.
View 4 Replies
View Related
Oct 15, 2014
I've attached my database as I have it now. I am trying to create what amounts to an activity log.
I have created my main Subject and underlying related Issues tables, and a table for my daily activity notes. I have created my main form and subforms that should be sufficient (hopefully) for my purpose. Where I am getting hung up now is making the Subject and Issues fields combo boxes and filling them.
For the top-level Subject, I want to be able to type a new one in at any time, but also have the option to choose from a dropdown on the control as well. Then, if I do type one in, the next time I try to add a new record, it would appear in the dropdown as well. I think I have to query the underlying field to drive the dropdown list, but I cannot remember how to do that.
For the second-level Issue, there would also be a dropdown in the same way as the Subject control, and I want to be able to choose from the dropdown or add a new one in the same way... but I need to make sure that the ones that appear in the dropdown are related to the top-level Subject shown in the main part of the form. Of course, I don't want to be able to add an Issue unless it is related to a parent Subject. On these things, I am totally lost.
Finally, I built my notes to show in the subform as a continuous form, which I have used only once before. I'd like it so that the notes show newest at the top. And, I'm thinking about putting a "lock" checkbox on the note record so that I don't overwrite previous notes unless I consciously go back to edit something. I'm not sure how I can make an individual note dependent on an individual checkbox in the continuous form.
View 1 Replies
View Related
Mar 6, 2008
Microsoft Access 2003
Novice and working on a project with deadline... please help.
I have a table w a field that I want to convert into a combo bo and use data in the field as the options:
FIELD: Student Status
OPTIONS:
Enrolled
Suspended
Withdrawn
How do I get the combo box to automatically pull the values from that field into the options in the field when u pull down the drop down box?
Am I being clear?
View 2 Replies
View Related
Jul 31, 2014
I'm trying to use a cascading combo box to filter the options that can be entered into a second combo box.
In frmBabies, a Mode of Delivery is selected from 8 options. 4 of these are "normal" deliveries and 4 are caesarean sections.
A second combo box selects the Indication for Operative Delivery. The table tblIndOpDel contains options for normal as well as caesareans. I would like to filter the indications so that the user cannot enter an indication for normal delivery for a caesarean section.
Both tblIndOpDel and tblDelMode have a foreign key to tblDelModeCat, which categories deliveries as normal or caesarean.
I'm stuck on how to proceed from here. Sample database attached.
View 2 Replies
View Related
Jan 31, 2015
How I can create a Multivalued Lookup however with an add values option?
View 8 Replies
View Related
Jun 9, 2012
I want to use information supplied to me by suppliers as spreadsheets to create a database that i can navigate through by selecting from drop down options.
Example;
Imagine a product being broken down by its features, such as a washing machine.
Here is a list of what i would need to sort on,
Manufacture
Model
Type
Size
Price
Colour...and so on
So, if a customer asked "what 8kg 1200rpm washing machines do you supply for under £300 and in black" i would like to able to find all that info by drilling down a few selections.
View 1 Replies
View Related
May 8, 2015
Windows 8.1, Access 2013, Microsoft Office 2007 , Access 2007 uninstalled When I try to open Options from File, I get the Windows Installer box open up, Preparing to install.......wait while windows configures Microsoft Office professional 2007. File Options was working before!
View 4 Replies
View Related
May 18, 2013
Id like to create a search field on a form, with a similar function to the standard Access 'find and replace' function. Only id like it to be alot more simple than the Access find and replace form.What i have is a Asset DB for the IT assets in the company i work for. We have a lot of phones, printers, computers and about 120 Laptops. The laptops are quite often reconfigured and given to new users, so the laptop details dont change but the user and software config does. I need to keep track of what software is installed where, for licensing reasons.
What i have is a simple form with the laptop name, serial number, operating system, software, location etc etc. What i would like to be able to do is, type a laptop name into a Txt field, hit a search button, then have the fields of the form populated with the laptops current config and then be able to edit the details from inside the form. ive tried using a combo box but i have more than 20 fields that need filling, so anybody whos used the 'me.txtboxname.value = me.combobox.column (1)' may know that you can only use 20 columns.
The default Access 'Find and Replace' system works fine but i dont want users to have to use it. I also dont want them to have to navigate through records using record selectors.
View 5 Replies
View Related
Jun 16, 2015
I have a drop down list to select a committee, but my list is only showing half of the list. There's no scroll bar, and when I try typing in one of the others, it tells me it's not on the list and asks if I would like to edit the list. When I select edit the list, it shows all of them.
View 2 Replies
View Related
Apr 1, 2015
I have a Access 2010 database running in runtime. What options do I have for spell check? I can bind to a 2010 Word spell check (if it is installed), but could I do a late bind to utilise any other office spell check? Tried to use a .net spell checker dll and get access to call out the text and get returned the errors? Not sure what options I have really...
View 1 Replies
View Related
Nov 9, 2005
Hello, I use a database at work that I made. Unfortunatly, I did not add a field for numbering the items that a customer orders. When entering an order It is important to my customers to keep it in a certain order. how do I change it so it adds a numbering to all the past orders as well? I've been trying to think of a way for months and cannot do this on my own. Thank you to anyone who takes the time to help me out. If you have any questions I'll try to answer them the best I can.
View 6 Replies
View Related
Dec 13, 2005
I have a line chart built in Access. Is there anyway I can change the line colors like I can in Excel? The default fuschia, bright yellow, and bright blue are horrendous.
View 3 Replies
View Related
