Search results

I think I know that About the Master-Child form. Isn't that the same as the Main form with a Subform on it? I already have that working. I was just curious as to why the wizard allows you to combine 2 tables, then set the view or layout to use the 2nd table (which puts all fields from both...

Thats good to know Doc_Man, I already found the setting in the Options so I knew that was there but I wasn't sure if I wanted it set that way for everything. I am just trying to learn some of the different ropes in respect to Access as I have only been working with it about a week :D I did...

On a simple 2 table DB I was trying originally to use the form wizard, select all the fields from the first table and only selected fields from the second table. Then I would select the view on the second page of the wizard to show all the fields from both tables, without separating them into a...

Worked for me! That was quick and it worked perfectly. I am just learning and once I get some of the syntax sorted out I will be on my way. :)

This may help... To do this is a little tricky at first as you need to be looking at a form with design view and then select: Tools|Options and on the EDITOR tab, place a checkmark in: Require Variable Declaration If you try to do this from the other window, like the default view, you can...

I have a form in which the subforms onExit event sets the focus to the autonumber CustomerID field in the main form but it stays on the current record. How can I get this to increment to the add new record with code? Thanks, sorebrain Access 2000 learning as fast as I can :D

JIT this may help... I googled and found this just to try to help even though I am just learning... <snip> Are you sure you are getting the #Name? error ???? This indicates that Access can not find a reference to an object .. such as a field in the recordset. Not that it does not contain a...

oops Sorry JIT, I didn't mean to jump in like that....

That sounds like the answer Wayne, Thanks for the prompt response. That sounds like what I was looking for. This will make my day :cool: sorebrain

I'm happy to see this post because... Thats the exact situation (or close enough to it) that I have been working like mad to figure out over the last couple days but wasn't asking the question correctly :D I figured subforms or tabs got me closer to the answer but in the end, I still have...

declaring variables If your talking about programming in general, like in VB for instance, declaring variables is always recommended by using the Option Explicit statement in the general declarations of a form. This forces variables to be declared so if you mispell them later in your code you...

A little history Just so you know where I am at. http://www.access-programmers.co.uk/forums/showthread.php?t=74551 That might help a little and I also emailed you privately, Thanks, sorebrain :)

Interesting... Thats good to know about the autonumber. I didn't know that when you compact and repair the database that it would do that. I thought it would still start at the next highest number and leave the deleted records as unused record numbers like: 1 2 5 6 7 start here at number 8 But...

More info on my question Hi, and thanks for your response. I live just west of you down I-10 in Crestview. Anyhow, I just ordered a book for Access 2000 and the other books I have read are for Access 97. I have also been reading Visual Basic Database programming but I believe that was the...

Maybe I need more magic dust... Ok, I went back and selected all of the fields from all of the 3 tables and it looks like I am down to just one field that I need to work on. Its a foreign key number ID field and I think I need to work on it for awhile...I am getting closer. Can a foreign key be...

I am quite new to Access 2000 and have some questions on a general level. I have 3 tables in my 1st database attempt and am trying to use the form wizard to allow fields from all 3 tables to be on 1 form. I add the fields I choose from the 3 different tables and prefer to set it as single form...

Search for mdb files Do a search for *.mdb files in Explorer on your C:\ drive. sorebrain

Ahhhhh....I figured it out Pat, I kept at it and figured out some stuff. I realized I had misunderstood your instructions and actually had 2 relationship lines drawn from the tblCustomers.CustomerID to the 2 different fields on the tblServices .CustomerID and .ServicesID and realized (but...

Problem with enforcing RI Pat, I have done all the editing and I cannot get referential integrity to work. I get the error msg "Microsoft Access cannot enforce referential integrity for this relationship" etc... I am trying to enforce it on the tblServices.CustomerID --->...

Ok, I am back in the General area Thanks Pat. I am back in the General area to get my original questions off to a good conclusion. I have been hard at it but even though only 5 days went by, I have been writing the date as 2 days ahead of today :D So I guess I have 7 days experience :cool...