469,315 Members | 1,812 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,315 developers. It's quick & easy.

make sure data is entered before going to new form?

AccessIdiot
493 256MB
Like your mother-in-law that visits too often, I am back. :-)

I have two tables, two forms. The primary key of table 1 is a foreign key in table two. I have a button on form one that opens form two and it should take the ID autonumber field from the first form and populate the ID field on the second form (and get stored in the table too).

But it's not working. My guess is that technically the data from the first form hasn't populated the database yet so it can't get carried over to form two.

So how do I tell Access that when I click the button to open up form two, go ahead and stick all the data that was entered on form one into the database (but you don't have to go to a new record, just stay put while form two is being filled out - eventually it will be closed).

Is it like a requery or refresh or something like that?

thanks to any and all help,
melissa :-)
Mar 23 '07
129 7742
NeoPa
32,173 Expert Mod 16PB
I will go through your post with the database when I get home. It'll all flow more sensibly then I'm sure.
I'm sure it will make perfect sense then.
As for me being your only hope, while I will try to help of course, I'm sure Denburt has been, and will continue to be, a great help getting this project moved forward in the way you envisage. I will certainly be talking to him about it when I can as I think he's already got a number of issues to bring up. Probably similar to ones I've spotted too, but we want to ensure it's presented as a consistent whole.
More later :)
Mar 29 '07 #51
AccessIdiot
493 256MB
Just got a pm from Denburt that he found a number of things that could be fixed so I am excited to learn from those! Thanks again to the two of you and don't mind the Star Wars reference, I couldn't resist. ;-)

by the way - where are the smiley tags on this forum? I don't see them in the menu on the post.
Mar 29 '07 #52
NeoPa
32,173 Expert Mod 16PB
Just got a pm from Denburt that he found a number of things that could be fixed so I am excited to learn from those! Thanks again to the two of you and don't mind the Star Wars reference, I couldn't resist. ;-)

by the way - where are the smiley tags on this forum? I don't see them in the menu on the post.
They're just the normal text smileys (but the versions without the '-'s).
If you ever want to duplicate what someone else has posted simply reply to their post and, without submitting any post, just go through the prepared quoted part of the post to see how the poster achieved the effect.
BTW Star Wars references are all good :)
Mar 29 '07 #53
Denburt
1,356 Expert 1GB
BTW Star Wars references are all good
Agreed.

O.K. I am glad you mentined the linked table in the wizard and I think those are quite relevant to this thread so if you wouldn't mention posting your findings I am sure a lot of people will find that interesting. I can't remember the last time I used a wizard but hey... Still good to know.

I noticed this last night but I wanted to wake up and double check.

When you design your queries you are using the wild card way to much.
For example:
tbl_Entrainment.* in one field and tbl_Gear_Entrainment.* in the next Gives you the following ID key tbl_Gear_Entrainment.Entrainment_ID and also tbl_Entrainment.Entrainment_ID So when you are in your form it will through a lot of issues your way that you really don't need or want to deal with. I think this has been our problem from the start.

I simply double click one of the headers on the table I want and all fields are highlighted I simply drag and drop from the highlighted fields. Keep in mind if you ar not going to use a field you don't want it in your query since it will slow things down (just good coding practices). A little speed on a small program like this may not be an issue but they tend to grow quite rapidly then before you know it you are going back over things and redoing them. FYI

I change the SQL on your entrainment for to:

Expand|Select|Wrap|Line Numbers
  1. SELECT tbl_Entrainment.*, tbl_Gear_Entrainment.Gear_Comments
  2. FROM tbl_Entrainment INNER JOIN tbl_Gear_Entrainment ON tbl_Entrainment.Entrainment_ID = tbl_Gear_Entrainment.Entrainment_ID;
You may make further changes as you see fit.

Your Query for the Seciman Entrainment does not need the entrainment table in it. This query had the same issue as above however removal of the entrainment table solved this issue. Now go into the Specimen form and change the controlsource of txt_EntrainmentID control to Entrainment_ID and you should be set.

