Search results

Only 1 frontend with the macros inside ... easier then for every user go to his desk, open db in edit mode and drag and drop form on desktop. What if form changes ? Only my opinion, there are always different ways to get to the thing you want

Try this. It is with macro instead of VBA. http://iswwwup.com/t/39d73d659c33/access-module-and-batch-file.html Then you make macro for each users. You can make it automatic if you get the windows username in the batch file and make macro for each user, so you not have to make x batch files...

You also have to write vba code. If not solved later i will send it but not home right now. I don't know it out of my head anymore. I use it for nightly scripts to update backend and import somz csv files from other programs. I also like to only maintain one front end

Try this then Private Sub Form_Current() If (Me.Tekst0 = "TBD") Then Me.Kader2 = 2 Else Me.Kader2 = 1 End If End Sub Where tekst0 is the name of the textbox, kader2 is the name of the option group. 2 is the value of TBD 1 is the value of NA, to change in code if different on your DB

Why not bound the option group to the control and remove the text boxes? It's shows double data. Either way bounding the option group to the table will solve your problem

Try if me!check38.value = True

Make an onload event on the form you opens and put Docmd.gotorecord ,,acnew

Make an combined field from firstname & lastname in your query and search then on that field

Make a group instead of 3 checkboxes. Icon in form design with XYZ on top

I have manytime same problem (win 10), rename file and extension to original name and will work

Adjust so the search term filters on the task name and dates are also selectable and filters to Status can not because don't have whole DB This would get you started As you see i deleted many VBA code for doing the same with many less Also added the show record link wich when you...

On the subform after the ID field you put a OnClick sub DoCmd.OpenForm "frmViewTask", acNormal, , "ID='" & Me.ID & "'"

No problem. I adjusted a little bit the DB to show you what i mean. If you add a subform in datasheet view to the form you get the headers and you can apply sorting without programming. Code after the form is not working because misses some fields , .... But at least you have an...

When you open the form does the subform looks like a query window? Can you click on the headers for sorting?

Had it on office 2013 to. Disable hardware rendering solved it for me https://support.microsoft.com/en-us/kb/2768648

What are the name of the forms? Pipform is the form with the button What is the name of the form with the subform you want to requery? What is the name of the subform? Forms!nameMainform!nameSubform.Form.Requery should do the work

Instead of your code place this DoCmd.Requery It will refresh your form You put your code in a sub onclick of the buttom?

Try Me.requery

Is the forms wich you open an continious form or a datasheetview ? If datasheet the user still can apply sorting on the headers

Apply sorting in the queries qryDynamicSearch and qryDynamicSearchRestricted