Recent content by rudy78

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...