Search results

It's been a couple years since I've dabbled in building a database, and I'm working on one that's nearly complete except for this one issue I'm trying to solve. I'm trying to create a combo box on a form based on a table that displays two text fields (while hiding the PK, so a 3-column box) that...

I'm working in an inventory database. I have a form where you can A) enter a new item/record or B) update an existing item/record. I have a combo box that I set up using the wizard to display the selected record on the form by referencing the ItemID number. Some ItemID numbers are 3-digits...

I made an inventory/rental database and I'm now in the process of fully working in it and of course I'm finding bells & whistles I would like to add. It has a search function that works well--user enters in parameters via combo boxes and it returns all inventory items meeting those criteria...

I'm trying to create several calculated fields (textboxes) in the Report Footer. My report is based on a query. I'm essentially creating an invoice with sums of line items. I'm very new to SQL and all of this, so I think it's something in my syntax, but I can't get some of them to play nice...

I'm trying to save a back-up of my database. Well, it's a copy of one someone here graciously corrected some issues for me that I've been working in all day and adding to. I'm working on a home computer, not connected to any work networks, etc. and it's giving me the error that it is in use by...

I'm working on a report that is based on a query. In the report footer, I've added some text fields with calculated values--basically creating an invoice and totaling specific fields in the report. The calculations are not part of the query. It was working just fine and doing all the...

I'm working on a report and am creating some calculated text fields. I have a checkbox, and if it is checked, I want it to calculate a value, and if unchecked return 0. Basically I'm trying to get: if checkbox = true, then count[field]*15 if checkbox = false, then 0 I'm very new and am still...

I have a sub-form that is not displaying data when I change records on the main form. Both forms are based on tables. I've been changing records on the main form via a combo box--works great, displays everything on the main form that it should. The subform is blank--I can enter in new data...

I'm working on a multiple item form where I want the user to be able to select an item from a cbo box, it autofill some fields, and the user can fill in the other fields as necessary. I got it mostly working, except one field does not auto-fill, so I'm beginning to wonder if it is how I have...

I have a multi-value sub-form based on an Inventory table where the user selects an InvnetoryID from a cbo box and it autopopulates the appropriate fields (setID and RentalRate). It fills SetID just fine, but will not populate RentalRate with the value from the Inventory table...

Before I even try to figure this out, I thought I'd ask if this is even possible. I'd like to create a Main form and a Sub form for managing a rental. The Main form would be based on a table of rental details (who the client is, the dates, etc.) The Sub form would be based on a rental...

I've written a search query to search tbl: Inventory with cbo boxes to select the criteria on a form. I have one criteria that is not filtering and I can't quite figure out why--it is set up exactly like all the others. SELECT Inventory.Photo1, Inventory.InventoryID, Inventory.SetID...

Hello! I'm new to all the things. I work in live performing arts and am using this um.....slower.....time to learn some new skills so I'm using Access to help streamline some of our production shop processes and inventory management systems at my company. I'm smack in the middle of the...

I've done a search through the forums, and found a couple threads that are similar, but I don't fully understand the answers. I have a query with various parameters on a form the user can select from combo boxes. I'd like to add a check box so that if it is ticked it will exclude any record...

Hello! I'm a very beginning beginner with both Access and any kind of coding. I'm running into a rather interesting issue with a select query with parameters not returning records that contain a specific value, even though they should be returned. I've posted in another forum, and the...