Now in your Entrainment form you have referential integrity set for Location_ID, Staff_ID,Weather_ID. But none are included in your form, that makes for an incmplete record and will not be saved.

Once you complete the above. In your entrainment form set the Specimen button to look like so.

Expand|Select|Wrap|Line Numbers
  1. Private Sub btnAddSpecimen_Click()                                                          'AddSpecimen button
  2. On Error GoTo Err_btnAddSpecimen_Click
  3.  
  4.     Dim stDocName As String
  5.     Dim stLinkCriteria As String
  6.  
  7.     stDocName = "frm_Specimen_Entrainment"
  8. If IsNull(Me!Entrainment_ID) Then
  9.     MsgBox "Please enter or view a record here before clicking this button!", vbCritical + vbOKOnly
  10.     Exit Sub
  11. End If
  12. If Me.Dirty = True Then
  13. DoCmd.RunCommand acCmdSelectRecord
  14. DoCmd.RunCommand acCmdSave
  15. End If
  16.  
  17.    DoCmd.OpenForm stDocName, , , , , , Me!Entrainment_ID
  18.  
  19. Exit_btnAddSpecimen_Click:
  20.     Exit Sub
  21.  
  22. Err_btnAddSpecimen_Click:
  23.     MsgBox Err.Description
  24.     Resume Exit_btnAddSpecimen_Click
  25.  
  26. End Sub
  27.  
Specimen form:
Expand|Select|Wrap|Line Numbers
  1. Private Sub Form_Load()                                                                 
  2. 'When form loads go to new record
  3. 'the following is not needed since we set the form to dataentry.
  4. 'DoCmd.OpenForm "frm_Specimen_Entrainment", , , , acNewRec
  5. If Not IsNull(Me.OpenArgs) Then
  6.     Me!txt_EntrainmentID = Me.OpenArgs
  7. End If
  8. End Sub
  9.  

This should help get this part of it going and give you some ideas on other things that may have issues. Let me know how it goes.
Mar 29 '07 #54
AccessIdiot
493 256MB
Have to head home but will chew on this in the morning.

Can't wait to get started - thanks for the long response and looking through the db!
Mar 29 '07 #55
Denburt
1,356 Expert 1GB
Oh and I missed this in the onload event I posted you will want to make a change it should look like the following:

Expand|Select|Wrap|Line Numbers
  1. Private Sub Form_Load()                                                     
  2. If Not IsNull(Me.OpenArgs) Then
  3.      'When form loads and you have openargs go to new record
  4.     Me.DataEntry = True
  5.     Me!txt_EntrainmentID = Me.OpenArgs
  6. End If
  7.     'DoCmd.OpenForm "frm_Specimen_Entrainment", , , , acNewRec
  8. End Sub
  9.  
Mar 29 '07 #56
NeoPa
32,173 Expert Mod 16PB
I didn't get a chance to discuss anything with Denburt last night I'm afraid. With a 6-hour time zone difference I suspect he wasn't available until after I'd had to call it a day.
What I did notice though, was that the code which enables the subform will execute even if an item hasn't been selected. This can cause the form to get into an unusable state as the subform won't allow any data entry and the operator cannot return to the main form.
I'll leave any further details till after you've looked at the new way of doing things illustrated by the Form Wizard (Unless I notice anything else fundamental that's worth mentioning).
Mar 30 '07 #57
AccessIdiot
493 256MB
When you design your queries you are using the wild card way to much.
For example:
tbl_Entrainment.* in one field and tbl_Gear_Entrainment.* in the next Gives you the following ID key tbl_Gear_Entrainment.Entrainment_ID and also tbl_Entrainment.Entrainment_ID So when you are in your form it will through a lot of issues your way that you really don't need or want to deal with. I think this has been our problem from the start.
Good to know. I figured it was just an easier way to write the query than to have to pull out all the fields individually. I will double check this on all forms.

Your Query for the Seciman Entrainment does not need the entrainment table in it. This query had the same issue as above however removal of the entrainment table solved this issue. Now go into the Specimen form and change the controlsource of txt_EntrainmentID control to Entrainment_ID and you should be set.
I assumed that's how the Entrainment_ID got "carried over" from the Entrainment form to the Specimen_Entrainment form. I see that is wrong and is probably what is causing most of other problems.

Now in your Entrainment form you have referential integrity set for Location_ID, Staff_ID,Weather_ID. But none are included in your form, that makes for an incmplete record and will not be saved.
Now this I don't get. I use the form wizard (I know you don't use them, sorry) to draw a combo box on my form. I choose what table I want to populate the dropdown and then the form asks where do I want the value to be stored? And so I point to the field in the Entrainment table.

