Search results

The fact you have another table with more fields is irrelevant. It is what is stored in the fields which matters more than how many. A number field with a large number is going to take up more room than a number with 1,000 in it. And the text fields can add up to, especially if they happen to...

And that would actually be incorrect. Access doesn't pad things like the SQL Server Data Type Char. So are you trying to change the size of the field while all objects are closed except that table?

So, you want the border color and width to be changed for text boxes, list boxes and combo boxes? And do you want the one that has the focus to be the one changed or do you mean all at the same time? And just some info for you - controls on different tabs are still just controls on the same...

Different problems really should have their own thread.

What version of Access are you using? You should be able to use CONDITIONAL FORMATTING as there is a selection which is instead of VALUE IS to CONTROL HAS FOCUS.

Yep, even though Access can handle 255 fields, the amount of data in the fields, except memo fields, still can't exceed the "page size" of 4Kb per record. So, depending on what you are trying to store, you could be hitting that limit.

Something good to read regarding this. http://www.kallal.ca/Articles/split/index.htm

I meant what is the SQL of them.

Is it a WEB Database (a specific type in Access 2010) or a regular one? You would normally keep a table of points and it would add a RECORD to the table if an order was over that amount. You shouldn't be updating a field to the value. Adding a record and then pulling their total via a...

Are you doing this in an Access 2010 or 2013 WEB database? If not, you should not be having calculated fields in your tables to begin with. That is what queries are for.

My question is how different are your queries? Are they different just in criteria? Or at least are several like that? You don't need to build queries for each criteria. You don't even need to have a query for each product type really (unless you have a non-normalized structure where there...

If it is a true Yes/No field, you just put FALSE (no quotes) or TRUE (no quotes) in the criteria (if you are using the Query By Example Grid). And for the date field the criteria in the QBE Grid: Is Null or Is Not Null

There is no set place. How do you want to deal with them? If you want it to happen just after you do an import via code, just put it into a standard module and then call it from your code. I would suggest the procedure get modified to this, because if you have more than one Import table, it...

Here you go. Take a close look at the function, the after update procedures of both combo's and the Current event of the form. You don't need the code in the form's AFTER UPDATE event so I deleted that.

Sorry, I have been unable to visit the forum recently. I am kind of confused as to what you actually have and it would probably work best if you can post a copy of the database with fake data. I think we could clear this up quite quickly if we could see what you have.

I've been unable to visit the forum for a while. But I have to say that I'm not sure what to tell you. Your inputs are quite complex and, from what I remember of your database (I did check back when you first uploaded it but then had issues which prevented me from coming to the site) it is in...

Yes, it makes sense and what I wrote before still stands. And I would change the field name in the Agents table to AgentID instead of just ID. It makes things much better when working with things. Same with the Table1 ID, but with that one that would be much like what I originally posted...

Get rid of the 0 as it is in the Encoding Parameter and that is not a valid option. Also, can you post the exact code you are using? Don't remove anything so we can see what other things might be conflicting.

Welcome to AWF. Unfortunately it sounds like your data is not normalized and therefore is going to be a much bigger pain to deal with than it would be if it were normalized. If it were normalized then it would be easy to do. So where does this come from and how do each of the fields relate...

It isn't the Control Key, it is the SHIFT key.