Search results

I have successfully use Environ as both a default value and a module, for multiple usernames. Environ is supposed to work on the OS level to get all kinds of data. I would check and see how the user is logging onto the network and check his account on the sever, check the workgroups and...

Try this: If Me.NewRecord Then Me.SubFrmOrg.Enabled = False End If hth.

Yes it makes sense, but I still would like to make sure that the relationships are correct, I help someone last week with a similar problem and the checkboxes in the second relationship weren't there and when he checked them everything started working. If that doesn't work then make a copy of...

Your welcome.

Change the data type of the subform to continuous form. hth.

Do the respective tables have a relationship? Do all have referential integrety checked? Do all have cascade update and delete turned on? Let just start at the top and work our way down. hth.

Subreports go on Reports and Subforms go on Form. If you have a form, then you can only add a subform to it. Just redign the subform to look like the subreport and that should take care of that. hth.

Your welcome, sorry I was not more help.

In the relationship, do you have the referential integrety checked? How about cascade update and delete? Trucktime also has a good idea. Myself I use a function to check the main form for blanks, before a user can enter the subform, but that is alot of coding and I don't relly think you want...

How elaborate and tricky would you like to get? You can go as far as the tabs are invisable till the last required txtbox on the main form is filled in. We can be as simple and easy as putting the focus on the first required data object. I have found that that the second method is usually...

Two PKeys will not link together. In table2 try adding Talble2Id and make it the PKey, now change HostName in table2 to long integer. Now in relationships link the Hostname of Table1 to HostName of Table 2 and now you should be able to turn on referential integerty and cascade updates and...

Have tried an UpDate query?

Try running C&R. hth.

Pat, thank you for that information, I will try and remember that. On my procedure, If it is a new record it does a undo and if it is not a new record then it does a delete. Just alittle FYI 4U. I know I used the wizard deleted record. hth.

Actually that is from Access 2000, not Access 95. I uderstand what you are saying, but the funny part of this is that the lady who taught me how to do that, us to work for MS and helped desigh Access. Bad habits die hard and slow. FYI 4U.

Try to create a new dbase and import everything in it. Then do a Compile and a C&R. Close it and reopen it and see if the helps. If not then your friend is right, but only as the vary last resort. Sorry I could not be of more help to you. LOL.

Your welcome.

To the first question, yes. Remember code runs fastest and queries will be next. There is no reason why you can not put your query into code I have seen it done alot. hth.

Now you can do this a couple of ways. First in the data objects GotFocus event put this: If Me.NewRecord Then Me!Your Name= Null End If This way it won't make existing records Null unless you change it. Also in the forms On Open event you use this: If Me.NewRecord Then Me!Your Name1= Null...

I have a cmdButton, cmdDelete, and I run this code in the OnClick event: If Me.NewRecord Then DoCmd.DoMenuItem acFormBar, acEditMenu, acUndo, , acMenuVer70 Else DoCmd.Echo False DoCmd.SetWarnings False DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70...