Search results

So, it is not just me I guess. I have been trying to get into the site for 2 days with no luck. Finally I tried a google search and was able to pull up a post which then enabled me to find the new posts section. I cannot see the main forum page nor any of the topic headings such as general...

Try something like this in the 'On No Data' event of your report: MsgBox "Sorry this report has no records to display" Cancel = True

I searched extensively for a low priced cart and tried out a lot of them. This one is the one that I bought and am very happy with it: http://www.candypress.com/CPmain3/default.asp

That works and is easy to do, thanks for the tip :D

Just for comparison, try it split with both the FE and BE on the server.

Try something like this as the row source for cboBusinessUnit (the second combo in the series): SELECT YourTableName.YourField FROM YourTableName WHERE (((YourTableName.FieldName)=[Forms]![frmToolInfo]![cboBusiness])); Amend the names to reflect your names. For more combos, adjust the values...

Use Winzip to 'Zip' them. Then they can be attached to the post.

Set the visible property of the sub form to no. Onclick event of your button: YourSubFormName.visible = True or: YourSubFormName.visible = False

http://www.access-programmers.co.uk/forums/showthread.php?t=38364

Did you try the front ends too or did you do it before the split?

You could try creating a new blank DB and import the tables from the original BE. Then rename the original and give the new one the original's name. Make a backup first though just in case!! Backup Backup Backup :D

The link that was in this post is no longer valid so I deleted it..... sorry

Just an FYI... My system has 97, 2000, and 2002 installed The query worked just fine for me.

Wouldn't you think that since the DB's are all in the same folder, and 2 of them work, that permissions are ok? If I read the original post correctly that is......

Shot in the dark but have you tried compact and repair? It doesnt really sound like network permissions so I tend to think DB trouble. Edit: better make a backup :)

Check this out too: http://www.access-programmers.co.uk/forums/showthread.php?t=38364

You're welcome, glad it worked out for you. On a side note, if your form is bound to a table, you really should use a query instead. It will provide a lot more versatility.

Actually there is an example in that db that does what you want. Look at the auto lock again. This disables due to having a value in the textbox rather than a checkbox checked but the princilple is the same. Also look at oncurrent of the form. Is the checkbox on your form bound to anything...

Sounds like you didn't bind the checkbox on the form to the field in the table. Edit, Check out the attachment

You are accessing the data through a form correct? You need to lock only the one form control that you want. Again, set the enabled value to no and use code that states that if the checkbox is checked then the control on your form is not enabled. That will lock only that single control.