In other words, I want the staff combo box to be populated by the staff table but I want the user's choice to be stored in Entrainment.Staff_ID. So how else would I set that?

Am working on the rest . . . thanks for sticking with me!
Mar 30 '07 #58
AccessIdiot
493 256MB
Okay maybe I answered my own question. I drag the fields from the Entrainment Select box onto my form and then right click and change them to combo boxes. Then set the row source to the table I want to populate them. Does that solve the referential integrity problem?
Mar 30 '07 #59
Denburt
1,356 Expert 1GB
Yes I think you are on tract the version of your DB did not have the following fields on the form whatsoever: Location_ID, Staff_ID,Weather_ID. And they are required fields so if they aren't on the form... ;) Do you see how i carry over the ID from one form to the next now? Good Luck Oh and uh, whats your next question. :)
Mar 30 '07 #60
AccessIdiot
493 256MB
You didn't see them? That's odd, they should be there all as combo boxes on the right side. I just had them set differently using queries instead of setting up their row source.

I think everything is carrying over. I ran into a snafu on the CheckFish function on the Fish_Specimen subform (within the Specimen_Entrainment form).

The species combo box was previously populated by a query so it made use of three fields: species id, species code, and fish which is a boolean yes/no if the species is a fish. Then the checkfish function will make the fish_specimen subform visible or not (I think it's set to enabled or not in your version but i'm changing it to visible) based on the value of the boolean (thanks to NeoPa for that awesome little function).

But because I used a query for the source of the combo box I could set the boolean value to the value of column(2) (third column in the query). Now that I have fixed the combo box to be just the table i'm not sure how to reference the appropriate column or fish field. Right now I'm getting an error message of "invalid use of null" on this line:
Expand|Select|Wrap|Line Numbers
  1. If Not IsNull(Me.Species_ID) Then blnFish = Me.Species_ID.Column(2)
