Search results

Solved Thanks :) both ways work great :D My teeth are feeling better already and my need for nicoteen is slowly decreasing. :p

Another Way? I have the one form which the users can open in edit mode or data entry mode. The problem is that the form changes a little as theres some data on it that shouldnt be viewed in edit mode. I would create two seperate forms but this would require me to change aload of other things...

I love this forum I learn something new everyday by looking at other peoples threads, anyway. I want to create a form with a single text box linked to my customers table, one where the user can enter a road I.E "Primrose Hill" As there are several people who live on this road it should pull...

Solved It works! thanks :) I baffled my brains tring to disable it from within the other forms button, I wouldn't have thought about disabling it from the propertys menu.

I have a few text boxes and retangles on a form, the textboxes are full of formulas, when you enter the data in three of the text boxes i press a button which runs the formula populating the other text boxes with data. What im trying to do is make the text boxes that are populated with data...

Good idea... thanks, Any idea how I can change the actual application icon, ie the file icon itself.

I know most of you guys are techi, but I've almost finished my DB and now its time to make it look good. from the start up I've selected an Icon, which is now displayed in the top left hand corner and in the task bar whilst its open. problem 1. If i am to copy the database onto someone elses...

No way!!!!!!!! Your a "£$!!%^&££" GENIOUS!!!!! Thanks for your help, i cant belive it was that simple. :D

OK i'm not to good at this but what i think you have to do is get rid of the data entry yes part, and to make the form unpopulated when you open it you need to change the code behind the button to "open acnew" <--- or something like that. that way it is opening the form at a new record and as...

It is a numeric data type, its an autonumber and unique id in the properties table I pasted that code over the existing, due to the [] around the part ive highligted i get an error box pop up stating, (run time error 2102, the form name "[02 Create vendor]" is misspelled or refers to a form...

Im fairly new to this programme, i've asked on various forums/chatrooms and have browsed every form page on here and other forums. I still haven't got an answer. EXPERTS please help :) I have one form called propertys and another called vendor. In the form propertys i have a button that opens...

Thanks for your reply, I did type it correctly, i'm not to good with VBA. Your way seems to make alot more sense, probaly a little stabler too. I've made the changes, thank you. it still hasn't solved my problem though :-(

To link up my forms i used the following two pieces of code Inside of the form opening Private Sub Form_beforeUpdate(Cancel As Integer) Me.[Property ID] = Forms![property]![Property ID] End Sub Inside of the button that opens the form DoCmd.OpenForm "My Form", acNormal, , [Property ID] = " &...

reply Thanks, at least my form isnt going to go irobot on me lol. theres no data in the tables yet i guess that was the problem. AI pretty scary

i dont know if this is a common problem with access, i've just posted a thread but i thought i'd keep this seperate as its another issue. when i format a form and select "allow additions" and turn this value to "no" it allows me to view the form ok, but every now and then when i open it it has...

Hi, I've asked this question before but to save time i never went into enough detail and therefore never got the right answer. I can not use subforms because there would be much to much data on the screen. my first table properties has a form to input all of the data. my second table...

I cant use a subform there wouldnt be enough room. theres more than one form to be linked you see. I said two rather than having to list them all. The real issue is form 1 links to form 2 which has another 3 forms attached, lets call them 3 options for now. if i click onto form two and select...

Hi, This is my first post, ive browsed through the forums and cant seem to find anything similar. I have two tables, table 1 is linked to table 2 via property ID in a one to many relationship Property id is in table 1 and formated as an autonumber in table 2 it is a number. form 1 has all...