Search results

This list if for bound objects, but it might still apply here. Shows what all the different verb choices do! http://msdn.microsoft.com/en-us/library/office/ff835064%28v=office.15%29.aspx

Can't say for sure, but I had a similar problem not too long ago, and the problem was that you can't have the recordset use joins between queries and still be updateable. So you could probably still get your updateable data-sheet view form, if the record source was just a single query/table...

What do you mean they showed up on your form? Were I go guess I would say they are something to do with name you give the computer on a network, and perhaps a related ID. So could potentially use it to determine what PC a change was made from, but not by which user on that PC.

Ah okay, in that case the .ColumnWidth won't work, as I think it only works on datasheet view forms. For a continuous form I would recommend the .Visible method. Maybe try: Forms![FormName]![FieldName].Visible = FalseAs It might have been something to do with the Me. part of the code used...

Having looked at this page: http://msdn.microsoft.com/en-us/library/office/aa224081%28v=office.11%29.aspx it looks like you should try something along the lines of Forms![FormName].[Subformname].Form![FieldName].ColumnWidth=0 (assuming your data is a datasheet view form that is a subform of...

Ah I see what you mean now. Well perhaps the thing to try is just reducing column widths to small but non-zero amounts. Like set them to 0.1, which Access might allow you to do. If its small enough it will just look like a little line when you print it, so should be almost as if it's not there...

Do you definitely have a username available? So if you just wrote some code that said Msgbox Environ("Username") Does anything come up? As far as I know, Environ("Username") returns the windows user name, so should do what you want (won't work on Macs!).

Not 100% sure what you are trying to do. Things you have set to not be visible in the way I suggested will not show up when printing, if that was your concern.

Usually to play with spreadsheets via access you need to bind them together by defining objects in VBA to represent things in excel. Here is how I would do something like this: Dim X As Object Dim Y As Object Dim XL As Object Dim rs As RecordSet Set X = CreateObject("Excel.Application") Set...

You can change the Visibility property of things in VBA. So in the 'OnClick' event of the thing being clicked on, write. Me.[ThingToHide].Visibility = False Hopefully this is what you were getting at.

Do those three users have anything special about the way they access the network that could slow things down? Could be that the weak link in the chain is the program opening the file to print, or the communication with the printer as JHB suggested.

You could make the calculation something like Iif(FieldValue=0,0,{Rest of calculation}), so that the meat of the work is only done when needed.

Sounds like your update query needs a criteria for the deduction. So in the RoleID field add critiera that it is equal to the RoleID of the thing currently being looked at in the form e.g. "=Forms!Roles!RoleID"

If you want to see the number increasing, you can slow the loop using a sleep function so that the cycle takes a non-negligible amount of time. See: http://stackoverflow.com/questions/469347/is-there-an-equivalent-to-thread-sleep-in-vba

Don't forget to also switch the colour back to whatever you had before on the Yes condition; just in case the user picked No by accident and then immediately changes their choice, or they are likely to change it to Yes while still viewing the record at some point.

If the sections with records were on subforms, then you could scroll through the parent form without scrolling the records. Don't know any proper techniques to change the function of the scroll wheel though, sorry.

150 fields... :eek: will take a long time to work out which one had the validation violation! So basically the problem is that one of the fields has data that isn't allowed into the field you are inserting to, so it just skips the entire row. Maybe (hopefully) you have an idea of which field...

You could have the value of the box be filled in by the code in your buttons. So the button code would be like: Private Sub btn_AddTest_Click() ' open Add test-Assignment Add form DoCmd.OpenForm "frm_TA_Add_Global" Forms![frm_TA_Add_Global]![YourComboBoxNameHere] = "Exam" End...

Things like Front or Front End are the ones I've most commonly seen to refer to database user interfaces, so I would start there. The type of thing you are suggesting is one of the most common forms of front end design, so there will likely be templates or examples you can find through google to...

It will be a struggle, as to show the multiple records from the last column, you in principle have to show multiple records for the rest of it, just so it has somewhere to show them! Possibly you could make a field which combines all the result of that result column for each person using...