I know it's not column 2 anymore but column 7 doesn't work either :) (it's the 8th field in the db)

Beyond that, could you please explain the code you suggested? I think I understand everything up to the dirty and RunCommand parts.

Also, will all this also apply to Replicate and Specimen Replicate?

thanks so much
Mar 30 '07 #61
AccessIdiot
493 256MB
Oh and how do I fix the "add another specimen" button on the entrainment_specimen form? :) It's just a "go to new record" type button but it is supposed to have the same entrainment_id. In other words, you should be able to have lots of specimens for one entrainment.
Mar 30 '07 #62
AccessIdiot
493 256MB
I didn't get a chance to discuss anything with Denburt last night I'm afraid. With a 6-hour time zone difference I suspect he wasn't available until after I'd had to call it a day.
What I did notice though, was that the code which enables the subform will execute even if an item hasn't been selected. This can cause the form to get into an unusable state as the subform won't allow any data entry and the operator cannot return to the main form.
I'll leave any further details till after you've looked at the new way of doing things illustrated by the Form Wizard (Unless I notice anything else fundamental that's worth mentioning).
Yes I know! Controls on the forms in terms of being able to go back and forth are seriously lacking. Right now I'm just trying to get it to work in a linear fashion but I don't know what I'm going to do about the user that wants to poke at this thing willy nilly. Right now it's very easy to break!

All suggestions are of course welcome.
Mar 30 '07 #63
NeoPa
32,173 Expert Mod 16PB
Melissa,
I suggest that your approach in leaving this till later is entirely appropriate. I've been a bit guilty of throwing too many things into the pot myself, after I said you need to be more disciplined in your communication - lol.
Let's come to this when the more fundamental issues are resolved. I feel that real progress is being made atm but perhaps too much going on at once. Let's get some changes in, let the dust settle, see a new version of the db and then tidy up any points still required. I'm sure it will be easier that way.
Fundamentally, the answer is to check that a value exists when the button is originally clicked before progressing, but we'll cover in detail at the right time.
Mar 30 '07 #64
Denburt
1,356 Expert 1GB
Oh and how do I fix the "add another specimen" button on the entrainment_specimen form? It's just a "go to new record" type button but it is supposed to have the same entrainment_id. In other words, you should be able to have lots of specimens for one entrainment.
I thought for sue I put it on my USB but then again I don't see it. :(

You should be able to change this like so. Me!txt_EntrainmentID.DefaultValue and that should get you what you need (unable to test at the moment).

Expand|Select|Wrap|Line Numbers
  1. Private Sub Form_Load()                                                                 
  2. 'When form loads go to new record
  3. 'the following is not needed since we set the form to dataentry.
  4. 'DoCmd.OpenForm "frm_Specimen_Entrainment", , , , acNewRec
  5. If Not IsNull(Me.OpenArgs) Then
  6.     Me!txt_EntrainmentID.DefaultValue = Me.OpenArgs
  7. End If
  8. End Sub
  9.  
I know you still have more going on and it's difficult to understand not having the BD here in front of me sry. My main goal was to get it going so you could enter a record then open the specimen form and enter records in there. I also wanted to point out a few things that would apply to the database as a whole. So if you can enter a retainment and the id Carries over to the Specimen form then hey great. When I get in this evening I will look it over again. Hope Neo and I will be able to talk tonight when I get home. I have got to get a PDA, I am looking at one right now with Wi/Fi and can utilize skype.... :)
Mar 30 '07 #65
AccessIdiot
493 256MB
It is all working great! Except of course the issue with the Fish Specimen subform. I still haven't figured that one out.

I'm going to see if I can apply the same to the Replicate form and Specimen Replicate.

Thanks again!
Mar 30 '07 #66
AccessIdiot
493 256MB
Okay I'm having some trouble here. The Replicate to Specimen_Replicate is a bit more complicated because the Replicate form is actually a subform within the Survey form, which has to be launched from the Main Menu form because of an OpenArgs that gets passed from Main Menu to Survey form.

I am running into all sorts of problems which will probably make sense only when you see the db.

First off with going from the Main Menu to the Survey form. The Survey form no longer opens at a new record and so barks at me that I can't go to the specified record.

Second I'm having all sorts of trouble now with the enabling/disabling of form and subform. I had it worked out with lots of help you remember :) The problem is that now i have two subforms on the survey form. I want to disable one subform when the controls on the form are disabled, but leave the replicate subform enabled. I'm having trouble targeting just one subform with the code you gave me. This is the code I'm trying on the Survey form:
Expand|Select|Wrap|Line Numbers
  1. 'Private Sub btnNewReplicate_Click()
  2. Dim ctl As Control
  3.  
  4. For Each ctl In Me.Controls
  5. If ctl.Name = "sbfm_Replicate" Or ctl.Name = "btnNewReplicate" Then
  6.     ctl.Enabled = True
  7. Else
  8.     If ctl.ControlType <> acLabel Or ctl.Name <> "sbrm_Replicate" Then
  9.         ctl.Enabled = False
  10.     End If
  11. End If
  12. Next
  13. End Sub
and code on the New Survey button on the replicate form:
Expand|Select|Wrap|Line Numbers
  1. Private Sub btnNewSurvey_Click()                                                    New Survey button - enable form, disable subform
  2. Dim ctl As Control
  3. For Each ctl In Me.Parent.Controls
  4.    If ctl.ControlType <> acLabel And Not ctl.Name = "sbfrm_Replicate" Then
  5.         ctl.Enabled = True
  6.         ctl.SetFocus
  7.    ElseIf ctl.Name = "sbfrm_Replicate" Then
  8.         ctl.Enabled = False
  9.     End If
  10. Next
  11. DoCmd.GoToRecord acDataForm, "frm_Survey", acNewRec
  12. DoCmd.GoToControl "txt_SurveyNum"
  13.  
  14.  
  15. End Sub
To add insult to injury the survey_ID (which both the survey and replicate tables have) is not carrying over from form to subform even though that is what is specified in the master/child linked fields. Talk about a major slap in the face!

So any help for any of these issues would, once again, be stupendous.

And of course the fish specimen problem. :)
Mar 30 '07 #67
NeoPa
32,173 Expert Mod 16PB
Now this is where indiscipline can throw us all off course.
Answering one problem at a time on someone else's db can be handled, but when more problems are thrown down when other problems are still outstanding, it just gets way too confusing. I'm not sure where we are atm.
Mar 30 '07 #68
AccessIdiot
493 256MB
lol, no doubt. I am going to compact/repair/backup/zip and ship a copy of the latest version to you NeoPa. Would you mind passing along to Denburt? I don't have an email address.

