Search results

Maybe it looks dead becouse is a lil complicated for me to understand what you need the db to do. I've looked at the excel and there are lots of calculations and for this you dont need a db. If u would like to take this outside the forum, my email is the same as the user, on gmail.

If you don't need to store the confirmation number (and i see no reasor for you to do it) you can simple put into control source of the confirmation field on the form this: =[field1] & [field2]. Field1 and Field2 and so one are the fields you want to concatenate.

I don't really know UK phone numbers format, but i think this could work: "+44 0 "000 000 0000. For the postcodes, you could use: aaaa"-"AAA. a is optional (letter or a digit) and A is mandatory. Try it! Feedback!

Your pic is unclear but u will have to insert data using a form and a subform. Use the wizard and it will make all the commections necesary for this to work.

In that case, for avoidin redoing the db, you can add a field where you will insert the id given by the customer. The autonumber remains pk and the customer id will be present only for activ clients, field required if client status is changed from waiting list to active.

I suggest one table, a status field (waiting list/approved). I don't understand why you need to re-allocate the ID. I'm confused.

Re: How to update number field in "many" table from autonumber field in "one" table The autonumber is not editable! So it is no possibility to update a field like this. No query will help. If you see the need for such a thing (changing and updating a index field), you better choose text ar...

MA 2007 also has a wizard for butons: in the ribbon, under Controls, you have to check the Use control wizard button. Then, click the Button button :). But, if you would like to use another method, you can create a simple button, on Event tab under on click field, you create a macro: action run...

Why wouldn't you use imput mask?

Could you upload a sample of your db? I dont see any reason not to work creating a relationship.

I cant figure it out eighter how to send pm. I dont know if it is ok to publish my email. If it is not a rule's breaker, my mail is same as username, on gmail.

Roughly, i sugest a db structure like this. You can insert "locality", "project", "site_type" tables again (i was to lazy), but other tables i see no point in inserting. You have to customize the forms; you can activate "aproved info" only when nom_status is "aproved". Also, restrictions, imput...

I hink i understand the intentions for your db. Not desregarding your work till now, i think you need to start over. The main reason is that in your current db you enter the same info more then one. Can i come with a db sugestion?

Maybe i could help if you describe a little your project. What your db should do?

On a closer look over your db, i see that u dont need more subforms, just one. I really don't understand the db that you are trying to create. There are a few unnecesary 1to1 relations. I have atached your db with a form (and a subform). !!!Also, you need to review your tables. I dont see the...

The way i see it is that you need to use a lots of subforms. What i dont understand is why u need tbl_sitedesignpara. You could obtain that by a query.

Same here. A new crew of new best friends: the newbies.

What info do you want to insert using the form?

Hi! I'm Catalin, but you can call me Paul; is more... british that Catalin. I'm from Romania, Dracula's country. I'm new to Access. I had used Excel for my bussines (a dental lab) but now we have to go to the next level: we have more employees and we have to use a special software for tracking...