Search results

What I've done in my system is invoice all items in full. For example, it totals up to a larger amount than the fixed quote amount. I then calculate the difference, with a simple formula something like: if nz(rsJob![QtAmt]) > 0# And nz(rsJob![QtAmt]) < rsInv![TAMOUNT] then nDiff =...

Interesting, it's still there in 2010. I wonder if that means that no one has ever reported this bug to Microsoft? I haven't seen 2010 yet. As I said, not a disabling problem, if you remain aware of it. Just a pain in the .......

Using form Design to create a blank form. I prefer to have forms of standard appearance so never use the wizards. This only happens after the initial first save (where you are prompted to supply a name for the form). After the first save, subsequent saves leave the form caption intact. This is...

I did this once by putting a numeric value into the Tag property of the Controls. In your case, that numeric value would be either 4 or 8. Then place a function in that form module..... Private Function SetControls(n as Integer) For Each ctl in Me.Controls ctl.Visible = Val(Nz(ctl.Tag)) <>...

I have noted the following bug in Access 2007 when creading and saving a new form. It trips me up every time :mad: 1. Create a new form. 2. Set various properties for the form. 3. Set Caption property in properties box. (at this stage the form is un-saved) 4. Save the form and the Caption...

Yes, but that could be where your problem lies. Are the values of the fixed formatted text boxes based on double numbers? Are these values calculated. It could be a rounding problem, where the displayed value is 0.00 and you're happy that it has a value of zero and should, for example, be not...

I have developed a similar system. What I did was... All time and expenses are totalled up, from the expenses table, by a calc routine and the total stored in the main job table. My main job job table has an additional field for Quoted Amount, which is usually left at zero. In the case of a...

In the original post, you refer to the Labels as Headings... Are these Controls displayed in a Form view or perhaps a Datasheet or Split Form view? For Controls displayed in a Datasheet or the Datasheet section of a Split Form then the Control itself has a 'Datasheet Caption' property on the...

Just a thought, but what data types are attached to the textbox values? What I mean is, are they Integer, Long, Double, Currency, or a mix?

I beg to differ, but the original post read as, "on save I want to add the record to the table", and in his sample code, he had the following statements: Private sub Commandxxx_click() Rsttblinvestigations.addnew Sounds pretty much like he was using an unbound form, to me.

I wouldn't use a bound form for this purpose. Just my choice but: 1. The data is entered into a blank form. At the end of the entry process the user may elect to post the data or abort by closing the form without posting. 2. If your database is used in a multiuser environment, which I suspect...

Oops! Sorry. I copied your code from the original post, amended parts and pasted it back to my reply. I never noticed that you had a spelling error in your recordset variable names. If you look carefully the DIM statement and the ADDNEW statements have a variable name, rsttblInvestigations...

This is a long shot but I have always had the same problem in Access 2007, I have never used Access 2010. I found the following workaround that seems to work for 2007. 1. Open the form in Form view (not design view). 2. Then open the VBA code view and change something (even if you just put in...

This is how I would do it... You need the .Value after your form control names. Private Sub Command66_Click() Dim rsttblInvestigations As DAO.Recordset Set rsttbInvestigations = CurrentDb.OpenRecordset("SELECT * FROM [tblInvestigations]") rsttblInvestigations.AddNew...

Your RowSource for the ComboBox needs a 'SELECT DISTINCT' statement. In Form Edit mode, select the ComboBox, select Properties, on the Data tab select RowSource and edit it, which will take you to a Query Builder window. Right click the tab on the Query Builder Window and select SQL VIEW. Change...

Hello All, My name is Peter and I have been involved in Access 2007 programming for about 4 years. My Access involvement has been mostly for personal use. I have however been involved with database programming for almost 30 years, having started with dBase II in 1982, then dBase III followed...