Search results

Would this make sense on a form for entering product testing data: 1. User selects product from a ComboBox (populated from a products table.) 2. On Change event: IF statement formats the tracking number field on the form to 5 or 6 digits. Each product in the product table contains a...

We have two main categories of products, and because they come from different manufacturers they have different tracking number formats. Is it possible to make it conditional? The data on which product something is comes from a separate table of course, so I could easily add a field for...

I've built a simple complaint tracking system, and part of the data collected is a tracking number. With the year turning over to 2010, the first digit is now a zero. This zero gets dropped when entering, and one some products that end up with two leading zeros, our tracking number loses two out...

I used the wizard to create a switchboard, and modified the design a little. The form view is essential a vertical list of command buttons with labels after them. Clicking on the label or the button will of course launch the form or report that it is set to. In design view, it looks much like...

That's something I struggled with even using forms at first. I didn't want a record to be able to be created without a complete data set. Eventually I found that I could make fields in the table "required" or not. There seem to be a lot of little things I pick up here and there. I've been...

New record button. Wow. I didn't even think of that being down there. Thank you! A quick google tells me that when in a form, "CTRL +" also creates a new record, so I'll have to try that this afternoon. While I could enter directly into tables for some of my forms, (this one is simply a...

Sorry I should have mentioned that. I am using the Data Entry Property. That was the only way I could find to limit people from being able to view records. I would use that AfterUpdate on the control, in this case the combo box, that is holding the data, and would... set the Default Value...

I have built a few simple forms for data-entry at this point, as I'm the only user of my database currently. At the bottom I've added two buttons, one called "Create &Another" which closes the form and then re-opens the same form so another record can be created. I did this because I don't...

Ah, good point. While I've been testing it by using the mouse to choose from the combo-box, I rarely do that when entering data. And as my store table is almost 1,400 records to start, maybe that's a good idea. Thanks!

Man, you're quick. Thanks, that's exactly what it was!

I don't think I'm putting this in the right place. I imagine it goes on the first combo-box. The one that if I change it, I need the second to be requeried. If I select a country now, "Access can't find the object 'me.'" I had put that line in the "On Change" property on the Country combo-box's...

Worked like a charm, thanks! Now I have a problem with population. If I try to choose a Province/State first, there is nothing in the list, since there is nothing in the Form's CountryID combo-box to match to. If I go choose a country, and then try to pick a province/state, it's still listing...

Ah! Again with the SQL. I think I'm starting to like this SQL stuff!

Yeah, that's exactly why I'm doing it. Nine times out of ten the complaint will come from the same state as the product is purchased, but every now and again you'll get someone who takes it over state lines and then complains. Even more rarely we get someone who is travelling abroad with a...

Alright, here's another two questions for you guys! I've started splitting more and more info into separate tables like I should have in the beginning. Example: tblStore had a column for Country, but it was just typed in. I've now created tblCountry, and changed that column to CountryID, which...

Oh. That was simple. I was trying to do it all with SQL. I guess they created a GUI for a reason.

After fixing it to ItemNumberID, it lists every product and the total of Quantities. Perfect. I have a field in "Products" called Obsolete that is a Yes/No. I check it off if the product is obsolete and no longer used. I've used that in my reports to only list data that is relevant to current...

If it were only that easy. I copied and pasted that, and looked up the sum() expression a little bit to try to understand what it was doing, and it doesn't want to work for me. I create a new blank query, switch to SQL view and paste that in. I switch to DataSheet view and it asks for an item...

That's what I've been trying, but I'm unsure how to get group totals. So far I've only been able to add a single Total row to the bottom of the query. Ideally I'd like to total it up by individual product, or at least brand. Would I need to create a query for each Product in order to get a total?

Wow. After creating a query, I can see the possibilities and power behind reports. And even when I had forgotten a field I needed, I just went back and added it to the query and then to the report. Easy peasy! Now I have another question, of course. I can export the report to Excel, but of...