Search results

appologies if my terminology is out! thanks for the help, support and your time in answeing my questions What I mean by 'run time' is when the program is actually running, not in design mode. I have got to the bottom of it, and learning every day!!! thank you all for the input!

Mmmn...this fell over today.... I used replication, to create the database for the user input. Then I made some design changes and the replication failed ! at such an early stage of development this is not such an issue, but in the long run it could be a problem if the tables became too...

use the new form wizard...

thanks for the input. I've been puzzled as to how i can lock/unlock (or whatever...) the control on each record as I navigate through. Will the 'on open' event reset for each individual record? I have been playing with this and need the record locked or unlocked on a 'per record' basis not...

check out this link... http://www.mvps.org/access/datetime/index.html

Hi I want to tick a check box next to a [date] field on a form which signifies 'date confirmed' on clicking the check box, I'd like the [date] field to be greyed out/locked/font colour changed etc... any thoughts on how to do it??? Thanks

Hi All, how do you open a form and a sub form using VBA..? I need to be able to pass a data string to an openform/findrecord sub. The form I want to pass the openform/findrecord command to, is a sub form. I can get it to open as an individual form but I want to open the parent form and have...

looks like the underlying problem is your tables... open a new database and try the following: Create new tables: tblTeachers & tblChildren link many children to single teacher, you should then be able to create a 'teachers form' then add a 'children sub form' to create your matrix and filters.

Hi I have a list box which contains project references for our customers, this list box is populated from a query. I want to be able to update the project ref and at the same time update the list box. how do I update the list box so that the query references a particular value in a field on a...

Thanks for the tips, can anyone give me a quick dummy's guide to replication please??? Thanks

HELP....developer best practices Hi and thanks for all the help so far..... When it comes to developing Access, what is the best practice given this scenario. The database I am developing will be multi user, I have created the table structure and a few forms to input the data into. My boss...

Thankyou to all who responded... I have now recovered the database and will not do anything as stupid as that again!!! Thankyou

all the check boxes... sorry I just wasny thinking...

I've just made a major mistake.... On messing about with my start up settings i have managed to lock myself out...!!! what a ****!! how do I / where do I look to reverse these?? Please help

Thanks Colin. That makes perfect sense

Hi sorry if this is a dumb request.... I have a table in which I store: 'cost price' , 'sell price' & 'Profit' what method can I use to automatically populate the 'profit' based on the entry of 'cost' and 'sale' price??? Thanks in anticipation

Hi, Thanks for the reply... that's what i tried to do, but when i clicked it in run time, it came up with a dialogue box asking me 'Enter Parameter Value' do I have something wrong with my relationships?

Hi...total newbie here trying to get out of the blocks! I want to be able to open forms with a button and filter in the process. I have Customer details in a table I have Site details in a table I have Product details in a table From my 'frmCustomer' I want to hit a comand button to open...