Search results

I'm seeing the same thing with one of my office 2007 reports. Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) ' if restitution is > 0 then show it, otherwise hide it Debug.Print "Initial Appearance with Address: Detail Format: Restitution is " &...

Tell me about it ;-) Want me to upload a sample?

I did that for a total on the row but it also doesn't appear to update to show the new value unless I do a recalc which updates every row in the form. Question to your response: User's need to be able to overwrite the default 26% value. If I create the calculation as part of the query, that...

In my simplified example I have a continuous form with 2 columns: curFine and curFinePenalty By default curFinePenalty = curFine *.26 and I am able to change the value by doing this in the before update event for curFine: me.curFinePenalty = me.curFine * .26 But the user is able to override...

In the book "Access 2007 VBA for data-centric Microsoft Office Applications Bible", the author has an example of doing a mail merge in the "Working with Word documnts and Templates" chapter, page 175. When I use her examples for mail merge, I'm not given the typical warning about querying the...

Found the problem, when the wizard created the control, it created the control with 2 columns and hid the first column (the key in the table). When I manually changed the select statement, I missed the need to change the combo to single column, and to change the space for the first field to the...

My question is similar to the original posters. I understand distinct works on all the fields in the select set but when I can't figure out why the following query works with a listbox but won't display any rows on a combo: SELECT DISTINCT tblCases.dtmCasePreTrialDate FROM tblCases WHERE...

but if I wanted to use the function as part of a query so the query returned the total as one if it's properties?

I've inherited a database that used to have a total field in it. I've removed the total but now find myself having to recalculate the total from existing fields in 37 places including 22 queries. Is there any way to create a function that can access the fields in the current records and return...

You know how sometimes while you're asking the question, the answer comes to you? Well in posting I finally noticed I missed the 's' in insert.

'Add fields to existing tables Set dbs = OpenDatabase(dbPath) Set tdf = dbs.TableDefs("States") Set fld = tdf.CreateField("txtCountry", dbText, 50) tdf.Fields.Append fld dbs.TableDefs.Refresh dbs.Execute "Update States set txtCountry = 'US';" ' Load the new...

But if the record is dirty, by the time the UNLOAD event fires, any changes the user made will be discarded because the required cell doesn't have a value so I thought I needed to ask the user about discarding in UNLOAD.

I have a required property and when the use exits the form, I want to give them the choice of returning to the form and adding a value or continuing to close. I also want to supress the standard dialog for warning the user about discarding their changes. Private Sub Form_BeforeUpdate(Cancel As...

Posting this here in the VBA section since it pertains more to programming practices than database design. I have two reports - rptInvoice, and rptEnvelope, both use qryGetPastDue as the datasource which gets all the accounts that are past due. Right now the users run each report individually...

I've added a text box to my splashscreen called txtStatusInfo. I would like to use it to tell the user what I'm doing (checking for valid license, database updates, backups, etc). I also don't want the user to be able to put anything into the text box so I set the Enabled = No and Locked = No...

I don't have any explicit permissions setup so its not an access rights issue. I've checked to make sure that add and edit are set to yes for the form and the recordsource is a single table. So it's not any of those.

I'm using Access 2007 and have a datasheet form setup on one of my tables. If I start with no records in the table, when I open the datasheet view I can't create more than one record. Once I've put anything in for the first record and exit the form and then come back, I can add records all day...

Bingo, thanks stopher.

No. I have a table tblPreferences which has the following columns: preferenceID - autonumber txtPreferenceName - string, name of the preference txtDescription - description of the preference memPreferenceValue - memofield with the preference value One of the rows in the table is: preferenceID...

I have a report (Default Community Service) that has a saved query as its datasource (Default Notices). However, I have 5 users that all have different indigency times that I need to put into the report. I am currently using a report variable in an unbound textbox to get the indigency trial...