I need to assign the value of a radio control or check box when clicked on to a variable, preferably using the SetTemVar macro.

There is one form which has several tabs and I noticed when I moved my mouse over the form itself, the form/screen flickers quickly everytime. It's like the...

I need a filter to be able to hide records that don't have any records in the detail form. My example is Member Master and Event Detail. If there is no...

I haven't been able to create a form/sub-form, both visible. Must be doing something wrong. Is there more than one way to do this? Or is there only one way...

I have created a Form from a table. The form is formatted the way I would like. I have several other tables that I would like to change to Forms but I...

I am trying to do the following: 1. Open a form that has combo boxes allowing me to select group and document. 2. Whenn the OK button is selected a query...

Hello, I can insert a random number column into the query and shuffle it to select the first row but I have 250,000 rows. I want to do something...

Hi, When I click to add new record it gives me a message "Can't go to specified recordset. You may be at the end of a recordset." I am using one table....

I added a field on our form. It looks like it was okay but every time I put a value/data in, the value/data isn't saved. Am I doing something wrong? Did I...

Hi, I am trying to email an object which is a refernce # from a form. This is the code i am using: Private Sub Command77_Click() Dim refnum As Long refnum =...

I have a form i want to create a DLookup where I get the Last_Name on the tblUserNameTest when the field txtUser on the active form equals the User_IDon the...

How to delete a xls file trought a macro or code, but with having an external file such as *.bat. Regards, Marco

I have a"cboFind" combo box that works perfectly until invoked after a "ws.CommitTrans". The cbo afterupdate event uses a recordsetclone in typical find...

I want to pass my many thanks to your team for all your inputs! You've been great!! THANK YOU!! Question: When I insert a command button on the form, I...

Hi. I have adate and I would like to transform it in a number. Ir order a query ready this number a use it as a criteria. I have 21-02-2008 and I need to...

We are glad to announce the releases of our new product DBForms from MS Access to ASP.NET+MS SQL v.1.0.0. This tool allows you to convert mdb (Microsoft...

Hi all, I'm using Access 2007 for the first time (always have used 2000) and I'm designing a form, and I can't seem to find the spacing tool (horizontal,...

I have a report base on a query with date parameters (beggining date and ending date). How can I have those date show on the report? Thanks, John

Version: Access 2007 I have a form with a List Box. The List Box RowSource is populated with Text File Names via the Office.FileDialog File Picker. When I...