Search results

A dialog box may be useful, but I think having a checkbox that indicates NA and enters a value in the table that will never be used (e.g. 9999) is probably the best option to make sure that something is always recorded for that field.

Thanks for the suggestions and ideas. I need to field to always have something in it, so we know if the person recording the data didn't just accidentally skip over it and forget that value. A flashpoint can be 0 (zero) and also can be a negative (theoretically, up to absolute zero). I...

I have a field where I'm recording the flashpoint of materials. The majority of the time, I'll have an actual number of the flashpoint (e.g. 100 or 140 or 200) but sometimes, I won't have a number or a number is not applicable. Is using a combo box the only way to integrate an "N/A" solution...

Awesome, that's handy to know. Thanks again for your time, you've been a huge help!

So this references column E?

Works perfectly, thanks! Your solution isn't close to any solutions I tried.

I have this snippet of code I found and it works perfectly. It concatenates cells and applies a bold formatting to only one part of the concatenation. Except it only works with the referenced cells (A1, B1). I am looking to have this work for each row automatically (A2, B2; A3, B3, etc). Sub...

Yeah, I thought about that too. Until yesterday, the entire string was basically only used as a unique tracking number. Now there is a requirement to show how many numbers (the sequential part) were created on each day for each week.

Thanks, your solution worked perfectly. I didn't know that I could structure a query like this. Super helpful!

Thanks, I will try this. The 0000 is a typo. Should read 0001.

We have a field that we track paperwork with that is 9 characters. The first 4 characters are a 'julian date', the 5th character is a dash and the last 4 characters are sequential. example: For today, we would use 4085-0001, 4085-0002, 4085-0003, etc. For yesterday: 4084-0001, 4084-0002, etc...

Thanks for the reply. That snippet I used is something I found somewhere else. also, I think you're right about using .value instead. I guess setting a value as default is the wrong terminology, since I don't want it to always be default. I just wanted something that I could populate my...

So I could set a query as the record source for the combo box, and set the text boxes equal to each column of the combo box?

I have a blank form that is usually entered from scratch, so all the fields are empty. We do fill out the form with standard data occasionally, so I'd like to be able to assign a button or use a combo box to automatically fill those fields with predetermined data. Two questions: 1) Can I...

Thanks for the links, jdraw, I'll definitely check them out in depth when I get a free minute. CJ - the extra table I'm looking at adding will be used solely for limiting data in a set of cascading combo boxes so the data in the new table will be pre-populated. Looking at this again this...

See attached photo (sorry for bad quality). This is how I have my database set up currently, except the part highlighted in red. I was asked to see if I can use the CAT (one) to narrow down the CLIN (to many) and this is how I think it should be structured. Is it okay to have this kind of...

Thanks for the help!

I suppose so. I didn't see any qualms about the way I set up my tables.

Yeah, that's how our process works, and how we get the cost. We pick CLINtype, and the CLINunit is narrowed down. And the cost is associated with the unique combination of CLINtype and CLINunit. I haven't set up the operation too 100% completion because I wanted to make sure my table set-up...

While the cost information may be the parent to the CLINtype and CLINunit, we look things up by CLINtype and CLINunit to get the price since there's so many CLINtypes. I see how your example would work but the products we deal with aren't clear cut where I can have a product table, per se...