cheers!
melissa :)
Mar 30 '07 #69
NeoPa
32,173 Expert Mod 16PB
All received and passed on.
We've talked at length about your database and found a couple of issues but Denburt is working on formulating them into a sensible post.
It's late now so maybe he'll get that posted tomorrow.
Mar 31 '07 #70
Denburt
1,356 Expert 1GB
Option Explicit At the top of your modules will help prevent typos and make sure all you varibles are declared.

The checkfish subroutine changed to sbfrm_FishSpecimen_Entrainment from sbfrm_FishSpecimen to match your subform name, we noticed this in several areas.

You should open your tables and take full use of all properties for each field especially the lookup field. These things follow the field unless you explicitly change it on a particular control. When you specify the lookup field it asks you if it will be a combo box or list box etc. so when you place this field on a control most of your work for that control is done.

Your frm_survey has a query in the recordsource which contains the table tbl_Staff, remove it as it is not needed in this recordsource. You only include tables you plan on updating and this form is not for adding staff members to your database this form simply wants to track the staff you do have and coordinate it with the surveys.

Your sbfrm_AddStaff still has an interesting hangup and I will try to look at that in a bit.

Neopa did I miss anything or do you see anything that may need a little more clarification?
Mar 31 '07 #71
NeoPa
32,173 Expert Mod 16PB
I think that covers the three points we discussed :)
Mar 31 '07 #72
AccessIdiot
493 256MB
Option Explicit At the top of your modules will help prevent typos and make sure all you varibles are declared.
Thanks, I always wondered what that meant.

The checkfish subroutine changed to sbfrm_FishSpecimen_Entrainment from sbfrm_FishSpecimen to match your subform name, we noticed this in several areas.
Dang, I should have caught that. I was trying to change so many things last Friday that I missed that one. Thanks for seeing that!

You should open your tables and take full use of all properties for each field especially the lookup field. These things follow the field unless you explicitly change it on a particular control. When you specify the lookup field it asks you if it will be a combo box or list box etc. so when you place this field on a control most of your work for that control is done.
Didn't realize I could set all that up with the tables. I will certainly do that in the future. Another good tip - thanks!

Your frm_survey has a query in the recordsource which contains the table tbl_Staff, remove it as it is not needed in this recordsource. You only include tables you plan on updating and this form is not for adding staff members to your database this form simply wants to track the staff you do have and coordinate it with the surveys.
In my thought process (obviously of a beginners) I was using the NotInList function to update the Staff table so I thought I would need it in the query. I guess since the code calls the Staff form I don't need it in the Survey form.

Your sbfrm_AddStaff still has an interesting hangup and I will try to look at that in a bit.
It is a continuous form so as soon as you choose something it adds another combo box. Kind of confusing to the user but once I explain it I think (hope) they'll get it. I originally had it as a a single form with an "add additional staff" button but once you click the button the first combo box disappears (obviously) and my tester thought the original info didn't stick so kept putting the same name in over and over. If I was smart with Access I could have something that says "you have added xxxxxx" in some kind of list but alas, I am not that smart. :)

Neopa did I miss anything or do you see anything that may need a little more clarification?
Thanks to you both for all of this help, I feel like I am really learning a lot about Access and how to set up projects and flow between forms!

