Search results

statsman, do a search on this site for custom autonumber. There hav been several good threads on this subject. It can be done, but it has to be done with code and not with an autonumber field, unless you do what rak suggests.

You don't want to store the calculated results, because with relational databases, there is no need to. Run queries on the raw survey data in you tables to obtain the scores needed. These queries can be the source of any report or form you want to present, or the query can be sent to Excel. Do a...

While you are in the Editor, check for missing or broken references.

Any chance you could make your report header a dynamic crosstab report itself? Then add it into the report you are working on as a subreport, in the report header. I've had to do something like that on a dynamic crosstab report I built.

Do a search here on Environ. I guess you could set up a bound text field in your data entry form to have a default value of the returned value from Environ. This would save the computer id, going by network or workstation log-in id.

It's not just that the Colts lost, they blew it AFTER the refs AND Bettis handed them early 2006 Xmas presents. They were given more than enough chances. I also thought Manning's "trying to be a good teamate, but..." schtick was really poor form. Sure, the Colts front line withered many times in...

You do NOT have to store the signature as an image. Sarah, I've asked before if you would post a version of your app here for us to look at. It does not have to include any real data. Make a copy and pull out any company logos, delete the table data and make up a few false records with...

Yes, you'll need a table for specs. You already have a parts table, so use the partID in the specs table. You should only need a partID field, attribute field (say for attribute "upper" or "lower") and spec field. The key in this table will be composite: both partID and attribute field, since...

Chad, the tables are looking good, except for the lookup fields. If you do a search on them here, you'll find most of the experienced folks here abhore them. I, too, built some of my first stuff using them, because Access' sample DB's used them, but it's not good practice. You and especially...

Do you report one result per each piece tested, per tub of pieces, or per truckload of pieces? Are you logging in now every individual piece you test (that was my impression), or is each tub an individual log entry, or the entire truckload an individual log entry? If each piece taken from a tub...

Chad, you don't necessarily have to use code. There are a few ways to approach it. You could have your main Log form, with an inspection subform and results subform directly on the main form. Link the forms by the Child:Master option in the main form's design view, linking inspection subform to...

Chad, take a look at this. Your individual tables for the possible inspections (Brinell, etc) were still set up to resemble a spreadsheet. You want to move away from that if you go to a relational database. I set up some tables and defined the relationships in the attached file. Note the names...

Chad, it doesn't matter if different parts require different inspections with this setup. If I understand you correctly, each part received is logged and then tested. The Log table catches the part then. The related Inpection table will have the logID in it for each required test and...

Yes she did. Search on nonnormal or on my name, as I posted in the thread she attached the sample in. It is pretty good, and I've used it to make a form set up to enter data in a non-normal fashion. Her example looks like a spreadsheet. It takes a couple of extra queries for each...

You need to get customerID out of the part table. The Parts table should have a partID and partdescription. Even if parts are specific to a customer (internal or external), it's probably not necessary to have it in the parts table, as you'll already have that noted in your log table. You might...

Where are the buttons located? In the form's Detail section (with a set of buttons for every record)? I usually put a Footer on my continuous forms for placement of command buttons. Haven't seen any odd behavior when doing this.

Nothing this big. Do a search, as there are recent posts on setting up an app that works with a small signature pad for capturing written signatures. Edit: Call or email this company and see if they have any Access apps to go withthe pad.

In the query's Design view, right-click up in the area where your tables are shown and choose "Properties" from the right-click menu. The 3rd line down is for Column names. Enter what you need there.

ghudson, almost every issue I've had, I've been able to run the answer down in a search, because of all the info here. It may take a while, especially in trying to "ask" the right search, but it usually bears fruit. I think the only big issues I had were a screwy text file import, dynamic Xtab...

Thanks for reminding me of this ghudson!!!! I'm working on a little parameter input form and I needed 2 sets of date prompts, one set with long date and one set with short date. The set with short date is equal to the set with long date, but I needed the 2 formats because of the underlying...