Search results for query: *

For those of us that work with dates alot, I wrote a function that might be of help. It takes the current date, and then returns the last day of the current month. For example, if today were August 15th, the function will return August 31. Since the function is based on the system date, it...

Subform properties are separate from the properties of the main form. They are independent. The only dependence between the two is on the child/master fields in the recordsets that the two forms use. It is necessary to open the Subform in design view and add a button to toggle the allow edits...

I believe you will need to write some asp pages for your website in order to do this. It is possible to create a replica of an object (a form, a table, etc.) in html format using tools built into Access. But I havn't explored this option much. In order to build an interface to your access...

There is also a possibility that the MDAC is causing it. MDAC is basically a bundle of information that access uses in regard to data. Its available at the microsoft website for free. Discrepencies in MDAC can cause errors if one machine is not compliant while the other is compliant.

The CancelUpdate method can be used to skip saving any changes. If its not used, the form saves automatically when a move method occurs or an update method occurs. The cancelUpdate method just discards the changes.

In the QBE pane (query design window) you need to make sure you have set the "Groupby" line for both of the fields that you want to use. The order that you put the fields in makes a difference too. It will break down the groups by each field that it comes to that has the Groupby...

I tried to do the exact same thing in my database. I found the easiest way to do this is a find button. Heres how it works.. they click the button, and a popup box apears and asks them for the record to locate (in your case it would ask them to enter the serial #) VB takes the value creates a...

GGW has the right idea for automating the macros in EXCEL. However it seems a bit easier to create the charts in Access and attach them to the report. If that isn't an option... It is possible to open an application in VBA code, once the application (EXCEL) is opened it will look for any...

For entry level reading, I'd recommend : Access97 Visual Basic Step By Step Its published by Microsoft Press. It is the best way to gradually ease yourself into using VBA. I also use Access 97Bible as mentioned in the previous post. It goes into almost every aspect of access97 but rarely...

You would first need to build a query. Take one field from each table you would like to count and pull it to the QBE pane in the query builder. Next click on the "Summation" character in the toolbar at the top. This displays a new row in the QBE pane that lets you count the values...

I'm working on a database and i'd like to be able to change the Active window's titlebar color to match the other colors i'm using ...instead of the old microsoft royal blue system color that is always displayed. I'm under the understanding that you can set objects in your forms to the...

Thanks for the ideas Doug. I tried the listbox..but it turns out i have 26 fields and listboxes are limited to display only 20. I worked on the 2 subform idea but I decided it would be best to just use a popup comment form instead. I wrote some code to pass the 3 values that I want to move...

I'd like to create a form that functions like a subform...ie: it updates itself as the current record in the main from changes. A subform works fine for me but the only problem I have with it is that you're not allowed to make the main form a 'Continuous form' with a subform. Access limits...

You might have already tried this..but I think all you are really needing to do is pass the values from one from to the other. You've got 2 forms. A 'source' form (form_family)and then the 'destination form' (form_visit) In your destination fields you need to refere to the values in the...

I don't think that there is a 'ready made ' way of doing this in access, but there is a fairly simple solution. In the form that you use to update the data, you will need to attach a bit of code to the text fields that will you use to make the updates. You will want to use the...

Thanks Michael, I moved the code behind the form and changed the syntax a bit to accomodate my input box. I also had to make it a DAO.Recordset. It works great! Here is the code in case anyone can use it: Private Sub Form_Activate() Dim db As Database Dim rec As DAO.Recordset Dim INcourtID As...

Hi, I'm still new to VBA but i've had relative success until now. My question is in regard to the simplest way to accept a value from a user (via an input box) and use that value to 'find' a record in my table that matches the input value. I have a table with a field called "courtID&quot...