If I may add on another problem - I am also having trouble with the line
Expand|Select|Wrap|Line Numbers
  1.     DoCmd.GoToRecord , , acNewRec
which is on the main menu on each of the buttons. It worked before but now it does not. I need to launch the survey form with a blank new record but as soon as there is just one record in the survey table I get the error message that I can't go to the specified record and the form opens with the existing record showing. I would like to have navigation controls on all these forms eventually so that the user can check out what they've done and make changes where need be.

I am thinking I may have to abandon the main menu with the three buttons that pass the string and just have a "survey type" menu on the survey form instead.

cheers,
melissa
Apr 2 '07 #73
Denburt
1,356 Expert 1GB
Darn forgot my jump drive my appologies. I won't be able to look it over until tonight.

I did notice that in the code this was commented out:
"DoCmd.OpenForm "frm_Specimen_Entrainment", , , , acNewRec"

If your using this on the Main menu then you should specify the name that you have opened otherwise it may be trying to take the Mani Menu to a new record.
DoCmd.GoToRecord ,"SomeFormName", acNewRec

Or in each form.

Expand|Select|Wrap|Line Numbers
  1. Private Sub Form_Load()                                                                 
  2. 'When form loads go to new record
  3. 'the following is not needed since we set the form to dataentry.
  4. DoCmd.OpenForm ,me.name, acNewRec
  5. If Not IsNull(Me.OpenArgs) Then
  6.     Me!txt_EntrainmentID.DefaultValue = Me.OpenArgs
  7. End If
  8. End Sub
  9.  
Should resolve that issue. :)
Apr 2 '07 #74
AccessIdiot
493 256MB
Cheers that works though I tweaked it a bit. I had the right code but in the wrong place. :-)

I'm not sure how i manged to louse this up but when I go from the Survey form to the Replicate subform the Survey_ID (primary key in Survey table and foreign key in Replicate table) does not update. I have to use a query for the control source of the Replicate subform because I am updating the Gear_Replicate table on the subform. However, the child/master link property is set and there is a relationship between the two so I'm not sure why it isn't updating? If I fill it in by hand it will advance but shouldn't it be automatic?
Apr 2 '07 #75
Denburt
1,356 Expert 1GB
However, the child/master link property is set and there is a relationship between the two so I'm not sure why it isn't updating? If I fill it in by hand it will advance but shouldn't it be automatic?

Very Strange.
Apr 2 '07 #76
AccessIdiot
493 256MB
Yes! Is there anything special I need to do or make sure I include to get the two to see each other? That is, to get the Survey_ID to show up on the subform?

Could it have anything to do with disabling the controls on the form when I want to enter information on the subform?
Apr 2 '07 #77
Denburt
1,356 Expert 1GB
Your child link and master link in the properties should make that work are you sure the names are spelled correctly? Go to the properties and highlight one of the fields then click on the box to the right if you don't get an error or message there then i would need to see it.
Apr 2 '07 #78
NeoPa
32,173 Expert Mod 16PB
Melissa,
First of all, I'm glad you're making such good progress with this.

Moving on, I've said this in many different ways, but feel the need to say it again. You really need to start thinking and working more methodically. There are clues in your posts that you're full of ideas and are not afraid to try all sorts of things out, but unless you work (and post) in a more methodical/disciplined way, your work and ours is likely to be overwhelmed by your workrate and enthusiasm. Too much all at once can be quite disruptive if you ever lose your thread (as you seem to have done from time to time).
Try to focus more on a single item until that is how you want it, then move on to something else, rather than running all your ideas forward in parallel. When something breaks it's very hard to find out where the problem is if you're working on so many different ideas all at once.
Following what is going on (in the thread) is also more difficult if many processes are running concurrently. I hope you understand I'm trying to help with this.

Best regards -Adrian.
Apr 3 '07 #79
Denburt
1,356 Expert 1GB
Melissa,
First of all, I'm glad you're making such good progress with this.
quoted for emphasis :)

