Search results

thanks, i did manage to relate by using lookup fields. thanks again!

I've installed access 2010. But now i cant set relation ships, (it's grayed out). Any chance i can find some help on the internet?

Hi guys, I'm glad you guys are looking into this problem and helping me out. I'll try to explain the following: Setup: two tables. one with all the main data and one with just name and a unique number. in the main database i want to save the names and what the persons have done. e.g. It's a...

access 2002 and it does have the DoCmd

i can add my form if you wish to see what's wrong....

I've tried that as well and it still comes up with the same message.

the combo is set to Yes. I tried to change it to no but it comes up with an error message. regards DoCmd.GoToRecord , , acNewRec It comes up when I save it with: DoCmd is not a recognised Macro.

I like to count all the records that have a True (Yes/No) returned on a checkbox. e.g. All customers that have been 'checked'. I like to have this single number come up on my form.

i still ahve some other issues. I like to start with a new record when i open my form. However at the moment I get to see the first record in the table. is there anything i can change to get a new record when i open the form?

I've tried it. but what happens now is that I cant add a name at all! it stays blank. I've used the following syntax in the after update event: Me.Push Out.DefaultValue = Chr(34) & Me.Push Out & Chr(34) is there anything that i do wrong?:confused:

1 I have agreed this that it should become a stand alone application... does this mean that a page can be viewed and used using a browser like IE? and a form needs to be used within Access?

thanks guys. i'm going to try it out straight away

I've acutally sorted it out. I was working in a page not in a form. But still the buttons that are 'custom' made are not working. I dont want to use the buttons that are there. i need to have a save button a new button and a delete button. I presume i cant have the form working without...

I'm designing a form where certain data like names should be displayed all the time. I'm using a different table to get the names (drop down button). but everytime i save the record i loose all the input info including the names. Whereas i need to keep those names until I change them. How can...

I've tried to create all above in a page first. now i'm trying to do it in a form. this means i can use toggle buttons as well as tabs. However I'm confused now. I'm not sure if the people who will use my database will have MS access installed. i thought that using a page means i can use...

well. i've added the delete, new and save button to the form and only one record can be saved when pressing the save. new/delete and save do not work after that.

All the data will be data that can not change except for one field. that has to be changed (time). so i guess it is unbound??

yes you are right in the first part. do you know how to do it? or can you get me on the right track? It's like an entry form where you being asked to enter a coutnry or state and you will have to pick it from a (drop down)-list. I've looked at more controls but that takes me to all programs...

You are right in both occasions. Sorry but i'm only a beginner. I have a form. I want to use it to input data. Although some of the data has to be managed by myself and i've created a table called name which only consists of a unique number field and a name field, some of the data of the name...

Hello, I've just started with Access and SQL databases. I've now created an input window with mostly y/n check boxes and drop down lists. Now i like to save my data in my main dB after I've ented the data. However I use another dB to get names using the drop down lists. How can i save the those...