Search results

You can do it with VBA but not really with macros (if I remember correctly).

You have to build your own custom menus. You can select existing menu items but they need to be added as custom items on your own menus. Do a search for the Access Freak's website. I can't seem to get there right now. He has a tutorial under tutorials - Access 2007 for how to create your...

Windows 7 (or 8) won't let you execute an Access database file from the program files directory. You need to put it in another folder on the C drive (or elsewhere).

If you use the recordset object the visible records in the form are affected immediately instead of if something is found. You can navigate back and forth within a clone without affecting the displayed records in a form and then you can set the bookmark of the recordset to the bookmark of the...

Also, you should probably use a RecordsetClone to search and set the value instead of the actual recordset.

But if the code would be used to do the same thing to other forms, you want to use ONE function and reuse it by just calling it. You don't want the same code on each form.

It could be your reference to the subform control and is Pernr a numeric or text field? Is your subform control (the control that the subform is housed/displayed in) actually named subfrm? And, is that the name of your subform too? If not, then you need to refer to the subform control not the...

A subform is not counted as a form when it is being used as a subform. It is housed within a subform control so you would need to reverence it like this: Set Frm = Forms!frmConsultingMain.SubformControlNameHere.Form The part I wrote SubformControlNameHere would be FrmConsultingFeeData IF...

You don't create the table in the frontend. You create the table, if not already done, in the OTHER database and then you use the EXTERNAL DATA tab to link to it. The Linked Table Manager is only for those tables already linked.

You can't tab between tabs natively. So, if you want to move on to the next tab when you get to the end, this is what I do. 1. Create a text box on each tab and leave it unbound and set its height and width to something very tiny, like .01". 2. Then set it so that text box is the last in...

Unless I'm misunderstanding what you are saying, if you use a Union query it is not going to be updateable.

No, that is NOT what I mean and what you are doing is not optimal. They each should not have a shortcut to the file, they need a COPY OF THE FILE. Read this because Albert D. Kallal explains why this is important (it isn't just something we say but there is a solid set of reasons behind it)...

There is some simpler code you could use - using DoCmd.TransferDatabase. This is a simple example which assumes you only have local tables in that database. But you can modify it to bypass other tables besides system if you need to. Function GetDatabaseTables(strFileAndPath) Dim tdf As...

Just as an FYI - I have a free tool on my website which will enable auto updating on your frontends. It is here: http://www.btabdevelopment.com/ts/freetools Be sure to read the documentation carefully if you choose to use it. And you can email me (email is on my Contact Me on my website)...

Something like this: Dim strResp As String strResp = IIf(DCount("*", "TableNameHere", "[FieldNameInTableHere]= " & Chr(34) & Me.TextBoxOnFormHere & Chr(34)) > 0, "Yes, it is there.", "No it is not there.") Msgbox strResp

Don't know if this will help but I made this procedure to run any stored procedure for my workplace: ' Procedure : RunSP ' Author : larson ' Date : 6/16/2009 ' Purpose : Runs a stored procedure with the parameters passed if parameters ' are included and just a stored...

Did you accidentally connect two autonumber fields as links?

If using a normal list box, you can use code to iterate through the selections and save to a separate table. And to load it, in the form's On Current event you would do the reverse - to pull the values from the table and select them. Or, if you are using Access 2007 or above, you can set...

I don't know that you are thinking of database design in the proper way as I can't fathom a situation which would occur as you have suggested. You would use a table for lookup values for the combo box where there is a PRIMARY KEY for each value. That value represents the FK when entered...

What he wrote ^^^^^^^^^^^^^^^^^^^