Search results

I have a button which allows me to open another form in my database, this forms are not connected. However when this form button is activated i would also like some fields from this table A to be copied into the table B and be displayed on the newly opened form. I'm getting confused with my...

I have a really strange problem. In order to play with some working code, i copied and pasted it into a word document. However when i pasted the old code back, and tried to press the button the code supports i get an error 'item not found in this collection' has anyone seen anything like this...

Hi, GOt a real big problem holding me up! I've got a percentage field as part of a totals calculation e.g i have Subtotal Freight Totals ( = [subtotal] +[freight]) the total is calculated by the above formulae in its control source however i want to add calculation to include my percentage...

is acCurrentView...anything relevant???

Hope this isn't too simple a question.. ....from a java programmer trying to code VB for the first time! Here's the background I've got a form called 'orders' in which a user types in the order details (e.g. customer name, delivery address etc.) the actual products ordered are detailed in a...

On making an invoice for my system... All the calculations need to be made in a form or table before making the report. the report is made by copying those fields. Does this help at all. if not come back to me. Invoices have been all i've worked on for the last week!

By a user interface..i think you mean this Create a form that has buttons that open all the forms you want the user to access (button wizard is easiest) This will be your 'main' form. I would reccommend that you remove the scroll bars and record selectors (from properties = no) and in the...

Can't you just use the button wizard... ..delete records option?? (novice talking!!)

To get colourful forms you need to play with the background colour (check out the properties), and play with your text colours etc. Colourful buttons don't really happen (isay that because there'd a post on this foum by rich with examples..but as a general rule their grey). I've got some really...

sounds like you neeed to find out a bit more about who held the original administrator rights

hate to add the novice touch...but I had the same problem, and rather than work with all the code, i simply used a button wizard e.g i used the wizard to open a form , selected the form i wanted to use.. i then just selected to open that form linking the two primary keys on each form. this...

hate to add the novice touch...but I had the same problem, and rather than work with all the code, i simply used a button wizard e.g i used the wizard to open a form , selected the form i wanted to use.. i then just selected to open that form linking the two primary keys on each form. this...

not sure this is what you mean..but.. each table must have a unique primary key. One table can only have one primary key. This key can logically be an 'autonumber'. By adding a primary key to a table you ensure no records can be duplicated becaude there can only be one instance of that field...

Think your exlaining exactly what i'm after Can you translate your 'waffle' into explanitory terms for an idiot??

Yep..Sarah it is!! My question was just above your reply...kinda similar!!

Thanks Rich, i've tried this, but it just does'nt want to be a percentage! Am i missing something simple?

nope..i'm another person you've helped a few times!!

Hi Col, Sorry..Don't think i explained properly. I have a field called 'renewal date' on my report. If this field is null in the form the report is based on, i just don't want the label 'renewal date' to show up. Nothing needs move, i think its quite a basic problem!?:D

Hi, have a really weird problem, I have a combo-box on a form, which displays a choice of 3 percentage values. These values came from a table. However when you select a value the format changes in the actual text box! E.g. If you select the value 5.0% then it will appear as 0.05 in the field...

Just tried the canshrink value set to yes and the label to visible:no And now you can't see the field on the report whether it is null or not..am i missing something?