I wasn't able to do anything on the PC last night I had everyone dragging me all over town but that happens. I will see if I can do more to help this evening.
Apr 3 '07 #80
AccessIdiot
493 256MB
Your child link and master link in the properties should make that work are you sure the names are spelled correctly? Go to the properties and highlight one of the fields then click on the box to the right if you don't get an error or message there then i would need to see it.
Cheers guys, thanks for the kind words. I apologize for jumping around. When I get stuck on something and can't move forward without help I have to put out the call for assistance and then move on to something else and try to fix that. I'm under such a deadline here (beyond it actually) that I need to try and make progress when I can. I also want to have the next question ready when I finally get a prior question answered. :) But I see I am bombarding you guys when you are trying to help me and that is not wise. Again I apologize! My aim is not to confuse.

Everything with the form/subform seems to check out so I don't know why the linked Survey_ID field is not updating. It just sits at 0 unless I type the correct value in.

I am happy to send an updated version of the db if you would like to see it. Thanks again for all your help and especially for looking at this beast on your home time.

cheers,
melissa
Apr 3 '07 #81
NeoPa
32,173 Expert Mod 16PB
I'm happy to take a new version Melissa (and will ensure that it's passed on to Denburt).
Remember to select the maximum compression. When I recompressed the last version it came down to less than half the size. Maybe I have a different version of the software, but it's worth selecting maximum anyway.

-Adrian.
Apr 3 '07 #82
AccessIdiot
493 256MB
Of course! I didn't realize there were levels of compression. I have Access '03 at work (they won't upgrade us to '07 because some people are terrified of MS Word looking different, grrrr).

I usually just hit "compact and repair database". Is there some other tool I should be using?

I pretty much have everything working now (I think!) except for that weird form to subform survey id problem. Any help on that is surely appreciated.

cheers,
melissa
Apr 3 '07 #83
NeoPa
32,173 Expert Mod 16PB
The levels of compression only exist in WinZip (or WinRar whichever you use).
In Access, it's just Compact & Repair.
Apr 4 '07 #84
AccessIdiot
493 256MB
Hey guys sorry to bump the thread but I was wondering if anyone had a clue why the Survey ID is not showing up in the subform?

thanks for any help!
Apr 5 '07 #85
Denburt
1,356 Expert 1GB
I spent a little time on this the other night but it left me baffled the only thing I could think of was that it might have something to do with the relationships but I was still not able to get it to work. I will do my best to try and look at it again as soon as I can but I have been real busy. You might try and do this... Create a new DB ( I know troubleshooting is always a pain) import ONLY the items you need for that form to function. Try it in the new database and see if it works. Look at the relationships window and see if they carried over. If it still doesn't work then remove all relationships and try again. If it still isn't working try recreating it...
Apr 5 '07 #86
AccessIdiot
493 256MB
Will do. I know things can get corrupted for no apparent reason.

Can you tell me though - what do you mean by "look in the relationships window"?

Again, thanks for your time and patience!

melissa
Apr 5 '07 #87
Denburt
1,356 Expert 1GB
Well I am still not sure if this may be an issue or not so I wanted to check any and all altenatives.

Look at the relationships window and see if they carried over.
Database window look at Tools Relationships.
Apr 6 '07 #88
NeoPa
32,173 Expert Mod 16PB
This enables you to view / create / amend defined links between your tables. Here is defined your Referential Integrity settings.
Apr 10 '07 #89
AccessIdiot
493 256MB
Oh right. Yeah, everything in the relationships window is kosher. That's where I designed all my table relationships from the beginning.

