Search results

Thank you for your input. Does this also work for form controls? I can't seem to get it to work?

Could you please educated me as to why this is not logical and sensible? The only reason I have it structured this way is because it worked for my Excel version. The first part of the three part code represents a client, the second part a site and the third part a segment of that particular...

Sorry yes I am referring to controls on a form, not fields in a table. I'm very new to Access, trying to get up to speed. Concatenating is the term I was looking for.

Hi I have three input fields: Q_1, Q_2, Q_3. If the values entered are 001, 002, 003 respectively I would like Q_4 to display a combination of the first three fields i.e. "001-002-003". This is incredibly easy in Excel, is it possible in Access 2007? Thank you

Hi I am in design view of a form and trying to independently adjust the field sizes. When I attempt this it adjusts all seven of my fields at the same time. How can I separate them to adjust them one at a time to different sizes? Access 2007. Thank you

That solved it. Thank you.

Hi I am currently creating my first Access database. My expertise is only in Excel so I'm in the process of making the transition. I have created a datasheet form and all I am attempting to do is create a simple drop down list of values for one of the cells. I'm sure this is ridiculously easy...

Hi Paul Thank you for your input. That's an encouraging start and I've already learnt a couple of new things there regarding subforms and master/child links. The mountain already seems more climbable. :) Any further advice appreciated. Enjoy the raquetball. Rich

Hi all So I have an invoicing and orders and dispatch system for my manufacturing company which I designed in Excel and it works fine. The problem is that the company has grown to such an extent that I now need multiple users to be inputting data into the database simultaneously which Excel...

Hi New member here. :) I'm reasonably experienced with Excel but highly inexperienced with Access. I need to get up to speed ASAP to convert my company invoicing & orders system from Excel to Access to allow multi-user access. I'm hoping this is the place to learn. Let the education begin...