I'm thinking something must be corrupt in the entire db though. The entrainment form always displays 1 of 1 record when I launch it, even if there are 20 records in the table. I can't navigate through the records except in the session I have the form open (e.g. if I add 3 records I can navigate those three and that's it).

I also tried importing into a new db ONLY those tables and forms needed to test the Survey form to Replicate subform Survey_ID issue and no dice.

So I'm wondering if something is just not right with the entire thing. Dang it. :(
Apr 10 '07 #90
[quote]Yo AccessIdiot can u tell me how to store data and make forms and also make me a form handler[quote]
Apr 10 '07 #91
Rabbit
12,516 Expert Mod 8TB
Oh right. Yeah, everything in the relationships window is kosher. That's where I designed all my table relationships from the beginning.

I'm thinking something must be corrupt in the entire db though. The entrainment form always displays 1 of 1 record when I launch it, even if there are 20 records in the table. I can't navigate through the records except in the session I have the form open (e.g. if I add 3 records I can navigate those three and that's it).

I also tried importing into a new db ONLY those tables and forms needed to test the Survey form to Replicate subform Survey_ID issue and no dice.

So I'm wondering if something is just not right with the entire thing. Dang it. :(
I'm just jumping in the middle of all this so what I say may have already been said.

Does creating a new form let you navigate through the records?

Usually this happens when you open the form in data entry mode which is basically you can only enter new records and edit those records. So check the Data Entry property of the form and set that to No.

If it's opening with a DoCmd.OpenReport, check to make sure that's not passing the acAdd argument.
Apr 10 '07 #92
AccessIdiot
493 256MB
I'm just jumping in the middle of all this so what I say may have already been said.

Does creating a new form let you navigate through the records?

Usually this happens when you open the form in data entry mode which is basically you can only enter new records and edit those records. So check the Data Entry property of the form and set that to No.

If it's opening with a DoCmd.OpenReport, check to make sure that's not passing the acAdd argument.
Thanks for jumping in Rabbit. :)

I'm going to assume you are talking about the problem I am having navigating records in the Entrainment form. I have tried creating a new form from scratch and that did not solve the problem. I did check that Data Entry was set to No.

I have also tried turning off the standard navigation buttons and using Lebans custom navigation toolset and that doesn't work either.

Any other suggestions are most welcome. :)
Apr 10 '07 #93
AccessIdiot
493 256MB
[quote=scorpionking007][quote]Yo AccessIdiot can u tell me how to store data and make forms and also make me a form handlerHey scorpionking007 you might want to start your own thread for that. You'll get a lot more responses than by jumping into my thread. :)
Apr 10 '07 #94
Rabbit
12,516 Expert Mod 8TB
[quote=AccessIdiot]
Yo AccessIdiot can u tell me how to store data and make forms and also make me a form handler

Hey scorpionking007 you might want to start your own thread for that. You'll get a lot more responses than by jumping into my thread. :)
You might also want to take a look at the posting guidelines first.
Apr 10 '07 #95
AccessIdiot
493 256MB
I'm sorry, did you mean me? Did I do something wrong?
Apr 10 '07 #96
Rabbit
12,516 Expert Mod 8TB
I'm sorry, did you mean me? Did I do something wrong?
Oh, sorry, no, not you. I quoted the wrong person.
Apr 10 '07 #97
Rabbit
12,516 Expert Mod 8TB
So I took a look at your database. The problem is with the record source of your entrainment form. It should be a LEFT JOIN and not an INNER JOIN.
Apr 10 '07 #98
AccessIdiot
493 256MB
Cool!

So that's something that Access created for me when I built the query for the control source of the form. Can you explain why it should be left join and not inner join and maybe how to prevent that next time? I think the same thing applies to another form I am using (Replicate subform). I am a little fuzzy on the joins (db class was a loooooooong time ago!).
Apr 10 '07 #99
Rabbit
12,516 Expert Mod 8TB
Cool!

So that's something that Access created for me when I built the query for the control source of the form. Can you explain why it should be left join and not inner join and maybe how to prevent that next time? I think the same thing applies to another form I am using (Replicate subform). I am a little fuzzy on the joins (db class was a loooooooong time ago!).
An inner join only returns the record if and only if they have matching records in each table.

A left join returns all records from the table on the left regardless of whether there is a matching record in the table on the right.

A right join is the opposite.
Apr 10 '07 #100

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

7 posts views Thread by John | last post: by
3 posts views Thread by Saket Mundra | last post: by
6 posts views Thread by scottyman | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by suresh191 | last post: by
reply views Thread by harlem98 | last post: by
1 post views Thread by Geralt96 | last post: by
reply views Thread by harlem98 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.